Oracle Database Discussions

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!

Not able to connect to Oracle using oracleuser/password@oracle_sid

1008348May 11 2013 — edited May 12 2013

Hi Guys ,

I am very new to oracle and trying to learn step by step .Today i installed Oracle 10g , after creating user , i am not able to connect to oracle using oracle sid . Directly i am able to connect by giving only username and password.

when i am trying to connect by :-

sqlplus username/password@SID then below error is coming:-

ERROR:
ORA-12170: TNS:Connect timeout occurred

I ahve checked my oracle sid by :-

select instance_name from v$instance;

and when i am trying to do :-

C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=tns_entry_name.lo
cal))(ADDRESS=(PROTOCOL=TCP)(HOST=218.93.250.18)(PORT=1521)))
TNS-12535: TNS:operation timed out

Please help me where i am wrong .

I am using windows 7 .

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2013

Added on May 11 2013

#connection, #general-database-discussions, #oracle

5 comments

349 views