Archived discussions are read-only. Learn more about SAP Q&A

Error-ORA-12505: TNS:listener does not currently know of SID given in conne

Dears,

On our AIX 6.1 server we were having one PI dev(PD1) instance,Now we have installed one PI QAS(PQ1) instance on it.

Now issue is that PD1 is working fine but while starting PQ1 instance it is giving error:

I have also changed port in listner,tnsnames.ora and in configtool to 1526 for PQ1 instance.

Checking PQ1 Database

-


Database is not available via R3trans

Running /usr/sap/PQ1/SYS/exe/run/startdb

Trying to start PQ1 database ...

Log file: /home/pq1adm/startdb.log

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

DB startup failed

While by SQLPLUS I checked that oracle is up but issue is SAP is not able to connect to oracle.

R3trans -x

This is R3trans version 6.18 (release 710 - 08.10.07 - 13:37:00).

unicode enabled version

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

R3trans finished (0012).

trans.log says:

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor'

Please suggest.

Shivam

Not what you were looking for? View more on this topic or Ask a question