Err in RMAN
I have Oracle9.2,RHlinux.(two separate system test & test1)
When i tried to connect to target database it shows as
rman target sys@test
Recovery Manager: Release 188.8.131.52.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
target database Password:
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
then i tried with sql to connect to that target DB(test) from test1
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
then i tried $ tnsping test
it works properly
If i log into test DB(logged directly into that machine)everything is working properly.
everything in the sense it is open and working.
create a password file
check the remote_login_password=exclusive
set the ORACLE_SID
grant sysdba to RMAN user
you connect to the target database like
rman target username/password@alias
SQL> grant sysdba to rman;
grant sysdba to rman
ERROR at line 1:
ORA-01990: error opening password file '/opt/ora9/product/9.2/dbs/orapw'
ORA-27037: unable to obtain file status
Is it necessary to give sysdba privilege to rman?
i tried with rman target username/password but same error prevails.
It is necessary to give sysdba priviege to RMAN.
do you have the password file in the dbs directory.
Oracle indicate that this error is generated if the instance/SID specific password file does not exist and the init.ora parameter ‘REMOTE_LOGIN_PASSWORDFILE’ is set to ‘EXCLUSIVE’ or ‘SHARED’.
create the password file if you dont have
orapwd file=\PWD.ora password=oracle
To clarify the orapwd command, you may want to ensure you are in $ORACLE_HOME/dbs directory prior to running the orapwd command and issue:
orapwd file=orapw<SID> password=<password> entries=<#_of_expected_SYSDBA_users>
i have deleted old one and recreated pwd file
$ orapwd file=orapwtest password=oracle entries=7
then i granted permission to rman the same error repeats
What is the output of echo $ORACLE_SID
[oracle@dbs]$ echo $ORACLE_SID