-
Hello,
The system is generating the error “ORA-12560: TNS: protocol adapter error” when we tried to connect to the oracle database(8.1.7) using SVRMGRL.
Where as we are able to connect to the database using sqlplus system/manager@bob
Please help me how to resolve this issue.
Thanks,
Nikee
-
Hi,
Is it an NT or Unix box ? Check the value of ORACLE_SID - this is a O/S variable & set that to U'r Oracle SID.
-
Hello Ganesh,
Thanks for the reply.
We are running on WINDOWS 2000 Service pack 2. I have already set the environment variable ORACLE_SID=BOB
Thanks,
Nikee
-
Hello Ganesh,
Here are some addtional information.
I am able to start the Listener service from windows servives, where as I am unable to start the Listener from the command prompt.
i.e. lsnrctl start
At this point system is displaying the following information:
Starting tnslsnr: please wait..
Thanks,
Nikee
-
Since you are able to connect to the database, through sqlplus that shows that the listeners are up and functional.
To connect to the server manager fist you would have to
set ORACLE_SID=bob
svrmgrl##
svrmgr> connect internal
I would suggest that you get accoustom to that of using sqlplus to do the administration as svrmgrl had been discontinued as of 9i.
set your ORACLE_SID
sqlplus "/ as sysdba"
Good luck.
Sam
-
Hello SAM,
Thanks for the suggestion.
Here I am just investigating the bug source. I am also able to connect to the database using the SVRMGRL but not the first time.
D:\>svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
ORA-12560: TNS:protocol adapter error
SVRMGR> connect internal@bob
Connected.
SVRMGR>
I am just wondering what excatly the error is.
Thanks.
Best regards,
Nikee
-
That is because you have not set your ORACLE_SID the environment variable.
D:\> set ORACLE_SID=bob (check the set command syntax)
Sam
-
Hello SAM,
I have already set the environment variable ORACLE_SID=BOB
Thanks,
Nikee
-
So does that mean that its working now?
Sam
-
Hello Sam,
The answer is 'NO, it is not working'.
I have opened this message after testing all kinds of possibility options.
Thanks,
Nikee
-
Check your $ORACLE_HOME/bin and see how many different svrmgrl.exe are there. I think there has to be one of svrmgrl##.exe Could you try using that and see whether it would go through? If nothing works, could your bounce your system and see whether it would work. BTW, is the server is on the same system where you are trying now?
Sam
-
One other thing is that there should not be any space between the env variables
set oracle_sid = bob Wrong
set oracle_sid=bob Correct
Try it and let me know of the status.
Sam
[Edited by sambavan on 07-18-2001 at 03:19 PM]
-
Hello Sam,
I am unable to start the listener from the command mode.
ie.
D:\>lsnrctl start
LSNRCTL for 32-bit Windows: Version 8.1.7.1.0 - Production on 18-JUL-2001 17:05:05
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
(System is just hanging out here. Do you know the reason for this.)
I feel that this is causing the main problem.
Thanks,
Nikee
-
Since you are on Windows, you have to start the lister through the services.
start --> control --> ... --> services
There you could stop and start the listeners and etc.
check that out.
Sam
-
Sam,
I am able to start and stop the listener service through the services.
But I am unable to start and stop the the listener service from the command promt. i.e. D:\>lsnrctl start
Thanks.
Best regards,
Nikee
-
In windows that command prompt functionality doesn't work.
Sam
-
solution
Hi, 17th Aug 2001 21:32 hrs chennai
Server description
============
O/S==>win2000 service pack1
Oracle ==>8.1.6
Project Development
Problem Description
=============
I found a solution for this .
I had the same problem today and browsed the forum for simillar kind of problem “ORA-12560: TNS: protocol adapter error”
Luckily with my good old friend sambavan name combination of search along with error number yielded this thread.
But initially in the morning i had the services marked as STARTING in control panel==>services==>oracleservice
This is problem is particularly appearing on oracle on win2000.
Many threads has also been reported on the same in this forum.
http://www.dbasupport.com/forums/sho...threadid=13505
Then i had to resort to startup force from svrmgrl for the developers to work on a project.
Then after few hours the problem has turned up to the same error as reported in this thread.
Since the db on the server pertained a development team i had to up the DB take a full DB export and do away with win2000 to winnt for future.
The solution for the problem i did was as follows
Solution
=====
1)I first removed the old oracle service from ORADIM utility
2)Created a new service from ORADIM (create the pfile in E:\Oracle\Ora81\DATABASE folder)
3)set oracle_sid=service_name(in my case i kept the same service name)
Note:After removing service or creating the service bounce back the server.
4) Files to modify:
listener.ora==>
Set the new SID_NAME in this file instead of the old one.
tnsnames.ora==>
set the new SERVICE_NAME ||rly here
init.ora==>
instance_name = new_name
service_names = new_name
6)in E:\Oracle\Ora81\DATABASE ==>copy the existing INIT.ora file and create a one simillar to the new one name.
7)Now before opening the svrmgrl set oracle_sid=
Wow i opened it successfully and took the full db export dump
and imported safe to another server.
But still if i once again shutdown and restart the old server the same error occurs.
I think the problem should be with TCP/IP mainly on win2000.
Further R&D required.
Cheers
Padmam
-
Did you get to apply the patch for the 8.1.7 and see whether this problem still exists? Is your win2000 using SP2. If not could you try putting the SP2 then the 8.1.7 latest patch and see whether the problem persists... Curious to know, but very lazy to try :(
Sam