| after shutdown ORA-12514 [message #392821] |
Thu, 19 March 2009 07:10  |
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 #392857 is a reply to message #392845] |
Thu, 19 March 2009 09:02  |
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 #393014 is a reply to message #392869] |
Fri, 20 March 2009 00:38 |
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 #393133 is a reply to message #393035] |
Fri, 20 March 2009 07:56 |
joy_division
Messages: 4963
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
