Saturday, July 7, 2012

Oracle "connected to an idle instance" and ORA-01034


When you try to connect to Oracle database and see "connected to an idle instance" as you enter sqlplus, there are chances that you have set incorrect file permissions.





Check that $ORACLE_HOME/bin has "drwxr-xr-x" permisson

The file "oracle" in $ORACLE_HOME/bin should have non-zero size and permission "-rwsr-s--x"



If the permission differs, set it correctly using the following command

chmod 6751 oracle





No comments:

Post a Comment