oracle package cannot start on cluster

[Hasan_9]

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

[Michael Steele_2]

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

[Mridul Shrivastava]

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.

[Darrel Louis]

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

[Delrish · Accepted solution]

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

[Faizer Jameel]

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

[Hasan_9]

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.

[Michael Steele_2]

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

[Darrel Louis]

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

[Hasan_9]

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.