启动数据库实例,分为两步:第一步,启动监听;第二步,启动数据库实例。
1.进入到sqlplus启动实例 [root@oracle ~]# su - oracle 切换到oracle用户 -bash-3.2$ lsnrctl start 启动监听 -bash-3.2$ sqlplus /nolog 进入sqlplus SQL> conn /as sysdba 连接到sysdba Connected to an idle instance. SQL> startup 启动数据库实例 Total System Global Area 594251776 bytes Fixed Size 1301504 bytes Variable Size 360711168 bytes Database Buffers 226492416 bytes Redo Buffers 5746688 bytes Database mounted. Database opened.2,关闭SQL> shutdown immediate 关闭数据库实例 Database closed. Database dismounted. ORACLE instance shut down.3,如何使数据库实例和linux系统一起启动在/etc/rc.d/rc.local中加入如下语句即可实现同系统启动实例: su - oracle -c "lsnrctl start" su - oracle -c “dbstart"4,查看命令ps aux | grep ora_ #若无ora_**_**相关的进程,则oracle数据库实例未启动netstat -tlnup | grep 1521 #若无任何显示,则EM未启动
emctl status dbconsole #查看EM状态5,开启oracle报错:SQL> startup
ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora'
解决方法:cp /home/oracle/app/admin/ost/pfile/init.ora.81201625147 /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.or