All entries for Monday 02 August 2010

August 02, 2010

oracle listener config

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.
ORACLE_HOME=/package/oracle/product/10.2.0
ORACLE_SID=argon

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.

Hongfeng Sun : 02 Aug 2010 15:23 | Tags: Oracle Oracle-Availability | Comments (0) | Close comments | Report a problem

« Tuesday 03 August 2010 - Sunday 01 August 2010 »

Search this blog

Search Warwick Blogs

Most recent comments

Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
"logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry