One of my friend installed Oracle first time. After installation, he just wants to make sure everything is working fine so he called me. If you are installing oracle for Unix/Linux oses first time then it will confuse you. He wanted to know how to start oracle service and test it. He emailed me the following error:
ORA-27101: shared memory realm does not exist
ORA-01034: ORACLE not available
You need to add following line to oracle user’s .bash_profile file for testing purpose (once it is tested, you can give control to Oracle DBA) (login as a oracle user):
$ cd;vi .bash_profile
Append following lines:
export ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
Save file. Just load the above settings:
$ . .bash_profile
Start oracle Net listing service:
$ lsnrctl start
ALTERNATIVELY use full path:
$ /home/oracle/oracle/product/10.2.0/db_1/bin/lsnrctl start
Start oracle database:
$ dbstart
ALTERNATIVELY, use full path:
$ /home/oracle/oracle/product/10.2.0/db_1/bin/dbstart
Connect to Oracle database with sqlplus client (test it with scott username):
$ sqlplus "scott/tiger"
sql> select * from tab;
To shutdown Oracle database:
$ lsnrctl stop
$ dbshut
Further readings:
If you are new to Oracle try out Oracle Database 10g Documentation library, especially 2 Day DBA is fantastic document. Do not forget check out John Smiley's "Installing Oracle Database 10g Release 2 on Linux x86" article. It will teach you the basics of installing Oracle Database 10g Release 2 on Red Hat Enterprise Linux or Novell SUSE Enterprise Linux, from the bare metal up.
You should follow me on twitter here or grab rss feed to keep track of new changes.
Featured Articles:
- 30 Handy Bash Shell Aliases For Linux / Unix / Mac OS X
- Top 30 Nmap Command Examples For Sys/Network Admins
- 25 PHP Security Best Practices For Sys Admins
- 20 Linux System Monitoring Tools Every SysAdmin Should Know
- 20 Linux Server Hardening Security Tips
- Linux: 20 Iptables Examples For New SysAdmins
- Top 20 OpenSSH Server Best Security Practices
- Top 20 Nginx WebServer Best Security Practices
- 20 Examples: Make Sure Unix / Linux Configuration Files Are Free From Syntax Errors
- 15 Greatest Open Source Terminal Applications Of 2012

- My 10 UNIX Command Line Mistakes
- Top 10 Open Source Web-Based Project Management Software
- Top 5 Email Client For Linux, Mac OS X, and Windows Users
- The Novice Guide To Buying A Linux Laptop













{ 2 comments… read them below or add one }
I was wondering for same how the hell get the rid of this error message :)
It is working now. thanks a lot
God bless all of you :D
–Ahmed
am having the same problem and i cant log in to isqlplus.can you help? pls..