Re: Q: File dependencies of SQLPLUS

bauhahnm_at_csis.gvsu.edu (Maurice Bauhahn) wrote: [...]
>ERROR: ORA-01034: ORACLE not available
>ORA-07429: smsgs: shmget() filed to get segment.
>UP-UX Error: 2: No such file or directory
 

>Any idea what file/s SQLPLUS is looking for so? The Oracle server process
>seems to be running. There is no critical data, but on the other hand we
>are not wild about reinstalling everything again either.

When you get an ORA-nnnn error, it's a good idea to look it up in the Oracle error codes doc. In this case (ORA-01034), it will tell you that the Oracle database instance to which you are trying to connect is not started. Either it hasn't been started, the startup failed, or you have incorrectly specified the target instance.

The supplemental errors (ORA-07429 and "HP-UX Error 2") don't really contribute useful info in this case. They are artifacts of the way a process connects to an Oracle instance in UNIX, namely by attaching the shared memory segments that represent the SGA.

/b

--
Bill Manry - IBM Products Division - Oracle Corp. USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Remove the "." from "B.Manry" to email me.