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.