DB startup failed

[Former Member]

Hello All,

I am facing a typical issue today, as i am unable to login into SAP which is fine till yesterday an it says connecting...... I took Offline BRBACKUP also on yesterday.

I checkedwith ps -ef grep command and both ora & sap are up.

So i tried stop the application and in the begining itself says " ABAP Database is not available via R3trans " and showing as ABAP database is not running. saposcol and listner are working fine with stop and start commands.

I tried again just to check the application is hetting up or not, but errors message showing as /usr/sap/NED/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed .

Recent changes i have done is kernel upgradtion (291 to 310)which is 1 week back, from then on system working fine with users and took couple of BRbackups also.

Our system is on ERP6.0 with 11g.

Request you all please suggest this sudden issue as what needs to be done.

When i checked the startdb.log under /home/sidadm , it shows as R3trans check finished with return code: 12

Rgds,

Durga.

Edited by: Durga,Gadde on Feb 6, 2012 12:44 PM

[Former Member]

Hi Durga,

I have facea a similar issue. Here is what worked for me.

1. Bring the entire SAP System down and make sure that your tnsnames.ora and listener.ora files in $ORACLE_HOME/network/admin and /usr/sap/<SID>/SYS/profile/oracle are in sync.

2. Start listener

3. Start sap

Regards,

Renu

[Former Member]

Hi,

Please start database from orasid.

sqlplus> startup

if DB starts, then start Listener as orasid

login as sidadm and execute R3trans -d

check if it gives 0000 return code.

if ti still gives return code 12, paste trans.log here for further investigation.

Regards,

Venkata S Pagolu

Edited by: Venkata Pagolu on Feb 22, 2012 12:56 PM

[former_member686974]

HI,

Check DB connect user/password is correct or not. Also check password experied or not.

Thanks

Mukul

[Former Member]

Hi Durga,

Can you start DB using orasid user and then try to start sap using sidadm.

From the error message i see that sidadm is unable to bring up the Database.

Regards,

Ershad Ahmed.

[former_member189546]

Hello,

From kernel directory run

r3trans -d

What errors are you getting in the trans.log produced?

regards,

John Feely

[Former Member]

Dear Durga,

Try to stop the complete system again and execute clean ipc and try to start the DB first and start the SAP.

Hope it works..

Thanks,

Veeresh K R

[Former Member]

Hi Durga,

Did you executed "saproot.sh", after the kernel patch?

Best regards,

Orkun Gedik