Error
rucha
SQL*Plus: Release 8.0.3.0.0 - Production on Tue Dec 22 20:26:57 2009
(c) Copyright 1997 Oracle Corporation. All rights reserved.
ERROR:
ORA-12203: TNS:unable to connect to destination
Whenever i write username:scott
and password: tiger
then this error occurs.
Please help me out!!!
hpuxrac
snip
What destinations are you able to connect to successfully?
Is scott/tiger a valid username/password combo on any destination?
Man I haven't seen 8.0.3 for a real long time!
ddf
You apparently do not have the ORACLE_SID variable set in your
environment, so Oracle is looking to remotely connect to an instance
named ORCL and since there is no ORCL configured in your local
tnsnames.ora file (if you even have one created) you're unable to
connect. Also, there is no default user named SCOTT, nor is that user
account created when creating a database. Why you're using 8.0.3 when
11.2.0 is out, 11.1.0 has been out for a while and 10.2.0 has been
out even longer is a mystery. You do not mention which operating
system this database runs under so it's difficult to give you
instructions on how to set the ORACLE_SID variable without possibly
confusing you.
You need a basic course in Oracle; you also need to know the SID of
your database and if that database is running. I will not provide
such a tutorial in this thread. You can read here:
http://www.cuddletech.com/articles/oracle/node12.html
and come back to ask specific questions.
David Fitzjarrell
Mladen Gogala
> SQL*Plus: Release 8.0.3.0.0 - Production on Tue Dec 22 20:26:57 2009
---------
The problem is here. You should make to look like this:
[oracle@lpo-oracle11-01 ~]$ sqlplus scott/tiger
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 22 13:30:10 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
SQL>