Shulou(Shulou.com)06/01 Report--

Reference: http://www.jb51.net/article/32214.htm

1. Some basic parameters of Oracle

[oracle@localhost ~] $echo $ORACLE_SID

Adela

[oracle@localhost ~] $echo $ORACLE_HOME

/ u01/app/oracle/product/12.1.0/db_1

[oracle@localhost ~] $echo $ORACLE_BASE

/ u01/app/oracle

two。 Modify / etc/oratab so that Oracle can start itself

[oracle@localhost ~] $vim / etc/oratab

Add a row

# $ORACLE_SID:$ORACLE_HOME::

Adela:/u01/app/oracle/product/12.1.0/db_1:Y

3. Create the file oracle under / etc/init.d/

[root@localhost ~] # touch / etc/init.d/oracle

[root@localhost ~] # chmod 755 / etc/init.d/oracle

[root@localhost ~] # vim / etc/init.d/oracle

Add the following script

#! / bin/sh# chkconfig: 35 80 1 description: Oracle auto start-stop script.## Set ORA_HOME to be equivalent to the $ORACLE_HOME# from which you wish to execute dbstart and dbshut # # Set ORA_OWNER to the user id of the owner of the# Oracle database in ORA_HOME.ORA_HOME=/u01/app/oracle/product/12.1.0/db_1ORA_OWNER=oracleif [!-f $ORA_HOME/bin/dbstart] thenecho "Oracle startup: cannot start" exitficase "$1" in'start') # Start the Oracle databases:echo "Starting Oracle Databases. "echo"-- "> > / var/log/oracledate +" T% a% D: Starting Oracle Databases as part of system up. "> > / var/log/oracleecho"-- -"> > / var/log/oraclesu-$ORA_OWNER-c" $ORA_HOME/bin/dbstart "> / var/log/oracleecho" Done "# Start the Listener:echo" Starting Oracle Listeners. "echo"-- "> > / var/log/oracledate +" T% a% D: Starting Oracle Listeners as part of system up. "> > / var/log/oracleecho"-- -"> > / var/log/oraclesu-$ORA_OWNER-c" $ORA_HOME/bin/lsnrctl start "> > / var/log/oracleecho" Done. "echo"-- > / var/log/oracledate + "% T% a% D. : Finished. "> > / var/log/oracleecho"-- > / var/log/oracletouch / var/lock/subsys/oracle ; 'stop') # Stop the Oracle Listener:echo "Stoping Oracle Listeners... "echo"-- "> > / var/log/oracledate +" T% a% D: Stoping Oracle Listener as part of system down. "> > / var/log/oracleecho"-- -"> > / var/log/oraclesu-$ORA_OWNER-c" $ORA_HOME/bin/lsnrctl stop "> > / var/log/oracleecho" Done. "rm-f / var/lock/subsys/oracle# Stop the Oracle Database:echo" Stoping Oracle Databases. "echo"-- "> > / var/log/oracledate +" T% a% D: Stoping Oracle Databases as part of system down. "> > / var/log/oracleecho"-- -"> > / var/log/oraclesu-$ORA_OWNER-c" $ORA_HOME/bin/dbshut "> > / var/log/oracleecho" Done. "echo"echo"-- "> > / var/log/oracledate +"% T% a % D: Finished. "> > / var/log/oracleecho"-> > / var/log/oracle ; 'restart') $0 stop$0 start;;esac

4. Add Servic

[root@localhost] # chkconfig-- level 35 oracle on

5. You need to stop the database before shutting down or restarting the machine, do the following

[root@localhost] # ln-s / etc/init.d/oracle / etc/rc0.d/K01oracle / / shutdown

[root@localhost ~] # ln-s / etc/init.d/oracle / etc/rc6.d/K01oracle / / restart

6. Test whether the command is valid

[root@localhost ~] # service oracle start / / start oracle

Starting Oracle Databases...

Done

Starting Oracle Listeners...

Done.

[root@localhost ~] # service oracle stop / / close oracle

Stoping Oracle Listeners...

Done.

Stoping Oracle Databases...

Done.

# service oracle restart / / restart oracle

[root@localhost ~] # service oracle restart

Stoping Oracle Listeners...

Done.

Stoping Oracle Databases...

Done.

Starting Oracle Databases...

Done

Starting Oracle Listeners...

Done.

7. Restart Linux

[root@localhost ~] # reboot

8. Enter oracle user after reboot and enter sqlplus

[oracle@localhost Desktop] $sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jul 18 23:16:17 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL > set linesize 300

SQL > set pagesize 30

SQL > select sysdate from dual

SYSDATE

-

18-JUL-15

The database starts normally!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.