Hi Mark,
Please allow me ..
---------------------------------
Hi Sharath,
These errors are the first few rocks that are but the first steps. a little bit of permutation and combination will help. I am adding my experience to your post may be helpful .
First you may want to understand what tnsnames.ora does.
I usaually think of it as a entry in telephone directory Lets take an example
----start ----
a.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 145.45.78.56)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
----end ----
Just by saying username/password@a.world we get connected to database but internally this a.world is mapped to the whole slew of information.
a.world (This "world" usaually comes from sqlnet.ora you can also try without this world and database may still let you connect)
Speaking again of the slew of information. . .
(PROTOCOL = TCP)
(Host = 145.45.78.56)
(Port = 1521)
this is what you already know.. the SQL net connection is TCP , and connecting to Host machine with IP as 145.45.78.56 (Best to give IP instead of machine names as it picks more dependencies ) and lastly the port number. This is the port number where Listener is listening for connections. (YOu must have given this port number during the time of installation )
(CONNECT_DATA = (SID = ORCL)
Now this is very important part sometimes it is SID and sometimes it is service name (orcl.oracle.ind.com or something long like servicename instead of SID which is short in which case it would be orcl) the difference between the two being service name is longer then SID and also gives the domain name in which the database was installed. (If I remember correctly it was before 8.1.6 that service name was used and after that SID works perfectly fine)
Having said all this ..BLAH BLAH... now is time for a quickie.. To solve connection woes (like yours ).. I have always found this DUMMY entry very useful when I make a new entry in tnsnames.ora
A few caveats --
Do NOT mess with the braces that contain the entry
DO NOT change the indentation (I am not sure Why I am not able to retain the indentation !!! )
Just chage the information to what is now required
lastly check what is there in sqlnet.ora (should be there with the tnsnames.ora file )
Now is a time to come back to your error messages.. these also tell a tale.
ORA-12203 : TNS : unable to connect to destination.
(Actually you encounter this error when the client from where you are connecting can not find the machine where this database is installed may be a typo in the HOST parameter of tnsnames.ora or may be the network cable at the back of computer is loose --tighten it )
ORA-12154 : TNS : Could not resolve service name.
well .. you can consider checking the SID parameter To double check what is your service name you might want to look at init.ora file (8.1.7 should have it Oracle 10g .. has spfile AFAIK)
ORA-12514 : Message 12514 not found: product=RDBMS80:facility=ORA
This usaually happens when the Oracle home from where you are trying to connect to the database is goofed up
I would suggest trying any other SQL plus shortcuts that might be there on the client machine.. well there should also a perfect explanation for this .. but this POST is already very long... and I am afraid you might be asleeep......zzzzzzz ZZZZ
hope it connects
Choudhary
The tnsnames.ora will be in ORACLE_HOME/net80/admin (Forms default tnsnames.ora path ) against ORACLE_HOME/network/admin (database default tnsname.ora path )
[ December 15, 2003: Message edited by: sunil choudhary ]
[ December 15, 2003: Message edited by: sunil choudhary ]