Linux to start with the system under the Oracle11g Automatic
Installed Oracle 11g each time had to manually start | stop the database (dbstart | dbshut), listener (lsnrctl), the console (emtcl).
rn
Set So, if manually start the database listener does not start at the same time (that is automatically activated when you start the database listener, stop the database listener stop), you need to modify the script file dbstart
rn
[root @ oracle bin] # vi dbstart
rn
Locate This remark, in the most front-end
rn
# First argument is used to bring up Oracle Net Listener
ORACLE_HOME_LISTNER = $ 1
/ / Need to be here ORACLE_HOME_LISTNER = $ 1 was revised to ORACLE_HOME_LISTNER = $ ORACLE_HOME
if [! $ ORACLE_HOME_LISTNER]; then
echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener"
echo "Usage: $ 0 ORACLE_HOME"
else
LOG = $ ORACLE_HOME_LISTNER / listener.log
rn
Similarly, need to modify the dbshut
rn
[root @ oracle bin] # vi dbshut
rn
# The this to bring down Oracle Net Listener
ORACLE_HOME_LISTNER = $ 1
/ / Need to be here ORACLE_HOME_LISTNER = $ 1 was revised to ORACLE_HOME_LISTNER = $ ORACLE_HOME
if [! $ ORACLE_HOME_LISTNER]; then
echo "ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener"
echo "Usage: $ 0 ORACLE_HOME"
else
LOG = $ ORACLE_HOME_LISTNER / listener.log
rn
After the start of the Linux system, go to / etc / init.d directory;
rn
[root @ oracle ~] # cd / etc / init.d
rn
Using the vi command, the new one in order to oracle named file (and copy the following code to the file)
rn
[root @ oracle init.d] # vi oracle
rn
#! / bin / sh
# Chkconfig: 345 61 61
# Description: Oracle 11g AutoRun Services
# / Etc / init.d / oracle
#
# Run-level Startup script for the Oracle Instance, Listener, and
# Web Interface
rn
export ORACLE_BASE = / u01/app/oracle
export ORACLE_HOME = $ ORACLE_BASE/product/11.1.0/db_1
export ORACLE_SID = ORCL
export PATH = $ PATH: $ ORACLE_HOME / bin
rn
ORA_OWNR = "oracle"
rn
# If the executables do not exist - display error
rn
if [!-f $ ORACLE_HOME / bin / dbstart-o!-d $ ORACLE_HOME]
then
echo "Oracle startup: cannot start"
exit 1
fi
rn
# Depending on parameter - startup, shutdown, restart
# Of the instance and listener or usage display
rn
case "$ 1" in
start)
# Oracle listener and instance startup
su $ ORA_OWNR-lc $ ORACLE_HOME / bin / dbstart
echo "Oracle Start Succesful! OK."
;;
stop)
# Oracle listener and instance shutdown
su $ ORA_OWNR-lc $ ORACLE_HOME / bin / dbshut
echo "Oracle Stop Succesful! OK."
;;
reload | restart)
$ 0 stop
$ 0 start
;;
*)
echo $ "Usage:` basename $ 0 `(start | stop | reload | reload)"
exit 1
esac
exit 0
rn
In the editing is complete, use the: x command to save the file.
rn
Vested with the executive authority
rn
[root @ oracle init.d] # chmod 750 / etc / init.d / oracle
rn
Link:
rn
[root @ oracle init.d] # ln-s / etc / init.d / oracle / etc/rc1.d/K61oracle
rn
[root @ oracle init.d] # ln-s / etc / init.d / oracle / etc/rc3.d/S61oracle
rn
Execute the following command:
rn
[root @ oracle init.d] # chkconfig - level 345 oracle on
rn
[root @ oracle init.d] # chkconfig - add oracle / / add to the service where
Related Posts of Linux to start with the system under the Oracle11g Automatic
-
ORACLE10G full version centos5 installed (the installation has passed)
ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...
-
SGA extended the principle of 32bit oracle
SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...
-
AX3.0 + Oracle 10G RAC installation
During these two days, you installed RAC, in a virtual machine inside, with a full day, there have been some questions on his way. Now have their own solution. In fact, it is loaded, it is easy, as long as planned, carefully point on OK, the trouble ...
-
High Availability Oracle Flashback
Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
-
Diagnosis and principles of order
SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...
-
ORACLE 10G dataguard configuration Step by Step
oracle dataguard













Leave a Reply