rman clonning error RMAN-04006: error from auxiliary database: ORA-01031
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