Hello all,
I am trying to setup Oracle 11.2.0.3 Data Guard on ASM on VirtualBox. I have 2 virtual machines running Oracle Linux 6.4. On the first VM where the primary database is (oraprim), there are GRID+Oracle database installed. On the second VM (orastand), there are GRID+ Software Only Oracle installation and I have not run netca. Primary DB is OPEN, Standby DB is in NOMOUNT.
I am currently trying to start the RMAN duplicate from the primary database, but I have trouble connecting to the auxiliary. I get the following error
Code:
[oracle@oraprim ~]$ rman target sys/xxxxx@orcl auxiliary sys/xxxxx@orcls
Recovery Manager: Release 11.2.0.3.0 - Production on Wed May 22 19:39:38 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1343269014)
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-12514: TNS:listener does not currently know of service requested in connect descriptor
Please note that I created the tnsnames.ora on the standby server manually because the NETCA did not create it. The lsnrctl status command says "The listener supports no services". However, tnsping between the 2 servers succeeds.
Primary database listener.ora and tnsnames.ora configuration:
Code:
[oracle@oraprim admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0.3/db1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENERORCL =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraprim.localdomain)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
ADR_BASE_LISTENERORCL = /u01/app/oracle
[oracle@oraprim admin]$
Code:
oracle@oraprim admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.3/db1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraprim.localdomain)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oraprim.localdomain)
)
)
ORCLS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orastand.localdomain)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcls.orastand.localdomain)
)
)
[oracle@oraprim admin]$
Standby database listener.ora and tnsnames.ora configuration:
Code:
[oracle@orastand admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0.3/db1/network/admin/listener.ora
# Generated by Oracle configuration tools.
ADR_BASE_LISTENERORCLS = /u01/app/oracle
LISTENERORCLS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orastand.localdomain)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
[oracle@orastand admin]$
Code:
[oracle@orastand admin]$ cat tnsnames.ora
# tnsnames.ora
# self-made
ORCLS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orastand.localdomain)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcls.orastand.localdomain)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraprim.localdomain)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oraprim.localdomain)
)
)
[oracle@orastand admin]$
I would really appreciate any advise on how to fix this issue.
Thank you for your time.