In my RAC(10.2.0.1.0) having 2 nodes on Solaris 10.

Once these 2 nodes getting reboot and after that I try to connect with DB through SQL prompt it shows me below mentioned error:
===============================================================
sqlplus "sys/sys123@newracdb as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 23 00:22:46 2008

Copyright © 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor:
================================================================
There is not any single modification in Listener/Tnsnames.ora file once the setup successfully finished...
I'hv enclosed listener and tnsname here for reference purpose.

Can anyone suggest me what are the possibility for this error?

Thanks,
Swati Desai

Connect to the database locally (that is, go to the server, log in, and type sqlplus / as sysdba). Then enter 'alter system register;' and see if that does the trick.

Hi,

I try with you are suggestion but it shows me an IDLE INSTANCE as below:
=============================================
sunblade2:orarac$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 23 20:04:48 2008

Copyright © 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> alter system register
2 ;
alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
==============================================

what to do now?

start up your database as it isnt started

How can I startup? please see the output in my last reply.

Swati,

"How can I startup? "

You have a RAC system and you don't how how to start your own database?

This does not sound right. Is this a joke?

Hi,

My previous comments is only for Dave's replied(Because I already shown the Output) not in general..

Thanks !!!

you seriously saying you dont know how to start a database?

Wow, a senior DBA who does not understand how to start an Oracle database. That just amazes me. My advice- read the Oracle concepts manual and DBA administration guides. Both available online from OTN will tell you how to start and stop an Oracle database.

Hi Swati,

If you need to get going fast on RAC, get the 10g RAC book. It has diagnostic scripts and complete instructions for all RAC operations:

http://www.dba-oracle.com/bp/bp_book18_10g_rac.htm

hi swati,
just give the command startup from sqlplus promt or give this command srvctl start service -d <database_name>.