Oracle toolkit

[Hans Hendriks_1]

Hello everyone,

I have a problem with a 7.3.4 instance from oracle and my toolkit.

We have a 2 node l class cluster with mc serviquard 11.12 and ux 11.0

We have several oracle instances that must become a package.

I configured a package with the oracle toolkit.

The package is oke and runs. Because when I swith the monitoring script of it runs.

But I have problems with the Oracle.sh script.
When I start the package with a cmrunpkg the package is going up and running.

But when I halt the package with cmhaltpkg it will not stop (see messages 1).

The routine in the oracle script does a Oracle.sh shutdown.

When I stop the package through stopping the processes and start the package again with cmrunpkg and after that I start from the promt ./Oracle.sh shutdown everything works as that it should be (see messages 2).

1) shutting down oracle session at
Oracle Server Manager Release 2.3.4.0.0.production
Copyright oracle corporation etc
oracle server release 7.3.4.5.0
with the distributes and parrallel query options
pl/sql Release 2.3.4.5.0

SVRMGR> Connected to an idle instace
SVRMGR> Ora-01012: not logged on
SVRMGR> Server Manager complete
Oracle shutdown done

2) shutting down oracle session at
Oracle Server Manager Release 2.3.4.0.0.production
Copyright oracle corporation etc
oracle server release 7.3.4.5.0
with the distributes and parrallel query options
pl/sql Release 2.3.4.5.0

SVRMGR> connected
SVRMGR>Database closed
Database dismounted
Oracle instance shut down
SVRMGR>Server Manager complete
Oracle shutdown done


Hope that someone can help me.

[Volker Borowski]

Hi Hans,

include a line

env > /tmp/env_mon.txt

in the Oracle.sh Script, right before the shutdown should be executed.
Compare the output in both cases.
I suspect that the environment, esp. $ORACLE_HOME / $ORACLE_SID is diffrent in both cases.

Volker

[Brian Crabtree]

I agree with volker. You will want to look through your package information for the 'halt' commands. Most likely, the settings are different or wrong.

Also, most systems do not use one package for multiple instances, but multiple packages for multiple instances. Sometimes, and application is failed with the database, but normally only one database is in a package.

If you are still having trouble, you might want to post your .sh file (or whatever your halt script is) after making sure that there are no passwords in it.

Thanks,

Brian

[Hans Hendriks_1]

Hi again.

I have tried the suggestion with the env and to log it.
I do not see any differance between when I shut oracle by hand and when I shut it by cmhaltpkg.

Any other suggestions ?

Thanks

[Hans Hendriks_1]

Hi again.

I have tried the suggestion with the env and to log it.
I do not see any differance between the env variables when I shut oracle by hand and when I shut it by cmhaltpkg.

Any other suggestions ?

Thanks