the discussion on oradim parameter intpwd
yesterday , I was installing a oracle8.0.5 database for a client on NT server . I am following this way to create service :
A. create password file :
orapwd file=f:\orant\database\pwdprod.ora password=XXX entried=5
B. create new instance service
set oracle_sid = prod
oradim80 -new -sid prod -startmode auto -pfile "f:\orant\database\initprod.ora"
then going to create database and so on .
but after all , there is only 1 service in control panel->service for prod
(oracleserviceProd) , but the other service oraclestartprod is not appearing !
later on , I found the difference that I delete the database and recreate the service by using:
set oracle_sid = prod
oradim80 -new -sid prod -intpwd XXX -startmode auto -pfile "f:\orant\database\initprod.ora"
(note that I didn't use orapwd to create password , but I add new parameter intpwd )
then everything is fine .both services are appearing .
I realize that the previous method is for oracle8i so maybe this is the reason ? ( because oracle8i need only 1 service oracleserviceProd)
could any Xpert tell me what's the tricky inside ?
问题点数：36、回复次数：5Top
1 楼maohaisheng（虫族：无名小虫）回复于 2003-05-03 12:34:40 得分 6
关注。
我只用过NOVELL的804版本Top
2 楼suguojun1（suguojun）回复于 2003-05-14 23:21:35 得分 30
You must set the parameter in local machine/software/oracle/home0 of the register table:
ORACLE_SID
ORACLE_HOME
ORA_<INST>_AUTOSTART
ORA_<INST>_PFILE
ORA_<INST>_SHUTDOWN
then can start two service.
It is no matter with the parameter -intpwd in oradim command.Top
3 楼black_snail（●男人要忍○）回复于 2003-05-16 08:44:35 得分 0
Trying to find some approval in metalink:
You will also need the following registry entries:
ORA_ORCL_PFILE
The value is set to point to the proper initORCL.ora file.
ORA_ORCL_SHUTDOWN
Set to TRUE
ORA_ORCL_SHUTDOWN_TIMEOUT
Set to 30
ORA_ORCL_SHUTDOWNTYPE
Set to 'i'
ORACLE_SID
Set to ORCL
ORA_ORCL_AUTOSTART
Set to TRUE
These should set the registry so that autostart will occur.
Top
4 楼black_snail（●男人要忍○）回复于 2003-05-16 08:48:48 得分 0
终于我发现有一个BUG:-)
I' ve some experiences with ora 8.1.6.x and Win 2000 and encountered auto startup problems as well. Important to know is there are some bugs related on this issue and my autostart problems where solved after I applied patch 8.1.6.3.4 ( From 8.1.6.0.0 > 8.1.6.3.0 > 8.1.6.3.4 ) This might be the solution for you as well.
This is bug #1266248. Problem is with the call that is made to ORADIM.EXE by the service when the registry entry ORA_SID_AUTOSTART=true. Oradim hangs and the service is shown to be in status 'starting'. The autostart option is fixed in release 8.1.7 and was also backported to 8.1.6.3.1. If you do not have any patchsets installed you will want to apply: 8.1.6.3.0 and the patchset exception: 8.1.6.3.4 (contaning the fix). These patchsets can be downloaded from the MetaLink patch site. Please read the readme.txt file before patch application.
Top
5 楼black_snail（●男人要忍○）回复于 2003-05-31 18:13:20 得分 0
check ID 1734007
some information from oracle to describle how to bring up the service
●龙飞虎○)
Top
