Re: Can't log on to SQLPLUS

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Tue, 12 Feb 2002 17:18:20 GMT
Message-ID: <3C694E5E.F0B98028@ci.seattle.wa.us>

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