RelationalDBDesignRelationalDBDesign


Create Database   «Prev 

Creating Oracle Instance

Creating an instance
ORADIM - NEW (-SID sid | -SRVC service)
Using the ORADIM command

  1. ORADIM: Is the command, and is different for different releases of Oracle. In Oracle8i (8.1.5), the command is simply ORADIM. In Oracle 8.0.x, the command is ORADIM80.
  2. -NEW: Tells ORADIM that you are creating a new instance, as opposed to removing or modifying an existing one.
  3. -SID sid: Specifies the SID name for the new instance.
  4. -SRVC: Specifies the service name for the new instance. You must use either -SID or -SRVC, but not both. In this course we will use -SID.
  5. -INTPWD: Specifies the internal password for the new instance. This is optional, and you do not need to do this now.
  6. -MAXUSERS integer: Reserves space for the specified number of database users.
  7. - STARTMODE auto|manual: Controls whether or not the service starts automatically (a) when Windows NT boots. A value of “auto” results in an automatic startup, while a value of “manual” requires you to manually start the service.
  8. -PFILE filespec: Points to your database parameter file (the initialization file).
  9. -TIMEOUT: This is in seconds, and controls the amount of time that is allowed to pass before ORADIM gives up on trying to create the service.

Oracle 13C Cloud Manager

Using ORADIM to Administer an Oracle Database Instance

ORADIM is a command-line tool that is available with Oracle Database. You are required to use ORADIM only if you are manually creating, deleting, or modifying databases. Database Configuration Assistant is an easier tool to use for this purpose.
The following sections describe ORADIM commands and parameters. Note that each command is preceded by a dash (-). To get a list of ORADIM parameters, enter:
oradim -? | -h | -help

Note: Specifying oradim without any options also returns a list of ORADIM parameters and descriptions. When you use ORADIM, a log file called oradim.log opens in ORACLE_ HOME\database, or in the directory specified by registry parameter ORA_CWD. All operations, whether successful or failed, are logged in this file. You must check this file to verify success of an operation.
If you have installed an Oracle Database service on Windows, then when logging in as SYSTEM user (LocalSystem), with startup mode set to Automatic, it is possible that the Oracle Database service starts but the database does not start automatically. The following error message is written to file ORADIM.LOG in directory ORACLE_ HOME\database:
ORA-12640: Authentication adapter initialization failed

Oracle Enterprise Management Agent, Oracle Enterprise Manager Management Server and Oracle Internet Directory may also fail, because they cannot connect to the database for the same reason. The workarounds are:
  1. Modify SQLNET.ORA
    You can modify SQLNET.ORA, either by removing the line
    sqlnet.authentication_services=(NTS)
    or by changing it to
    sqlnet.authentication_services=(NONE)
    
  2. Start the database after the service starts
    You can start the database manually after the Oracle Database service has started, using SQL*Plus and connecting as SYSDBA.
  3. Start the service as a specific user