| RAC monitoring through 12c grid control [message #560246] |
Wed, 11 July 2012 08:45  |
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
|
Senior Member |
|
|
Hello Expert,
I have plan to monitor RAC database (2 instance) through 12c grid control. Please suggest for the below query.
Do i need to install agent on both the nodes.?
Do i need to configure both the instance.?
Thanks.
|
|
|
|
|
|
|
|
| Re: RAC monitoring through 12c grid control [message #560262 is a reply to message #560250] |
Wed, 11 July 2012 10:13  |
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
|
Senior Member |
|
|
Hi, When configuring RAC database with 12c grid control, I'm getting error: Failed to connect to the database: IO Error: NL Exception was generated.
When using same TNS, it was connecting properly with OMR database. Please suggest.
error from grid screen, when doing test connection:
Failed to connect to the database: IO Error: NL Exception was generated The Connect Descriptor was CCLCLMP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cclclmdb1v)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = cclclmdb2v)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CCLCLMP) (FAILOVER_MODE= (TYPE=SELECT) (METHOD=BASIC) ) ) )
-bash-3.2$ tnsping CCLCLMP
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 11-JUL-2012 10:50:58
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cclclmdb1v)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = cclclmdb2v)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CCLCLMP) (FAILOVER_MODE= (TYPE=SELECT) (METHOD=BASIC))))
OK (30 msec)
-bash-3.2$
[Updated on: Wed, 11 July 2012 10:13] Report message to a moderator |
|
|
|
|
|
|
|
| Re: RAC monitoring through 12c grid control [message #560670 is a reply to message #560455] |
Mon, 16 July 2012 05:21 |
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
|
Senior Member |
|
|
CCGRDDB1 is the OMR GRID DATABASE and CCLCLM is the target database which is need to be configured. Thus in the below i have connected on OMR DB and then connected to target DB.
Kindly suggest further to look into the issue.
$ export ORACLE_SID=CCGRDDB1
$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 13 14:26:31 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> conn dbsnmp/dbsnmp@CCLCLMP
Connected.
SQL>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
