Error-ORA-12505: TNS:listener does not currently know of SID given in conne
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
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.
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).
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor'