asked on
Cross connection between oracle DB 11g and oracle developer suite 10g issues
Hi
I have installed oracle database 11g on my pc and recently installed oracle developer suite 10g
I am unable to connect to my database using oracle developer suite It's giving an error that
"ORA-12154:TNS could not resolve the connect identifier specified"
How to solve this problem or can't we connect to database using older version of suite
Kindly answer me this question as soon as possible
Thanks
Hinamansoor
I have installed oracle database 11g on my pc and recently installed oracle developer suite 10g
I am unable to connect to my database using oracle developer suite It's giving an error that
"ORA-12154:TNS could not resolve the connect identifier specified"
How to solve this problem or can't we connect to database using older version of suite
Kindly answer me this question as soon as possible
Thanks
Hinamansoor
Oracle Database
Last Comment
hinamansoor
Are you or have you been able to connect to the database before you installed developer suite? You should know for sure that your DB is up and running and that you can connect. After that, setup the connection in developer suite.
ASKER
yes i am sure db is running successfuly and first time i have installed db11g and dev10g
Thanks
Thanks
Ok, so I assume you were able to connect using sqlplus, can you show the error (screenshot) that you are getting in developer?
ASKER
only the error which is "ORA-12154:TNS could not resolve the connect identifier specified"
nothing else.
sql>connect scott/tiger@hina-----its ok
Thanks
nothing else.
sql>connect scott/tiger@hina-----its ok
Thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
SOLVED this problem by this way thanks for all.
copied these 2 file from database11g--NETWORK--ADMI
DevSuiteHome_1---network-a
1.sqlnet.ora
2.tnsnames.ora
copied these 2 file from database11g--NETWORK--ADMI
DevSuiteHome_1---network-a
1.sqlnet.ora
2.tnsnames.ora