linux自动监听重启服务,linux 下开启oracle服务和开启监听和 开机自动重启

1. 手动重启sql

su - oracle 切换到oracle用户模式下

sqlplus /nolog //登陆sqlplus

SQL> connect /as sysdba //链接oracle

SQL> startup //起动数据库

SQL> exit //退出sqlplus ，起动监听

cd $ORACLE_HOME/bin //进入oracle安装目录

lsnrctl start //起动监听

2 . 自动重启数据库

[root@ST ~]# vi /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.

#

#

orcl:/u01/app/oracle/product/11.2.0/dbhome_1:Y --这里本来是N，改为Y便可。

[root@ST ~]# vi /etc/rc.d/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 -lc "/u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnrctl start"

su oracle -lc /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart

--su oracle 指用户名