Linux oracle设置开机自启动

Linux oracle设置开机自启动

1.修改/etc/oratab文件

[oracle@node01:/home/oracle]$ cat /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 field 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.##cxmtdb:/u01/app/oracle/product/19.3.0/db:Y

2.修改/etc/rc.local文件 vim /etc/rc.local

#OracleBeginsu oracle -lc "/u01/app/oracle/product/19.3.0/db/bin/lsnrctl start"su oracle -lc /u01/app/oracle/product/19.3.0/db/bin/dbstart#OracleEnd

3.给rc.local文件授权

[root@node01:/root]$ chmod 755 /etc/rc.local

4. 注：在oracle 12c以及以后的数据中，不能启动内部的pdb库，可以写一个触发器如下：

create trigger open_devafter startup on databasebeginexecute immediate ‘alter pluggable database pdb01,pdb02,pdb03 open’;end;/

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。