一直以为DB的initSID.ora必须在DB server上,其实把initSID.ora放在任何一个客户端都可以启动DB
1。关闭DB
oracle@svr66 ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Sat Dec 29 11:09:26 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
2。copy initSID.ora到客户端
3。在客户端启动DB
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 12月 29 11:15:37 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn sys/sys@primary as sysdba
已连接到空闲例程。
SQL> startup pfile=d:\initPROD.ora
ORACLE 例程已经启动。
Total System Global Area 581506668 bytes
Fixed Size 452204 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
数据库装载完毕。
数据库已经打开。
SQL>
4。验证
[oracle@svr66 ~]$ ps -ef|grep ora_|grep oracle
oracle 5142 1 0 11:16 ? 00:00:00 ora_pmon_PROD
oracle 5144 1 1 11:16 ? 00:00:00 ora_dbw0_PROD
oracle 5146 1 1 11:16 ? 00:00:00 ora_lgwr_PROD
oracle 5151 1 0 11:16 ? 00:00:00 ora_ckpt_PROD
oracle 5153 1 3 11:16 ? 00:00:00 ora_smon_PROD
oracle 5155 1 0 11:16 ? 00:00:00 ora_reco_PROD
oracle 5157 1 0 11:16 ? 00:00:00 ora_cjq0_PROD
oracle 5160 1 0 11:16 ? 00:00:00 ora_qmn0_PROD
oracle 5162 1 0 11:16 ? 00:00:00 ora_arc0_PROD
oracle 5164 1 0 11:16 ? 00:00:00 ora_arc1_PROD
oracle 5211 26797 0 11:16 pts/4 00:00:00 grep ora_
1。关闭DB
oracle@svr66 ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Sat Dec 29 11:09:26 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
2。copy initSID.ora到客户端
3。在客户端启动DB
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 12月 29 11:15:37 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn sys/sys@primary as sysdba
已连接到空闲例程。
SQL> startup pfile=d:\initPROD.ora
ORACLE 例程已经启动。
Total System Global Area 581506668 bytes
Fixed Size 452204 bytes
Variable Size 402653184 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
数据库装载完毕。
数据库已经打开。
SQL>
4。验证
[oracle@svr66 ~]$ ps -ef|grep ora_|grep oracle
oracle 5142 1 0 11:16 ? 00:00:00 ora_pmon_PROD
oracle 5144 1 1 11:16 ? 00:00:00 ora_dbw0_PROD
oracle 5146 1 1 11:16 ? 00:00:00 ora_lgwr_PROD
oracle 5151 1 0 11:16 ? 00:00:00 ora_ckpt_PROD
oracle 5153 1 3 11:16 ? 00:00:00 ora_smon_PROD
oracle 5155 1 0 11:16 ? 00:00:00 ora_reco_PROD
oracle 5157 1 0 11:16 ? 00:00:00 ora_cjq0_PROD
oracle 5160 1 0 11:16 ? 00:00:00 ora_qmn0_PROD
oracle 5162 1 0 11:16 ? 00:00:00 ora_arc0_PROD
oracle 5164 1 0 11:16 ? 00:00:00 ora_arc1_PROD
oracle 5211 26797 0 11:16 pts/4 00:00:00 grep ora_
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/87010/viewspace-376672/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/87010/viewspace-376672/