Date: Sun, 14 Feb 2010 14:45:45 -0800 (PST)
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