| Connecting [message #53759] |
Wed, 09 October 2002 19:55  |
delPinux
Messages: 1
Registered: October 2002
|
Junior Member |
|
|
Why can't I log into SQL*PLUS using
user: system, password: manager like everybody can?
I get an error message:
ORA-12203: TNS could not connect
Help please! i need to get an reverse engineering program done!
thanks
|
|
|
|
| Re: Connecting [message #53760 is a reply to message #53759] |
Wed, 09 October 2002 20:24  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
Hi,
Make sure that the Listener is up and Running.
Database is up and running..
Is the system passwors is Manager ? (Are u sure ? )
chech whether u want to connect to a remote Database, where in u r expected to produce a host string...
Check all the abov issues
|
|
|
|
| Re: Connecting [message #54602 is a reply to message #53759] |
Fri, 22 November 2002 16:46 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
The ora-12203 is a general error that basically says that the client was unable to connect to the destination with the information it was provided.
Lookup the sqlnet.log on the erroneous machine. You
should see a set of errors followed by the 12203 error. Or the other best way to go around this problem is to setup sqlnet tracing and see the real errors that caused the failure.
Check you TNS_ADMIN, ORACLE_HOME and ORACLE_SID are setup correctly.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
