Oracle数据库在Linux中dbstart没有反应的解决

2014-11-24 17:29:51 · 作者: · 浏览: 0

su root
vi /etc/oratab
*:/opt/oracle/product/9.2.0.4:N
ego:/opt/oracle/product/9.2.0.4:N



将对应的数据库改为Y就可以
*:/opt/oracle/product/9.2.0.4:N
ego:/opt/oracle/product/9.2.0.4:Y


上面是我的配置
>dbstart
Can't find init file for Database "ego".
Database "ego" NOT started.


意思就是没有找到init文件 我的数据库实例是ego


这个文件在$ORACLE_HOME/dbs/目录下
>cd $ORACLE_HOME/dbs


解决办法就是建立一个initego.ora的软连接就可以了
> ln -s spfileego.ora initego.ora
这样就可以


>dbstart
SQL*Plus: Release 9.2.0.4.0 - Production on 星期五 3月 21 14:40:10 2008


Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


SQL> Connected to an idle instance.
SQL> ORACLE instance started.


Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production


Database "ego" warm started.