Linux Error: 2: No such file or directory
433977Dec 6 2004 — edited Sep 27 2007Hi all,
Trying to complete my installation or Oracle 9i (9.2.0.4) on RedHat Linux AS2.1. One last error (I hope):
I have set ORACLE_SID=bluetest and can connect to the database ok with:
# sqlplus "/ as sysdba"
SQL> startup pfile=/path/to/pfile
database is mounted and opened. I can even run queries such as 'select tname from tab". I even created new tables etc. No problems there.
However, when I try to connect using:
# sqlplus user/password@bluetest
I am getting:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
# tnsping bluetest works fine and user does exist and has connect privilege.
I have checked bdump/alert_bluespace.log and udump/*.trc files but I cannot find any errors in there.
Also, the $ORACLE_HOME directory and subdirectories are all owned by user "oracle", group "oinstall" and have rwxr-xr-x permissions.
Is there anybody out there that could give me a clue what file or directory it is looking for.
Thanks in advance,
Rudi.