-
Err in RMAN
Hi
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 9.2.0.4.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
scott/tiger@test
ERROR:
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.
Last edited by ams-jamali; 03-12-2008 at 08:29 AM.
-
hi
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
-
hi,
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.
-
Hi
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:
Code:
orapwd file=orapw<SID> password=<password> entries=<#_of_expected_SYSDBA_users>
-
hi
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
test
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|