Database couldn't start automaticly

[Former Member]

Hello to all!

I installed an empty SAP ERP system and faced with the problem:

database couldn't start automaticly with startsap script with sidadm user:

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

DB startup failed

But if is make su - orasid, run sqlplus / as sysdba and make startup after that I can start SAP normally. I think it's a permission problems. And I use

oracle secure file storage (sap kernel 7.41), maybe this is a problem too. Thanks!

ls -ls /usr/sap/WM1/SYS/global/security/rsecssfs/key/

-rw-r--r-- 1 wm1adm sapsys 187 May  7 16:01 SSFS_WM1.KEY

[Former Member · Accepted solution]

Also I can see in logs TNS lost contact, and when I run sqlplus / as sysdba with sidadm user I see this error too:

sqlplus / as sysdba

ERROR:

ORA-12547: TNS:lost contact

[former_member182657 · Accepted solution]

Hi,

TNS lost contact, and when I run sqlplus / as sysdba with sidadm user

First i would suggest you to start your listener from ora<sid> instead of sidadm user & then try to start the database with startup options.If possible share the results for command ps -ef | grep ora

For the general issue ORA-12547 you could follow SAP Note  131561 - Work processes sometimes abend during database connect

Good luck !!

[former_member207186 · Accepted solution]

Hi,

Regarding this "TNS:lost contact" issue, you can refer to SAP Note 505630 - "Composite SAP Note ORA-12547" for troubleshooting.

Regards,
Bíborka

[Former Member · Accepted solution]

Oh thanks a lot Biborka !

I fixed my problem with note 12547:

Relink the Oracle software as ora<sid> with

cd $ORACLE_HOME/rdbms/li

make -f ins_rdbms.mk instal