Learn how to create an Oracle Database instance using ORADIM.
oradim [-NEW -SID SID] | -SRVC service_name | -ASMSID SID | -ASMSRVC service_name [-SYSPWD password][-MAXUSERS number][-STARTMODE auto | manual] [-SRVCSTART system | demand] [-PFILE filename | -SPFILE] [-SHUTMODE normal | immediate | abort] [-TIMEOUT secs] [-RUNAS osusr[/ospass]]
For this command, note the following:
-NEWindicates that you are creating a new instance. This is a mandatory parameter.
SIDis the name of the instance to create.
service_nameis the name of the service to create (
SIDis the name of the Oracle Automatic Storage Management instance to create.
service_nameis the name of the Oracle Automatic Storage Management service to create.
passwordis the system password.
numberis the number of users defined in the password file. The default is
manualindicates whether to start the instance when the Oracle Database service is started. The default is
-SRVCSTART system | demandindicates whether to start the Oracle Database service upon computer restart. Default is
systemspecifies that the service be configured to automatically start when the system boots or reboots.
Demandspecifies that the user has to explicitly start the service.
filenameis the initialization parameter file to be used with this instance. Ensure that you specify the complete path name of this file, including the drive letter.
-SPFILEindicates that a server parameter file (SPFILE) be used during startup instead of a PFILE.
-SHUTMODEspecifies how to stop an instance. It requires an argument and the default is
SHUTMODEis omitted, then there is no attempt made to shutdown the instance when the service is shut down.
secssets the maximum time to wait (in seconds) before the service for a particular
SIDstops. The default is 90 seconds. It cannot be used without the
-RUNAS osusr[/ospass] ("run as") makes it possible to specify both the Oracle Home User and its password. If the given
osusris different from the Oracle Home User, then the Oracle Home User is used instead of the
osusralong with the given
ospasscan be specified on the command line, Oracle recommends accepting
ORADIM creates Oracle Database service, Oracle VSS Writer service, and Oracle Scheduler service to run under the Oracle Home User account. If this account is a Windows Local User Account or Windows Domain User Account, then ORADIM prompts for the password for that account and accepts the same through
For simplicity in demonstrating this feature, this example does not perform the password management techniques that a deployed system typically uses. In a production environment, follow the Oracle Database password management guidelines, and disable any sample accounts.
To create an instance called
PROD, for example, enter:
C:\> oradim -NEW -SID prod -STARTMODE auto -PFILE C:\app\username\admin\prod\pfile\init.ora
Oracle Database Security Guide for password management guidelines and other security recommendations.