Home » RDBMS Server » Server Administration » ORA-12560 (Oracle 8.1.7)
ORA-12560 [message #376305] Tue, 16 December 2008 21:28 Go to next message
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 #376348 is a reply to message #376305] Wed, 17 December 2008 01:34 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
One possible solution might be to put those commands in a .BAT file, create a shortcut to it on you desktop, and just click on it when you want to start the database Smile
Re: ORA-12560 [message #376394 is a reply to message #376348] Wed, 17 December 2008 03:46 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #376571 is a reply to message #376570] Wed, 17 December 2008 21:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check your registry in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 and see if ORACLE_SID is set. In addition, can you verify that ORA_AFRES_AUTOSTART is set to TRUE in the registry?
Re: ORA-12560 [message #376851 is a reply to message #376571] Thu, 18 December 2008 21:42 Go to previous messageGo to next message
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 #376859 is a reply to message #376851] Thu, 18 December 2008 22:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check ORA-27101: shared memory realm does not exist .
Re: ORA-12560 [message #377238 is a reply to message #376305] Mon, 22 December 2008 01:37 Go to previous messageGo to next message
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
Re: ORA-12560 [message #377313 is a reply to message #377238] Mon, 22 December 2008 05:44 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Use %ORACLE_HOME% on Windows:
C:> echo The current ORACLE_HOME is %ORACLE_HOME%


Previous Topic: DBCA widnow is very slow
Next Topic: Table not showing dba_tab_modifications(10g)
Goto Forum:
  


Current Time: Fri Dec 09 15:53:28 CST 2016

Total time taken to generate the page: 0.33163 seconds