Re: ORA-28009

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

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
> The problem is as follows:
> ./<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

Original text of this message