Re: ORA-28009

From: joel garry <>
Date: Mon, 15 Feb 2010 11:33:40 -0800 (PST)
Message-ID: <>

On Feb 14, 2:45 pm, syd_p <> wrote:
> 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

Have you set things up so someone can connect remotely as sys there? Connecting locally merely means the local user has group rights.


-- is bogus.
Received on Mon Feb 15 2010 - 13:33:40 CST

Original text of this message