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


Linux下在安装完Oracle数据库后试图使用dbstart启动数据库但是没有反应这时需要更改一下oracle的配置

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.

相关内容