I tried to connect to the database ( Two sid's ) using
SQL*Plus I got the error messages :
ORA-01034 : Oracle Not Available
ORA-27101 : Shared memory realm does not exit.
and by Manager SVRMGRL, I got the following error message:
ORA-12560:TNS Protocol adapter error.
I created a new databese service by using ORADIM utilities. I got the
same error message. I checked listener and tnsnames and looks fine
but by changing the GLOBAL_DBNAME on SID_DESC from GLOBAL_DBNAME
= PROD( The name of the sid) to GLOBAL_DBNAME = Oracle8.) and the error message changed to ORA
- 12514 :TNS:Listener couldn't resolve SERVICE_NAME given in connect