Oracle Database Express Edition (XE)

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!

Cannot connect SYS AS SYSDBA

430221Jan 27 2006 — edited Jan 27 2006

I have Oracle express edition installed on my labtop from which I can connect to the other remote databases.
I can connect as system from sqlplus by typing
SQL>connect SYSTEM@XE
Password: myppwd;

But when I try to connect SYS how do I specify the database I tried
with following which gives error
SQL> connect SYS AS SYSDBA@XE
error:expected SYSDBA OR SYOPER not "sydba@xe"

After connecting as system I tried the following - Idid not give @xe
SQL>connect sys as sysdba
error:TNS:Unable to connect to the destinations.

Can someone help me. I need to create some objects connected as sys
Please help
George

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2006

Added on Jan 27 2006

11 comments

1,210 views