Re: [Linux-HA] Oracle OCF Script throws SP2-0640: Not connected
Hi Dejan, Unlike the Oracle Default Profile setting Passwords are supposed to have a unlimited lifetime, they had expired after 180 days :-/ Thank you very much for your advice. Mit freundlichen Grüßen / Best regards Christian Wendt Bosch Software Innovations GmbH Information Technology (INST/PRV3-IT) Schöneberger Ufer 89-91 10785 Berlin GERMANY www.bosch-si.de www.blog.bosch-si.com Tel. +49 30.72 61 12-308 Fax +49 30.72.61.12-100 christian.we...@bosch-si.com Registered office: Berlin, Register court: Amtsgericht Charlottenburg, HRB 148411 B Executives: Rainer Kallenbach; Thomas Cotic, Michael Hahn, Klaus Hüftle -Ursprüngliche Nachricht- Von: Dejan Muhamedagic [mailto:deja...@fastmail.fm] Gesendet: Dienstag, 5. August 2014 12:46 An: linux-ha@lists.linux-ha.org Cc: Wendt Christian Betreff: Re: [Linux-HA] Oracle OCF Script throws SP2-0640: Not connected Hi, On Fri, Aug 01, 2014 at 04:40:25PM +, Wendt Christian wrote: Hello *, i did a lot of research but i´m not able to get the purpose whether our oracle ressource fails on Wednesday. Oracle start will fail with the message: /usr/lib/ocf/resource.d/heartbeat/oracle start INFO: orcSNBGW instance state is not OPEN (dbstat output: SP2-0640: Not connected) ERROR: oracle instance orcSNBGW not started: Showdbstat throws: /usr/lib/ocf/resource.d/heartbeat/oracle showdbstat Full output: SP2-0640: Not connected Stripped output: OPEN So the first method of showdbstat monitoring the DB fails, but the second one succeeds. That seems to be a bug with the OCFMON monitoring user password expired. It was fixed. You can either update the oracle RA from upstream or reset the OCFMON password (OCFMON) and set its life to unlimited. Thanks, Dejan It is not possible to start oracle within the pacemaker cluster anymore. Everytime we start it, it´ll fail. I´ve attached the bash output while starting oracle with the ocf script. Database and OS is fine. Nothing changed in the last days. Do have any ideas? Thank you in advance. Mit freundlichen Grüßen / Best regards Christian Wendt Bosch Software Innovations GmbH Information Technology (INST/PRV3-IT) Schöneberger Ufer 89-91 10785 Berlin GERMANY www.bosch-si.de www.blog.bosch-si.com Tel. +49 30.72 61 12-308 Fax +49 30.72.61.12-100 christian.we...@bosch-si.com Registered office: Berlin, Register court: Amtsgericht Charlottenburg, HRB 148411 B Executives: Rainer Kallenbach; Thomas Cotic, Michael Hahn, Klaus Hüftle Content-Description: bashx_oracle_ocf.txt HOSTXXX:/opt/oracle/app/diag/rdbms/orcsnbgw/orcSNBGW/trace # bash -x /usr/lib/ocf/resource.d/heartbeat/oracle start + : /usr/lib/ocf/lib/heartbeat + . /usr/lib/ocf/lib/heartbeat/ocf-shellfuncs ++ unset LC_ALL ++ export LC_ALL ++ unset LANGUAGE ++ export LANGUAGE +++ basename /usr/lib/ocf/resource.d/heartbeat/oracle ++ __SCRIPT_NAME=oracle ++ '[' -z /usr/lib/ocf ']' ++ '[' /usr/lib/ocf/lib/heartbeat = /usr/lib/ocf/resource.d/heartbeat ']' ++ : /usr/lib/ocf/lib/heartbeat ++ . /usr/lib/ocf/lib/heartbeat/ocf-binaries +++ PATH=/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr +++ /bin:/bin:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/ +++ sbin:/sbin:/bin:/usr/sbin:/usr/bin +++ PATH=/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr +++ /bin:/bin:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/ +++ sbin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/ucb +++ export PATH +++ : gawk +++ : '/usr/bin/grep -E' +++ : -a +++ : mail +++ : /bin/ping +++ : /bin/sh +++ : /usr/bin/test +++ : /usr/bin/test +++ : basename +++ : blockdev +++ : cat +++ : fsck +++ : fuser +++ : getent +++ : grep +++ : ifconfig +++ : iptables +++ : ip +++ : mdadm +++ : modprobe +++ : mount +++ : msgfmt +++ : netstat +++ : perl +++ : python +++ : raidstart +++ : raidstop +++ : route +++ : umount +++ : reboot +++ : poweroff +++ : wget +++ : whoami +++ : strings +++ : scp +++ : ssh +++ : swig +++ : gzip +++ : tar +++ : md5 +++ : drbdadm +++ : drbdsetup ++ . /usr/lib/ocf/lib/heartbeat/ocf-returncodes +++ OCF_SUCCESS=0 +++ OCF_ERR_GENERIC=1 +++ OCF_ERR_ARGS=2 +++ OCF_ERR_UNIMPLEMENTED=3 +++ OCF_ERR_PERM=4 +++ OCF_ERR_INSTALLED=5 +++ OCF_ERR_CONFIGURED=6 +++ OCF_NOT_RUNNING=7 +++ OCF_RUNNING_MASTER=8 +++ OCF_FAILED_MASTER=9 ++ . /usr/lib/ocf/lib/heartbeat/ocf-directories +++ prefix=/usr +++ exec_prefix=/usr +++ : /etc/init.d +++ : /etc/ha.d +++ : /etc/ha.d/rc.d +++ : /etc/ha.d/conf +++ : /etc/ha.d/ha.cf +++ : /var/lib/heartbeat +++ : /var/run/resource-agents +++ : /var/run/heartbeat/rsctmp +++ : /var/lib/heartbeat/fifo +++ : /usr/lib64/heartbeat +++ : /usr/sbin +++ : '%Y/%m/%d_%T ' +++ : /dev/null +++ : /etc/ha.d/resource.d +++ : /usr/share/doc/heartbeat +++ : oracle +++ : /var/run/ +++ : /var/lock/subsys/ ++ . /usr/lib/ocf/lib/heartbeat/ocf-rarun ++ : 0 ++ __ocf_set_defaults start
[Linux-HA] Oracle OCF Script throws SP2-0640: Not connected
Hello *, i did a lot of research but i´m not able to get the purpose whether our oracle ressource fails on Wednesday. Oracle start will fail with the message: /usr/lib/ocf/resource.d/heartbeat/oracle start INFO: orcSNBGW instance state is not OPEN (dbstat output: SP2-0640: Not connected) ERROR: oracle instance orcSNBGW not started: Showdbstat throws: /usr/lib/ocf/resource.d/heartbeat/oracle showdbstat Full output: SP2-0640: Not connected Stripped output: OPEN So the first method of showdbstat monitoring the DB fails, but the second one succeeds. It is not possible to start oracle within the pacemaker cluster anymore. Everytime we start it, it´ll fail. I´ve attached the bash output while starting oracle with the ocf script. Database and OS is fine. Nothing changed in the last days. Do have any ideas? Thank you in advance. Mit freundlichen Grüßen / Best regards Christian Wendt Bosch Software Innovations GmbH Information Technology (INST/PRV3-IT) Schöneberger Ufer 89-91 10785 Berlin GERMANY www.bosch-si.de www.blog.bosch-si.com Tel. +49 30.72 61 12-308 Fax +49 30.72.61.12-100 christian.we...@bosch-si.com Registered office: Berlin, Register court: Amtsgericht Charlottenburg, HRB 148411 B Executives: Rainer Kallenbach; Thomas Cotic, Michael Hahn, Klaus Hüftle HOSTXXX:/opt/oracle/app/diag/rdbms/orcsnbgw/orcSNBGW/trace # bash -x /usr/lib/ocf/resource.d/heartbeat/oracle start + : /usr/lib/ocf/lib/heartbeat + . /usr/lib/ocf/lib/heartbeat/ocf-shellfuncs ++ unset LC_ALL ++ export LC_ALL ++ unset LANGUAGE ++ export LANGUAGE +++ basename /usr/lib/ocf/resource.d/heartbeat/oracle ++ __SCRIPT_NAME=oracle ++ '[' -z /usr/lib/ocf ']' ++ '[' /usr/lib/ocf/lib/heartbeat = /usr/lib/ocf/resource.d/heartbeat ']' ++ : /usr/lib/ocf/lib/heartbeat ++ . /usr/lib/ocf/lib/heartbeat/ocf-binaries +++ PATH=/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/sbin:/bin:/usr/sbin:/usr/bin +++ PATH=/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/ucb +++ export PATH +++ : gawk +++ : '/usr/bin/grep -E' +++ : -a +++ : mail +++ : /bin/ping +++ : /bin/sh +++ : /usr/bin/test +++ : /usr/bin/test +++ : basename +++ : blockdev +++ : cat +++ : fsck +++ : fuser +++ : getent +++ : grep +++ : ifconfig +++ : iptables +++ : ip +++ : mdadm +++ : modprobe +++ : mount +++ : msgfmt +++ : netstat +++ : perl +++ : python +++ : raidstart +++ : raidstop +++ : route +++ : umount +++ : reboot +++ : poweroff +++ : wget +++ : whoami +++ : strings +++ : scp +++ : ssh +++ : swig +++ : gzip +++ : tar +++ : md5 +++ : drbdadm +++ : drbdsetup ++ . /usr/lib/ocf/lib/heartbeat/ocf-returncodes +++ OCF_SUCCESS=0 +++ OCF_ERR_GENERIC=1 +++ OCF_ERR_ARGS=2 +++ OCF_ERR_UNIMPLEMENTED=3 +++ OCF_ERR_PERM=4 +++ OCF_ERR_INSTALLED=5 +++ OCF_ERR_CONFIGURED=6 +++ OCF_NOT_RUNNING=7 +++ OCF_RUNNING_MASTER=8 +++ OCF_FAILED_MASTER=9 ++ . /usr/lib/ocf/lib/heartbeat/ocf-directories +++ prefix=/usr +++ exec_prefix=/usr +++ : /etc/init.d +++ : /etc/ha.d +++ : /etc/ha.d/rc.d +++ : /etc/ha.d/conf +++ : /etc/ha.d/ha.cf +++ : /var/lib/heartbeat +++ : /var/run/resource-agents +++ : /var/run/heartbeat/rsctmp +++ : /var/lib/heartbeat/fifo +++ : /usr/lib64/heartbeat +++ : /usr/sbin +++ : '%Y/%m/%d_%T ' +++ : /dev/null +++ : /etc/ha.d/resource.d +++ : /usr/share/doc/heartbeat +++ : oracle +++ : /var/run/ +++ : /var/lock/subsys/ ++ . /usr/lib/ocf/lib/heartbeat/ocf-rarun ++ : 0 ++ __ocf_set_defaults start ++ __OCF_ACTION=start ++ unset LANG ++ LC_ALL=C ++ export LC_ALL ++ '[' -z '' ']' ++ : 0 ++ '[' '!' -d /usr/lib/ocf ']' ++ '[' -z '' ']' ++ : oracle ++ '[' -z '' ']' ++ : We are being invoked as an init script. ++ : Fill in some things with reasonable values. ++ : default ++ return 0 ++ : ++ ocf_is_true '' ++ case $1 in ++ false + . /usr/lib/ocf/lib/heartbeat/ora-common.sh + PROCS_CLEANUP_TIME=30 + MONUSR=OCFMON + OCF_REQUIRED_PARAMS=sid + OCF_REQUIRED_BINARIES=sqlplus + ocf_rarun start + mk_action_func ++ echo oracle_start ++ tr - _ + ACTION_FUNC=oracle_start + validate_args + is_function oracle_start ++ command -v oracle_start + test zoracle_start = zoracle_start + simple_actions + case $__OCF_ACTION in + check_required_params + local v + for v in '$OCF_REQUIRED_PARAMS' + is_var_defined OCF_RESKEY_sid +++ echo OCF_RESKEY_sid ++ eval echo '$OCF_RESKEY_sid' +++ echo orcSNBGW + test z '!=' zorcSNBGW + run_function oracle_getconfig + is_function oracle_getconfig ++ command -v oracle_getconfig + test zoracle_getconfig = zoracle_getconfig + oracle_getconfig + ora_common_getconfig orcSNBGW /opt/oracle/app/product/11.2.0/dbhome_1 oracle '' + ORACLE_SID=orcSNBGW + ORACLE_HOME=/opt/oracle/app/product/11.2.0/dbhome_1 + ORACLE_OWNER=oracle + TNS_ADMIN= + '[' x = x/opt/oracle/app/product/11.2.0/dbhome_1 ']' + '[' x = xoracle ']' + '[' x = x ']' +
Re: [Linux-HA] Oracle OCF Script throws SP2-0640: Not connected
i'm using resource-agents-3.9.2-0.25.5 on Suse 11 Sp2 and i don't have any . /usr/lib/ocf/lib/heartbeat/ora-common.sh maybe you need to create a new database user ++ local 'conn_s=connect OCFMON/OCFMON' ++ shift 1 ++ local func ++ echo 'connect OCFMON/OCFMON' 2014-08-01 18:40 GMT+02:00 Wendt Christian christian.we...@bosch-si.com: Hello *, i did a lot of research but i´m not able to get the purpose whether our oracle ressource fails on Wednesday. Oracle start will fail with the message: /usr/lib/ocf/resource.d/heartbeat/oracle start INFO: orcSNBGW instance state is not OPEN (dbstat output: SP2-0640: Not connected) ERROR: oracle instance orcSNBGW not started: Showdbstat throws: /usr/lib/ocf/resource.d/heartbeat/oracle showdbstat Full output: SP2-0640: Not connected Stripped output: OPEN So the first method of showdbstat monitoring the DB fails, but the second one succeeds. It is not possible to start oracle within the pacemaker cluster anymore. Everytime we start it, it´ll fail. I´ve attached the bash output while starting oracle with the ocf script. Database and OS is fine. Nothing changed in the last days. Do have any ideas? Thank you in advance. Mit freundlichen Grüßen / Best regards Christian Wendt Bosch Software Innovations GmbH Information Technology (INST/PRV3-IT) Schöneberger Ufer 89-91 10785 Berlin GERMANY www.bosch-si.de www.blog.bosch-si.com Tel. +49 30.72 61 12-308 Fax +49 30.72.61.12-100 christian.we...@bosch-si.com Registered office: Berlin, Register court: Amtsgericht Charlottenburg, HRB 148411 B Executives: Rainer Kallenbach; Thomas Cotic, Michael Hahn, Klaus Hüftle ___ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems -- esta es mi vida e me la vivo hasta que dios quiera ___ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
Re: [Linux-HA] Oracle OCF Script throws SP2-0640: Not connected
Hi, On Fri, Aug 01, 2014 at 04:40:25PM +, Wendt Christian wrote: Hello *, i did a lot of research but i´m not able to get the purpose whether our oracle ressource fails on Wednesday. Oracle start will fail with the message: /usr/lib/ocf/resource.d/heartbeat/oracle start INFO: orcSNBGW instance state is not OPEN (dbstat output: SP2-0640: Not connected) ERROR: oracle instance orcSNBGW not started: Showdbstat throws: /usr/lib/ocf/resource.d/heartbeat/oracle showdbstat Full output: SP2-0640: Not connected Stripped output: OPEN So the first method of showdbstat monitoring the DB fails, but the second one succeeds. That seems to be a bug with the OCFMON monitoring user password expired. It was fixed. You can either update the oracle RA from upstream or reset the OCFMON password (OCFMON) and set its life to unlimited. Thanks, Dejan It is not possible to start oracle within the pacemaker cluster anymore. Everytime we start it, it´ll fail. I´ve attached the bash output while starting oracle with the ocf script. Database and OS is fine. Nothing changed in the last days. Do have any ideas? Thank you in advance. Mit freundlichen Grüßen / Best regards Christian Wendt Bosch Software Innovations GmbH Information Technology (INST/PRV3-IT) Schöneberger Ufer 89-91 10785 Berlin GERMANY www.bosch-si.de www.blog.bosch-si.com Tel. +49 30.72 61 12-308 Fax +49 30.72.61.12-100 christian.we...@bosch-si.com Registered office: Berlin, Register court: Amtsgericht Charlottenburg, HRB 148411 B Executives: Rainer Kallenbach; Thomas Cotic, Michael Hahn, Klaus Hüftle Content-Description: bashx_oracle_ocf.txt HOSTXXX:/opt/oracle/app/diag/rdbms/orcsnbgw/orcSNBGW/trace # bash -x /usr/lib/ocf/resource.d/heartbeat/oracle start + : /usr/lib/ocf/lib/heartbeat + . /usr/lib/ocf/lib/heartbeat/ocf-shellfuncs ++ unset LC_ALL ++ export LC_ALL ++ unset LANGUAGE ++ export LANGUAGE +++ basename /usr/lib/ocf/resource.d/heartbeat/oracle ++ __SCRIPT_NAME=oracle ++ '[' -z /usr/lib/ocf ']' ++ '[' /usr/lib/ocf/lib/heartbeat = /usr/lib/ocf/resource.d/heartbeat ']' ++ : /usr/lib/ocf/lib/heartbeat ++ . /usr/lib/ocf/lib/heartbeat/ocf-binaries +++ PATH=/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/sbin:/bin:/usr/sbin:/usr/bin +++ PATH=/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/ucb +++ export PATH +++ : gawk +++ : '/usr/bin/grep -E' +++ : -a +++ : mail +++ : /bin/ping +++ : /bin/sh +++ : /usr/bin/test +++ : /usr/bin/test +++ : basename +++ : blockdev +++ : cat +++ : fsck +++ : fuser +++ : getent +++ : grep +++ : ifconfig +++ : iptables +++ : ip +++ : mdadm +++ : modprobe +++ : mount +++ : msgfmt +++ : netstat +++ : perl +++ : python +++ : raidstart +++ : raidstop +++ : route +++ : umount +++ : reboot +++ : poweroff +++ : wget +++ : whoami +++ : strings +++ : scp +++ : ssh +++ : swig +++ : gzip +++ : tar +++ : md5 +++ : drbdadm +++ : drbdsetup ++ . /usr/lib/ocf/lib/heartbeat/ocf-returncodes +++ OCF_SUCCESS=0 +++ OCF_ERR_GENERIC=1 +++ OCF_ERR_ARGS=2 +++ OCF_ERR_UNIMPLEMENTED=3 +++ OCF_ERR_PERM=4 +++ OCF_ERR_INSTALLED=5 +++ OCF_ERR_CONFIGURED=6 +++ OCF_NOT_RUNNING=7 +++ OCF_RUNNING_MASTER=8 +++ OCF_FAILED_MASTER=9 ++ . /usr/lib/ocf/lib/heartbeat/ocf-directories +++ prefix=/usr +++ exec_prefix=/usr +++ : /etc/init.d +++ : /etc/ha.d +++ : /etc/ha.d/rc.d +++ : /etc/ha.d/conf +++ : /etc/ha.d/ha.cf +++ : /var/lib/heartbeat +++ : /var/run/resource-agents +++ : /var/run/heartbeat/rsctmp +++ : /var/lib/heartbeat/fifo +++ : /usr/lib64/heartbeat +++ : /usr/sbin +++ : '%Y/%m/%d_%T ' +++ : /dev/null +++ : /etc/ha.d/resource.d +++ : /usr/share/doc/heartbeat +++ : oracle +++ : /var/run/ +++ : /var/lock/subsys/ ++ . /usr/lib/ocf/lib/heartbeat/ocf-rarun ++ : 0 ++ __ocf_set_defaults start ++ __OCF_ACTION=start ++ unset LANG ++ LC_ALL=C ++ export LC_ALL ++ '[' -z '' ']' ++ : 0 ++ '[' '!' -d /usr/lib/ocf ']' ++ '[' -z '' ']' ++ : oracle ++ '[' -z '' ']' ++ : We are being invoked as an init script. ++ : Fill in some things with reasonable values. ++ : default ++ return 0 ++ : ++ ocf_is_true '' ++ case $1 in ++ false + . /usr/lib/ocf/lib/heartbeat/ora-common.sh + PROCS_CLEANUP_TIME=30 + MONUSR=OCFMON + OCF_REQUIRED_PARAMS=sid + OCF_REQUIRED_BINARIES=sqlplus + ocf_rarun start + mk_action_func ++ echo oracle_start ++ tr - _ + ACTION_FUNC=oracle_start + validate_args + is_function oracle_start ++ command -v oracle_start + test zoracle_start = zoracle_start + simple_actions + case $__OCF_ACTION in + check_required_params + local v + for v in '$OCF_REQUIRED_PARAMS' + is_var_defined OCF_RESKEY_sid +++ echo OCF_RESKEY_sid ++ eval echo '$OCF_RESKEY_sid' +++ echo orcSNBGW