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.