Sybase online script exits with 10
Hi,
we are doing a VCS migration from 5.1 to 6.2 and we are not able to bring up the sybase DB's has it was working on 5.1.
The DB agent configuration was copied from 5.1 and already:
Disconnected LevelTwoMonitorFreq = 0
Detailed Run_ServerFile = "/opt/sybasexp/admin/RUN_files" & interfaces_File = "/opt/sybasexp/interfaces"
encripted the SA password
Enabled agent debug
and I'm always getting:
2019/05/08 15:17:48 VCS DBG_AGDEBUG script (/opt/VRTSagents/ha/bin/Sybase/online) exited with status (10)
Already checked the PATH var and the RUN_file for to many chars...
It seems that the online agent script doesn't run at all.
Any help woul be appreciated.
Here are the sybase agent logs:
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |hq_ds_xp|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |hq_ds_xp|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |sybasexp|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |sybasexp|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |/opt/sybasexp/links/hq_ds_xp|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |/opt/sybasexp/links/hq_ds_xp|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |12|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |12|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |sa_veritas|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |sa_veritas|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |ha_veritas|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |ha_veritas|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |adm|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |adm|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |ha_monitor|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |ha_monitor|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |/opt/VRTSagents/ha/bin/Sybase/SqlTest.pl|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |/opt/VRTSagents/ha/bin/Sybase/SqlTest.pl|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: ||
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: ||
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |/opt/sybasexp/interfaces|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 V-16-50-0 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |/opt/sybasexp/interfaces|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_FFDC Generating FFDC for resource (syb_hq_ds_xp) as monitor entry point reported OFFLINE after online operation
==============================================
2019/05/08 15:46:47 VCS DBG_AGDEBUG Calling online for resource syb_hq_ds_xp
VCSAgType.C:call_online[1673]
2019/05/08 15:46:47 VCS DBG_AGDEBUG Calling exec_script without passing container information
VCSAgType.C:_exec_script[3371]
2019/05/08 15:46:47 VCS DBG_AGDEBUG Value of VCSAgResEPStruct is {ResName=syb_hq_ds_xp, EpName=online, EpEnum=7, ConfLevel=676549714, MonitorInfo=691740758}
VCSAgProcess.C:exec_script[1887]
2019/05/08 15:46:47 VCS DBG_AGDEBUG child pid is - 18258
VCSAgProcess.C:exec_script[2116]
2019/05/08 15:46:47 VCS DBG_1 Sybase:syb_hq_ds_xp:online:Run_ServerFile set to : /opt/sybasexp/admin/RUN_files
2019/05/08 15:46:47 VCS DBG_1 Sybase:syb_hq_ds_xp:online:interfaces_File set to : /opt/sybasexp/interfaces
2019/05/08 15:46:47 VCS DBG_1 Sybase:syb_hq_ds_xp:online:DelayAfterOnline set to : 10
2019/05/08 15:46:47 VCS DBG_5 Sybase:syb_hq_ds_xp:online:Entry point is running in global zone.
2019/05/08 15:46:47 VCS DBG_5 Sybase:syb_hq_ds_xp:online:interfaces_File '/opt/sybasexp/interfaces' will be used while connecting to isql.
2019/05/08 15:46:49 VCS DBG_AGDEBUG script (/opt/VRTSagents/ha/bin/Sybase/online) exited with status (10)
VCSAgProcess.C:exec_script[2200]
2019/05/08 15:46:49 VCS DBG_AGINFO Resource(syb_hq_ds_xp) - online entry point exited with a return value 10.
VCSAgType.C:call_online[1698]
2019/05/08 15:46:49 VCS DBG_AGDEBUG Canceling timer for (syb_hq_ds_xp) op(1612)
VCSAgTimer.C:_cancel[947]
2019/05/08 15:46:58 VCS DBG_AGDEBUG Calling monitor for resource syb_hq_ds_xp
VCSAgType.C:call_monitor[1492]
2019/05/08 15:46:58 VCS DBG_1 Sybase:syb_hq_ds_xp:monitor:Starting a new monitor cycle.
Sybase.C:sybase_monitor[363]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |hq_ds_xp|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |hq_ds_xp|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |sybasexp|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |sybasexp|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |/opt/sybasexp/links/hq_ds_xp|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |/opt/sybasexp/links/hq_ds_xp|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |12|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |12|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |sa_veritas|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |sa_veritas|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |ha_veritas|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |ha_veritas|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |adm|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |adm|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |ha_monitor|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |ha_monitor|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |/opt/VRTSagents/ha/bin/Sybase/SqlTest.pl|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |/opt/VRTSagents/ha/bin/Sybase/SqlTest.pl|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: ||
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: ||
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Untrimmed attribute value: |/opt/sybasexp/interfaces|
Sybase.C:trim[111]
2019/05/08 15:46:58 VCS DBG_4 Sybase:syb_hq_ds_xp:monitor:Trimmed attribute value: |/opt/sybasexp/interfaces|
Sybase.C:trim[120]
2019/05/08 15:46:58 VCS DBG_3 Sybase:syb_hq_ds_xp:monitor:Finished validation.
Sybase.C:sybase_monitor[402]
2019/05/08 15:46:58 VCS DBG_3 Sybase:syb_hq_ds_xp:monitor:Finished null check.
Sybase.C:sybase_monitor[409]
2019/05/08 15:46:58 VCS DBG_3 Sybase:syb_hq_ds_xp:monitor:Modified path of MonScript.
Sybase.C:sybase_monitor[417]
2019/05/08 15:46:58 VCS DBG_3 Sybase:syb_hq_ds_xp:monitor:Finished checking permissions of MonScript.
Sybase.C:sybase_monitor[424]
2019/05/08 15:46:58 VCS DBG_3 Sybase:syb_hq_ds_xp:monitor:Finished checking permissions of QrmTest script '/opt/VRTSagents/ha/bin/Sybase/QrmTest.pl'.
Sybase.C:sybase_monitor[437]
2019/05/08 15:46:58 VCS DBG_AGDEBUG Monitor-Info is 1
VCSAgPrimitives.C:VCSAgGetMonitorLevel[4588]
2019/05/08 15:46:58 VCS DBG_3 Sybase:syb_hq_ds_xp:monitor:VCSAgGetMonitorLevel returned level_one [1] level_two [0]
Sybase.C:sybase_monitor[440]
2019/05/08 15:46:58 VCS DBG_3 Sybase:syb_hq_ds_xp:monitor:Zone is NOT enabled.
Sybase.C:sybase_monitor[467]
2019/05/08 15:46:58 VCS DBG_AGINFO The values of Container Object attributes are given below
VCSAgRes.C:get_container_object[2375]
2019/05/08 15:46:58 VCS DBG_AGINFO The RIC for the Resource is 1 and PassCInfo is 0
VCSAgRes.C:get_container_object[2428]
2019/05/08 15:46:58 VCS DBG_AGINFO Container created with Name , Type and Enabled 0
VCSAgRes.C:get_container_object[2443]
2019/05/08 15:46:58 VCS DBG_AGINFO Creating object of Zone container
VCSAgContainer.C:create_container[230]
2019/05/08 15:46:58 VCS DBG_1 Sybase:syb_hq_ds_xp:monitor:The uid for user (sybasexp) is (31127)
Sybase.C:sybase_monitor[491]
2019/05/08 15:46:58 VCS DBG_1 Sybase:syb_hq_ds_xp:monitor:Performing process stats monitoring
Sybase.C:sybase_monitor[498]
2019/05/08 15:46:58 VCS DBG_1 Sybase:syb_hq_ds_xp:monitor:Cookie name is: dataserversyb_hq_ds_xp.
Sybase.C:sybase_monitor[520]
2019/05/08 15:46:58 VCS DBG_1 Sybase:syb_hq_ds_xp:monitor:Cookie analysis finished. proc_ok is FALSE
Sybase.C:sybase_monitor[555]
2019/05/08 15:46:58 VCS DBG_1 Sybase:syb_hq_ds_xp:monitor:Could not find a process for data server hq_ds_xp. Returning OFFLINE.
Sybase.C:sybase_monitor[774]
2019/05/08 15:46:58 VCS DBG_2 Sybase:syb_hq_ds_xp:monitor:Quorum device attribute is not set.
Sybase.C:sybase_monitor[789]
2019/05/08 15:46:58 VCS DBG_AGINFO Resource(syb_hq_ds_xp) - monitor entry point exited with a confidence value 0.
VCSAgType.C:call_monitor[1584]
2019/05/08 15:46:58 VCS DBG_AGINFO syb_hq_ds_xp reported state (Offline) & conf_level (0)
VCSAgRes.C:call_entry_point[1599]
2019/05/08 15:46:58 VCS DBG_AGDEBUG Canceling timer for (syb_hq_ds_xp) op(1608)
VCSAgTimer.C:_cancel[947]
==============================================
repeats...
2019/05/08 15:48:58 VCS ERROR V-16-2-13066 Thread(9) Agent is calling clean for resource(syb_hq_ds_xp) because the resource is not up even after online completed.
2019/05/08 15:48:59 VCS DBG_4 Sybase:syb_hq_ds_xp:clean:Using password level CT001
2019/05/08 15:48:59 VCS INFO V-16-20018-51 Sybase:syb_hq_ds_xp:clean:Could not open directory [/var/tmp/sybase_shm/hq_ds_xp] for read [No such file or directory]
2019/05/08 15:48:59 VCS NOTICE V-16-20018-78 Sybase:syb_hq_ds_xp:clean:Cannot remove Shared Memory.
2019/05/08 15:49:00 VCS INFO V-16-2-13716 Thread(9) Resource(syb_hq_ds_xp): Output of the completed operation (clean)
==============================================
ksh: isql: not found
==============================================
2019/05/08 15:49:00 VCS DBG_FFDC Generating FFDC for resource (syb_hq_ds_xp) as clean entry point completed successfully
==============================================
2019/05/08 15:48:58 VCS DBG_AGDEBUG Calling clean for resource syb_hq_ds_xp
VCSAgType.C:call_clean[1051]
2019/05/08 15:48:58 VCS DBG_AGDEBUG Calling exec_script without passing container information
VCSAgType.C:_exec_script[3371]
2019/05/08 15:48:58 VCS DBG_AGDEBUG Value of VCSAgResEPStruct is {ResName=syb_hq_ds_xp, EpName=clean, EpEnum=2, ConfLevel=2037409064, MonitorInfo=891552}
VCSAgProcess.C:exec_script[1887]
2019/05/08 15:48:59 VCS DBG_AGDEBUG child pid is - 18400
VCSAgProcess.C:exec_script[2116]
2019/05/08 15:48:59 VCS DBG_5 Sybase:syb_hq_ds_xp:clean:Entry point is running in global zone.
2019/05/08 15:48:59 VCS DBG_5 Sybase:syb_hq_ds_xp:clean:interfaces_File '/opt/sybasexp/interfaces' will be used while connecting to isql.
2019/05/08 15:48:59 VCS DBG_1 Sybase:syb_hq_ds_xp:clean:Clean EP invoked with CleanReason 3.
2019/05/08 15:48:59 VCS DBG_4 Sybase:syb_hq_ds_xp:clean:Using password level CT001
2019/05/08 15:48:59 VCS DBG_1 Sybase:syb_hq_ds_xp:clean:Running isql command: su sybasexp -c ' . /opt/sybasexp/links/hq_ds_xp/SYBASE.sh; isql -X -Shq_ds_xp -Usa_veritas -I /opt/sybasexp/interfaces '
2019/05/08 15:49:00 VCS DBG_AGDEBUG script (/opt/VRTSagents/ha/bin/Sybase/clean) exited with status (0)
VCSAgProcess.C:exec_script[2200]
2019/05/08 15:49:00 VCS DBG_AGINFO Resource(syb_hq_ds_xp) - clean entry point exited with a return value 0.
VCSAgType.C:call_clean[1079]
2019/05/08 15:49:00 VCS DBG_AGINFO Resource(syb_hq_ds_xp) - Clean was successful.
VCSAgType.C:call_clean[1085]
2019/05/08 15:49:00 VCS DBG_AGDEBUG Canceling timer for (syb_hq_ds_xp) op(1603)
VCSAgTimer.C:_cancel[947]
==============================================