Oracle Error ORA-01034: ORACLE not available


ocilogon(): OCISessionBegin:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

1. Start -> Programs -> oracle -> OraHome81 -> Database Administration -> DBA Studio
2. Launch DBA Studio Standalone
3. Select DB Name
4. Username: sys
Password: change_on_install
Connect as: SYSDBA
5. DB Name -> Instance -> Database
6. Look at the Database State on the right side Panel
Select OPEN and Click APPLY then Click OK when asked for startup parameter
Click CLOSE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s