agent version 11.1.0.1.0 and database version is 11.2.0.2.0

All posts relating to Oracle database administration.

Moderator: Tim...

agent version 11.1.0.1.0 and database version is 11.2.0.2.0

Postby royalyogi » Tue Apr 30, 2013 5:25 am

My database version is 11.2.0.2.0 but my agent version is 11.1.0.1.0.
should I upgrade my agent version or it is not required ?
Becuase we are getting some error on agent log and CPU utilization is eating to 100%.


SQL> select *from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL> host;emctl status agent
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 11.1.0.1.0
OMS Version : 11.1.0.1.0
Protocol Version : 11.1.0.0.0
Agent Home : C:\app\oracle\grid\agent11g
Agent binaries : C:\app\oracle\grid\agent11g
Agent Process ID : 9772

Agent log Snipped :
SQL = "/* OracleOEM */ BEGIN :succ_sub := 0; dbms_aqadm.enabl"...
LOGIN = dbsnmp/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PgODB02B.co.uk)(PORT=1521))(CONNECT_DATA=(SID=ORCLDBSTANDBY)))
2013-04-29 06:28:53,421 Thread-26636 ERROR recvlets.aq: Error enabling user dbsnmp for aq agent PgODB02B__3872_orcltandby on
orclstandby: ORA-16000: database open for read-only access
ORA-06512: at line 1
2013-04-29 06:28:53,421 Thread-26636 ERROR recvlets.aq: unable to create subscription on oracle_database orcldbstandby
2013-04-29 06:29:08,085 Thread-24120 WARN vpxoci: OCI Error -- ErrorCode(16000): ORA-16000: database open for read-only access
ORA-06512: at line 1
royalyogi
Senior Member
 
Posts: 168
Joined: Tue Apr 23, 2013 3:59 pm

Re: agent version 11.1.0.1.0 and database version is 11.2.0.

Postby Tim... » Tue Apr 30, 2013 4:10 pm

Hi.

Well, I would definitely suggest being on the latest version of Grid Control (or Cloud Control) you can, but I don't think the agent version is incompatible with your database.

The error says the database is open in read-only mode!

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: agent version 11.1.0.1.0 and database version is 11.2.0.

Postby royalyogi » Wed May 01, 2013 5:21 am

Sorry I forgot to mention that.
This is standby database and database get hanged due to CPU will be 100% once agent has started

SQL> select database_role,open_mode from v$database;

DATABASE_ROLE OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY READ ONLY WITH APPLY
royalyogi
Senior Member
 
Posts: 168
Joined: Tue Apr 23, 2013 3:59 pm

Re: agent version 11.1.0.1.0 and database version is 11.2.0.

Postby Tim... » Wed May 01, 2013 9:17 am

Hi.

My first suggestion would be to switch the standby to normal managed recovery, rather than active data guard, then see if the problem still occurs. If it doesn't then I thing your agent may need updating so it can cope with active data guard.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 3 guests