RMAN-04005: error from target database: ORA-01031: insufficient privileges
DBA2011Nov 5 2009 — edited Nov 6 2009Trying to duplicate db
I checked orapwd file seems ok,
oracle:tulpcorpadb03$ rman TARGET sys/*****@wcmp AUXILIARY /
Recovery Manager: Release 9.2.0.8.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
I findout this, this is prod db and not allowed to bounce to change, any other workaround to make rman duplicate work without changing this?
SQL> show parameter password
NAME TYPE VALUE
-----------
remote_login_passwordfile string NONE
SQL> connect /as sysdba;
Connected.
SQL> select * from v$pwfile_users;
no rows selected