How to install Oracle as a Linux service

Method One: Use Oracle's own startup and shutdown scripts

1. Oracle User modified/etc/oratab file:

1. $ vi/etc/oratab
2. Orcl:/oracle/app/product/10.2.0/db_1:n

Switch

Orcl:/oracle/app/product/10.2.0/db_1:y

That is, change the last n to Y, allowing the Dbstart startup database to run at system startup.

2. ORACLE User modified $oracle_home/bin/dbstart file:

1. # su-oracle
2. $ cd $ORACLE _home/bin
3. $ VI Dbstart

Find oracle_home_listner= ..... This line, modified into

Oracle_home_listner=/u01/app/oracle/product/10.1.0/db_1

or directly modified to:

oracle_home_listner= $ORACLE _home

3. Test run Dbshut, Dbstart

See if you can start Oracle Services and Listener services:

3.1. Execute the appropriate script to test

1. #su-oracle
2. $CD $ORACLE _home/bin
3. $./dbstart (Start database and listen)
4. $ PS-EFW | grep Ora_ (see if the database process is started)
5. $ lsnrctl Status (view listening status)
6. $ PS-EFW | grep LISTEN | Grep-v grep (View listening process, remove grep query itself)
7. $./dbshut (shut down the database, monitoring will not shut down, need to stop manually)

3.2. Modify the permissions of the Dbstart and Dbshut log files:

1. $su-root
2. #cd $ORACLE _home
3. #chown Oracle:oinstall Startup.log
4. #chown Oracle:oinstall Shutdown.log

Note: Startup.log and Shutdown.log may not be created automatically after you run the./dbstart and./dbshut.

4. Create a service

1. $su-root
2. # cd/etc/rc.d/init.d/
3. # VI Oracle (Oracle is the service name that will be installed to the system, can be taken)

There are two scripts to choose from, starting with different content.

Modify the Environment Variable configuration section (blue font position) according to your environment

Script 1 (Start database, listen, Dbconsole, Sqlplus)

The following 3 lines of the red font are required

345: Define Run Level

80: Service Start priority at boot (the smaller the number starts sooner)

10: Service Stop priority at shutdown (the smaller the number, the sooner it is closed)

2. #!/bin/bash
4. # chkconfig:345 80 10
6. # Description:startup Script for Oracle Databases
8. #/etc/rc.d/init.d/oracle
10. Export oracle_base=/u01/oracle
12. Export oracle_home=/u01/oracle/product
14. Export oracle_sid=pa
16. Export path= $PATH: $ORACLE _home/bin
18. ora_ownr="Oracle"
20. # If the executables does not exist--display error
22. if [!-F $ORACLE _home/bin/dbstart-o!-D $ORACLE _home]
24. Then
26. echo "Oracle Startup:cannot Start"
28. Exit 1
30. Fi
32. # depending on parameter-startup, shutdown, restart
34. # of the instance and listener or usage display
36. Case "$" in
38. Start
40. # Oracle Listener and Instance startup
42. Echo-n "Starting Oracle:"
44. su-$ORA _ownr-c "$ORACLE _home/bin/dbstart"
46. Touch/var/lock/oracle
48. su-$ORA _ownr-c "$ORACLE _home/bin/emctl start Dbconsole"
50. su-$ORA _ownr-c "$ORACLE _home/bin/isqlplusctl start"
52. echo "OK"
54. ;;
56. Stop
58. # Oracle Listener and instance shutdown
60. Echo-n "Shutdown Oracle:"
62. su-$ORA _ownr-c "$ORACLE _home/bin/emctl stop Dbconsole"
64. su-$ORA _ownr-c "$ORACLE _home/bin/isqlplusctl Stop"
66. su-$ORA _ownr-c "$ORACLE _home/bin/dbshut"
68. su-$ORA _ownr-c "$ORACLE _home/bin/lsnrctl Stop"
70. Rm-f/var/lock/oracle
72. echo "OK"
74. ;;
76. Reload|restart)
78. $ stop
80. $ start
82. ;;
84. *)
86. echo "Usage: ' basename ' Start|stop|restart|reload"
88. Exit 1
90. Esac
92. Exit 0

Script 2 (Start database and listen only)

The following 3 lines of the red font are required

345: Define Run Level

80: Service Start priority at boot (the smaller the number starts sooner)

10: Service Stop priority at shutdown (the smaller the number, the sooner it is closed)

2. #!/bin/bash
4. # chkconfig:345 80 10
6. # Description:startup Script for Oracle Databases
8. #/etc/rc.d/init.d/oracle
10. Export oracle_base=/u01/oracle
12. Export oracle_home=/u01/oracle/product
14. Export oracle_sid=pa
16. Export path= $PATH: $ORACLE _home/bin
18. Case "$" in
20. Start
22. Su oracle-c $ORACLE _home/bin/dbstart
24. Touch/var/lock/oracle
26. echo "OK"
28. ;;
30. Stop
32. Echo-n "Shutdown Oracle:"
34. Su oracle-c $ORACLE _home/bin/dbshut
36. Rm-f/var/lock/oracle
38. echo "OK"
40. ;;
42. *)
44. echo "Usage: ' basename ' Start|stop"
46. Exit 1
48. Esac
50. Exit 0

Save exit.

Open Terminal execution:

1. $su-root
2. #chown oracle.oinstall/etc/rc.d/init.d/oracle
3. #chmod 775/etc/rc.d/init.d/oracle

Then execute:

1. #chkconfig--add Oracle

or run the following command

1. #chkconfig--level 345 Oracle on
2. #chkconfig--list Oracle

Normal output:

Oracle 0:off 1:off 2:off 3:on 4:on 5:on 6:off

5. Check

Depending on the result of the operation above, when the corresponding RunLevel is on (for example: 5:on), the corresponding/ETC/RC.D/RCN.D (for example: and

5:on corresponds to:/etc/rc.d/rc5.d) A file is generated below: S99oradbstart, open with VI S99oradbstart

The file, you can see the contents of the file and/etc/rc.d/init.d/oradbstart content the same, indicating that the configuration is successful, in fact

S99oradbstart is a link to/etc/rc.d/init.d/oradbstart, and we can use the file command to view:

1. $file/etc/rc.d/rc5.d/s99oradbstart
2. S99oradbstart:symbolic link to '. /init.d/oradbstart

After this is turned on, the Oracle service will start automatically.

You can also manually control the service run:

#service Oracle Start Start

#service Oracle Stop shutdown

$ps-ef | grep ora See if the Oracle-related process has started

6. A little note:

6.1 In the script file: # chkconfig:345 99 10

Indicates that the 3,4,5 level starts the service, 99 is in the corresponding/ETC/RC.D/RCN.D (n is the level specified earlier, here is 345) The serial number of the linked file generated under the directory (Start priority level) s99oradbstart,10 for the level indicated above

/ETC/RC.D/RCN.D (n is a level other than 345) the serial number of the linked file generated by the directory (priority level of service stop)

K10oradbstart.

6.2 Command Description:

PS: Monitor Background process

-e Displays all processes.

-F full format.

-H does not display the caption.

-L long format.

-W wide output.

grep: is a command used under Linux to search for content contained in the output.

1. For example, I want to search for a string of characters called "BBB" named Aaa.txt, which can be used

Cat Aaa.txt|grep BBB

2. I want to search the current directory contains BB files, you can use

LS |grep bb

Example: PS-EFW | grep LISTEN | Grep-v grep: View the monitor containing the listen, removing the listener containing grep.

6.3 Chkconfig: Function description

Check and set up the various services of the system.

Syntax: chkconfig [--add][--del][--list][system service] or Chkconfig [--level < rank code >][system service][on/off/reset]

Note: This is a program developed by Red Hat in accordance with the GPL rules, which can query which system services the operating system performs at each level of execution, including a variety of resident services.

Parameters:

--add adds the specified system service, allows the CHKCONFIG directive to manage it, and adds relevant data to the system-initiated narrative file.

--del deletes the specified system service, is no longer managed by the Chkconfig directive, and deletes the relevant data within the system-initiated narrative file.

--list lists the system services that are specified.

--level< Class code > Specify which execution level the system service should be opened or closed.

Note: RunLevel can be thought of as a system state, image a little, you can think RunLevel a bit like Microsoft's Windows operating system Normal,safemode, and command prompt only. Entering each runlevel requires starting or shutting down the corresponding series of services (services), which are placed in directory/ETC/RC.D/RC in the form of initialization scripts. d/or/ETC/RC? D

The following (?) represents the corresponding serial number of the RunLevel.

In most Linux distributions, there are typically 8 runlevel

Runlevel System State

0 Halt The System

1 Single user mode

2 Basic Multi User mode

3 Multi User mode

5 Multi user mode with GUI

6 Reboot The System

s, s single user mode

Most of the desktop Linux system default RunLevel is 5, the user login is a graphical interface;

And most of the server version of the Linux system default RunLevel is 3, the user login is the character interface;

RunLevel 1 and 2 are rarely used except for commissioning;

RunLevel s and s are not intended for direct user use, but are used to prepare for single user mode.

Method Two: Use a self-built startup and shutdown script

1. Create a startup and shutdown script

1. # mkdir-p/home/oracle/bin
2. # Cd/home/oracle/bin
3. # VI Startora (create startup script)

The script reads as follows:

1. Sqlplus/nolog << EOF
2. Connect/as SYSDBA
3. Startup
4. Exit
5. Exit
6. echo "Oracle Start ok!"
7. # VI Stopora (create close script)

The script reads as follows:

1. Sqlplus/nolog << EOF
2. Connect/as SYSDBA
3. Shutdown immediate
4. Exit
5. Exit
6. echo "Oracle Shutdown ok!"
7. # chown Oracle:oinstall Startora Stopora
8. # chmod 775 Startora Stopora

2. Create a service

1. # CD/ETC/RC.D/INIT.D
2. # VI Oracle

The following 3 lines of the red font are required, and the blue font is configured according to the actual environment.

345: Define Run Level

80: Service Start priority at boot (the smaller the number starts sooner)

10: Service Stop priority at shutdown (the smaller the number, the sooner it is closed)

2. #!/bin/bash
4. # chkconfig:345 80 10
6. # Description:startup Script for Oracle Databases
8. Export oracle_base=/u01/oracle
10. Export oracle_home=/u01/oracle/product
12. Export oracle_sid=pa
14. Export path= $PATH: $ORACLE _home/bin:/home/oracle/bin
16. Export ora_owner=Oracle
18. Case ' "in
20. "Start")
22. su-$ORA _owner-c "$ORA _home/bin/lsnrctl start"
24. su-$ORA _owner-c "/home/oracle/bin/startora"
26. ;;
28. "Stop")
30. su-$ORA _owner-c "$ORA _home/bin/lsnrctl Stop"
32. su-$ORA _owner-c "/home/oracle/bin/stopora"
34. ;;
36. Esac
38. $su-root
40. #chown oracle.oinstall/etc/rc.d/init.d/oracle
42. #chmod 775/etc/rc.d/init.d/oracle

Then execute:

#chkconfig--add Oracle

or run the following command

1. #chkconfig--level 345 Oracle on
2. #chkconfig--list Oracle

Normal output:

Oracle 0:off 1:off 2:off 3:on 4:on 5:on 6:off