cmhaltpkg stops oracle with error

[Hasan_9]

Hello All,

Current State:
Listener and database starts manually without any error.I can connect to database and make query.
Listener and database stops manually without any error.
I use HP Enterprise Cluster Master Toolkit (ECMT) version B.03.00 as start/stop/monitor scripts
Cmrunpkg can start the database without any error.
Cmrunhaltpkg stops the database but report an error. Here is a result of cmhaltpkg:

# cmhaltpkg -v oracle
Halting package oracle.
cmhaltpkg : Script failed with no restart: oracle should not be restarted.
Check the syslog and pkg log files for more detailed information.

Attached you can find the pkg log. Here is syslog.log reports:

May 27 22:06:23 test-dev CM-CMD[16770]: cmhaltpkg -v oracle
May 27 22:06:23 test-dev cmcld: Request from node test-dev to disable global switching for package oracle.
May 27 22:06:23 test-dev cmcld: Request from node test-dev to halt package oracle on node test-dev.
May 27 22:06:23 test-dev cmcld: Executing '/etc/cmcluster/pkg/oracle/oracle.cntl stop' for package oracle, as service PKG*1793.
May 27 22:06:23 test-dev CM-oracle[16779]: cmhaltserv oracle
May 27 22:06:24 test-dev su: + tty?? root-oracle
May 27 22:06:25 test-dev CM-oracle[16861]: cmmodnet -r -i 192.168.1.3 192.168.1.0
May 27 22:06:27 test-dev LVM[16903]: vgchange -a n /dev/vg01
May 27 22:06:27 test-dev LVM[16911]: vgchange -a n /dev/vg02
May 27 22:06:24 test-dev su: + tty?? root-oracle
May 27 22:06:27 test-dev LVM[16919]: vgchange -a n /dev/vg03
May 27 22:06:27 test-dev cmcld: Service PKG*1793 terminated due to an exit(1).
May 27 22:06:27 test-dev cmcld: Halted package oracle on node test-dev.
May 27 22:06:27 test-dev cmcld: Package oracle halt script exited with NO_RESTART.
May 27 22:06:27 test-dev cmcld: Examine the file /etc/cmcluster/pkg/oracle/oracle.cntl.log for more details.
May 27 22:06:27 test-dev cmcld: Switching disabled on package oracle.
May 27 22:06:27 test-dev cmcld: Package oracle did not halt cleanly. Owning node encountered an error during halt.

[Luk Vandenbussche]

Hi,
There are errors in /etc/cmcluster/pkg/oracle/toolkit.sh

Advise to do the following.

1) start the package without starting the database
2) Start / stop database with the script to search for error
./toolkit.sh start
./toolkit.sh stop
3) Start monitor script manually
4) If all the errors are solved then restart the package with automatically start of oracle

[Warren_9 · Accepted solution]

hi,

how come the "toolkit.sh start" is calling in halting?

May 27 22:06:23 - Node "test-dev": Halting service oracle
May 27 22:06:24 - Node "test-dev" *** /etc/cmcluster/pkg/oracle/toolkit.sh called with start argument. ***

please check the customer defind halt procedure in the oracle.cntl is configure correctly.

GOOD LUCK!!

[Enrico P.]

Hi,
all the errors are because the Oracle Instance isn' t started and the listener was already running.
So first resolve this problem and after check for the other.

Enrico

[melvyn burnard]

I would sugest you check your user_defined_halt_commands setting, it appears you are trying to START Oracle and not STOP it.

[Matthew Ghofrani]

Here is a long shot. Did your Oracle listener configured with a password? If so, in most cases start listener will succeed while stop would fail.

Matthew From Boston

[Hasan_9]

Thank you