SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-12154

user520824Sep 3 2009 — edited Sep 3 2009

I am using oracle 10g. I can connect the database thru sql plus and using Toad and working fine.
however the access is denied when trying to connect thru Rapid SQL.
Can anyone help me. I get error when i try to connect thru Rapid SQL

ORA-12154: TNS: could not resolve the connect identifier specified.

Please help

Edited by: user520824 on Sep 3, 2009 12:26 PM

Anurag Tibrewal

Hi

Check if the connect string you are providing exist in the tnsnames.ora file. If not then add it.

If it exists then you might be having multiple oracle home, in that case find out the oracle home which Rapid SQL use it and add the entry there.

If not above then please post the tns entry.

Regards
Anurag Tibrewal

Hoek

I'd say: stick to SQL*Plus and/or your other interface.
I have no clue what Rapid SQL pretends to be (and I don't want to know) but check:

http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/troublestng.htm#CEGJAGGH
But anyway: I'd just stick to the SQL*Plus prompt.
Or download SQL Developer for free from http://www.oracle.com/technology/software/products/sql/index.html

1 - 2

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2009

Added on Sep 3 2009

2 comments

311 views

SQL & PL/SQL

ORA-12154

Comments

Post Details