Oracle's simplest, self-booting with the system

Oracle's simplest, self-booting with the system
As the saying goes, the user is God, they sometimes ask a question is very simple, just need a word, a minute will be finished. But it may take at least half an hour or even half a month for our DBA to meet his word. Is there a better and faster way? I tell everyone that there is;
I take the example, the user is usually to maintain the simple, need the database itself to boot with the system. A very easy word, but to the DBA for at least half an hour to configure the implementation of this function. So today after you finish this document, you can complete the self-initiated configuration after he has not finished speaking. Very easy.


first, to configure their own initiative

1. Join the startup item [[email protected] ~]# cat >>/etc/rc.d/rc.local <<eofsu-oracle-c "lsnrctl start" su-oracle-c "sql Plus sys/oracle as Sysdba @/home/oracle/.script/.startup "Su-oracle-c" emctl start Dbconsole "EOF2, creating and editing startup files [email prot Ected] ~] #su-oracle[[email protected] ~] #mkdir-P/home/oracle/.script/[[email protected] ~]# cat >/HOME/ORACLE/.SCR Ipt/.startup <<eofstartup;alter System Register;exit 0EOF

Second, restart verification:




Third, determine whether the database and EM and monitoring are all up

# # #监听状态 [[email protected] ~]$ lsnrctl statuslsnrctl for linux:version 11.2.0.3.0-production on 03-OCT-2014 07:26:2  2Copyright (c) 1991, Oracle. All rights reserved. Connecting to (Description= (address= (PROTOCOL=IPC) (key=extproc1521)) STATUS of the LISTENER------------------------Alias listenerversion Tnslsnr for Linux:version 11. 2.0.3.0-productionstart Date 03-oct-2014 07:13:54uptime 0 days 0 hr. Min. sectra Ce level offsecurity on:local OS authenticationsnmp offlistener Param Eter File/dbsoft/product/11.2.3/db_1/network/admin/listener.oralistener Log file/dbsoft/diag/tnslsnr/db01/list  ener/alert/log.xmllistening Endpoints Summary ...  (Description= (address= (PROTOCOL=IPC) (key=extproc1521))) (Description= (address= (protocol=tcp) (HOST=DB01) (port=1521))) Services Summary ...  Service "Woo" has 1 instance (s). Instance "Woo", status Ready, HAs 1 handler (s) for the This service ...  Service "Wooxdb" has 1 instance (s). Instance "Woo", status ready, have 1 handler (s) for the This service ... The command completed successfully## #数据库状态SQL > select Instance_name,host_name,status from V$instance;instance_n HOST_NAME STATUS--------------------------------Woo db01 open## #EM状态 [[email protected] ~]$ emctl Stat   US dbconsoleoracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 Copyright (c) 1996, Oracle Corporation. All rights reserved.https://db01:1158/em/console/aboutapplicationoracle Enterprise Manager 11g is running. ------------------------------------------------------------------Logs is generated in directory/dbsoft/product/  11.2.3/db_1/db01_woo/sysman/log

So far we've decided. This also allows the database to be configured to initiate itself proactively, and is much simpler than the old method recommended by Oralce, such as the following link:

Oracle starts and shuts down with the system itself (old method) under Linux

Oracle's simplest, self-booting with the system