我的oracle数据库为什么每次启动都是空闲进程？

grwdpy

原帖由 zergduan 于 2008-3-25 16:40 发表
Z:\>oradim
ORADIM:  [options]。  请参阅手册。
请输入以下命令之一:
  通过指定以下参数创建例程:
    -NEW -SID sid | -SRVC service [-INTPWD password] [-MAXUSERS number] [-STARTMODE a|m] [-PFILE fil
e] [-TIMEOUT secs]
  通过指定以下参数编辑例程:
-EDIT -SID sid [-NEWSID sid] [-INTPWD passwd] [-STARTMODE a|m] [-PFILE file] [-SHUTMODE a|i|n] [-SH
UTTYPE srvc|inst]
  通过指定以下参数删除例程:
    -DELETE -SID sid | -SRVC service name
  通过指定以下参数启动服务和例程:
    -STARTUP -SID sid [-USRPWD password] [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename]
  通过指定以下参数关闭服务和例程:
    -SHUTDOWN -SID sid [-USRPWD password] [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE a | i | n]
  通过指定以下参数查询帮助: -? | -h | -help
您为 -NEW 命令输入了无效的选项

黑色部分，或者直接改注册表~

Setting Registry Parameters
To start or stop an Oracle9i database through Oracle Services, set the following registry parameters to the indicated values:

ORA_SID_AUTOSTART

When set to true, the default value, this parameter causes Oracle9i database to start when OracleServiceSID is started.

ORA_SID_PFILE

This parameter sets the full path to the initialization parameter file. The default path is ORACLE_BASE\ADMIN\db_name\pfile\init.ora

ORA_SHUTDOWN

When set to true, this parameter enables the selected Oracle9i database to be shut down when OracleServiceSID is stopped. This includes any database in the current Oracle home. Default value is false.

ORA_SID_SHUTDOWN

When set to true, this parameter causes the Oracle9i database identified by the SID value to shut down when OracleServiceSID is stopped. Default value is false.


--------------------------------------------------------------------------------
Caution:
If ORA_SHUTDOWN or ORA_SID_SHUTDOWN is set to false, then shutting down OracleServiceSID will still shut down Oracle9i database. But it will be an abnormal shutdown, and Oracle Corporation does not recommend it.

--------------------------------------------------------------------------------


The following two registry parameters are optional:

ORA_SID_SHUTDOWNTYPE

This parameter controls database shutdown mode. Set it to a (abort), i (immediate), or n (normal). Default mode is i (immediate) if you do not set this parameter.

ORA_SID_SHUTDOWN_TIMEOUT

This parameter sets maximum time to wait before the service for a particular SID stops.

The registry location of these required and optional parameters is determined by the number of Oracle home directories on your computer. If you have only one Oracle home directory, then these parameters belong in:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0


If you have multiple Oracle home directories, then these parameters belong in:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID


where ID is incremented for each additional Oracle home directory on your computer.


--------------------------------------------------------------------------------
Note:
If you use ORADIM utility to create or edit instances, then the utility automatically sets the relevant registry parameters to their appropriate values.

--------------------------------------------------------------------------------

thks very much

zergduan

跟你的pfile内容没有任何关系，空闲例程说明根本没有到nomount状态，也就是说根本没有去读pfile~

如果你修改过pfile的文件名or路径，到有可能因为找不到pfile/spfile所以无法nomount~

zergduan

lz 我看错了你的是10g注册表路径有些不同，看这个

http://download.oracle.com/docs/ ... istry.htm#sthref672

grwdpy

原帖由 zergduan 于 2008-3-25 16:57 发表
lz 我看错了你的是10g注册表路径有些不同，看这个

http://download.oracle.com/docs/ ... istry.htm#sthref672

谢谢了，我自己再结合我的实际看看。