linux设置监听自动启动不了,linux设置oracle数据库和监听开机自动启动 矫情吗;* 2023-01-21 07:26 212阅读 0赞 版权声明:本文为博主原创文章,遵循 CC 4.0 by-sa 版权协议,转载请附上原文出处链接和本声明。 本文链接:https://blog.csdn.net/weeknd/article/details/72673786 默认的单机oracle数据库中,oracle不会随着操作系统的启动而启动,需要手工启动。下面设置开机自动启动 \[oracle@CSICN20RPT01 etc\]$ vi 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. \# \# rpt:/u01/app/oracle/product/11.2.0.4/db\_1:Y Note:这里把N改成Y(no该为yes) \[root@CSICN20RPT01 etc\]\# pwd /etc \[root@CSICN20RPT01 etc\]\# vi 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 route add default gw 192.168.40.1 su - oracle -c 'lsnrctl start' su - oracle -c 'dbstart' lsnrctl start 和 dbstart 要改成Oracle实际安装的目录 Note:添加红色部分,启动监听,启动数据库 测试: 重启操作系统,查看数据库状态 \[oracle@CSICN20RPT01 ~\]$ sqlplus / as sysdba SQL\*Plus: Release 11.2.0.4.0 Production on Wed May 24 10:23:56 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select instance\_name,status from v$instance; INSTANCE\_NAME STATUS \---------------- ------------ rpt OPEN \[oracle@CSICN20RPT01 ~\]$ lsnrctl status Services Summary... Service "rpt" has 2 instance(s). Instance "rpt", status UNKNOWN, has 1 handler(s) for this service... Instance "rpt", status READY, has 1 handler(s) for this service... Service "rptXDB" has 1 instance(s). Instance "rpt", status READY, has 1 handler(s) for this service... The command completed successfully 开始启动数据库和监听ok。 ———————————————— 版权声明:本文为CSDN博主「weeknd」的原创文章,遵循CC 4.0 by-sa版权协议,转载请附上原文出处链接及本声明。 原文链接:https://blog.csdn.net/weeknd/article/details/72673786
还没有评论,来说两句吧...