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 22.214.171.124.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.
03-12-2008, 08:38 AM
create a password file
check the remote_login_password=exclusive
set the ORACLE_SID
grant sysdba to RMAN user
03-12-2008, 08:44 AM
i would try that
03-12-2008, 08:50 AM
you connect to the target database like
rman target username/password@alias
03-13-2008, 12:25 AM
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.
03-13-2008, 12:37 AM
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
03-13-2008, 01:15 AM
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: