topic Re: Process final status code. in Operating System - OpenVMS

Process final status code.

Kjartan Konradsson — Wed, 14 Jan 2004 06:17:17 GMT

Hi there..

Can anyone tell me what the code 10000002 means. I'm trying to start connection to Oracle database and the connection process goes up but dies with this status code. I can't find it anywhere on the system. Running OVMS 7.3-1

Kjartan

Re: Process final status code.

Karl Rohwedder — Wed, 14 Jan 2004 06:31:27 GMT

It simply means error (2), the leading 1 suppresses output of the error.
May be you could check ACCOUNTING for reasons the process dies as long as logfiles.

Re: Process final status code.

Kjartan Konradsson — Wed, 14 Jan 2004 06:42:47 GMT

I have had a look at the Accountng.dat and I see there
Final status code: 10000002
Final status text:

Oracle checks in the startup file, when starting up connection process, for the status of starting up the detached process and gets this status from the startup.

Re: Process final status code.

Lokesh_2 — Wed, 14 Jan 2004 06:44:22 GMT

Hi,

Issue the following command and see if you can find something on your system.

$ help/message/status=%X10000002

Thanks & regards,
Lokesh

Re: Process final status code.

Kjartan Konradsson — Wed, 14 Jan 2004 06:57:22 GMT

I have already done that an get
%MSGHLP-F-NOTFOUND, message not found in Help Message database.

So there is nothing to get there..

KK

Re: Process final status code.

Lokesh_2 — Wed, 14 Jan 2004 07:39:35 GMT

Hi,

In this case I guess you have to check the oracle troubleshooting documentation.

Best regards,
Lokesh

Re: Process final status code.

Ian Miller. — Wed, 14 Jan 2004 07:59:25 GMT

There is little information in the code 10000002
The initial 1 is the message supression flag. The 2 is the serverity = error.
A proper vms condition value would normally contain a facility code and message code but these are 0 in the code specified.

I think you will have to examine an oracle log file to determine the cause.

Re: Process final status code.

Kjartan Konradsson — Wed, 14 Jan 2004 08:58:14 GMT

Hi there..

I've solved the problem I was in by creating a new command file that oracle is using, when starting up connection to database. The only thing that was wrong was that I had put the SID name in lowercase insted of uppercase.
Oracle 9.2.0.4

Thanks

Re: Process final status code.

Hein van den Heuvel — Wed, 14 Jan 2004 10:22:53 GMT

> The only thing that was wrong was that I had put the SID name in lowercase insted of uppercase.
Oracle 9.2.0.4

Classical problem, lousy error reporting by Oracle.

Thanks for posting this update!
I guess you can not assign yourself 10 points can you?
I woudl like to see that, not for the points themself, but just to indicate closure?!

Cheers,
Hein.