skip to main content

SAP NetWeaver Newbie

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

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.