Standby -> ORA-01031: insufficient privileges

From: Milen Kulev <makulev_at_gmx.net>
Date: Tue, 24 May 2005 22:40:35 +0200
Message-ID: <000001c560a0$d6980cd0$0a00a8c0@trivadis.com>

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_at_orcl auxiliary sys/oracle_at_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_at_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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 24 2005 - 16:45:24 CDT