Home » RDBMS Server » Server Administration » how can open database when database already shutdown (Oracle 10g)
how can open database when database already shutdown [message #655180] Wed, 24 August 2016 03:03 Go to next message
rayrevan
Messages: 21
Registered: August 2016
Junior Member
how can i open again my database when database already shutdown?

I shutdown database and trying to startup mount, and database disconnect and cant be open cause TNS lintener cant be found.
can anyone help me?
Re: how can open database when database already shutdown [message #655181 is a reply to message #655180] Wed, 24 August 2016 03:11 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
connect locally without using a listener.

Assuming it's a Unix-Like OS, as the Oracle user:

export ORACLE_SID=YourSID
sqlplus "/ as sysdba"
Re: how can open database when database already shutdown [message #655182 is a reply to message #655180] Wed, 24 August 2016 03:11 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
You need to be precise. Are you, for example, getting an error such as this:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Re: how can open database when database already shutdown [message #655183 is a reply to message #655180] Wed, 24 August 2016 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Your question is unclear.
Copy and paste your SQL*Plus session INCLUDING the connection.
Before, Please read How to use [code] tags and make your code easier to read.

Note that you don't need any listener if you are on the database server.

Re: how can open database when database already shutdown [message #655184 is a reply to message #655180] Wed, 24 August 2016 03:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

In addition, you didn't feedback, answer the questions that have been asked and tell us how you solve the problem in your previous topic.
Do it now.

Re: how can open database when database already shutdown [message #655185 is a reply to message #655180] Wed, 24 August 2016 03:16 Go to previous messageGo to next message
rayrevan
Messages: 21
Registered: August 2016
Junior Member
My database isnt local database, but using database server.
in listener i using IP address to get access to database


 ORA-1251: TNS:LISTENER DOES NOT KNOW OF SID GIVEN IN CONNECT DESCRIPTOR  
Re: how can open database when database already shutdown [message #655186 is a reply to message #655184] Wed, 24 August 2016 03:18 Go to previous messageGo to next message
rayrevan
Messages: 21
Registered: August 2016
Junior Member
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 24 15:07:41 2016

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

SQL> connect sys/*****@10.10.11.125 as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Re: how can open database when database already shutdown [message #655187 is a reply to message #655186] Wed, 24 August 2016 03:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

2 posts, 2 different messages! And the first one is wrong:
ORA-01251: Unknown File Header Version read for file number %s
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Connect locally to the database as already said.

Michel Cadot wrote on Wed, 24 August 2016 10:14

In addition, you didn't feedback, answer the questions that have been asked and tell us how you solve the problem in your previous topic.
Do it now.
Re: how can open database when database already shutdown [message #655188 is a reply to message #655187] Wed, 24 August 2016 03:30 Go to previous messageGo to next message
rayrevan
Messages: 21
Registered: August 2016
Junior Member
yeah there 2 error from 2 application i used.

When i trying to connect using toad : TNS dont know SID

When i trying to connect using sqlplus : tns dont know service requested
Re: how can open database when database already shutdown [message #655189 is a reply to message #655188] Wed, 24 August 2016 03:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

As already said, connect locally.

Re: how can open database when database already shutdown [message #655193 is a reply to message #655188] Wed, 24 August 2016 05:33 Go to previous messageGo to next message
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
Senior Member
What is the operating system on the database server?

Can you log in to the database server?
Re: how can open database when database already shutdown [message #655205 is a reply to message #655193] Wed, 24 August 2016 12:26 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Once everything is shutdown the only way to restart the oracle database server is to go in as the oracle user on the unix server hosting the databse or on a windows machine restart the listener and database services as an admin user.

[Updated on: Wed, 24 August 2016 12:26]

Report message to a moderator

Re: how can open database when database already shutdown [message #655210 is a reply to message #655205] Wed, 24 August 2016 20:13 Go to previous messageGo to next message
rayrevan
Messages: 21
Registered: August 2016
Junior Member
Bill B wrote on Wed, 24 August 2016 12:26
Once everything is shutdown the only way to restart the oracle database server is to go in as the oracle user on the unix server hosting the databse or on a windows machine restart the listener and database services as an admin user.
[quote ]What is the operating system on the database server?
Can you log in to the database server?[/quote]

I cant manage to connect to database, so we decide to restart database server and listener.
Thanks for all your response.
Re: how can open database when database already shutdown [message #655221 is a reply to message #655210] Thu, 25 August 2016 02:48 Go to previous messageGo to next message
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
Senior Member
Er, so is the problem now fixed?
Re: how can open database when database already shutdown [message #655222 is a reply to message #655221] Thu, 25 August 2016 02:52 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
I suppose it is if "reboot the server" is considered an acceptable solution. I would fire any "DBA" who did that.
Re: how can open database when database already shutdown [message #655223 is a reply to message #655222] Thu, 25 August 2016 02:58 Go to previous message
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK
Senior Member
I once worked with a SQL Server DBA who convinced management that a daily system restart was best-practice. I despair sometimes...
Previous Topic: user access problem
Next Topic: ORA-00959: While dropping tablespace.
Goto Forum:
  


Current Time: Thu Nov 28 18:52:07 CST 2024