Re: Can't log on to SQLPLUS

"Peter Chatterton" <peter_at_chatterton.name> wrote in message news:6Q%98.11313$NP4.1294680_at_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.
>
>
>

sqlplus <username>/<password> issues an implicit connect statement In 9i you can't logon anymore as a normal SYS user, you MUST add 'as sysdba' or 'as sysoper'
usually that is best done
sqlplus /nolog
connect sys/<password, please change it> as sysdba @<your file>

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address