Home » RDBMS Server » Server Administration » logging(connection) problem with DBA Studio
logging(connection) problem with DBA Studio [message #136279] Wed, 07 September 2005 05:33 Go to next message
Mitesh Shah
Messages: 24
Registered: August 2004
Junior Member
My Oracle 8i & Developer 2000 is working fine but I can't login in DBA Studio . It gives me error
ORA-12545 - Connect Failed because target host or object does not exist.
ORA-12541 - TNS No Listener.

Please give me detailed procedure to log & creating user & table using DBA Studio.

Thanks once again.

Waiting for your reply.
Re: logging(connection) problem with DBA Studio [message #136292 is a reply to message #136279] Wed, 07 September 2005 07:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Every client will use its won tnsnames.ora.
So DBAstudio might be looking into a different tnsnames.ora.
Check it out.
Re: logging(connection) problem with DBA Studio [message #136999 is a reply to message #136292] Mon, 12 September 2005 12:42 Go to previous messageGo to next message
Mitesh Shah
Messages: 24
Registered: August 2004
Junior Member
Thanks for your reply,

I have checked their are 4 TNSNAMES.ORA FILE. BUT I COULDN'T UNDERSTAND WHAT TO CHECK. I ALSO DONT UNDERSTAND WHAT IS WRITTEN THEIR. EARLIER I USE ORACLE NAVIGATOR TO CREATE USER AND MODIFY TABLES OR IMPORT TABLES. I WANT TO USE DBASTUDIO BUT IT IS CANNOT LOG ON(CONNECTED).

AGAIN My Oracle 8i & Developer 2000 is working fine With each other connection but I can't login in DBA Studio . It gives me error
ORA-12545 - Connect Failed because target host or object does not exist.
ORA-12541 - TNS No Listener.

Please give me detailed procedure to log & creating user & table using DBA Studio.

Re: logging(connection) problem with DBA Studio [message #137002 is a reply to message #136999] Mon, 12 September 2005 13:43 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
copy ORACLE_HOME_USED_BYSQLPLUS/network/admin/tnsnames.ora
to
ORACLE_HOME_USED_by_dbastudio/network/admin/tnsnames.ora

Previous Topic: Oracle problem Simulator software
Next Topic: Fail to load Oracle10g Driver in ODBC
Goto Forum:
  


Current Time: Fri Jan 10 10:38:17 CST 2025