Home » RDBMS Server » Server Administration » after shutdown ORA-12514 (10g)
after shutdown ORA-12514 [message #392821] Thu, 19 March 2009 07:10 Go to next message
ora_baby
Messages: 89
Registered: May 2008
Member
hi

i want to mount database.
i did:
sql> Connected. conn system@orcl as sysdba
 password: **********
Connected.
sql> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
sql> startup mount
2514: TNS:listener does not currently know of service requested in connect descriptor


i saw lsnrctl status before shutdown - Instanse "orcl" status READY
after shutdown i haven't this row

what do i wrong?

[Updated on: Thu, 19 March 2009 07:11]

Report message to a moderator

Re: after shutdown ORA-12514 [message #392825 is a reply to message #392821] Thu, 19 March 2009 07:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Connect locally to start your database.

Regards
Michel
Re: after shutdown ORA-12514 [message #392829 is a reply to message #392825] Thu, 19 March 2009 07:48 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
how can i mount database?
Re: after shutdown ORA-12514 [message #392833 is a reply to message #392829] Thu, 19 March 2009 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer.

Regards
Michel
Re: after shutdown ORA-12514 [message #392838 is a reply to message #392833] Thu, 19 March 2009 08:13 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
i understood you.
what do you mean?
Re: after shutdown ORA-12514 [message #392845 is a reply to message #392838] Thu, 19 March 2009 08:31 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
Connect locally to start your database.


1/ Connect your database server

2/ set your oracle sid

3/ start your database
Re: after shutdown ORA-12514 [message #392857 is a reply to message #392845] Thu, 19 March 2009 09:02 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
ok

now my database is shutdown.

i want to connect to database ORCL
sql> conn system@orcl as sysdba

and
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


next
i start Database Configuration Assistant->Configure
as result i may connect to database ORCL

next
sql> conn system@orcl as sysdba
Enter password: **********
Connected.
sql>


i will try again
sql> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
sql> startup mount
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Re: after shutdown ORA-12514 [message #392859 is a reply to message #392857] Thu, 19 March 2009 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LOCALLY means NO @...

Regards
Michel
Re: after shutdown ORA-12514 [message #392869 is a reply to message #392859] Thu, 19 March 2009 09:15 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Connect your remote server

If windows

set ORACLE_SID=orcl

sqlplus "/as sysdba"

startup 


If linux / unix

export ORACLE_SID=orcl

sqlplus "/as sysdba"

startup 


Babu
Re: after shutdown ORA-12514 [message #393014 is a reply to message #392869] Fri, 20 March 2009 00:38 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
gentlebabu
i want srartup mount database and next i want change archive mode. but after shutdown i can not startup mount

Michel Cadot
i dont understand what do you want to say me
can you explain in terms of an example?
Re: after shutdown ORA-12514 [message #393015 is a reply to message #393014] Fri, 20 March 2009 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try "conn / as sysdba"?

Regards
Michel
Re: after shutdown ORA-12514 [message #393019 is a reply to message #393015] Fri, 20 March 2009 00:51 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
yes, i wrote about it
sql> conn system@orcl as sysdba
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Re: after shutdown ORA-12514 [message #393032 is a reply to message #393019] Fri, 20 March 2009 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't you see the difference between:
Quote:
conn system@orcl as sysdba

and
Quote:
conn / as sysdba


Don't you understand now my sentence:
Quote:
LOCALLY means NO @...


Regards
Michel
Re: after shutdown ORA-12514 [message #393035 is a reply to message #393032] Fri, 20 March 2009 01:48 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
at present i understood you.
thank you
Re: after shutdown ORA-12514 [message #393133 is a reply to message #393035] Fri, 20 March 2009 07:56 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
ora_baby wrote on Fri, 20 March 2009 02:48
at present i understood you.
thank you


I am not sure that this sentence actually means what it says as the below is from a previous message of yours

ora_baby wrote on Thu, 19 March 2009 09:13
i understood you.
what do you mean?

Re: after shutdown ORA-12514 [message #393167 is a reply to message #392821] Fri, 20 March 2009 11:21 Go to previous message
ahudspith
Messages: 26
Registered: January 2009
Location: Avoiding the tax man.
Junior Member
LOL!

When you use "@" you are using Oracle's SQL*Net service.

So... if the listener's not up you'r not going to get very far are you?

Log onto host as oracle.
Set your environment.
sqlplus '/ as sysdba'

It really is that simple.


Adam
Previous Topic: upgrade steps for 10g
Next Topic: insufficient privileges error ORA-01031 when trying to connect as sysdba
Goto Forum:
  


Current Time: Sat Dec 03 22:11:17 CST 2016

Total time taken to generate the page: 0.07687 seconds