update patch level faild

[Former Member]

Hi all,

After update patch level from 144 to 146, the system appear error when I start system:

"/usr/sap/PTS/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

"

Please advise,

Thanks

Duypm

[former_member227283]

Hi,

Pls refer the Note 403004 - Database connect using R3trans fails

Will help you to resolve the error.

Thanks

Anil

[Former Member]

Hi,

Status of database opened

SQL> select status from v$instance;

STATUS

-

---

OPEN

Status of R3trans as below

sap-hn:ptsadm 4> R3trans -d

This is R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/PTS/SYS/exe/run') or dbms_type ('ORA')"

R3trans finished (0012).

Please advise,

Duypm

[Former Member]

Hi,

Your DIR_LIBRARY path is not set correctly.

Set this parameter to correct value.

Please see the below link.

[;

Thanks,

Shambo

[former_member227283]

Hi,

Can u check the status of database using sqlplus command " select status from v$instance"

if the status shows open , then pls check the status of R3trans check as below.

login with user sidadm & run the command "R3trans -d" if there is an error , the pls past the r3trans log file.

Thanks

Anil

[Former Member]

HI,

I using OS Linux 5.3, Database oracle 10.2.0.2, ECC6.0. I started listener. But when I start, I get error as below:

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Oct 4 11:18:08 2009

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1191182336 bytes

Fixed Size 2070712 bytes

Variable Size 603981640 bytes

Database Buffers 570425344 bytes

Redo Buffers 14704640 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

-

---

Sun Oct 4 11:18:24 ICT 2009

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/PTS/SYS/exe/run/startdb: Terminating with error code 12

Please advise,

Thanks

Duypm

[Former Member]

Hi

It happens when the exe file in run directory "strdbms.cmd" unable to start the DB,try to copy this exe file from your old kernel file and try to start your SAP

Hope you backup the original file before doing this activity

Regards

Udya

[former_member227283]

Hi,

Check the status of you oracle lisener "lsnrctl status". If it is stopped, then start it manually "lsnrctl start",

if lisner is started stage already. Then try to start database manually. after that start sap . then see what error .

Thanks

Anil

[JPReyes]

Theres not enough information here, beside that seems like you haven't done enough reading about kernel patches (I presume thats what you're up to).

In any case.

• Not enough information

• No research done

Read the "Rules of Engagement"

Regards

Juan

[sunny_pahuja2]

Hi,

Could you please give details of your system (OS, Database, ERP/NW ?)..

Also, paste startsap log here ?

Thanks

Sunny

[Former Member]

Hi

Please check below document for help

http://help.sap.com/saphelp_47x200/helpdata/en/3d/ad5d6c4ebc11d182bf0000e829fbfe/frameset.htm

cheers,

Sudhakar