All entries for Monday 02 August 2010
August 02, 2010
I puppetized Oracle listener.ora, then suddenly I cannot connect to Oracle
sqlplus system/xxx@db_service ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Solaris-AMD64 Error: 2: No such file or directory
I checked the configuration, everything seems fine.
After some fruitless effort, I notice the value $oracle_home in of /var/opt/oracle/oratab is /usr/local/oracle. /usr/local/oracle is the symlink of /package/oracle. I changed the value of /var/opt/oracle/oratab to /package/oracle and reset the environment variable ORACLE_HOME to /package/oracle. Restarted the database and I can now connect to database.