Skip to Main Content

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!

ORA-12170: TNS:Connect timeout occurred

Tony007Apr 24 2017 — edited Apr 24 2017

hi am in window 7 running database 12c am geting this error when doing this

SQL> connect /as sysdba

ERROR:

ORA-01017: invalid username/password; logon den

SQL> connect sys as sysdba

Enter password:

Connected.

SQL> alter user usernmae identified by username;

alter user username identified by username

           *

ERROR at line 1:

ORA-01918: user 'usernmae' does not exist

SQL> alter session set container=dbname;

Session altered.

SQL> show_conn;

SP2-0158: unknown SHOW option "_conn"

SQL> show conn_name;

SP2-0158: unknown SHOW option "conn_name"

SQL> show con_name;

CON_NAME

------------------------------

DBNAME

SQL> alter user ils identified by ils;

User altered.

SQL> connect iUSERNAME/USERNAME@DBNAME;

ERROR:

ORA-12170: TNS:Connect timeout occurred

This post has been answered by Rob the Real Relic on Apr 24 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2017
Added on Apr 24 2017
7 comments
4,558 views