ORA-12547 // prd databse down after failover test

[mohsin_m3]

Hello All,

prd databse down after failover test

hostname:orasid 3> oerr ora 12547

12547, 00000, "TNS:lost contact"

// *Cause: Partner has unexpectedly gone away, usually during process

// startup.

// *Action: Investigate partner application for abnormal termination. On an

// Interchange, this can happen if the machine is overloaded.

plaixlpc051:orasid 4> sqlplus

/usr/bin/procmap : no such process : 2384066

/usr/bin/procmap : no such process : 2384066

/usr/bin/procmap : no such process : 2384066

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Jul 11 18:02:17 2009

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

Enter user-name: / as sysdba

SP2-0306: Invalid option.

Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]

where <logon> ::= <username>[/<password>][@<connect_identifier>] | /

Enter user-name: / as sysdba

ERROR:

ORA-12547: TNS:lost contact

Enter user-name:

hostname:orasid 5> logout

hostname:sapmgr> sudo su - sidadm

hostname:sidadm 1> R3trans -d

This is R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SID'"

R3trans finished (0012).

hostname:sidadm 2>

please help me to resolve the issue.

Regards

[Former Member · Accepted solution]

check this note ,

Note 505630 - Composite SAP Note ORA-12547

Also

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/db-startup-failed-terminating-with-er...

Regards,

Ravi

[mohsin_m3]

After file system mount

as per note 954896

Note 505630

issue has been solved

Thx

[Former Member]

Your listner seems to be down. Start your listner, check tnsnames.ora and listner.ora.

to start listner use lsnrctl start from the command prompt.

[Former Member]

Hi,

Please find the Note below.

Note 954896 - ORA-12547 connecting to sqlplus / as sysdba on AIX 5L

Thanks

Rishi Abrol