Error or-12514 after shutdown

[igor.rmarinho]

Environment information:
* Oracle version: 10g
* Operating system: XP / Winserver 2003

I have a problem, whenever I create a bank (use The database configuration wizard) and I give the

Select all

shutdown immediate

and then I'll give the

Select all

startup mount;

it does not come back ...
Always the error or-12514
Now I'm running on the local machine, but on the server is giving the same problem.
Someone already had this problem and know how to solve?

[igor.rmarinho]

Error Screen [url=http://img37.imageshack.us/i/ora12514.png/]

Uploaded with [url=http://imageshack.us]ImageShack.us

[igor.rmarinho]

Sorry to post again ... But I forgot to post the LSNRCTL status screen
[url=http://img85.imageshack.us/i/lsnrctlstatus.jpg/]

Uploaded with [url=http://imageshack.us]ImageShack.us

[diegolenhardt]

It is connected to SQLPlus as:

does

Select all

 
sqlplus "/ as sysdba" 

You must be doing
SQLPLUS SYS @ SID

[igor.rmarinho]

I'm in SQLPlus like Sysdba

[diegolenhardt]

It seems that you are connecting via Listener, and then clear after it knocks down the local seat to connect again

is using @sid?

[igor.rmarinho]

I am shaking

Select all

sqlplus /nolog 
conn sys@t1/senha as sysdba

Does it have to be otherwise?

[diegolenhardt]

I assume that you are on the machine where the bank is, then it would be:

Windows:

Select all

set ORACLE_SID=t1

Linux

Select all

export ORACLE_SID=t1 
sqlplus "/ as sysdba"

will connect, make the startup that will work ....

When you use the @ T1 you are connecting through the listener, but as you will connect If the bench is out, you said?

[igor.rmarinho]

It worked: D
Thank you Diego !!!
It was 2 days Garrado in this problem!
and the staff talking to me to do things "mirabolantes" possible !!
vlw!

[diegolenhardt]

Tranquil,

needing there, usually things are simpler than they seem..rs

embrace