Re: ORA-28009

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 15 Feb 2010 13:45:27 +0100
Message-ID: <4b7941eb$0$22933$e4fe514c_at_news.xs4all.nl>

Op 14-2-2010 23:45, syd_p schreef:
> Hi,
> I am running a shell script which call a perl script which uses DBI to
> connect to a remote (ie another server) which creates schemas ie table
> spaces, users, tables in the waiting DB.
>
> Or rather it does not:
> Database Connection Error: ORA-28009: connection as SYS should be as
> SYSDBA or SYSOPER (DBD ERROR: OCISessionBegin)
> The problem is as follows:
> ./create_stuff.sh<database type> <database name> <host> <username>
> <password> <port>
>
> I ran one of the many scripts locally on the unix command line with
> the hardcoded string "sqlplus sys as sysdba/bloggs" and that works OK.
>
> The problem is that the shell script, calls more shell scripts, calls
> perl scripts and passing in "sys" as a parameter fails at the Oracle
> 10G level cos we need the AS sysdba.
> And if I call the script with "sys as sysdba" "bloggs" (or similar
> tried a few things) it goes wrong big time.
>
> Possibly the answer is to create a user that has the powers of "sys as
> sysdba" or something similar. But I am stuck really...
>
> can anyone help plz?
>
> Syd
>

Try this: username: "sys", database name "DBNAME as sysdba"

Shakespeare Received on Mon Feb 15 2010 - 06:45:27 CST