重启服务器后重启数据库

一、251服务器验证，生产环境可用
[root@localhost ~]# su - oracle //切换数据库oracle用户
[oracle@localhost /]$ export ORACLE_SID=ats //切换数据库实例
[oracle@localhost /]$ lsnrctl start //启动监听程序
//关闭命令：[oracle@localhost /]$ lsnrctl stop
[oracle@localhost /]$ lsnrctl status //查看监听程序状态，可以看到“ats”实例
Services Summary...
Service "ats" has 1 instance(s).
Instance "ats", status READY, has 1 handler(s) for this service...
Service "atsXDB" has 1 instance(s).
Instance "ats", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost /]$ sqlplus /nolog
SQL> conn /as sysdba //用sys用户登录
SQL> startup //启动实例 实例错误时，会提示：
　　　　　　ORA-01078: failure in processing system parameters
　　　　　　LRM-00109: could not open parameter file '/oracle/product/10.2.0/db_1/dbs/initorcl.ora'
　　　　　　//SQL> shutdown //不出问题不要关闭
　　　　　　//SQL> quit

提示：关闭防火墙，要不然客户端无法连接
禁用防火墙 systemctl disable firewalld
关闭防火墙 systemctl stop firewalld

转载于:https://www.cnblogs.com/ygkeke/p/10874357.html