Re: ORA-28009
From: joel garry <joel-garry_at_home.com>
Date: Mon, 15 Feb 2010 11:33:40 -0800 (PST)
Message-ID: <ed30f3bc-42bb-4e84-a2dc-c20d78657135_at_s25g2000prd.googlegroups.com>
On Feb 14, 2:45 pm, syd_p <sydneypue..._at_yahoo.com> 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
> 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
Date: Mon, 15 Feb 2010 11:33:40 -0800 (PST)
Message-ID: <ed30f3bc-42bb-4e84-a2dc-c20d78657135_at_s25g2000prd.googlegroups.com>
On Feb 14, 2:45 pm, syd_p <sydneypue..._at_yahoo.com> 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
> 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
Have you set things up so someone can connect remotely as sys there? Connecting locally merely means the local user has group rights. http://www.orafaq.com/wiki/Oracle_database_Security_FAQ#Managing_administrative_.28privileged.29_users_and_password_files
jg
-- _at_home.com is bogus. http://news.techworld.com/security/3212681/spam-hits-google-buzz-already/?intcmp=nws-hm-lReceived on Mon Feb 15 2010 - 13:33:40 CST