stopsap problem ( Redhat linux-Oracle )

[Former Member]

Hello,

stopsap command when I try to shut down the system so wait long time.Database can not close. Problem does not appear in the log file. but with the command ( orasid ->shutdown immediate ) database is shutdown. Detected after the sap instance ( stopsap ) is closed. I'll try to update kernel ( 179 --> 236 ). The proposal is out of this here?

*stopsapDVEBMGS00.log*_

Called command: /usr/sap/SID/SYS/exe/run/stopsap DVEBMGS00

Stopping the SAP instance DVEBMGS00

-

---

Instance on host r3test stopped

Waiting for cleanup of resources.....

Running /usr/sap/SID/SYS/exe/run/stopdb

Stopdb log

-

---

Fri May 7 12:08:25 EEST 2010

LOGFILE FOR STOPPING ORACLE

Trying to stop CGT database ...

-

---

Fri May 7 12:08:26 EEST 2010

checking required environment variables

ORACLE_HOME is >/oracle/CGT/102_64<

ORACLE_SID is >CGT<

-

---

Fri May 7 12:08:26 EEST 2010

Connect to the database to check the database state:

R3trans check finished with return code: 0

Database is running

Continue with stop procedure

-

---

Fri May 7 12:08:26 EEST 2010

Forceing a log switch and then stop the database

SQL*Plus: Release 10.2.0.2.0 - Production on Fri May 7 12:08:27 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SP2-0310: unable to open file "/home/cgtadm/stopdb.sql"

SQL> Hangup

-

---

Fri May 7 12:11:27 EEST 2010

/usr/sap/CGT/SYS/exe/run/stopdb was killed or interrupted. Terminating.

( I have to cancel the shutdown process takes longer. Because of that, there are errors in the log file.)

Redhat 5 / Orace 10.2 / Ecc 6.0 / Kernel 179

regards

ismail

[former_member227283]

Hi ismail,

For analysing this problem follow below procedure.

1. Login with cgtadm.

2. sqlplus "/as sysdba"

3. Shutdown immediate.

check what result you get after doing above steps.

4. Login with oracgt

2. sqlplus "/as sysdba"

3. Shutdown immediate.

Check what result you get after doing above steps.

Share the result on forum, depend upon we can move forward to resolve the issue.

Thanks

Anil

[Former Member]

Hello,

I updated R3trans and tp files. Problem solved.

Thank you.

Regards

ismail

[Former Member]

PLease check for permissions on the file ""/home/cgtadm/stopdb.sql"

Since sap has already stopped , go to oraSID and connect to

sqlplus "/as sysdba"

Issue ,

shutdown immediate;

Thanks,

Phani

[paul_power]

Hi,

It seems the root cuase of the issue is at:

SP2-0310: unable to open file "/home/cgtadm/stopdb.sql"

can you verfiy the permissions and contents on this path?

regards,

Paul