Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

agent is not able to control oracle database

Created: 25 Jun 2012 • Updated: 26 Jun 2012 | 2 comments
This issue has been solved. See solution.

Dear All,

I am working on 5.1sp1rp2.

On my platform there is a oracle 11g2.

vcs is not able to control oracle. 

for example when I try to offline the database (which is started up manually)

in engine_a log it says;

2000/01/13 11:07:13 VCS INFO V-16-1-50135 User root fired command: hares -offline qipdb  impdneilab1  from ::ffff:10.127.65.147

2000/01/13 11:07:13 VCS NOTICE V-16-1-10300 Initiating Offline of Resource qipdb (Owner: Unspecified, Group: ClusterService) on System impdneilab1

2000/01/13 11:07:14 VCS ERROR V-16-2-13064 (impdneilab1) Agent is calling clean for resource(qipdb) because the resource is up even after offline completed.

2000/01/13 11:07:15 VCS ERROR V-16-2-13069 (impdneilab1) Resource(qipdb) - clean failed.

2000/01/13 11:08:15 VCS ERROR V-16-2-13077 (impdneilab1) Agent is unable to offline resource(qipdb). Administrative intervention may be required.
 
in oracle_a log it says;
 
2000/01/13 10:43:27 VCS NOTICE V-16-20002-210 Oracle:qipdb:monitor:Setting cookie for proc = ora_lgwr_qipdb, PID = /proc/13893/psinfo

2000/01/13 10:43:27 VCS NOTICE V-16-20002-210 Oracle:qipdb:monitor:Setting cookie for proc = ora_dbw0_qipdb, PID = /proc/13885/psinfo

2000/01/13 10:43:27 VCS NOTICE V-16-20002-210 Oracle:qipdb:monitor:Setting cookie for proc = ora_pmon_qipdb, PID = /proc/13867/psinfo

2000/01/13 10:43:27 VCS NOTICE V-16-20002-210 Oracle:qipdb:monitor:Setting cookie for proc = ora_smon_qipdb, PID = /proc/13897/psinfo

2000/01/13 11:07:14 VCS ERROR V-16-2-13064 Thread(3) Agent is calling clean for resource(qipdb) because the resource is up even after offline completed.

2000/01/13 11:07:15 VCS ERROR V-16-2-13069 Thread(3) Resource(qipdb) - clean failed.

2000/01/13 11:08:15 VCS ERROR V-16-2-13077 Thread(3) Agent is unable to offline resource(qipdb). Administrative intervention may be required.
my main.cf;
 
impdneilab1: cat /etc/VRTSvcs/conf/config/main.cf

include "types.cf"

include "ClusterConnectorConfigType.cf"

include "OracleTypes.cf"


cluster impdneilab (

        UserNames = { admin = HQRjQLqNRmRRpZRlQO, root = dllSlkLmmHmoLi }

        ClusterAddress = "10.127.65.146"

        Administrators = { admin, root }

        )


system impdneilab1 (

        )


system impdneilab2 (

        )


group ClusterService (

        SystemList = { impdneilab1 = 0, impdneilab2 = 1 }

        AutoStartList = { impdneilab1, impdneilab2 }

        OnlineRetryLimit = 3

        OnlineRetryInterval = 120

        )


        Application VitalQIP (

                Enabled = 0

                Critical = 0

                StartProgram = "/etc/init.d/qip-es-ic.sh start"

                StopProgram = "/etc/init.d/qip-es-ic.sh stop"

                PidFiles = { "/opt/qip/etc/qip-dnsupdated.pid",

                         "/opt/qip/etc/qip-logind.pid",

                         "/opt/qip/etc/qip-msgd.pid",

                         "/opt/qip/etc/qip-qipupdated.pid",

                         "/opt/qip/etc/qip-rmisched.pid",

                         "/opt/qip/etc/qip-rmtd.pid",

                         "/opt/qip/etc/qip-ssltd.pid",

                         "/opt/qip/etc/qipd.pid",

                         "/opt/qip/tomcat/logs/catalina.pid",

                         "/var/run/named.pid" }

                )


        DiskGroup oracle_dg (

                Critical = 0

                DiskGroup = oracle_dg

                )


        IPMultiNICB OAM-Logical-IP (

                Critical = 0

                BaseResName = OAM-MultiPath

                Address = "10.127.65.146"

                NetMask = "255.255.255.192"

                DeviceChoice = e1000g0

                )


        Mount oradata (

                Critical = 0

                MountPoint = "/oradata"

                BlockDevice = "/dev/vx/dsk/oracle_dg/oradata"

                FSType = vxfs

                FsckOpt = "-n"

                )


        Netlsnr oracle_listener (

                Critical = 0

                Owner = oracle

                Home = "/opt/oracle/product/11.2.0"

                TnsAdmin = "/opt/oracle/product/11.2.0/network/admin"

                EnvFile = "/opt/oracle/.profile"

                )


        Oracle qipdb (

                Critical = 0

                Sid = qipdb

                Owner = oracle

                Home = "/opt/oracle/product/11.2.0"

                Pfile = "/oradata/admin/qipdb/pfile/initqipdb.ora"

                StartUpOpt = STARTUP

                EnvFile = "/opt/oracle/.profile"

                DetailMonitor = 1

                User = cluser

                Pword = cluser

                Table = cltable

                MonitorOption = 1

                )


        Proxy OAM-Net-Proxy (

                Critical = 0

                TargetResName = OAM-MultiPath

                )


        Volume oradata_vol (

                Volume = oradata

                DiskGroup = oracle_dg

                )


        OAM-Logical-IP requires OAM-Net-Proxy

        VitalQIP requires oracle_listener

        VitalQIP requires qipdb

        oracle_listener requires OAM-Net-Proxy

        oradata requires oradata_vol

        oradata_vol requires oracle_dg

        qipdb requires oradata



        // resource dependency tree

        //

        //      group ClusterService

        //      {

        //      IPMultiNICB OAM-Logical-IP

        //          {

        //          Proxy OAM-Net-Proxy

        //          }

        //      Application VitalQIP

        //          {

        //          Netlsnr oracle_listener

        //              {

        //              Proxy OAM-Net-Proxy

        //              }

        //          Oracle qipdb

        //              {

        //              Mount oradata

        //                  {

        //                  Volume oradata_vol

        //                      {

        //                      DiskGroup oracle_dg

        //                      }

        //                  }

        //              }

        //          }

        //      }



group Network (

        SystemList = { impdneilab1 = 0, impdneilab2 = 1 }

        Parallel = 1

        AutoStartList = { impdneilab1, impdneilab2 }

        )


        MultiNICB OAM-MultiPath (

                UseMpathd = 1

                MpathdCommand = "/usr/lib/inet/in.mpathd -a"

                Device = { e1000g0 = "", nxge0 = "" }

                IgnoreLinkStatus = 0

                DefaultRouter = "10.127.65.129"

                )


        Phantom Network-Phantom (

                )




        // resource dependency tree

        //

        //      group Network

        //      {

        //      Phantom Network-Phantom

        //      MultiNICB OAM-MultiPath

        //      }
 
and oracletyoes.cf
 
impdneilab1: more /etc/VRTSvcs/conf/config/OracleTypes.cf

type Netlsnr (

        static str ContainerType = Zone

        static str AgentDirectory = "/opt/VRTSagents/ha/bin/Netlsnr"

        static keylist SupportedActions = { VRTS_GetInstanceName, VRTS_GetRunningServices, "tnsadmin.vfd" }

        static int LevelTwoMonitorFreq = 1

        static str ArgList[] = { Owner, Home, TnsAdmin, Listener, EnvFile, MonScript, LsnrPwd, AgentDebug, Encoding }

        str Owner

        str Home

        str TnsAdmin

        str Listener

        str EnvFile

        str MonScript = "./bin/Netlsnr/LsnrTest.pl"

        str LsnrPwd

        boolean AgentDebug = 0

        str Encoding

        str ContainerName

)


type Oracle (

        static str ContainerType = Zone

        static str AgentDirectory = "/opt/VRTSagents/ha/bin/Oracle"

        static keylist SupportedActions = { VRTS_GetInstanceName, VRTS_GetRunningServices, DBRestrict, DBUndoRestrict, DBResume, DBSuspend, DBTbspBackup,

"home.vfd", "owner.vfd", getid }

        static str ArgList[] = { Sid, Owner, Home, Pfile, StartUpOpt, ShutDownOpt, EnvFile, AutoEndBkup, DetailMonitor, User, Pword, Table, MonScript, Age

ntDebug, Encoding, MonitorOption }

        str Sid

        str Owner

        str Home

        str Pfile

        str StartUpOpt = STARTUP_FORCE

        str ShutDownOpt = IMMEDIATE

        str EnvFile

        boolean AutoEndBkup = 1

        int DetailMonitor

        str MonScript = "./bin/Oracle/SqlTest.pl"

        str User

        str Pword

        str Table

        boolean AgentDebug = 0

        str Encoding

        int MonitorOption

        str ContainerName

)

thanks for you help,

Halit

Comments 2 CommentsJump to latest comment

mikebounds's picture

Does your Oracle instance use a Pfile, mostly SPfiles are used these days and if this is the case then you should blank out the pfile attribute.  Also I would blank out User, Pword and Table attribute and set DetailMonitor to zero, to simplify things and you can put this back once it is working.

Mike

UK Symantec Consultant in VCS, GCO, SF, VVR, VxAT on Solaris, AIX, HP-ux, Linux & Windows

If this post has answered your question then please click on "Mark as solution" link below

halit.sakca's picture

Hi Mike,

Thanks for commenting and advises it was not pfile.

It was about OracleTypes.cf.

Basically OracleTypes.cf in /config was different than /conf so I replaced it from /conf to /config.

Then, bringing resources online.

here is a note to "self helpers" in order to edit main.cf;

hastop -all force

gabconfig -a => see membership is gone

"do the changes" 

hastart on both node

look at to engine_A.log

regards,

Halit

SOLUTION