| SP2-0640: Not connected [message #180180] |
Fri, 30 June 2006 08:58  |
pyaranoid
Messages: 5
Registered: June 2006
|
Junior Member |
|
|
Hi Gurus,
I have a weird problem all of a sudden. My Oracle DB is working properly till yesterday. When i tried connecting to it today using scott/tiger@orcl its not accepting.
So i entered as system/system..it connected
when i tried to select instance_name from v$instance; it is giving me error
SP2-0640: Not connected
Please find me a solution asap
Thanks
Suresh
|
|
|
|
| Re: SP2-0640: Not connected [message #180181 is a reply to message #180180] |
Fri, 30 June 2006 09:05  |
wpaillan
Messages: 35
Registered: March 2005
Location: Santiago - Chile
|
Member |
|
|
hi
SP2-0640 Not connected.
PASSW[ORD] [username]
Cause: The PASSWORD command was issued when there was no connection to the Oracle instance.
Action: Connect to the Oracle database before re-issuing the PASSWORD command.
|
|
|
|
| Re: SP2-0640: Not connected [message #180183 is a reply to message #180181] |
Fri, 30 June 2006 09:10 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Well, that was helpful.
It doesn't look like your database is up.
Have a look in the alert log, and see if that reports any recent errors.
|
|
|
|
|
|
|
|
| Re: SP2-0640: Not connected [message #454915 is a reply to message #180180] |
Sat, 08 May 2010 09:07 |
keepitsimple07
Messages: 1
Registered: May 2010
Location: india
|
Junior Member |
|
|
hi all,
i have installed Oracle10g on Solaris10[x86]
i can open my browser, and can login to
http:/ / localhost:1158 / em fine
using
username; sys
password; --password--
connect as; SYSDBA
however when i try to login to SQLPLUS on the command line, using the command 'connect'
and entering the above username and password, it doesnt let me login saying; invaid username and password.
so, how do i login to SQLPLUS?
please let em know
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
