3、建立服务连接:
系统启动时启动数据库,我们需要以下连结∶
--------------------------------------------------------------------------------
$ ln -s ../init.d/oracle /etc/rc.d/rc2.d/S99oracle
$ ln -s ../init.d/oracle /etc/rc.d/rc3.d/S99oracle
$ ln -s ../init.d/oracle /etc/rc.d/rc5.d/S99oracle #rc4.d unused
--------------------------------------------------------------------------------
要在重新启动时停止数据库,我们需要以下连结∶
--------------------------------------------------------------------------------
$ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle # 停止
$ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle # 重新启动
如果启动时候遇到这样的错误:
Can't find init file for Database "lht".
Database "lht" NOT started.
这个错误可以/var/log/oracle中看到
解决办法:缺少init file,需要生成initlht.ora文件;
可以去ls /$oracle_home/dbs核实,会发现缺少initlht.ora;
sqlplus "/as sysdba"
create pfile from spfile;
生成完毕;
接着测试,执行dbstart;
[oracle@oracelserver oracle]$ dbstart
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jun 23 13:03:14 2009
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 "lht" warm started.
至此,算是完成了。