topic Re: oracle package cannot start on cluster in Operating System - HP-UX

oracle package cannot start on cluster

Hasan_9 — Sat, 27 May 2006 09:57:24 GMT

Hi All,
I try to run an oracle package on my two nodes cluster. I got the attached error in package's log. Please advice what I should do.

Hasan

Re: oracle package cannot start on cluster

Michael Steele_2 — Sat, 27 May 2006 11:04:11 GMT

Check .profile for root on both and make sure a non-interactive session will work.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1001739

Re: oracle package cannot start on cluster

Mridul Shrivastava — Sat, 27 May 2006 11:59:52 GMT

There is some issue with oracle as oracle is not starting, I would suggest you to involve oracel team and check the configuration.
Moreover could u pls check the permissions on /etc/hosts on all the servers.
Pls check the control script files which is starting oracle as its unable to start oracle.

Re: oracle package cannot start on cluster

Darrel Louis — Sat, 27 May 2006 12:08:58 GMT

Hasan,

How do you start the Oracle instance?
are you using "su -c ora_user ".

Is this a new package or a existing?

Have you tried to start it manually,
- Mount Filesystem
- start Oracle instance.
If the above is working there is something wrong in your control file.

Darrel

Re: oracle package cannot start on cluster

Delrish — Sat, 27 May 2006 23:25:35 GMT

Did you customize "PFILE" in your haoracle.conf? you should enter a correct path to oracle's pfile.
Also check that the pfile exist in the path and if necessary re-create it.

Alireza

Re: oracle package cannot start on cluster

Faizer Jameel — Sun, 28 May 2006 01:26:15 GMT

Hi Hasan
The error says that "Failed to RUN customer commands"
So this could be due to the following reasons
1. The Oracle startup and shutdown scripts are not in the correct path or their permissions are not set right.
2. The calling scripts are itself having some issue.
So as suggested the best way to test this is:
1. mount the all file systems for the Application
2. Run the script [ that is used in the package] to start the Oracle application and the database.
If these scripts give the same issue then just contact your DBA to check the Oracle startup and shutdown scripts.
Thanks
Faizer

Re: oracle package cannot start on cluster

Hasan_9 — Sun, 28 May 2006 01:37:12 GMT

Thank you everybody,

The first problem has been solved with re creating oracle pfile.
Now, I have got an error during cmhaltpkg.
cmhaltpkg halts the package with error.Attached you will find package's log file.please advice.

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

Re: oracle package cannot start on cluster

Michael Steele_2 — Sun, 28 May 2006 07:12:22 GMT

Please attach following results.

netstat -a | grep 1521 (* listener port *)
errors in listener.ora
errors in listener log
lsof -i tcp:1521
lsnrctl status

verify environment variables in PATH

Re: oracle package cannot start on cluster

Darrel Louis — Sun, 28 May 2006 08:48:52 GMT

Hasan,

You should check your oracle environment settings if these are correct.
Can you also check your stop and start scripts.

Do the following:
- Comment out the startup and stop of Oracle out of your control file.
- Than start the package.
- Manually start Oracle.
- Check if Oracle started oke.
- stop Oracle
If the above is oke, than start to drill down to how oracle is stopped and started from the package

GoodLuck

Darrel

Re: oracle package cannot start on cluster

Hasan_9 — Mon, 29 May 2006 00:26:07 GMT

Thank you guys,
The first problem has been solved with creating pfile from spfile and start the database wit it.However I have a new problem with cmhaltpkg. I will open a new thread for this issue.