How do I start the Oracle database server as a service under Linux operating systems?
Starting the Oracle database server is very easy under Linux:
a) Login as an oracle user
b) First start the Oracle listener processes using lsnrctl utility
c) Next start the Oracle database using dbstart utility that reads the oratab file (/etc/oratab)
d) Connect to server using sql plus client or isql pluse web based client
Type the following commands:
$ su - oracle
$ lsnrctl start
$ dbstart
To make the entire process easy we have a shell script that starts and stops Oracle database.
Download script to /tmp directory and rename it as oracle
Copy script to /etc/init.d directory:
# cp /tmp/oracle /etc/init.d/oracle
Create a soft link (Run level 3):
# cd /etc/rc3.d/
# ln -s ../init.d/oracle S100oracle
# ln -s ../init.d/oracle K100oracle
Alternatively, use the chkconfig command to add script:
# chkconfig --add oracle
# chkconfig --list oracle
Please note that you can just use script directly, to start the Oracle type the following command:
# /etc/init.d/oracle start
To stop the Oracle type the following command:
# /etc/init.d/oracle stop
Featured Articles:
- 20 Linux System Monitoring Tools Every SysAdmin Should Know
- 20 Linux Server Hardening Security Tips
- My 10 UNIX Command Line Mistakes
- Linux: 20 Iptables Examples For New SysAdmins
- 25 PHP Security Best Practices For Sys Admins
- The Novice Guide To Buying A Linux Laptop
- 10 Greatest Open Source Software Of 2009
- Top 5 Email Client For Linux, Mac OS X, and Windows Users
- Top 20 OpenSSH Server Best Security Practices
- Top 10 Open Source Web-Based Project Management Software
- Top 5 Linux Video Editor Software
Facebook it - Tweet it - Print it -
{ 8 comments… read them below or add one }
Thanks a lot
i did worked, thanks a lot
it’s working..
thanks a lot..
it works
thanks a lot!
The download link has been blocked.
Safe Browsing
Diagnostic page for bash.cyberciti.biz
What is the current listing status for bash.cyberciti.biz?
Site is listed as suspicious – visiting this web site may harm your computer.
Part of this site was listed for suspicious activity 3 time(s) over the past 90 days.
What happened when Google visited this site?
Of the 17 pages we tested on the site over the past 90 days, 15 page(s) resulted in malicious software being downloaded and installed without user consent. The last time Google visited this site was on 2010-09-14, and the last time suspicious content was found on this site was on 2010-09-14.
Malicious software is hosted on 1 domain(s), including superstoreviagra.com/.
1 domain(s) appear to be functioning as intermediaries for distributing malware to visitors of this site, including simplyguide.com/.
This site was hosted on 1 network(s) including AS36351 (SOFTLAYER).
Has this site acted as an intermediary resulting in further distribution of malware?
Over the past 90 days, bash.cyberciti.biz did not appear to function as an intermediary for the infection of any sites.
Has this site hosted malware?
No, this site has not hosted malicious software over the past 90 days.
How did this happen?
In some cases, third parties can add malicious code to legitimate sites, which would cause us to show the warning message.
Could you please fix it?
Thank you.
This has been already fixed, but Google will take day or two to remove the same. Try wget.
HTH
cheers. was very helpful.
on RHEL5U4.
Can you explain what the
# set username
SUSER=”suser”
# set password
SPASS=”spass”
are for?
thank you for the script.
do i need to modify the script to use it in Ubuntu 10.10 Desktop , Debian base