Hi Everyone,
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
I am trying to configure EM on 2 node RAC as follows:
[oracle@INODB02 bin]$ ./emca -config dbcontrol db -repos create -cluster
STARTED EMCA at Jul 3, 2015 7:26:30 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database unique name: CATIN
Service name: CATIN
Listener port number: 1521
Listener ORACLE_HOME [ /u01/11.2.0/grid ]: /u01/app/oracle/product/11.2.0/db_1/
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Cluster name: INODB-cluster
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/11.2.0/grid ]: /u01/app/oracle/product/11.2.0/db_1
ASM port [ 1521 ]: 1521^C
[oracle@INODB02 bin]$ ./emca -config dbcontrol db -repos create -cluster
STARTED EMCA at Jul 3, 2015 7:28:24 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database unique name: CATIN
Service name: CATIN
Listener port number: 1521
Listener ORACLE_HOME [ /u01/11.2.0/grid ]: /u01/app/oracle/product/11.2.0/db_1/
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Cluster name: INODB-cluster
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/11.2.0/grid ]: /u01/11.2.0/grid
ASM port [ 1521 ]: 1521
ASM username [ ASMSNMP ]: sys
ASM user password:
Jul 3, 2015 7:29:45 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Jul 3, 2015 7:29:50 PM oracle.sysman.emcp.DatabaseChecks checkDataGuardEnabled
WARNING: ORA-01507: database not mounted
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
tnsnames.ora:
CATIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = INODB-cluster)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CATIN)
)
)
CATIN1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = INODB02-VIP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CATIN)
)
)
CATIN2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = INODB01-VIP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CATIN)
)
)
listener.ora:
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
Listerner status on INODB02:
[oracle@INODB02 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-JUL-2015 18:45:33
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 26-MAY-2015 19:17:07
Uptime 41 days 23 hr. 28 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/INODB02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.116.136)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.116.143)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "CAT" has 1 instance(s).
Instance "CATIN1", status READY, has 1 handler(s) for this service...
Service "CATIN" has 1 instance(s).
Instance "CATIN1", status READY, has 1 handler(s) for this service...
Service "CATINXDB" has 1 instance(s).
Instance "CATIN1", status READY, has 1 handler(s) for this service...
Service "catinods" has 1 instance(s).
Instance "catinods", status READY, has 1 handler(s) for this service...
Service "catinodsXDB" has 1 instance(s).
Instance "catinods", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@INODB02 ~]$
listener status on INODB01 :
lsnrctl status
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 07-JUL-2015 18:46:19
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 04-JUN-2015 17:53:00
Uptime 33 days 0 hr. 53 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/INODB01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.116.134)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.116.141)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "CAT2" has 1 instance(s).
Instance "CATIN2", status READY, has 1 handler(s) for this service...
Service "CATIN" has 1 instance(s).
Instance "CATIN2", status READY, has 1 handler(s) for this service...
Service "CATINXDB" has 1 instance(s).
Instance "CATIN2", status READY, has 1 handler(s) for this service...
The command completed successfully
There are no errors in the listener.log file.
Request for your kind help. Please let me know if any more information is needed from my end.
Regards,
Priyesh Sheth