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:
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' startup exit