Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rman clonning error RMAN-04006: error from auxiliary database: ORA-01031

Muhammad.UsmanApr 5 2010 — edited Apr 13 2013
hi!

I am cloning database orcl to standby1 using rman,orcl is in open state while standby database in in nomount state.
i am facing this error.

oracle@primary dbs]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 5 00:18:45 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target /

connected to target database: ORCL (DBID=1242818429)

RMAN> connect auxiliary sys@standby1

auxiliary database Password:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges


DETAILS:
SID=orcl
hostname=primary.11g.com(192.168.0.50)

Primary parameter file
[oracle@primary d01]$ more pfileorcl.ora
orcl.__db_cache_size=104857600
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__oracle_base='/d01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=146800640
orcl.__sga_target=276824064
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=146800640
orcl.__streams_pool_size=8388608
*.audit_file_dest='/d01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/d01/app/oracle/oradata/orcl/control01.ctl','/d01/app/oracle/fl
ash_recovery_area/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain='11g.com'
*.db_name='orcl'
*.db_recovery_file_dest='/d01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/d01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.log_archive_config='dg_config=(orcl,standby1)'
*.log_archive_dest_2='service=standby1 async valid_for=(online_logfile,primary_r
ole) db_unique_name=standby1'
*.memory_target=423624704
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
[oracle@primary d01]$

network configuration at primary

[oracle@primary admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /d01/app/oracle/product/11.2.0/db11g/
network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

STANDBY1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby.11g.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standby1)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary.11g.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.11g.com)
)
)

[oracle@primary admin]$ more listener.ora
# listener.ora Network Configuration File: /d01/app/oracle/product/11.2.0/db11g/
network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary.11g.com)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /d01/app/oracle

[oracle@primary admin]$ cd ..
[oracle@primary network]$ cd ..
[oracle@primary db11g]$ cd dbs
[oracle@primary dbs]$ ls
hc_orcl.dat lkORCL orapworcloriginal snapcf_orcl.f
init.ora orapworcl peshm_orcl_0 spfileorcl.ora
[oracle@primary dbs]$


SID=standby1
hostname=standby.11g.com(192.168.0.51)

network configuration at standby1

[oracle@standby admin]$ ls
listener.ora samples shrept.lst tnsnames.ora
[oracle@standby admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /d01/app/oracle/product/11.2.0/db11g/
network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

STANDBY1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby.11g.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = standby1)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = primary.11g.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.11g.com)
)
)

[oracle@standby admin]$ more listener.ora
# listener.ora Network Configuration File: /d01/app/oracle/product/11.2.0/db11g/
network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = standby1)
(ORACLE_HOME = /d01/app/oracle/product/11.2.0/db11g)
(SID_NAME = STANDBY1)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby.11g.com)(PORT = 1521))
)

ADR_BASE_LISTENER = /d01/app/oracle/

[oracle@standby admin]$
[oracle@standby admin]$
[oracle@standby admin]$ cd ..
[oracle@standby network]$ cd ..
[oracle@standby db11g]$ cd dbs
[oracle@standby dbs]$ ls
hc_standby1.dat init.ora initstandby1.ora orapwstandby1 peshm_standby1_0
[oracle@standby dbs]$ cat initstandby1.ora
DB_NAME=standby1
[oracle@standby dbs]$


TNSPING FROM PRIMARY TO STANDBY

[oracle@primary ~]$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 05-APR-2010 00:58:29

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/d01/app/oracle/product/11.2.0/db11g/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = primary.11g.com)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.11g.com)))
OK (10 msec)
[oracle@primary ~]$ tnsping standby1

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 05-APR-2010 00:58:36

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:
/d01/app/oracle/product/11.2.0/db11g/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = standby.11g.com)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = standby1)))
OK (10 msec)
[oracle@primary ~]$


TNSPING FROM STANDBY TO PRIMARY

[oracle@standby dbs]$ tnsping standby1

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 05-APR-2010 13:17:40

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = standby.11g.com)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = standby1)))
OK (0 msec)
[oracle@standby dbs]$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 05-APR-2010 13:17:45

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = primary.11g.com)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.11g.com)))
OK (10 msec)
[oracle@standby dbs]$

Now please help both db have password file ,both can ping each other but still i cannot connect to standby database
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2013
Added on Apr 5 2010
25 comments
15,009 views