Shulou(Shulou.com)05/31 Report--

Editor to share with you the configuration of the operating system restart after the Oracle database and monitor automatic startup example analysis, I hope you will learn something after reading this article, let's discuss it together!

-- when the operating system is configured to restart, the instance starts automatically

-- change the flag N at the end of the line of the instance to Y

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

#

# This file is used by ORACLE utilities. It is created by root.sh

# and updated by either Database Configuration Assistant while creating

# a database or ASM Configuration Assistant while creating ASM instance.

# A colon,':', is used as the field terminator. A new line terminates

# the entry. Lines beginning with a pound sign,'#, are comments.

#

# Entries are of the form:

# $ORACLE_SID:$ORACLE_HOME::

#

# The first and second fields are the system identifier and home

# directory of the database respectively. The third filed indicates

# to the dbstart utility that the database should, "Y", or should not

# "N", be brought up at system boot time.

#

# Multiple entries with the same $ORACLE_SID are not allowed.

#

#

Fire:/u01/app/oracle/product/11.2.0/db_1:Y

-- configure that database snooping starts automatically after the operating system restarts

[root@localhost ~] # vim / etc/rc.local

#! / bin/sh

#

# This script will be executed * after* all the other init scripts.

# You can put your own initialization stuff in here if you don't

# want to do the full Sys V style init stuff.

Touch / var/lock/subsys/local

Su-oracle-c 'dbstart'

Su-oracle-c 'lsnrctl start'

After reading this article, I believe you have a certain understanding of "sample analysis of configuring Oracle database and monitoring automatic startup after operating system restart". If you want to know more about it, welcome to follow the industry information channel, thank you for reading!

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.