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 ?
---------------------------------------------------------------
You must set the parameter in local machine/software/oracle/home0 of the register table:
ORACLE_SID
ORACLE_HOME
ORA_
1<inst>_AUTOSTART
2ORA_<inst>_PFILE
3ORA_<inst>_SHUTDOWN
4then can start two service.
5It is no matter with the parameter -intpwd in oradim command.
6
7\------------------------------------------------------------
8Trying to find some approval in metalink:
9
10You will also need the following registry entries:
11
12ORA_ORCL_PFILE
13The value is set to point to the proper initORCL.ora file.
14
15ORA_ORCL_SHUTDOWN
16Set to TRUE
17
18ORA_ORCL_SHUTDOWN_TIMEOUT
19Set to 30
20
21ORA_ORCL_SHUTDOWNTYPE
22Set to 'i'
23
24ORACLE_SID
25Set to ORCL
26
27ORA_ORCL_AUTOSTART
28Set to TRUE
29
30These should set the registry so that autostart will occur.
31
32\----------------------------------------------------------
33终于我发现有一个BUG:-)
34
35I' 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.
36
37This 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.</inst></inst></inst>