as per the procedure i set up all the oracle environment and given the system user password as complex one which include '@' character.
after that when i tried to connect to my database its giving me error ORA-12170: TNS:Connect timeout occurred
after doing lots of searches i found the solution that oracle use the connection string which is user name and password with combination of user@password
the problem in this is my password is also have '@' character so connection string is not correct.
then i change the password of system user to simple one and its started working......
S:\>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Aug 24 16:48:32 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> alter user <username> identified by <Password>;
User altered.
SQL>
after that when i tried to connect to my database its giving me error ORA-12170: TNS:Connect timeout occurred
after doing lots of searches i found the solution that oracle use the connection string which is user name and password with combination of user@password
the problem in this is my password is also have '@' character so connection string is not correct.
then i change the password of system user to simple one and its started working......
S:\>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Aug 24 16:48:32 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> alter user <username> identified by <Password>;
User altered.
SQL>
No comments:
Post a Comment