一、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