server not starting

[Former Member]

Hi,

We had a SAP Nw2004 SPS9 installation on a AIX box.

WE ahd downlaoded the SPS20 to upgarde the server.

During the upgrade process the m/c got hang.

As a result i retsrated the m/c.

Now while starting the sap server using "startsap all"

It is waiting at the followign stage

Checking ADA db Database

I coudl see the following lines in the startsap_SCS01.log file

:$

-

---

(290996) Starting: local ms.sapCTS_SCS01 pf=/usr/sap/CTS/SYS/profile/CTS_SCS01_ctsaix05

(327904) Starting: local en.sapCTS_SCS01 pf=/usr/sap/CTS/SYS/profile/CTS_SCS01_ctsaix05

(184394) Waiting for Child Processes to terminate.

Instance on host ctsaix05 started

Starting SAP-Collector Daemon

-

---

saposcol already running

Running /usr/sap/CTS/SYS/exe/run/startdb

/usr/sap/CTS/SYS/exe/run/startdb completed successfully

Checking ADA db Database

-

---

~

It just hangs there

Best Regards

Manoj

[Former Member]

Hi,

Shutdown oracle and SAP completely recheck that none of the process are alive and then do a startsap all.

I believe the issue is because the server was not shutdown properly leaving hanging threads.

Thanks & Regards,

Vijith

[Former Member]

Hi Vijith ,

Thankd for the reply.

It is using maxdb db

I ahve stopped all the processes and started it again one by one

like

startsap DB

startsap R3

but no luck

Best Regards

Manoj

[roland_mallmann]

Hi Manoj,

please inform us which exact MaxDB version (incl. Buildnr.) you're using.

Additionally, please have a look at the knldiag and knldiag.err files and see if you see any errors, or situations like LOG FULL. Both mentioned files reside in the socalled Rundirectory of your instance, standard path would be /sapdb/data/wrk/<SID> on Unix systems.

I think a LOG FULL situation might be the cause of your issue. More on this can be found here: <a href="https://wiki.sdn.sap.com/wiki/display/MaxDB/Standardproblemsituations">MaxDB Standard problem situation</a>.

Hope that helps.

Regards,

Roland