HPUX-ia64 Error: 2: No such file or directory

[Mohan Radhakrishnan]

SQLException Occurred : ORA001034: ORACLE not available
ORA-27101: shared memory realm does not exist
HPUX-ia64 Error: 2: No such file or directory

---------------------

I have seen similary errors posted to this forum.

Does anyone have any ideas ?

[AnthonySN]

read this
http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=1

[Matti_Kurkela]

"No such file or directory" is a generic POSIX error text which is sometimes used in error situations that aren't related to files or directories. In those cases, it means "you asked for something that does not exist".

The Oracle error ORA-27101 probably refers to the same error as the HPUX-ia64 error, but the Oracle client can state the error in a more useful way: "shared memory realm does not exist". Oracle clients can use a shared memory realm to communicate with the database engine, if the client and the database are located on the same host.

The Oracle error ORA001034 is again a more generic error description: "ORACLE not available", i.e. there does not seem to be an Oracle database in the configured location.

To summarize:
Your application wants to connect to a (local?) Oracle database, but cannot do that because Oracle does not seem to be running on the local host.

If this server is supposed to run the Oracle database locally, find the name of the database and verify that the application is using the correct database name.

If the database is supposed to be on the remote host, verify the application's database connection settings. In that case, there is probably an Oracle client installed on the local system: in that case, the important configuration files might be tnsnames.ora and/or sqlnet.ora, both located in $ORACLE_HOME/network/admin directory.

MK

[John Brooks_1]

My first thought was to check your ORACLE_SID. Make sure it is set to the correct database.

What were you tring to do when you received this message? Did you review your Oracle Alert log?

[Mohan Radhakrishnan]

We haven't checked the alert log but this is random. It does not show this error everytime.

Our DBA has increased SGA memory to 1 GB

[John Brooks_1]

If the error is not in the alert log then the database is not catching the error ,thus; the error is at the O/S or client level.

How is your client setup? running from a PC or HP-UX shell? If your running from the shell, make sure your ORACLE_SID is set.