Standby -> ORA-01031: insufficient privileges
- From: "Milen Kulev" <makulev@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 May 2005 22:40:35 +0200
Hello listers,
I am trying to build a standby database (for learning purposes) with RMAN.
The problem is, when I try to connect to the standy instance (which is in
NOMOUNT status),
I am always getting the following error (executed on primary host(host1)):
[host1:orcl:~] ->rman target sys/oracle@orcl auxiliary sys/oracle@stby
Recovery Manager: Release 10.1.0.4.0 - Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1086744555)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
orcl is my primary database
stby is my standby database
Even on the standby machine(host2), when I execute the following statement,
I am getting the same error:
[host2:orcl:/u01/app/oracle/product/10.1.0/db_1/dbs] ->sqlplus 'sys/oracle@stby
as sysdba' ;
SQL*Plus: Release 10.1.0.4.0 - Production on Mon May 23 16:34:43 2005
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Standby Database (TNS name = stby) is NOMOUNT status.
Configration of both databases :
*.remote_login_passwordfile = EXCLUSIVE
There is a password file (orapworcl) on the standby machine :
host2:orcl:/u01/app/oracle/product/10.1.0/db_1] ->ls -l $ORACLE_HOME/dbs
total 44
-rw-rw---- 1 oracle oinstall 1544 May 22 12:25 hc_orcl.dat
-rw-r--r-- 1 oracle oinstall 12920 May 8 08:43 initdw.ora
-rw-r--r-- 1 oracle oinstall 8385 May 8 08:43 init.ora
-rw-rw---- 1 oracle oinstall 24 May 23 13:56 lkSTBY
-rwSr----- 1 oracle oinstall 1536 May 23 13:56 orapworcl
-rw-r----- 1 oracle oinstall 3584 May 23 13:35 spfileorcl.ora
[host2:orcl:/u01/app/oracle/product/10.1.0/db_1] ->
OS User "oracle" ist a member of OS "dba" group:
[host2:orcl:/u01/app/oracle/product/10.1.0/db_1/dbs] ->id
uid=700(oracle) gid=701(oinstall) groups=701(oinstall),700(dba)
The password file (orapworcl) was created with the command:
[host2:orcl:/u01/app/oracle/product/10.1.0/db_1/dbs] ->orapwd file=orapworcl
password=oracle force=Y
Whatever I do, I am still getting "ORA-01031: insufficient privileges" error
message.
OS version:
[host2:orcl:/u01/app/oracle/product/10.1.0/db_1/dbs] ->uname -a
Linux host2.example.com 2.4.21-27.EL #1 Wed Dec 1 22:08:15 EST 2004 i686 i686
i386 GNU/Linux
[host2:orcl:/u01/app/oracle/product/10.1.0/db_1/dbs] ->cat <
/etc/redhat-release
Red Hat Enterprise Linux AS release 3 (Taroon Update 4)
Oracle Software (primary + standby):
SQL> select * from V$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod
PL/SQL Release 10.1.0.4.0 - Production
CORE 10.1.0.4.0 Production
TNS for Linux: Version 10.1.0.4.0 - Production
NLSRTL Version 10.1.0.4.0 - Production
What I am missing here?
MILEN
--
//www.freelists.org/webpage/oracle-l
Other related posts:
