Help - Search - Members - Calendar
Full Version: Unable to connect RAC database through SQL*plus
Oracle DBA Forums > Oracle > Oracle Forum
Swati Desai
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
andrew kerber
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.
Swati Desai
QUOTE (andrew kerber @ Aug 1 2008, 12:52 PM) *
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?
dave
QUOTE (Swati Desai @ Aug 2 2008, 09:10 AM) *
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
Swati Desai
QUOTE (dave @ Aug 2 2008, 09:26 AM) *
start up your database as it isnt started

How can I startup? please see the output in my last reply.
aussie_dba
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?
Swati Desai
QUOTE (aussie_dba @ Aug 2 2008, 12:09 PM) *
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 !!!
dave
QUOTE (Swati Desai @ Aug 2 2008, 01:28 PM) *
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?
Ben Prusinski Oracle DBA
QUOTE (Swati Desai @ Aug 1 2008, 05:47 AM) *
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


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.
burleson
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
sudipto2579
hi swati,
just give the command startup from sqlplus promt or give this command srvctl start service -d <database_name>.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.