Introduction to Oracle Oradim

The following articles mainly introduce the actual usage of Oracle Oradim tools. First, we start with the creation routine, that is, the new sid | SRVC service [INTPWD Password] [MAXUSERS quantity] [STARTMODE a | m] [PFILE file] [TIMEOUT seconds.

Edit routine:

Edit sid sid [NEWSID sid] [INTPWD Password] [STARTMODE auto | manual] [PFILE file name] [SHUTMODE a | I | n] [SHUTTYPE srvc | inst | srvc, inst] [TIMEOUT seconds]

Delete routine:

Delete sid sid | SRVC service name

Start services and routines:

Startup sid sid [USRPWD Password] [STARTTYPE srvc | inst | srvc, inst] [PFILE file name]

Disable services and routines:

Shutdown sid sid [USRPWD Password] [SHUTTYPE srvc | inst | srvc, inst] [SHUTMODE a | I | n]

Query help:

? | H | help

Instructions:

SID sid specifies the name of the instance to be started

SRVC service name

USRPWD password specifies the password of an internal user. This parameter is not required if you log on as an NT administrator.

PFILE: Specifies the initialization parameter file for the instance. If the parameter file is in the default location of the Oracle Oradim tool, this command is not required.

STARTTYPE srvc | inst | srvc, inst indicates what srvc is to be started-only start the service inst-start the instance, the service must have started and started working srvc, inst-services and instances are started

SHUTTYPE srvc | inst | srvc. inst indicates what to terminate. The Parameter options are the same as above.

STARTMODE a | m indicates the mode in which the instance is started automatically in a-auto mode) m-manual mode manual)

SHUTMODE a | I | n indicates the shutdown mode used to terminate an instance. The a-abort mode I-immediate Mode n-normal mode is used.

Example:

1. generate a new instance Management Service in the service. The startup mode is manual.

 
 

  
  
oradim NEW SID test STARTMODE manual PFILE "D:\Oracle\admin\test\pfile\inittest.ora  
  
  
oradim NEW SRVC OracleServicetest STARTMODE manual PFILE "D:\Oracle\admin\test\pfile\inittest.ora  
 
 

Note: The valid service name is "OracleService" followed by "SID"

SID test is equivalent to SRVC OracleServicetest

2. Delete this instance or service

 
 

  
  
oradim DELETE SID test  
  
  
oradim DELETE SRVC OracleServicetest  
 
 

3. Edit the instance and change the startup mode to manual

 
 

  
  
oradim EDIT SID test STARTMODE manual 
 
 

4. Edit the instance and change the startup mode to automatic

 
 

  
  
oradim EDIT SID test STARTMODE auto 
 
 

5. The Oradim tool starts test

 
 

  
  
oradim STARTUP SID test  
  
  
oradim STARTUP SID test STARTTYPE srvc,inst  
 
 

6. Only start the test service

 
 

  
  
oradim STARTUP SID test STARTTYPE srvc 
 
 

7. Only start the test instance

 
 

  
  
oradim STARTUP SID test STARTTYPE inst 
 
 

8. Disable test.

 
 

  
  
oradim SHUTDOWN SID test  
  
  
oradim SHUTDOWN SID test SHUTTYPE srvc,inst   
 
 

The above content is an introduction to the usage of Oracle Oradim tools. I hope you will find some gains.