need help badly....

[Trina]

Hi everyone,
when i startup the pfile, it gives me an error message:
ORA-12560: TNSrotocol adapter error.

How can I fix it?

[Trina]

I don't know why the green face is on there, the error is
ORA-12560: TNS PROTOCOL ADAPTER ERROR

[sambavan]

Did you get to make any changes in the tnsnames.ora file, such as changing the type of protocol adaptor to be used and etc? If not could you please confirm what is the protocol addoptor you use for this service, such as TCP/...


Sam

[Trina]

the protocol is TCP.

[Trina]

Here is what happen.

My co-worker logged on to sqlplus and gave her an error message:
'ORA-01033: ORACLE initialization or shutdown in progress.'
Then, she went to the svrmgrl to shutdown the database. It said that the database
is not on.

When I start the svrmgrl and start the pfile, it gives me 2 error messages:
1. LCC-00161: Message 161 not found;
product: RDBMS; facility: MGR

2. ORA-12560:
TNS: protocol adapter error

I checked out listener.ora and tnsnames.ora, and the protocol shows as TCP. PLease
give me as much advise as you can. Also, the client and server is on one machine.

[sambavan]

What is your OS? What is your database version?

Check your alert log to see the cause of the problem!!

IF you are on Unix or any Unix flavoured environment, could you please give me some more information?

1. How many instances that you run on it?
2. Can you afford to bounce the server if you cannot bring this instance up? (worst case scenario)



First of all, go ahead and check your environment setup and make sure that they are all pointing to the correct places.

Confirm the
ORACLE_SID=
ORACLE_HOME=
LD_LIBRARY_PATH=
ORACLE_BASE=

Then start the server manager and

SVRMGR> connect sys/passwd as sysdba
SVRMGR> startup nomount
SVRMGR> alter database mount;
SVRMGR> recover database;
SVRMGR> alter database open;


When you encounter LCC-00161, could you please let me know at what point that you are getting it. It is also possible during this process you could get "end-of-file-communication" error message. Don't worry if you were to encounter one.

If it does not come up smoothly, the next step is to bounce your server, to fixup the dangling resources to start with.

The person on the below mention thread too happen to enconter the similar LCC and it got fixed when he reset the environment and the problem as a whole got fixed when he had restarted the server.

http://www.dbasupport.com/forums/sho...threadid=10098


IF you have any questions please let us know.


Sam

[Trina]

OS = NT
DB version = 8.1.6

[sree_sri]

--------------------------------------------------
SVRMGR> connect sys/passwd as sysdba
SVRMGR> startup nomount
SVRMGR> alter database mount;
SVRMGR> recover database;
SVRMGR> alter database open;
-----------------------------------------
No need to startup nomount.

directly you can startup mount

svrmgr>connect sys/passwd as sysdaba
svrmgr>startup mount
svrmgr>recover database;
svrmgr>alter database open;
--------------------------------------------
Trina,

Go to command prompt
type set command and see what the env parameters.
If you see the ORACLE_HOME,ORACLE_SID and other paramters then it's fine, Else
set ORACLE_HOME=
set ORACLE_SID=
Then connect to svrmgr and follow the above steps. Good Luck.

[sambavan]

Could you confirm that the listeners are up and running. On the dos prompt issue:

lsnrctl status


Sam

[Trina]

The listener is on. We found out that in the NT server 4.0 registry, it does not have
the Oracle_sid there.