R12: XML Reports end with WARNING Status, Using Virtual Hostname by Veritas HA
Dear Experts, We are using the Veritas HA cluster to configure our ERP Application on Virtual Hostname. With Release 11i every thing was working fine, We have upgraded our Application from 11.5.10.2 to R12, 12.1.3. Now in the Upgraded Application we are unable to open/view any of the XML based Concurrent Reports. All the XML Concurrent Reports are ending in Status WARNING. When we click on the View Out put, we are just getting the XML code and not the XML based reports. The log file of Out Put Postprocessor shows the following errors: ================================================ 5/28/13 12:40:20 PM] [STATEMENT] [960882:RT4152834] Get Output Type [5/28/13 12:40:20 PM] [STATEMENT] [960882:RT4152834] XML file name: /mnt/oracle/ERPROD/inst/apps/ERPROD_erp-lh-dr/logs/appl/conc/out/o4152834.out [5/28/13 12:40:20 PM] [STATEMENT] [960882:RT4152834] XML file is on node: ERP-LH-DR [5/28/13 12:40:20 PM] [UNEXPECTED] [960882:RT4152834] java.sql.SQLException: Exhausted Resultset at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1224) at oracle.apps.fnd.cp.util.CpUtil.getCanonicalLocalNode(CpUtil.java:127) at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:244) at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176) [5/28/13 12:40:20 PM] [960882:RT4152834] Completed post-processing actions for request 4152834. And error like below: The error we are getting from the Application log files are related to Hostname. Following is the abstract from the Output Post Processor log. [5/29/13 2:56:02 PM] [UNEXPECTED] [960900:RT4155505] java.sql.SQLException: Exhausted Resultset at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1224) at oracle.apps.fnd.cp.util.CpUtil.getCanonicalLocalNode(CpUtil.java:127) at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:244) at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:176) =============================================================== Concurrent Manger Log files shows the following error: =========================================================== --------------------------------------------------------------------------- Executing request completion options... Output file size: 430455 ------------- 1) PUBLISH ------------- Beginning post-processing of request 4158856 on node ERP-LH-DR at 30-MAY-2013 18:53:38. Post-processing of request 4158856 failed at 30-MAY-2013 18:53:38 with the error message: One or more post-processing actions failed. Consult the OPP service log for details. -------------------------------------- ------------- 2) PRINT ------------- Not printing the output of this request because post-processing failed. -------------------------------------- Finished executing request completion options. --------------------------------------------------------------------------- Concurrent request completed ========================================================== Please suggests: 1- Is there any way to make these XML reports work with Veritas HA, using Virtual hostname 2- Can we identify or pin point from where the Out Put Postprocessor is setting the Physical Hostname. Regards Ali Ammar6.5KViews1like6CommentsNetApp snapmirror resource not getting online with VCS integration
Dear All, I would like to have some help to identify following error while onlining a NetApp SnapMirror agent that was intergrated with VCS. The filer name and its credential s were given properly and even i can able to ssh it from the servers but for some reason the resource is not getting online and shows following error in the engine.log 2014/09/30 15:02:44 VCS WARNING V-16-20059-1002 (node)NetAppSnapMirror:testSM:online:Encountered errors while decrypting password! 2014/09/30 15:02:44 VCS ERROR V-16-20059-1000 (node11) NetAppSnapMirror:testSM:online:ONTAPI 'system-get-version' failed on filer node1.sys Error : in Zapi::invoke, cannot connect to socket Actually i am doing global Clustering configuration where i have two node cluster and a filer at primary site, In dr i have a single node cluster and a filer. the replication is async. Any support highly appreacited. Thanks. Uvi.4.5KViews1like12CommentsNFS Export of Solaris, Non-Global Zone, Direct Mounted VxFS Filesystem
Solaris 10 Update 11 SF-HA 6.1 with VxVM update 100 I've got a direct mounted VxFS filesystem in a Solaris non-global zone that needs to be NFS shared. This would be part of a failover group. group dbprod1 ( SystemList = { mia-sgz-p11 = 0, mia-sgz-p12 = 1 } AutoStartList = { mia-sgz-p11, mia-sgz-p12 } ) Mount MNT_prod1_rpt1_arch01 ( Critical = 0 MountPoint @mia-sgz-p11 = "/export/zones/mia-sdb-p04/root/od/prod1_rpt1_arch01" MountPoint @mia-sgz-p12 = "/export/zones/mia-sdb-p05/root/od/prod1_rpt1_arch01" BlockDevice = "/dev/vx/dsk/prod1_dg/prod1_rpt1_arch01" FSType = vxfs FsckOpt = "-y" ) I've read over both 6.1 bundled agent guide and the virtualization gudie and cannot figure out how to get NFS Server to start in the non-global zones. This service group will control one of two Oracle databses running in this local zone. The databases have to be able to failover independently of each other.Solved4.4KViews2likes13CommentsVCS Oracle cluster failover without using Oracle Agent
We would like to have VCS control serverfailover(Active/Passive Cluster)but not register our Oracle databases to VCS, but rather have them be restarted by the standard Oracle restart scripts (which read the oratab file) from the Oracle installation. Is there a writeup on how to accomplish this ???4.4KViews1like10CommentsChange the Host IP address in the Veritas cluster
Hello All, We have a Veritas cluster server setup (VCS-HA,VCS-CFS & VERITAS-RAC) where on few setup we required to change the data IP address of some host(node). I refer few notes but not sure except /etc/hosts is there any file need to update/edit. Please help me if you have any process/technote to make those change & make that changed IP persistant. Also would like to know the impact of this activity. The systems are Linux 6.5 & 6.6 & cluster versions are VCS 6.2 & 6.1.Solved3.6KViews0likes3CommentsUsing VCS Resources to Mount NFSv4 Exports
Hi all, I have a two node VCS cluster running on RHEL 5 (VCS version 6). I need the cluster to use the Mount resource to mount an NFSv4 exported FS from a NetApp filer. I couldn't find any information in the documentation on how to perform this, as the FS type should be nfs4 for a regular mount command but the resource contains only option for "nfs" FS type. Any advice would be much appreciated. Thanks, YairSolved3.5KViews1like6CommentsListener resource remain faulted
Hello, we are doing some failure tests for a customer. We have VCS 6.2 running on solaris 10. We have an Oracle database and of course the listener associated with it. We try to simulate different kind of failures. One of them is to kill the listener. In this situation the cluster observes that the listener has died, and it fails over the service to the other node. BUT the listener resource will remain in FAULTED state on the original node, and the group to which belongs will be in OFFLINE FAULTED state. In this situation if something goes wrong on the second node the service will not fail back to the original one until we manually run hagrp -clear. Is there anything we can do to fix this? (to have the clear done automatically) Here are some lines from the log: 2015/03/30 17:26:10 VCS ERROR V-16-2-13067 (node2p) Agent is calling clean for resource(ora_listener-res) because the resource became OFFLINE unexpectedly, on its own. 2015/03/30 17:26:11 VCS INFO V-16-2-13068 (node2p) Resource(ora_listener-res) - clean completed successfully. 2015/03/30 17:26:11 VCS INFO V-16-1-10307 Resource ora_listener-res (Owner: Unspecified, Group: oracle_rg) is offline on node2p (Not initiated by VCS) in these it says that clean for the resource has completed successfully, but the resource is still faulted. but if I run hares -clear manually, the the fault goes away. 20150330-173628:root@node1p:~# hares -state ora_listener-res #Resource Attribute System Value ora_listener-res State node1p ONLINE ora_listener-res State node2p FAULTED 20150330-173636:root@node1p:~# hares -clear ora_listener-res 20150330-173653:root@node1p:~# hares -state ora_listener-res #Resource Attribute System Value ora_listener-res State node1p ONLINE ora_listener-res State node2p OFFLINE 20150330-173655:root@node1p:~#Solved3.4KViews0likes5CommentsNBU agent for VCS
Where would I find the VCS NBU agent package and documentation. Normally you can find an agent athttps://sort.symantec.com/agentsor in the bundled agents guide, but I cannot find NBU agent in either of these locations. I am planning to upgrade an NBU (master) VCS cluster from 5.1 to 6.1 so wanted to look at VCS 5.1 and 6.1 agent docs and also obtain the 6.1 VCS agent package Mike3.3KViews0likes17CommentsBug in VCS's Oracle agent Health check Monitoring scripts?
Has anyone hit a bug when using VCS's Oracle agent in "Health Check Honitoring" mode (MonitorOption=1)? I've recently tested this with VCS 6.0.1 on Solaris10 x64, and discovered that the agent attempts to run scripts called "oraapi_32", "oraapi_3211g", "oraapi_64" or "oraapi_6411g" in the agent's directory "/opt/VRTSagents/ha/bin/Oracle". However, this fails because the standard installation doesn't give these scripts execute permission for non-root users, yet it's the (non-root) Oracle user that needs to run these scripts. I added global execute permission to these scripts in my test environment, and this allowed Health Check Honitoring to work OK. Has anyone else hit this problem? Is there an official workaround or solution? Best Regards, Alistair.Solved3.3KViews1like4Comments