From: syd_p <sydneypuente_at_yahoo.com>
Date: Sun, 14 Feb 2010 14:45:45 -0800 (PST)
Message-ID: <75ef2fa5-c2c9-4710-ac57-63f2ebcb3369_at_k19g2000yqc.googlegroups.com>

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 Received on Sun Feb 14 2010 - 16:45:45 CST

Original text of this message