ORA_12560 when try to startup a db in W2000
I have a database in W2000 (i no have created the services) when i connect to startup it, i receive the next error:
C:\Documents and Settings\ctornel>sqlplus /nolog
SQL*Plus: Release 22.214.171.124.0 - Production on Mar Oct 9 13:09:49 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
ORA-12560: TNS:error del adaptador de protocolo
How can i resolve the problem,,,arrrr
oerr ORA 12560
12560, 00000, "TNSrotocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors.For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.
Have you set ORACLE_SID?
Also check Listener.
Last edited by PAVB; 10-09-2007 at 08:27 AM.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
It is an environment variable ORACLE_SID being not set.
On the command prompt, type set and see if it is there. Most likely, it is not there. You can do the following:
cmd> set ORACLE_SID=mySId
I have correctly exported the environment variable
And I receive the same error.
why, tell us all why starting the listener is going to have any effect on his problem?
Originally Posted by habeebksa
Just want to make sure, did you do the following
Also, check if you are getting anything in
1) Oracle's alert.log file.
2) Operating system log (MyComputer->Manage->Event Viewer->Application or System)
I am pretty sure you will find something meaningful there.
I need to make some tasks:
1.- I restored the bd from a cold backup,
2.- The service name no were correctly
3.- when you finish of restore the database, create the service like:
oradim -NEW -SID -INTPWD -PFILE
With that you create the service, and now you can make 2 things:
a) Start the service that start the database
b) connect in prompt
connect sys/ as sysdba
" You are connected to an idle instance"
And OK, let you have started the DB.
Thanks for all.
I wait to be of help.
Click Here to Expand Forum to Full Width