Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't log on to SQLPLUS
Are we supposed to guess at what version? And perhaps other bits of useful
information? And is the name of your instance, as aliased in TNSNAMES really
install_sys_helper_packages.sql? Somehow ... I don't think so.
Daniel Morgan
Peter Chatterton wrote:
> 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 Tue Feb 12 2002 - 11:18:20 CST
![]() |
![]() |