OraFAQ Forum: Backup & Recovery » connect sys/*** as sysdba errors

Home » RDBMS Server » Backup & Recovery » connect sys/*** as sysdba errors

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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!!!

Report message to a moderator

Re: connect sys/*** as sysdba errors [message #154173 is a reply to message #154169]

Fri, 06 January 2006 02:01

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Are you using Windows???

Is your Oracleservice Up and running??

Start the service and try again.

you can search the forum for the same error. Its been answered so many times.

Report message to a moderator

Re: connect sys/*** as sysdba errors [message #154177 is a reply to message #154173]

Fri, 06 January 2006 02:10

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

I am using Window 2000;
I must start what services?;

just I have two database name is TEST1, TEST2 and I connect sys/*** as sysdba with TEST1 correct. But when I drop database TEST1 then I connect sys/*** as sysdba with TEST2. I get a error

please tell me why?

Report message to a moderator

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.

Report message to a moderator

Previous Topic:	backup error
Next Topic:	How does one put a database into ARCHIVELOG mode?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 03:00:18 CDT 2024