| ORA-12560 [message #376305] |
Tue, 16 December 2008 21:28  |
alister
Messages: 101
Registered: August 2007
Location: India
|
Senior Member |
|
|
Hi Everybody,
I had installed Oracle 8.1.7 on a machine. But When I use SQL Plus I get ORA 12560 TNS Protocol adaptor error. So I gave the following commands:
D:\ set ORACLE_SID=AFRES
D:\svrmgrl
svrmgrl:\ connect internal
svrmgrl:\ startup
Now the database starts. Every time I boot the system I have to follow this set on instructions.
I have checked the services and all oracle services are set to automatic and have been started.
I have also tried searching for ORA-12560 on this forum but could not get anything that could help me.
Can someone please help me.
Thanks
Alister
|
|
|
|
|
|
| Re: ORA-12560 [message #376394 is a reply to message #376348] |
Wed, 17 December 2008 03:46  |
samg4ug
Messages: 33
Registered: July 2007
Location: India
|
Member |
|
|
Hi,
You are trying to connect from the same node itself or from some other node.
And have you created a listener using netca ?
Regards,
Sam G
|
|
|
|
| Re: ORA-12560 [message #376402 is a reply to message #376305] |
Wed, 17 December 2008 04:03 |
TomG
Messages: 11
Registered: December 2008
|
Junior Member |
|
|
Hi,
The ORA-12560 occurs generally when :
- ORACLE_SID is not set correctly (seems OK here)
- The service is not started (seems OK here)
- Using Terminal Services (with bequeath connection)
- The SID name includes special characters (seems OK here)
So :
Do you use TSE ?
Does problem occur with *local* connection ?
Does it work via listener ("@db") ?
Tom
|
|
|
|
| Re: ORA-12560 [message #376570 is a reply to message #376305] |
Wed, 17 December 2008 21:27 |
alister
Messages: 101
Registered: August 2007
Location: India
|
Senior Member |
|
|
Hi Everybody,
I tried putting it in a .bat file, inclulded it in the startup and started the machine. The .bat file works only upto
D:\svrmgrl
When the prompt comes to
SVRMGRL:\ It waits. This part does not work in the .bat file.
I am connecting it from the same node.
I do not know whether I am using TSE, and about using via listener ("@db"). What is TSE?
When I installed Oracle I let it do everything. I have not created the listner via netca. What is netca?
Thank you all very much.
Alister
|
|
|
|
|
|
| Re: ORA-12560 [message #376851 is a reply to message #376571] |
Thu, 18 December 2008 21:42 |
alister
Messages: 101
Registered: August 2007
Location: India
|
Senior Member |
|
|
Hi Everybody,
In HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 there is no ORACLE_SID. I created it. ORA_AFRES_AUTOSTART is set to TRUE in the registry. Now I restarted the machine. Now I am getting
ORA - 01034 - Oracle not availabe
ORA - 27101 Shared memore realm does not exist
Thanks a lot.
Alister
[Updated on: Thu, 18 December 2008 21:44] Report message to a moderator |
|
|
|
|
|
| Re: ORA-12560 [message #377238 is a reply to message #376305] |
Mon, 22 December 2008 01:37 |
alister
Messages: 101
Registered: August 2007
Location: India
|
Senior Member |
|
|
Hi
how do I get the $ promt for checking
$ echo $ORACLE_HOME
$ /app/oracle/817 << Correct
Thanks
Alister
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
