hadimdh
asked on
ORA-12560:TNS Protocol adapter error.
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
descriptor.
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
descriptor.
in SQLNET.ORA
change the value of
SQLNET.AUTHENTICATION_SERV ICES=(NTS) to SQLNET.AUTHENTICATION_SERV ICES=(NONE )
Change the user that starts the OracleService to the Oracle DBA user who is
defined to the Windows domain.
1. Go to Control Panel, Services,
2. right click the OracleService<SID>
3. select properties, select the Log On tab
4. Click on the Account radio button
5. fill in the domain qualified dba user and password (e.g. oradba\dbapwd)
6. Click OK
7. Restart the service
change the value of
SQLNET.AUTHENTICATION_SERV
Change the user that starts the OracleService to the Oracle DBA user who is
defined to the Windows domain.
1. Go to Control Panel, Services,
2. right click the OracleService<SID>
3. select properties, select the Log On tab
4. Click on the Account radio button
5. fill in the domain qualified dba user and password (e.g. oradba\dbapwd)
6. Click OK
7. Restart the service
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Schewertner,
Thanks for your comments, I used tnsping 10 orawin, but I got the following error message :
Failed to resolve names.
Thanks for your comments, I used tnsping 10 orawin, but I got the following error message :
Failed to resolve names.
ASKER
Thanks Baonguyen1,
All the sid's are up and running, Thaks for every body
All the sid's are up and running, Thaks for every body
ASKER
Baonguen1,
When I restarted the server I got the same problem, It looks that the problem exist still, If I run a backup scripts also I should restart all services manually with the scripts which you have provided.
When I restarted the server I got the same problem, It looks that the problem exist still, If I run a backup scripts also I should restart all services manually with the scripts which you have provided.
Use
c:>tnsping 10 orawin
where 'orawin' stands for the alias names in tnsnames.ora to check if using this alias you can connect the listener.