Home » RDBMS Server » Enterprise Manager » RAC monitoring through 12c grid control (11g R1 Linux 64bit)
RAC monitoring through 12c grid control [message #560246] Wed, 11 July 2012 08:45 Go to next message
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 #560248 is a reply to message #560246] Wed, 11 July 2012 08:49 Go to previous messageGo to next message
Michel Cadot
Messages: 58519
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes.
2/ Yes.

Regards
Michel
Re: RAC monitoring through 12c grid control [message #560250 is a reply to message #560248] Wed, 11 July 2012 08:58 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks Michel.

Also do add RAC clusterware, I suppose it can be configured by any one of the both nodes. Please correct me if i'm wrong.
Re: RAC monitoring through 12c grid control [message #560262 is a reply to message #560250] Wed, 11 July 2012 10:13 Go to previous messageGo to next message
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 #560449 is a reply to message #560262] Fri, 13 July 2012 00:53 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Kindly update, if anyone looking on this.
Re: RAC monitoring through 12c grid control [message #560455 is a reply to message #560449] Fri, 13 July 2012 01:26 Go to previous messageGo to next message
John Watson
Messages: 4373
Registered: January 2010
Location: Global Village
Senior Member
Does your TNS connect string actually work? tnsping doesn't attempt to contact a database instance, you know, all it does is test whether the listener is running. Try to connect, as DBSNMP, with SQL*Plus.
Re: RAC monitoring through 12c grid control [message #560670 is a reply to message #560455] Mon, 16 July 2012 05:21 Go to previous message
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>
Previous Topic: Data Guard installation problem at Grid
Next Topic: Scheduling Export database
Goto Forum:
  


Current Time: Wed Jul 23 15:07:28 CDT 2014

Total time taken to generate the page: 0.19237 seconds