James Briar Messages: 72 Registered: January 2002 Location: Morden (South London)
Member
If i run a simple batch script called jim.cmd (On an NT server) the script works fine but if i try to run the same batch script in say a few mins time using the "at" command i get the error messages "RMAN-04005: error from target database" and "ORA-01031: Insufficient Privileges".
The jim.cmd file contains :-
set ORACLE_SID=imptest
rman < e:jim.sql > e:jimlog
Mahesh Rajendran Messages: 9777 Registered: March 2002 Location: oracleDocoVille
Senior Member
this is bug. Workaround is
to create a passwordfile using orapwd utility
then add initsid.ora entry and restart.
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
grant sysdba/sysoper to RMAN user
svrmgrl> grant sysdba to <user>;
svrmgrl> grant sysoper to <user>;
Now try again.
James Briar Messages: 72 Registered: January 2002 Location: Morden (South London)
Member
I've tried your fix but it did not work. I did :-
e: orapwd file=e:oracleora81databasepwdimptest.ora password=change_on_install entries=5
e: set ORACLE_SID=imptest
e: sqlplus internal
SQL> grant sysdba to sys;
SQL> grant sysoper to sys;
Also the parameter file had the entry "remote_login_passwordfile=exclusive" already set and i shutdown and restarted the implive database.
James Briar Messages: 72 Registered: January 2002 Location: Morden (South London)
Member
It now works after setting up the password file etc. I had to amend jim.sql and change "connect target /" to "connect target sys/change_on_install" and now the script runs ok. The script still fails with the RMAN-04005 error if i code "connect target /" in the file. I'll stick with coding "connect target sys/change_on_install" in the jim.sql file from now on.
dave604 Messages: 2 Registered: April 2009 Location: Vancouver, Canada
Junior Member
Yes I know I responded to an old post, but that's because people with the same problem still find the post via google, and I wanted to share how I resolved the problem.
Yes I know I responded to an old post, but that's because people with the same problem still find the post via google, and I wanted to share how I resolved the problem.
Some/many/most Original Posters NEVER search for solution before postings their FAQ again, again, again.
you should check whether your current logged in ( operating system ) user is member of ora_dba group in windows os.Administrator of the server can add you to ORA_DBA Group
] 
Members
Search
Help
Register
Login
Home
