Can't log on to SQLPLUS

From: Peter Chatterton <peter_at_chatterton.name>
Date: Mon, 11 Feb 2002 22:21:00 -0500
Message-ID: <6Q%98.11313$NP4.1294680@news20.bellglobal.com>

From dos in the specified directory I tried:

SQLPLUS sys/change_on_install @install_sys_helper_packages.sql and got:

"ORA-28009 connection to sys should be as sysdba or sysoper
"Cause: CONNECT sys/password is no longer a valid syntax.
"Action: Try connect sys/password as sysdba or connect sys/password as
sysoper.
But why is it talking about 'connect'?

And doesn't SYS have enough dba type rights anyway?

I also logged on to sql plus as system and tried:

grant sysdba to sys
and got a 2!

I'm trying to install the xml helper packages in appendix A of the o'reilly book 'building xml apps'.

Thanks for your attention, if not help,
Peter. Received on Mon Feb 11 2002 - 21:21:00 CST