Problem solve Get help with specific problems with your technologies, process and projects.

ORA-01034 and ORA-27101 errors after installing Oracle 9i 9.2 on Solaris v5.9

I installed Oracle 9i 9.2 on a system running Solaris 9 v5.9. The install went fine. I was able to run SQL*Plus and even populate the database. After rebooting I started the listener and got a message back saying it started successfully. Now when I go to run SQL*Plus and put in the login credentials, I get the following error:

ORA-01034: Oracle not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

I checked all my environment variables and they are set. I placed them in my .profile file so they are set and exported automatically. I even checked the /etc/system file to make sure there were no errors in my shared memory parameters. I am stumped here. I have been online looking for answers. I have tried many solutions that worked for others but will not work in my situation.

Thanks in advance for the help.

Oracle and SQL Server are very different in that Oracle has a separate process that just listens for network connection requests and spawns the proper process. That means that you need to have a listener running and you also need to start the database instance(s). Usually, this can be done in a system startup script (the dbstart script in $ORACLE_HOME/bin can be helpful for this).

You'll need to start the instance--here's a primer:

sqlplus '/ as sysdba'

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.