Skip to Content

ORA-12547 Terminating with error code 14

Hello,

While stopping the solution manager 7.1 on oracle  11.2.0.2 through stopsap script it gives me below error while trying to stop SAP:

1.

********************************

ERROR:

ORA-12547: TNS:lost contact

SP2-0640: Not connected

ERROR:

ORA-12547: TNS:lost contact

ORA-12547: TNS:lost contact

------------------------------ Wed Oct 31 16:22:43 PDT 2012

Connect to the database to check the database state:

R3trans check finished with return code: 0

Database is still running

*** ERROR: shutdown failed

/usr/sap/SID/SYS/exe/run/stopdb: Terminating with error code 13

*************************************

The database is still up along with the listener.

But when I individually stop the three one by one, it stops without any error.

1.Stop SAP instance

2.Stop listener

3.Stop database

2. Also the similar is the issue with startsap as mentioned below :

********************************************

Database is not available via R3trans

-------------------------------------------

Trying to start SID database ...

Log file: /home/sidadm/startdb.log

No SQL*Net V2 connect to SID available.

Check that the listener is running: "lsnrctl status".

Start the listener as user orasid: "lsnrctl start".

/usr/sap/SID/SYS/exe/run/startdb: Terminating with error code 14

DB startup failed

please send the tracefile /home/sidadm/startsap.trc to support

********************************************

But if i start following one by one it starts with no error :

1. Start db using startup

2. start listener using lsnrctl start LISTENER_SID

3. start sap startsap

I have already gone through few forum suggestion & tried registering listener with oracle using "alter system register" still i get the same problem.

I have attached my network admin files, kindly request your help to solve the same.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Nov 01, 2012 at 05:23 AM

    hi sampat,

    ORA-12547: TNS:lost contact

    please check below notes

    Note 505630 - Composite SAP Note ORA-12547

    SAP note 131561

    Terminating with error code 14

    please start the listener services.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2012 at 05:24 AM

    Hello Shradha,

    Please check the Note

    505630 - Composite SAP Note ORA-12547

    Regards,

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Gaurav for your efforts !!

      I have gone through these notes & tried as per current oracle release & scenario change of queuesize but still I had the same problem.

      Thanks

      Shradha

  • avatar image
    Former Member
    Nov 02, 2012 at 07:48 AM

    Please start your sap system as usual and attach satrtdb.log file.

    Regards

    Roman

    Add comment
    10|10000 characters needed characters exceeded

    • Hello

      The stopdb.log and startdb.log barely gives you an indications about the underlying issue.

      I suspect a permission issue here for the sidadm user to connect to the database and shut it down.

      Cheers

      / RB /

  • Nov 02, 2012 at 05:21 PM

    Hello

    I suggest you to stop the database normally.

    Have you done any changes to the system before this like Kernel upgrade ?

    One you have stopped the database switch to sidadm and start the database.

    Before that make sure the listener is running.

    startsap db

    Also check the output of R3trans -d

    Also check the user groups of the users sidadm and orasid.

    Issue the command id under the respective users.

    Cheers

    RB

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 07, 2012 at 07:48 PM

    Hi  Shraddha,

    Checkout the tnsping <DBSID> command at your OS level and let us know the output.

    Also , have you modified your network files while attaching here and hide the SID of the system?

    Regards,

    Pankaj Pabreja

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member shradha sampat

      Hi ,

         Please ensure that tnsnames,listener,sqlnet.ora file in /oracle/SID/112_64/network/admin is same as in /sapmnt/sid/profile/oracle.

      If not, try to sync each other and check whether it works.

      Thanks and Regards,

      Vimal

  • avatar image
    Former Member
    Jan 05, 2013 at 08:32 PM

    Hi shrada,

    1. check the environment variable TNS_ADMIN value.

         let me know the value.

    2. Shutdown the database with with command

         shutdown abort.

    3. kill all the process of oracle and listener at os level.

    4.To start oracle :

    sqlplus /nolog

    connect /as sysdba

    startup nomount.

        (capature the output and paste it in your reply.

    alter database mount

        ( capture the output and paste it in your next reply)

    alter database open.

        (capture the output and paste it in your next reply)

    Add comment
    10|10000 characters needed characters exceeded