Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation







Oracle ORADIM Utility
Oracle Tips by Burleson Consulting

Advanced Oracle Utilities: The Definitive Reference by Rampant TechPress is written by the top Oracle database experts (Bert Scalzo, Donald Burleson, and Steve Callan).  The following is an excerpt from the book.


On Windows, Oracle provides a simple utility like .exe for easily starting and stopping database services and/or instances via command line – oradim. Unlike UNIX, where the dbstart and dbshut scripts simply launch Oracle processes, oradim must work in the Windows paradigm of launching the Oracle processes as services. Below is a screen snapshot showing a Windows machine running two database instances and a listener. Also note that unlike UNIX, on Windows the Oracle background processes are all executed within threads of just the one Oracle process. See the section later this chapter on ORAKILL for more detailed information.

Figure 4.3:  Running Multiple Database Instances

The oradim utility can be launched several different ways to accomplish differing tasks. Also, the parameters passed vary depending upon the purpose being invoked. It creates a log file in the directory $ORACLE_HOME\database.


To create a new instance, the syntax is as follows:

-NEW -SID sid | -SRVC service | -ASMSID sid | -ASMSRVC service

[-SYSPWD password] [-STARTMODE auto | manual] [-SRVCSTART system | demand]

[-PFILE file | -SPFILE] [-SHUTMODE normal | immediate | abort]

[-TIMEOUT seconds] [-RUNAS os_user/os_password]


To modify an existing instance, the syntax is as follows:

-EDIT -SID sid | -ASMSID sid

[-SYSPWD password] [-STARTMODE auto | manual] [-SRVCSTART system | demand]

[-PFILE file | -SPFILE] [-SHUTMODE normal | immediate | abort]

[-SHUTTYPE service | instance] [-RUNAS os_user/os_password]


To delete an existing instance, the syntax is as follows:

 -DELETE -SID sid | -ASMSID sid | -SRVC service | -ASMSRVC service


To start up an existing instance, the syntax is as follows:


[-SYSPWD password] [-STARTTYPE service | instance | service,instance]

[-PFILE filename | -SPFILE]


To shut down an existing instance, the syntax is as follows:


[-SYSPWD password] [-SHUTTYPE service | instance | service,instance]

[-SHUTMODE normal | immediate | abort]


Here is a simple example of trying to stop an instance:


C:\Temp>oradim -shutdown -sid ORDB2

ORA-01031: insufficient privileges


Although no password is needed to perform this task, the Windows user must have sufficient privileges to execute this command successfully. Looking back up at the services screen snapshot, see that the database is running under the local system account, i.e. administrator. Since, in this example, the user is logged onto the machine using the domain/bscalzo Windows User ID, there are not the privileges to run oradim on that database instance, or any database instance for that matter.


The listener command line utility (lsnrctl) provides the DBA a method for starting, stopping and checking the status of the database listener as well as several other listener management tasks. The lsnrctl utility can either be run as a command line invocation or as a command line interpreter, as shown in these two examples:

$ lsnrctl command [listener_name]


$ lsnrctl

LSNRCTL> command [listener_name]


The lsnrctl command offers the following commands:


To create or change an encrypted password


Exit the program


Exit the program


Re-read the listener.ora file without a restart


Lists information about services, instances, & service handlers


Alters parameter values for the listener until shutdown


Displays current parameter values for the listener


Start a program on the server where listener is running


Start the named listener


Display status of the named listener


Stop the named listener


Start tracing for the named listener


Shows current version of lsnrctl utility


r more details on Oracle utilities, see the book "Advanced Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.

You can buy it direct from the publisher for 30% off directly from Rampant TechPress.

Remote DBA Service

Oracle Tuning Book


Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software










BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.