怎么随系统systemctl启动数据库

2025-03-14 技术教程

本篇内容主要讲解“怎么随系统systemctl启动数据库”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“怎么随系统systemctl启动数据库”吧!

一、修改oratab文件

[root@adg19c~]#grepwoo/etc/oratabwoo:/DBSoft/oracle/product/19.3/dbhome_1:N[root@adg19c~]#sed-i's/:N/:Y/'/etc/oratab[root@adg19c~]#grepwoo/etc/oratabwoo:/DBSoft/oracle/product/19.3/dbhome_1:Y二、编辑ora19c调用文件

[root@adg19c~]#cat/usr/local/ora19c.sh#!/bin/bashecho################################echo#scriptFororac19c.service#echo################################/DBSoft/oracle/product/19.3/dbhome_1/lsnrctlstart/DBSoft/oracle/product/19.3/dbhome_1/bin/dbstart/DBSoft/oracle/product/19.3/dbhome_1/~[root@adg19c~]#chmod+x/usr/local/ora19c.sh三、编辑ora19c服务配置文件

[root@adg19c~]#cat/etc/systemd/system/ora19c.service[Unit]Description=Oracle19cAfter=syslog.targetnetwork.target[Service]LimitMEMLOCK=infinityLimitNOFILE=65535Type=oneshotRemainAfterExit=yesUser=oracleEnvironment="ORACLE_HOME=/DBSoft/oracle/product/19.3/dbhome_1"ExecStart=/usr/local/ora19c.sh[Install]WantedBy=multi-user.target四、启动数据库

[root@adg19c~]#systemctlenableora19c.service[root@adg19c~]#systemctlstartora19c.service[root@adg19c~]#systemctlstatusora19c.service*ora19c.service-Oracle19cLoaded:loaded(/etc/systemd/system/ora19c.service;enabled;vendorpreset:disabled)Active:active(exited)sinceThu2020-03-1218:26:26CST;11sagoProcess:4607ExecStart=/usr/local/ora19c.sh(code=exited,status=0/SUCCESS)MainPID:4607(code=exited,status=0/SUCCESS)CGroup:/system.slice/ora19c.service`-4611/DBSoft/oracle/product/19.3/dbhome_1/bin/tnslsnrLISTENER-inheritMar1218:26:25adg19cora19c.sh[4607]:SNMPOFFMar1218:26:25adg19cora19c.sh[4607]:ListenerParameterFile/DBSoft/oracle/product/19.3/dbhome_1/network/admin/listener.oraMar1218:26:25adg19cora19c.sh[4607]:ListenerLogFile/DBSoft/oracle/diag/tnslsnr/adg19c/listener/alert/log.xmlMar1218:26:25adg19cora19c.sh[4607]:ListeningEndpointsSummary...Mar1218:26:25adg19cora19c.sh[4607]:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=adg19c)(PORT=1521)))Mar1218:26:25adg19cora19c.sh[4607]:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Mar1218:26:25adg19cora19c.sh[4607]:ThelistenersupportsnoservicesMar1218:26:25adg19cora19c.sh[4607]:ThecommandcompletedsuccessfullyMar1218:26:25adg19cora19c.sh[4607]:ProcessingDatabaseinstance"woo":logfile/DBSoft/oracle/product/19.3/dbhome_1/rd...tup.logMar1218:26:26adg19csystemd[1]:StartedOracle19c.Hint:Somelineswereellipsized,use-ltoshowinfull.五、完全启动之后状态：

[root@adg19c~]#su-oracle[oracle@adg19c~]$sqlplus/assysdbaSQL*Plus:Release19.0.0.0.0-ProductiononThuMar1218:30:422020Version19.3.0.0.0Copyright(c)1982,2019,Oracle.Allrightsreserved.Connectedto:OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0-ProductionVersion19.3.0.0.0SQL>selectinstance_name,statusfromgv$instance;INSTANCE_NAMESTATUS----------------------------wooOPENSQL>七、方法二，时候老版本Linux7.1 编辑/etc/oratab

[root@adg19c~]#vi/etc/init.d/dbora#!/bin/sh#description:Oracleautostart-stopscript.##SetORA_HOMEtobeequivalenttothe$ORACLE_HOME#fromwhichyouwishtoexecutedbstartanddbshut;##SetORA_OWNERtotheuseridoftheownerofthe#OracledatabaseinORACLE_HOME.ORA_HOME=/DBSoft/oracle/product/19.3/dbhome_1ORA_OWNER=oraclecase"$1"in'start')#StarttheOracledatabases:#Thefollowingcommandassumesthattheoraclelogin#willnotprompttheuserforanyvalues#Remove"&"ifyoudon'twantstartupasabackgroundprocess.su-$ORA_OWNER-c"$ORA_HOME/bin/dbstart$ORA_HOME"&touch/var/lock/subsys/dbora;;'stop')#StoptheOracledatabases:#Thefollowingcommandassumesthattheoraclelogin#willnotprompttheuserforanyvaluessu-$ORA_OWNER-c"$ORA_HOME/bin/dbshut$ORA_HOME"&rm-f/var/lock/subsys/dbora;;Esac7.3 修改文件权限

[root@adg19c~]#chgrpdba/etc/init.d/dbora[root@adg19c~]#chmod750/etc/init.d/dbora7.4 添加到启动文件中

[root@adg19cinit.d]#ln-s/etc/init.d/dbora/etc/rc.d/rc0.d/K01dbora[root@adg19cinit.d]#ln-s/etc/init.d/dbora/etc/rc.d/rc3.d/S99dbora[root@adg19cinit.d]#ln-s/etc/init.d/dbora/etc/rc.d/rc5.d/S99dbora

到此，相信大家对“怎么随系统systemctl启动数据库”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！