connect sys/*** as sysdba errors [message #154169] |
Fri, 06 January 2006 01:40 |
quytc
Messages: 81 Registered: November 2005 Location: Viet Nam
|
Member |
|
|
I have connected database by user SYS,then I run command following.
SQL> connect sys/change_on_install as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
Warning: You are no longer connected to ORACLE.
Can anybody tell me where is error??????
thanks!!!
|
|
|
|
|
Re: connect sys/*** as sysdba errors [message #154184 is a reply to message #154177] |
Fri, 06 January 2006 03:05 |
tarundua
Messages: 1080 Registered: June 2005 Location: India
|
Senior Member |
|
|
Set the environment variable to TEST2 and then try to login
c:\> set ORACLE_SID=TEST2
and even if not successful then first search the forum for the same error , its been discussed so many times.
And even then if it is not solved then post back your problem again.
|
|
|