topic Re: Oracle toolkit in Operating System - HP-UX

Oracle toolkit

Hans Hendriks_1 — Tue, 18 Jun 2002 18:46:16 GMT

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.

Re: Oracle toolkit

Volker Borowski — Tue, 18 Jun 2002 18:53:55 GMT

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

Re: Oracle toolkit

Brian Crabtree — Wed, 19 Jun 2002 00:18:58 GMT

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

Re: Oracle toolkit

Hans Hendriks_1 — Wed, 19 Jun 2002 06:45:34 GMT

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

Re: Oracle toolkit

Hans Hendriks_1 — Wed, 19 Jun 2002 06:46:36 GMT

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