Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2004
    Posts
    11

    Red face Unanswered: Starting the Oracle Instance

    I am just a beginner who is aiming for DBA. I have Windows NT and Oracle 8 on it. I have been trying to start an Oracle instance but am stuck on the very 2nd line of command. The command "Oradim80_new_sid sam _intpwd tom" gives out error - "Oradim80_new_sid" has not been recognised as internal or external command. Can anybody tell what am I doing wrong...SOS. Thanks in advance...

  2. #2
    Join Date
    Apr 2004
    Posts
    9
    When installing the oracle database did you ask oracle to create a default database.

    If you did then go to the dos promp:

    cd <oracle directory>
    type SQLPLUS

    log in as the sysdba i.e / as sysdba
    then type STARTUP if the database is not open.

    if you did not create a database then you will have to create a newone.

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Your problem may be in the syntax
    Oradim80_new_sid

    At command prompt, type
    c:\> oradim80 ?

    This will give you the proper syntax ...

    oradim80 -new ... etc

    I think the problem is with the "_" instead of "-" as well as spaces between parameters ....

    HTH
    Gregg

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Hi,
    Oradim utility is used to create,delete , edit an instance.
    For starting up an instance u donot need the help of Oradim.
    For starting up an instance.
    Another way of starting up the instance
    Go to command prompt

    c:\>SET ORACLE_SID=<SIDNAME>
    C:\>SVRMGRL30 (I GUESS FOR ORACLE8)
    SVRMGRL>CONNECT INTERNAL
    IF IT ASKS FOR PASSWORD THEN GIVE IT AS ORACLE WHICH IS THE DEFAULT.
    SVRMGRL>CONNECTED
    SVRMGRL>STARTUP
    THE ABOVE COMMAND IS SUFFICIENT ENOUGH TO START THE INSTANCE AS WELL AS THE DB.

    Or else u could also start it from Services dialog under control panel.
    OracleServicesid.

    Kaushik

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    From the original post, it looks like you are trying to run the .bat file from the "Create Database" utility. Under NT, the first line sets the environment variable for the SID. The second line creates the new instance ....

    If you are trying to CREATE the instance and database, ORADIM80 is correct ... your syntax for it is wrong.... ORADIM80 ? will show you the proper syntax .....

    If you ALREADY have created the instance .... Then you should find it as a Service that can be started or stop ....

    Gregg

  6. #6
    Join Date
    Apr 2004
    Posts
    11

    Talking Thanks

    Gregg hi,

    Thanks a lot.

    Samar

  7. #7
    Join Date
    Apr 2004
    Posts
    11
    Hi,
    Pls tell what is preferable to make database while installation ? If I do and do not create database on installation, how do I go about making one i.e what should be steps after installing oracle ? I have Oracle 8 on NT.
    Thanks...

  8. #8
    Join Date
    Apr 2004
    Posts
    9

    create a database

    If you did not create a database on install then:

    this link should be useful

    http://www.adp-gmbh.ch/ora/admin/cre...manually8.html

    You will not get the default data table though!

    regards

  9. #9
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    I don't remember whether or not Oracle 8.0 had a "Database Configuration Assistant" ... If so, use it ...

    If not, you need to build scripts to build the database ...

    Create the INSTANCE first by using ORADIM80...

    Build script to create the database and system tablespace.
    Build script to create additional tablespaces, rollback segments that you need and to run the CATALOG and CATPROC scripts.
    Build your INITxxx.ORA parameter file

    Run SVRMGRL30(?) connecting as internal
    startup nomount pfile=....\initxxx.ora -- start database with nomount
    Run the first script to create the database
    @directory\filename
    Run the second script to create tablespaces and Oracle objects
    @directory\filename

    Once complete, stop/start database, CHANGE passwords for
    SYS and SYSTEM and others ....

    Ensure that in the REGISTRY you have AUTOSTART=TRUE for so that
    the database will start when the SERVICE starts. Ensure the SERVICE is set to AUTOMATIC (if that's what you want) ....

    I believe that Oracle 8.0 has the Configuration Assistance through ...

    HTH
    Gregg

Posting Permissions

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