|
-
 Originally Posted by prav_saras
Hi,
Thanks for yr reply.
sqlplus is wroking, but not able to coonect by using anyother software.
Is there anything about the tnsnames.ora?
There should be one tnsnames.ora or can have two tnsnames.ora,
coz i guess there is something wrong with it
regards,
praveen
You have somewhat answered yourself. . See you can connect through sqlplus, meaning its the problem with your 'other software'. Check your tnsnames.ora in the client machine, you must have jumbled up with either sid, service name or port. Make sure you're connecting to the correct instance in the correct port with correct sid or service name. You can refer to listener.ora in server, to see which port will listen for which instance.
HTH
gtcol
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote