When running some Oracle commands (imp/exp), I got this error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
This is due to the fact that you need to have the ORACLE_SID and the ORACLE_UNQNAME be exactly the same.
In other words, the SID used to start the listener (ORACLE_UNQNAME) and the one used to connect to it (ORACLE_SID) must be exactly the same.
Example:
export ORACLE_UNQNAME=orcl
export ORACLE_SID=ORCL
Won’t work.
You need to set
export ORACLE_UNQNAME=orcl
export ORACLE_SID=orcl
for that to work! It’s case-sensitive, go figure…
