如何自动启动数据库

2025-03-08 技术教程

这篇文章主要介绍如何自动启动数据库，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

自动重启，需要grid的支持

自动管理资源

[oracle@edsir1p8-+ASM~]$crs_stat-tNameTypeTargetStateHost------------------------------------------------------------ora.DATA.dgora....up.typeONLINEONLINEedsir1p8ora.asmora.asm.typeONLINEONLINEedsir1p8ora.cssdora.cssd.typeONLINEONLINEedsir1p8ora.diskmonora....on.typeONLINEONLINEedsir1p8

通常2种方式自动启动数据库

[oracle@edsir1p8-+ASM~]$tail-3/etc/oratabPROD4:/u01/app/oracle/product/11.2.0/db_1:NEMREP:/u01/app/oracle/product/11.2.0/db_1:N+ASM:/u01/app/oracle/product/11.2.0/grid:N---这种方式通常不好用

2.crs_stat

这是个资源表，让数据库和监听注册到这个表里

[oracle@edsir1p8-+ASM~]$srvctladddatabase-dPROD4-o/u01/app/oracle/product/11.2.0/db_1[oracle@edsir1p8-+ASM~]$srvctlconfigdatabase--查看哪些数据库已经注册

关监听，注册

[oracle@edsir1p8-+ASM~]$srvctladdlistener-llistener-p1521-o/u01/app/oracle/product/11.2.0/db_1PRCN-2061:Failedtoaddlistenerora.LISTENER.lsnrPRCN-2065:Port(s)1521arenotavailableonthenodesgivenPRCN-2035:Port1521isnotavailableonnode(s)orvirtualhost(s):edsir1p8.us.oracle.com

--关监听

[oracle@edsir1p8-+ASM~]$lsnrctlstop[oracle@edsir1p8-+ASM~]$srvctladdlistener-llistener-p1521-o/u01/app/oracle/product/11.2.0/db_1[oracle@edsir1p8-+ASM~]$srvctlconfiglistener--查看监听是否注册成功

[oracle@edsir1p8-+ASM~]$crs_stat-tNameTypeTargetStateHost------------------------------------------------------------ora.DATA.dgora....up.typeONLINEONLINEedsir1p8ora....ER.lsnrora....er.typeOFFLINEOFFLINEora.asmora.asm.typeONLINEONLINEedsir1p8ora.cssdora.cssd.typeONLINEONLINEedsir1p8ora.diskmonora....on.typeONLINEONLINEedsir1p8ora.prod4.dbora....se.typeOFFLINEOFFLINE

=============================================================

--重启服务器，看效果

oracle@edsir1p8-~]$ps-ef|grepsmonoracle53875106009:25pts/200:00:00grepsmon--没有实例启动[oracle@edsir1p8-~]$lsnrctlstatus-bash:lsnrctl:commandnotfound--没有任何的Oracle环境变量

[oracle@edsir1p8-~]$.oraenvORACLE_SID=[oracle]?+ASMTheOraclebaseforORACLE_HOME=/u01/app/oracle/product/11.2.0/gridis/u01/app/oracle[oracle@edsir1p8-+ASM~]$lsnrctlstatus

LSNRCTLforLinux:Version11.2.0.1.0-Productionon22-JUN-201709:25:58Copyright(c)1991,2009,Oracle.Allrightsreserved.Connectingto(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))TNS-12541:TNS:nolistenerTNS-12560:TNS:protocoladaptererrorTNS-00511:NolistenerLinuxError:111:Connectionrefused--监听没有启动

SQL>quitDisconnected

[oracle@edsir1p8-+ASM~]$srvctlstartdatabase-dPROD4PRCD-1027:FailedtoretrievedatabasePROD4PRCR-1070:Failedtocheckifresourceora.prod4.dbisregisteredCannotcommunicatewithcrsd

SQL>startupORA-01078:failureinprocessingsystemparametersORA-29701:unabletoconnecttoClusterSynchronizationServiceSQL>quitDisconnected

[oracle@edsir1p8-+ASM~]$crsctlstarthasCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.

[oracle@edsir1p8-+ASM~]$crs_stat-tNameTypeTargetStateHost------------------------------------------------------------ora.DATA.dgora....up.typeONLINEOFFLINEora....ER.lsnrora....er.typeONLINEONLINEedsir1p8ora.asmora.asm.typeONLINEOFFLINEora.cssdora.cssd.typeONLINEOFFLINEora.diskmonora....on.typeONLINEONLINEedsir1p8ora.prod4.dbora....se.typeOFFLINEOFFLINE

[oracle@edsir1p8-+ASM~]$crsctlenablehasCRS-4622:OracleHighAvailabilityServicesautostartisenabled.--必须开机自启动，只有他开机自启动，注册到里面的资源才能开机自启动

重启服务器，看效果

===========================================================

--集群管理的方式将数据库开

[oracle@edsir1p8-+ASM~]$srvctlstartdatabase-dPROD4--执行相反操作srvctlremovedatabase-dPROD4---移除数据库srvctlremovelistener-llistener---如果注册错误可以使用该命令删除

以上是“如何自动启动数据库”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注亿速云行业资讯频道！