Using Tools and Utilities

Choosing Which Tool or Utility To Use
Starting Tools and Utilities
Using Instance Manager from the Command Line
Using SQL*Loader with Windows NT
Oracle Database Administration Tools Support

Choosing Which Tool or Utility To Use

Oracle7 Server for Windows NT includes various tools and utilities to perform database administration. The following table lists available tools and utilities and the operating system on which each can be used.

Tool or Utility Windows NT Server Windows NT Client Windows 95 Client Windows 3.1 Client
Instance Manager Graphical User Interface (GUI)

YES

NO

NO

NO

Instance Manager command line

YES

NO

NO

NO

Server Manager

YES

YES

YES

NO

Oracle7 Utilities ¹

YES

YES

YES

YES

Oracle Enterprise Manager

YES

YES

YES

NO

Windows NT Tools ²

YES

NO

NO

NO

OCOPY

YES

NO

NO

NO

SQL*Plus

YES

YES

YES

YES

Oracle7 Utilities consist of Export/Import, SQL*Loader, and the Password Utility.

Windows NT Tools belong to the Windows NT operating stem and can be used to perform operations on Oracle7 databases.

Note Some tools and utilities perform the same database administration tasks, though no one tool or utility performs all database administration tasks.

The following table lists tools and utilities that enable you to perform common database administration tasks. The footnotes provide additional information and references to other documentation. After choosing a tool or utility for performing a task, go to the section "Starting Tools and Utilities" in this chapter for instructions on starting the tool or utility. Unless otherwise noted, all tools and utilities listed in the following table can also be used on a Windows 95 client or a Windows 3.1 client.

Task/Use... Instance Manager¹ ² Server Manager³ Oracle7 Utilities Windows NT Tools Oracle Enterprise Manager OCOPY⁴ SQL*Plus
Create an Oracle7 database service

YES
Use command line or GUI ⁵

NO

NO

NO

NO

NO

NO

Start an Oracle7 database service

YES
Use command line only

NO

NO

YES
Use Control Panel

NO

NO

NO

Delete an Oracle7 database service

YES
Use GUI only

NO

NO

NO

NO

NO

NO

Delete an Oracle7 service but not the database

YES
Use command line only

NO

NO

NO

NO

NO

NO

Create a database

YES

YES

NO

NO

NO

NO

NO

Start a database ⁶

YES
Use command line or GUI

YES

NO

NO

YES
Use OEM Instance Manager ⁷

NO

NO

Connect to a database

NO

YES

NO

NO

YES

NO

YES

Shut down a database

NO

YES

NO

NO

YES
Use OEM Instance Manager

NO

NO

Export

NO

NO

YES
Use Export Utility

NO

YES
Use Data Manager

NO

NO

Import

NO

NO

YES
Use Import Utility

NO

YES
Use Data Manager

NO

NO

Change internal database passwords

YES ⁸
Use command line or GUI

NO

YES
Use ORAPWD73

NO

NO

NO

NO

Back up and restore files

NO

NO

NO

YES
Use NTBACKUP.EXE

YES ⁹

YES

NO

Move data from external files to Oracle7

NO

NO

YES
Use SQL*Loader

NO

YES
Use Data Manager

NO

NO

Authenticate DBAs and users

NO

YES

NO

NO

YES

NO

YES

Grant database roles

NO

YES

NO

YES
Use User Manager

YES
Use Security Manager

NO

YES

Create database objects ¹⁰

NO

YES

NO

NO

YES
Use Schema Manager

NO

YES

Instance Manager is available in both command line and graphical user interface (GUI) mode.

Instance Manager (both command line and GUI) is sometimes referred to as NT Instance Manager to distinguish it from Oracle Enterprise Manager Instance Manager.

Server Manager is available in line mode only.

The OCOPY utility is only available on Windows NT.

If you use Instance Manager in GUI mode to create a service, a new database is created automatically. To create a service without creating a database, use Instance Manager in command line mode.

Before starting a database, ensure that a database instance has been created. This is done automatically if you use the starter database. Ensure that the services have also been started.

Oracle Enterprise Manager Instance Manager is a tool that can start up and shut down a database and perform other limited functions. This tool cannot be used to create database services, or create and remove databases.

Instance Manager can only set a password when none was previously set. If a password has been previously set, Instance Manager cannot change it.

Tape backup functionality of Oracle Enterprise Manager is not available with Oracle7 databases on Windows NT or any other Windows platform.

See Oracle7 Server Administrator's Guide for guidelines on creating database objects. In particular, see the appendix "Space Estimations for Schema Objects" that provides equations for estimating the space requirements for clusters, nonclustered tables, and indexes. Windows NT uses the same fixed header, transaction header, and row header constants described in that guide.

Starting Tools and Utilities

This section describes:

How to start tools and utilities on Windows NT
Where to go for further information on using these tools and utilities

Additional Windows NT specific information on using these tools and utilities (where relevant)

Note You will frequently be referred back to this section for tool and utility startup procedures.

Tool or Utility How to Start This Tool or Utility... For More Information, Refer To...
Instance Manager GUI mode

Double-click the Oracle Instance Manager icon in the Oracle for Windows NT Program Group.
or
Enter the following without any parameters at the command prompt:

C:\> ORADIM73
The online help for Instance Manager.

Instance Manager command line mode

Enter the following with parameters at the command prompt

C:\> ORADIM73 parameters
To get a complete listing of ORADIM73 parameters, enter a question mark preceded by a dash after the executable name:

C:\> ORADIM73 -?
Note... If you do not specify any parameters, or incorrect parameters, the GUI version of Instance Manager appears.

The section "Using Instance Manager from the Command Line" in this chapter.

Server Manager (Line mode only)

Enter the following at the command prompt:

C:\> SVRMGR23

Oracle Server Manager User's Guide

The chapter "Administering a Database" of this Getting Started, which contains examples of starting and stopping the database with Server Manager.

Oracle7 Utilities:
Export Utility

Enter the following at the command prompt followed by your username and password.

C:\> EXP73
EXP73 runs and prompts you for parameters or you can control how EXP73 runs by entering the EXP73 command followed by various parameters. To obtain a list of these parameters enter the following at the command prompt:

C:\> EXP73 HELP=Y
Note... When running the Export utility, the default values for the following parameters under Windows NT are:
BUFFER 4K
RECORDLENGTH 2K
Note... To export an entire database, you must login with the username SYSTEM. Do not use INTERNAL or SYS.

Oracle7 Server Utilities, which describes how to use the Export utility.

Oracle7 Server Messages for information on error messages.

Oracle7 Utilities:
Import Utility

Enter the following at the command prompt followed by your username and password.

C:\> IMP73
IMP73 runs and prompts you for parameters or you can control how IMP73 runs by entering the IMP73 command followed by various parameters. To obtain a list of these parameters enter the following at the command prompt:

C:\> IMP73 HELP=Y
Note... When running the Import utility, the default values for the following parameters under Windows NT are:
BUFFER 4K
RECORDLENGTH 2K

Oracle7 Server Utilities, which describes how to use the Import utility.

Oracle7 Server Messages for information on error messages.

Oracle7 Utilities:
SQL*Loader

Invoke SQL*Loader at the command prompt followed by certain keywords. Enter the following and SQL*Loader displays a Help screen with the available keywords and default values.

C:\> SQLLDR73

Oracle7 Server Utilities, which describes how to use the SQL*Loader utility.

Oracle7 Server Messages for information on error messages.

The section "Using SQL*Loader with Windows NT" in this chapter.

Oracle7 Utilities:
Password Utility

Enter the following at the command prompt:

C:\> ORAPWD73 FILE=filename PASSWORD=password ENTRIES=max_users
where:

filename is the instance's password filename

password is the login password for the instance

max_users is the maximum number of users

Oracle7 Server Administrator's Guide, which describes how to use the Password utility.

Windows NT Tools
Control Panel

Choose Main ->Control Panel ->Services (for Windows NT 3.51)
or
Go to Start->Settings->Control Panel->Services (for Windows NT 4.0)

The section "Managing Oracle Database Services" in the chapter "Administering a Database".

Your Windows NT operating system documentation.

Windows NT Tools
User Manager

Choose Administrative Tools ->User Manager (for Windows NT 3.51)
or
Go to Start->Programs->Administrative Tools -> User Manager (for Windows NT 4.0)

Your Windows NT operating system documentation.

Windows NT Tools
NTBACKUP.EXE

Choose Administrative Tools ->Backup (for Windows NT 3.51)
or
Go to Start->Programs->Administrative Tools -> Backup (for Windows NT 4.0)

Your Windows NT operating system documentation.

Oracle Enterprise Manager

Choose the Oracle Enterprise Manager icon from the Windows NT Program Group (for Windows NT 3.51).
or
Go to Start->Programs->Oracle Enterprise Manager (for Windows NT 4.0).
Then:

Log on when prompted.

Select an appropriate tool from the Database Application Tools palette.

Log on to your selection when prompted.

Oracle Enterprise Manager Installation Guide and the online help provided with each Database Application Tool.

OCOPY

Enter the following at the command prompt.

C:\> OCOPY73
See the chapter "Backing Up and Recovering Database Files" in this Getting Started.

SQL*Plus

Enter the following at the command prompt:

C:\> SQLPLUS
or
Choose the SQL*Plus icon from the Oracle for Windows NT Program Group.

SQL*Plus User's Guide for Windows Platforms

SQL*Plus User's Guide and Reference

SQL*Plus Quick Reference

Using Instance Manager from the Command Line

ORADIM73 is the Instance Manager command line file name. This section describes the ORADIM73 commands and parameters. Note that each command is preceded by a dash.

Task Use This Parameter...
Create an instance

ORADIM73 -NEW -SID sid [-INTPWD internal_pwd]
[-MAXUSERS number][-STARTMODE auto, manual]
[-PFILE filename]
where:

sid is the value of the new system identifier (SID).

internal_pwd is the password for the INTERNAL account. Mandatory unless DBA_AUTHORIZATION or DBA_sid_AUTHORIZATION is set to BYPASS in \\HKEY_LOCAL\MACHINE\SOFTWARE\ORACLE\ of the Windows NT Registry.

number is the number of users defined in the password file. The default is five.

auto or manual indicate whether to start the database automatically or manually at startup. The default setting is manual.

filename is the INITsid.ORA file to be used with this instance.

Note... -NEW and -SID are mandatory parameters. The remaining parameters are optional.
Note... Creating an instance using ORADIM73 in command line mode only creates the password file and related service. The database (that is, the database files) is not created. If you use Instance Manager in GUI mode to create an instance, a new database is automatically created.

Start an instance

ORADIM73 -STARTUP -SID sid -PFILE filename [-USRPWD user_pwd] -STARTTYPE SRVC,INST
where:

sid is the value of the SID to start.

filename is the INITsid.ORA file to be used with this instance.

user_pwd is the password for the INTERNAL account. Mandatory unless DBA_AUTHORIZATION or DBA_sid_AUTHORIZATION is set to BYPASS in \\HKEY_LOCAL\MACHINE\SOFTWARE\ORACLE\ of the Windows NT Registry.

SRVC is for starting the services and INST is for starting an instance (both can be specified).

Note... -STARTUP, -SID and -STARTTYPE are mandatory parameters. The remaining parameters are optional.

Stop an instance

ORADIM73 -SHUTDOWN -SID sid [-USRPWD user_pwd] -SHUTTYPE SRVC, INST - SHUTMODE a, i, n
where:

sid is the value of the SID to stop.

user_pwd is the password for the INTERNAL account. Mandatory unless DBA_AUTHORIZATION or DBA_sid_AUTHORIZATION is set to BYPASS in \\HKEY_LOCAL\MACHINE\SOFTWARE\ORACLE\ of the Windows NT Registry.

SRVC is for stopping the services and INST is for shutting down a database (both can be specified).

Specifications on how to stop an instance; a indicates abort mode, i indicates immediate mode, and n normal mode.

Note... -SHUTDOWN, -SID and -SHUTTYPE are mandatory parameters. The remaining parameters are optional.

Edit an instance

ORADIM73 -EDIT -SID sid [-NEWSID newsid][-INTPWD internal_pwd]
[-STARTMODE auto, manual][-PFILE filename]
where:

sid is the value of the SID to edit.

newsid is the new SID for the instance (enter only if changing an existing instance name).

internal_pwd is the password for the INTERNAL account. This is necessary only if the password file was not created earlier.

auto or manual indicate whether to start the database automatically or manually at startup.

filename is the INITsid.ORA file to be used with this instance.

Note... -EDIT and -SID are mandatory parameters. The remaining parameters are optional.
Note... This command cannot be used to change the password, as it does not overwrite the existing password file. It can only create a new password file when none already exists. To create a new password file, use ORAPWD73.EXE

Delete an instance

ORADIM73 -DELETE -SID sida, sidb, sidc,...
ORADIM73 -DELETE -SRVC srvca, srvcb, srvcc,...
where:

sida, sidb, sidc are the values of the SIDs to delete.

srvca, srvcb, srvcc are the services to delete.

Display a complete list of Instance Manager commands

ORADIM73 -? | /? | /h | /help

Note When you use ORADIM73 in command line mode, Instance Manager opens a log file ORADIM73.LOG in ORACLE_HOME\RDBMS73. All operations (both successful and failed) are logged in this file. You must check this file to verify the success of an operation.

Using SQL*Loader with Windows NT

This section describes Windows NT specific information for using SQL*Loader (SQLLDR73.EXE).

Windows NT Processing Options

These are the possible values for the OS-dependent file processing specifications string option, referred to in the "SQL*Loader Control File Reference" chapter of Oracle7 Server Utilities User's Guide.

Processing Option Description
"VAR xxxx"

Load variable length records. Specify the OSD "VAR recsizehint" in the control file for this option to take effect. The xxxx gives an estimate of the average record size to SQL*Loader so that it can approximate buffer sizes accurately and not waste memory. The default length is eighty characters. The xxxx does not specify how many leading bytes of length are included in each record. It only acts as a hint to SQL*Loader. Each record must always be preceded by five ASCII bytes containing the length of the remainder of the record. For example, a record must look like the following:

00024This is a 24 byte string
Any whitespace, carriage returns or linefeeds at the end of the record are ignored unless specifically included in the byte count in the length field.

"FIX n"

Fixed record format in which each record is exactly n bytes long. If the record is terminated by a newline character, the newline character must be the nth byte.

""¹

Stream record format in which each record is terminated by a newline character. The maximum record size is 48 KB.

Two double quote characters with no space in between.

Direct Path Option

SQL*Loader includes a direct path option that bypasses Oracle7 redo log and data verification features, thereby decreasing loading time. Use the direct path option with data files known to be error free.

Control File Conventions

When preparing a SQL*Loader (.CTL) control file, you must follow certain syntax and notational conventions. When specifying datatypes in the SQL*Loader control file, note that the default size of native datatypes are specific to Windows NT. You cannot override these defaults in the control file.

Native Datatypes Default Field Length
INTEGER

4

SMALLINT

2

FLOAT

4

DOUBLE

8

Additional Information For a complete list of options and instructions on using SQL*Loader, see the Oracle7 Server Utilities. The directory ORANT\RDBMS73\LOADER contains a number of examples on the use of SQL*Loader.

Oracle Database Administration Tools Support

The following tools can be used for database administration depending on your release of Oracle7 Server for Windows NT.

32-bit Oracle Database Administration Tools

For Oracle7 Server release 7.3.2.1.x or below, Windows NT and Windows 95 users can choose to continue to use 32-bit Oracle Database Administration Tools (not included on the Oracle7 Server for Windows NT release 7.3.3 CD-ROM disc), which contain a subset of the full functionality of Oracle Enterprise Manager. This version of the Toolbar includes such tools as Database Manager and Object Manager.

Note 32-bit Oracle Database Administration Tools for Windows NT and Windows 95 are not supported for administering an Oracle7 Server release 7.3.2.2.1 and above. Oracle Corporation recommends that you use Oracle Enterprise Manager for administering databases, including database releases 7.3.2.1.x.

16-bit Oracle Database Administration Tools

16-bit Oracle Database Administration Tools for Windows 3.1 are supported for administering Oracle7 databases, when Oracle Enterprise Manager is not available. These tools are not included on the Oracle7 Server for Windows NT release 7.3.3 CD-ROM disc.

Note 16-bit Oracle Database Administration Tools are not being shipped after Oracle7 Server for Windows NT release 7.3.2.3.1. These tools will continue to be supported by Oracle Corporation for users who are using releases prior to and including release 7.3.2.3.1.

Prev Next

Library

Product

Contents

Index

Tool or Utility	Windows NT Server	Windows NT Client	Windows 95 Client	Windows 3.1 Client
Instance Manager Graphical User Interface (GUI)	YES	NO	NO	NO
Instance Manager command line	YES	NO	NO	NO
Server Manager	YES	YES	YES	NO
Oracle7 Utilities ¹	YES	YES	YES	YES
Oracle Enterprise Manager	YES	YES	YES	NO
Windows NT Tools ²	YES	NO	NO	NO
OCOPY	YES	NO	NO	NO
SQL*Plus	YES	YES	YES	YES

Task/Use...	Instance Manager¹ ²	Server Manager³	Oracle7 Utilities	Windows NT Tools	Oracle Enterprise Manager	OCOPY⁴	*SQLPlus**
Create an Oracle7 database service	YES Use command line or GUI ⁵	NO	NO	NO	NO	NO	NO
Start an Oracle7 database service	YES Use command line only	NO	NO	YES Use Control Panel	NO	NO	NO
Delete an Oracle7 database service	YES Use GUI only	NO	NO	NO	NO	NO	NO
Delete an Oracle7 service but not the database	YES Use command line only	NO	NO	NO	NO	NO	NO
Create a database	YES	YES	NO	NO	NO	NO	NO
Start a database ⁶	YES Use command line or GUI	YES	NO	NO	YES Use OEM Instance Manager ⁷	NO	NO
Connect to a database	NO	YES	NO	NO	YES	NO	YES
Shut down a database	NO	YES	NO	NO	YES Use OEM Instance Manager	NO	NO
Export	NO	NO	YES Use Export Utility	NO	YES Use Data Manager	NO	NO
Import	NO	NO	YES Use Import Utility	NO	YES Use Data Manager	NO	NO
Change internal database passwords	YES ⁸ Use command line or GUI	NO	YES Use ORAPWD73	NO	NO	NO	NO
Back up and restore files	NO	NO	NO	YES Use NTBACKUP.EXE	YES ⁹	YES	NO
Move data from external files to Oracle7	NO	NO	YES Use SQL*Loader	NO	YES Use Data Manager	NO	NO
Authenticate DBAs and users	NO	YES	NO	NO	YES	NO	YES
Grant database roles	NO	YES	NO	YES Use User Manager	YES Use Security Manager	NO	YES
Create database objects ¹⁰	NO	YES	NO	NO	YES Use Schema Manager	NO	YES

Tool or Utility	How to Start This Tool or Utility...	For More Information, Refer To...
Instance Manager GUI mode	Double-click the Oracle Instance Manager icon in the Oracle for Windows NT Program Group. or Enter the following without any parameters at the command prompt: C:\> ORADIM73	The online help for Instance Manager.
Instance Manager command line mode	Enter the following with parameters at the command prompt C:\> ORADIM73 parameters To get a complete listing of ORADIM73 parameters, enter a question mark preceded by a dash after the executable name: C:\> ORADIM73 -? Note... If you do not specify any parameters, or incorrect parameters, the GUI version of Instance Manager appears.	The section "Using Instance Manager from the Command Line" in this chapter.
Server Manager (Line mode only)	Enter the following at the command prompt: C:\> SVRMGR23	Oracle Server Manager User's Guide The chapter "Administering a Database" of this Getting Started, which contains examples of starting and stopping the database with Server Manager.
Oracle7 Utilities: Export Utility	Enter the following at the command prompt followed by your username and password. C:\> EXP73 EXP73 runs and prompts you for parameters or you can control how EXP73 runs by entering the EXP73 command followed by various parameters. To obtain a list of these parameters enter the following at the command prompt: C:\> EXP73 HELP=Y Note... When running the Export utility, the default values for the following parameters under Windows NT are: BUFFER 4K RECORDLENGTH 2K Note... To export an entire database, you must login with the username SYSTEM. Do not use INTERNAL or SYS.	Oracle7 Server Utilities, which describes how to use the Export utility. Oracle7 Server Messages for information on error messages.
Oracle7 Utilities: Import Utility	Enter the following at the command prompt followed by your username and password. C:\> IMP73 IMP73 runs and prompts you for parameters or you can control how IMP73 runs by entering the IMP73 command followed by various parameters. To obtain a list of these parameters enter the following at the command prompt: C:\> IMP73 HELP=Y Note... When running the Import utility, the default values for the following parameters under Windows NT are: BUFFER 4K RECORDLENGTH 2K	Oracle7 Server Utilities, which describes how to use the Import utility. Oracle7 Server Messages for information on error messages.
Oracle7 Utilities: SQL*Loader	Invoke SQLLoader at the command prompt followed by certain keywords. Enter the following and SQLLoader displays a Help screen with the available keywords and default values. C:\> SQLLDR73	Oracle7 Server Utilities, which describes how to use the SQLLoader utility. Oracle7 Server Messages* for information on error messages. The section "Using SQL*Loader with Windows NT" in this chapter.
Oracle7 Utilities: Password Utility	Enter the following at the command prompt: C:\> ORAPWD73 FILE=filename PASSWORD=password ENTRIES=max_users where: filename is the instance's password filename password is the login password for the instance max_users is the maximum number of users	Oracle7 Server Administrator's Guide, which describes how to use the Password utility.
Windows NT Tools Control Panel	Choose Main ->Control Panel ->Services (for Windows NT 3.51) or Go to Start->Settings->Control Panel->Services (for Windows NT 4.0)	The section "Managing Oracle Database Services" in the chapter "Administering a Database". Your Windows NT operating system documentation.
Windows NT Tools User Manager	Choose Administrative Tools ->User Manager (for Windows NT 3.51) or Go to Start->Programs->Administrative Tools -> User Manager (for Windows NT 4.0)	Your Windows NT operating system documentation.
Windows NT Tools NTBACKUP.EXE	Choose Administrative Tools ->Backup (for Windows NT 3.51) or Go to Start->Programs->Administrative Tools -> Backup (for Windows NT 4.0)	Your Windows NT operating system documentation.
Oracle Enterprise Manager	Choose the Oracle Enterprise Manager icon from the Windows NT Program Group (for Windows NT 3.51). or Go to Start->Programs->Oracle Enterprise Manager (for Windows NT 4.0). Then: Log on when prompted. Select an appropriate tool from the Database Application Tools palette. Log on to your selection when prompted.	Oracle Enterprise Manager Installation Guide and the online help provided with each Database Application Tool.
OCOPY	Enter the following at the command prompt. C:\> OCOPY73	See the chapter "Backing Up and Recovering Database Files" in this Getting Started.
SQL*Plus	Enter the following at the command prompt: C:\> SQLPLUS or Choose the SQL*Plus icon from the Oracle for Windows NT Program Group.	SQLPlus User's Guide for Windows Platforms* SQLPlus User's Guide and Reference SQLPlus Quick Reference

Task	Use This Parameter...
Create an instance	ORADIM73 -NEW -SID sid [-INTPWD internal_pwd] [-MAXUSERS number][-STARTMODE auto, manual] [-PFILE filename] where: sid is the value of the new system identifier (SID). internal_pwd is the password for the INTERNAL account. Mandatory unless DBA_AUTHORIZATION or DBA_sid_AUTHORIZATION is set to BYPASS in \\HKEY_LOCAL\MACHINE\SOFTWARE\ORACLE\ of the Windows NT Registry. number is the number of users defined in the password file. The default is five. auto or manual indicate whether to start the database automatically or manually at startup. The default setting is manual. filename is the INITsid.ORA file to be used with this instance. Note... -NEW and -SID are mandatory parameters. The remaining parameters are optional. Note... Creating an instance using ORADIM73 in command line mode only creates the password file and related service. The database (that is, the database files) is not created. If you use Instance Manager in GUI mode to create an instance, a new database is automatically created.
Start an instance	ORADIM73 -STARTUP -SID sid -PFILE filename [-USRPWD user_pwd] -STARTTYPE SRVC,INST where: sid is the value of the SID to start. filename is the INITsid.ORA file to be used with this instance. user_pwd is the password for the INTERNAL account. Mandatory unless DBA_AUTHORIZATION or DBA_sid_AUTHORIZATION is set to BYPASS in \\HKEY_LOCAL\MACHINE\SOFTWARE\ORACLE\ of the Windows NT Registry. SRVC is for starting the services and INST is for starting an instance (both can be specified). Note... -STARTUP, -SID and -STARTTYPE are mandatory parameters. The remaining parameters are optional.
Stop an instance	ORADIM73 -SHUTDOWN -SID sid [-USRPWD user_pwd] -SHUTTYPE SRVC, INST - SHUTMODE a, i, n where: sid is the value of the SID to stop. user_pwd is the password for the INTERNAL account. Mandatory unless DBA_AUTHORIZATION or DBA_sid_AUTHORIZATION is set to BYPASS in \\HKEY_LOCAL\MACHINE\SOFTWARE\ORACLE\ of the Windows NT Registry. SRVC is for stopping the services and INST is for shutting down a database (both can be specified). Specifications on how to stop an instance; a indicates abort mode, i indicates immediate mode, and n normal mode. Note... -SHUTDOWN, -SID and -SHUTTYPE are mandatory parameters. The remaining parameters are optional.
Edit an instance	ORADIM73 -EDIT -SID sid [-NEWSID newsid][-INTPWD internal_pwd] [-STARTMODE auto, manual][-PFILE filename] where: sid is the value of the SID to edit. newsid is the new SID for the instance (enter only if changing an existing instance name). internal_pwd is the password for the INTERNAL account. This is necessary only if the password file was not created earlier. auto or manual indicate whether to start the database automatically or manually at startup. filename is the INITsid.ORA file to be used with this instance. Note... -EDIT and -SID are mandatory parameters. The remaining parameters are optional. Note... This command cannot be used to change the password, as it does not overwrite the existing password file. It can only create a new password file when none already exists. To create a new password file, use ORAPWD73.EXE
Delete an instance	ORADIM73 -DELETE -SID sida, sidb, sidc,... ORADIM73 -DELETE -SRVC srvca, srvcb, srvcc,... where: sida, sidb, sidc are the values of the SIDs to delete. srvca, srvcb, srvcc are the services to delete.
Display a complete list of Instance Manager commands	ORADIM73 -? \| /? \| /h \| /help

Processing Option	Description
"VAR xxxx"	Load variable length records. Specify the OSD "VAR recsizehint" in the control file for this option to take effect. The xxxx gives an estimate of the average record size to SQLLoader so that it can approximate buffer sizes accurately and not waste memory. The default length is eighty characters. The xxxx* does not specify how many leading bytes of length are included in each record. It only acts as a hint to SQL*Loader. Each record must always be preceded by five ASCII bytes containing the length of the remainder of the record. For example, a record must look like the following: 00024This is a 24 byte string Any whitespace, carriage returns or linefeeds at the end of the record are ignored unless specifically included in the byte count in the length field.
"FIX n"	Fixed record format in which each record is exactly n bytes long. If the record is terminated by a newline character, the newline character must be the nth byte.
""¹	Stream record format in which each record is terminated by a newline character. The maximum record size is 48 KB.

Native Datatypes	Default Field Length
INTEGER	4
SMALLINT	2
FLOAT	4
DOUBLE	8