DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORADIM

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    Thumbs up

    What is Oradim? Does every shop run this? How would you know that you are running ORADIM.

    As you can see from my question, I have no idea what Oradim is. Can any body "break it down"(explain) to me what this is and what it does,etc?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Here is some thing that I was able to get from the Metalink. This is some thing that is new for a unix person like me. I am used to the server manager and not oradim. BTW, I couldn't find an expansion for oradim, if some one could explain that it would be really good. PURPOSE
    =======
    This bulletin explains how to create new database services and
    delete existing database services for an Oracle7, Oracle8, and Oracle8i
    database on Windows NT or Windows 2000 using the Oracle Instance Manager ORADIM
    utility. It also explains how to start or stop an existing database using the
    ORADIM utility.

    Please note that only versions 8.1.6 or higher of the database are supported
    on Windows 2000. For more information, please see [NOTE:77627.1] Oracle
    Database Server Product Support Matrix for Windows 2000.


    SCOPE & APPLICATION
    ====================
    The intended audience for this article is Oracle DBAs who have a
    moderate knowledge of Oracle7 or Oracle8 Server and an in-depth
    knowledge of Windows NT. This bulletin makes the following assumptions:

    - Oracle 7.3, 8.0 or 8.1 has been successfully installed.

    - All commands will be issued at the server itself.

    - You are logged on to the Windows NT server as Administrator or a user
    with Administrator privileges.


    CONVENTIONS AND DEFAULTS
    ========================

    For the purposes of this discussion, the following conventions are
    used:

    < > indicates a value that you must provide.
    [ ] indicates an optional value that you can provide.

    ORADIMxx refers to the ORADIM program specific to your
    version:

    Oracle 7.3: ORADIM73
    Oracle 8.0: ORADIM80
    Oracle 8.1: ORADIM (no version designation)

    All ORADIMxx commands are issued from a DOS Command Prompt.
    While the commands in the bulletin may span several lines,
    they should be entered as a single command line when typing
    them at the command prompt.

    ORADIMxx messages are not displayed on the screen, instead
    they are logged to a file. The file is overwritten with each
    ORADIMxx command. The filenames and locations are:

    Oracle 7.3: <oracle_home>\RDBMS73\ORADIM73.LOG
    Oracle 8.0: <oracle_home>\RDBMS80\ORADIM80.LOG
    Oracle 8.1: <oracle_home>\DATABASE\ORADIM.LOG


    RELATED DOCUMENTS
    =================
    [NOTE:61716.1] "ORACLE DATABASE SERVICES ON WINDOWS NT"


    NAMING ORACLE INSTANCES ON NT
    =============================
    Each instance of the database on the Windows NT/2000 server must be uniquely
    identified by a System IDentifier (SID). For Oracle 7.3 and 8.0, this is a
    string that is one to four alphanumeric characters long; however, for
    Oracle 8.1, the SID can be up to 64 alphanumeric characters long.


    BACKGROUND
    ==========
    In order to start an existing database or create a new
    database, the Windows NT service OracleService<sid> must be
    created. This is the only service that is required for an
    Oracle database.

    For versions 7.3 and 8.0: Optionally you may wish to have the
    Windows NT service OracleStart<SID> created which allows the
    database to be started automatically when the server is booted.

    For version 8.1: No other service is required to autostart the
    database upon server reboot. (See Chapter 9 of the Oracle8i Getting
    Started for Windows NT for more information.)

    The ORADIMxx utility makes changes to the server's registry so
    the commands must be executed at the server itself. If you wish
    to do these from a remote workstation, you must use a utility,
    such as PCAnywhere, which allows you to update a remote server's
    registry.

    You may need to create or recreate the database services for the
    following reasons:

    1. You want to create a new database by running scripts or
    entering the create database commands manually. Before this can
    be done the database service for the new SID must exist.

    2. The database is no longer automatically starting when the server
    boots. Provided that the database can be started manually,
    recreating the database services will usually resolve this issue.

    3. You want to change the INTERNAL password and also update the
    services so that the database will start with the new INTERNAL
    password.


    COMMAND LINE VS GUI ORADIM (Oracle7 ONLY!)
    ==========================================
    In Oracle7 the ORADIM73 utility has both a command line and GUI mode.
    (The GUI version of ORADIM was desupported in Oracle8 Version 8.0 as it
    is replaced by the Database Configuration Assistant.)

    The ORADIM73 GUI mode, invoked by entering ORADIM73 without any command line
    options or by selecting NT Instance Manager from the Oracle for Windows
    NT program group, allows you to create or delete a database including its
    associated datafiles.

    The command line version of ORADIM allows you to recreate the database
    services which does not affect the database files themselves. It also
    allows you to start up and shut down the database.



    INSTRUCTIONS
    ============
    I. DELETING EXISTING SERVICES
    If you are creating services for a new database, skip to Part II.
    A. If you are recreating existing database services, the
    password file for the instance will be recreated. If the value
    for the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE is set to
    EXCLUSIVE and you have granted other users SYSDBA and/or SYSOPER
    privileges, you will need to regrant these privileges to the
    users. The following query, executed by a user with DBA
    privileges, will display the users granted the SYSDBA and/or
    SYSOPER privileges:

    SELECT * FROM V$PWFILE_USERS;

    B. Perform a clean shutdown of the database using the
    appropriate DBA tool (SVRMGR23, SVRMGR30 or SVRMGRL) or
    Oracle Enterprise Manager Instance Manager. Stopping the
    OracleService<SID> does NOT perform a clean shutdown of the
    database.

    C. At the Command Prompt, type:

    ORADIMxx -DELETE -SID <SID>

    This command will delete the OracleService<SID> and (in 7.3 and
    8.0) OracleStart<sid> services.

    D. Verify that both services have been removed by checking the Windows
    NT/2000 Services from Control Panel. If you already have the
    Services panel open, you must exit out and reopen it as it does not
    refresh. On some systems it may take 10 - 15 seconds for the
    services to be removed.

    Proceed to part II if both services have been removed. If both
    services still exist, repeat steps C and D again. You may also
    want to review the ORADIM log file for any error messages.

    E. In some cases the OracleStart<SID> service may not get
    deleted. You can manually remove that service, or any Oracle
    service, with the following command:

    ORADIMxx -DELETE -SRVC <service_name>

    where service_name is the full name of the oracle
    service. Multiple service names may be specified by
    separating them with commas:

    ORADIMxx -DELETE -SRVC ORACLESERVICEORCL,
    ORACLESTARTORCL

    Again, verify that the services have been deleted before proceeding.


    II. CREATING SERVICES
    A. ORADIMxx -NEW -SID <SID> -INTPWD <password> -STARTMODE
    <mode> -PFILE <pfile>
    where:
    sid is the database SID
    password is the password for INTERNAL
    mode is the startup mode for the services, either
    AUTO or MANUAL
    pfile is the full path and name of the
    INIT<sid>.ORA file

    B. Review the ORADIM log file for any errors.
    In some cases the existing password file cannot be erased by
    ORADIM, typically if the properties of the file have been altered.
    There will be an error in the ORADIM log file to this effect.
    Move, rename, or delete the existing password file, PWD<sid>.ORA
    located by default in <oracle_home>\DATABASE. This is normally a
    hidden file so you may need to change the View options in Explorer
    to show hidden files.

    C. Verify that the services were created.
    * Important Note * The OracleService<SID> service will be started if
    you specified AUTO for the start mode. The OracleStart<SID> service
    will not be started as ORADIM does not know whether these
    services are for an existing database or for one that has not yet
    been created.

    D. If there are any errors in step B or both services were not created
    you must follow the steps in Part I to delete the existing
    services before you can recreate them.


    III. STARTING THE ORACLE SERVICES AND/OR DATABASE INSTANCE
    A. ORADIMxx -STARTUP -SID <SID> -USRPWD <password> -
    STARTTYPE <type> -PFILE <pfile>
    where:
    sid is the database SID
    password is the password for INTERNAL
    type is the startup type. SRVC will start just
    the service. SRVC, INST will start both the
    service and the database instance.
    pfile is the full path and name of the INIT<SID>.ORA file

    B. Review the ORADIM log for any errors.


    IV. SHUTTING DOWN THE ORACLE DATABASE INSTANCE AND/OR SERVICES
    A. ORADIMxx -SHUTDOWN -SID <SID> -USRPWD <password> -
    SHUTTYPE <type> -SHUTMODE <mode>
    where:
    sid is the database SID
    password is the password for INTERNAL
    type is the shutdown type. INST will shutdown
    just the database instance. INST, SRVC will
    shutdown both the database instance and the
    service.
    mode is the type of database shutdown: N for
    Normal, I for Immediate, or A for Abort

    B. Review the ORADIM log for any errors.

    +++++++++++++++++++++++++++++++++++++++

    looks like all the MS product has this capability.

    Sam

    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width