Huge points for a working script.

[Steven E. Protter]

The end of the reports60_server script is at issue now.

I added at Oracle's behest a ps -ef | grep for the process that is supposed to start, right after the nohup statement that is supposed to start the daemon.

Last line of script is exit 0


Strangely after adding the ps -ef and rebooting, the daemon starts.

Makes no sense at all.

[Brian Crabtree]

I'm not sure if you are exporting the enviroment variable somewhere else, but you are exporting your TNS_ADMIN variable without a valid ORACLE_HOME in your script. You might want to consider hardcoding this path to your tnsnames.ora file, and verifying that the tnsnames.ora file has the correct configuration for the report server. (original is found in $ORACLE_HOME/6iserver/network/admin)

Brian

[Yogeeraj_1]

hi Steven,

Quite strange problem. Seems to be occurring on HP-UX platforms only.

I have observed that all the supplied "reports60_server" script contains the last line "exit 0". Have been working with 9iAS 1.0.2 patch 5a, patch 11 and patch 12.

Is the solution to replace exit 0 with exit 1 or just to remove that last line?

Best Regards
Yogeeraj

[Judy Traynor]

note:

/bin/sh is not the same shell as /sbin/sh

[Judy Traynor]

don't know if it is the shell thing - but would try to be consistent (posix vs bourne)

[Steven E. Protter]

The consistency problem is all Oracles.

I am a posix man, through and through unless forced otherwise.

Software AG databases require korn and sometimes bourne.'

Oracle is inconsistent.

Apologies for the delay in awarding you your points guys.

[Yogeeraj_1 · Accepted solution]

Dear Mr. Protter,

please allow me to post this information that deals with forms as well report server startup on HP-UX systems.

For those who have metalink access, see:
Please check out the Note:
Note:210097.1 Configuring automatic startup & shutdown of 9iAS Forms & Reports Servers during HP-UX system reboot

Best Regards
Yogeeraj