Manual D/B creation on Windows2000
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Manual D/B creation on Windows2000

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    hi folks,
    Could some body guide me how to create a database
    manually on windows 2000.

    How can i set the password for "internal" account
    when i am creating a database manually on WIN2000.

    Is password for INTERNAL account is mandatory on WIN2000.

    Thanks
    Sonia


  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    When ur installing oracle software it will ask do u want to create a database,say no and after sucessfully installing oracle.Then use oradim utility to create a service.Make a entry of this in the registry i.e oracle_sid=orcl.
    Then connect to svrmgrl as internal and start the database in nomount stage.
    Then execute the create database command.
    This will create a new database for u.

    cheese
    anandkl
    anandkl

  3. #3
    Join Date
    Feb 2002
    Posts
    267

    d/b creation

    hi anand thanx

    could u pls give me the exact syntax of orodim utility with and example.
    thanx
    sonia

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    oradim /? gives the output:

    DIM-00002: Valid commands are: -DELETE, -EDIT, -NEW, -STARTUP, and -SHUTDOWN
    Please enter one of the following command:
    Create an instance by specifying the following parameters:
    -NEW -SID sid | -SRVC service [-INTPWD password] [-MAXUSERS number] [-STARTMODE a|m] [-PFILE file] [-TIMEOUT secs]
    Edit an instance by specifying the following parameters:
    -EDIT -SID sid [-NEWSID sid] [-INTPWD password] [-STARTMODE auto|manual] [-PFILE filename]
    [-SHUTMODE a|i|n] [-SHUTTYPE srvc|inst|srvc,inst] [-TIMEOUT seconds]
    Delete instances by specifying the following:
    -DELETE -SID sid | -SRVC service name
    Startup services and instance by specifying the following parameters:
    -STARTUP -SID sid [-USRPWD password] [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename]
    Shutdown services and instance by specifying the following parameters:
    -SHUTDOWN -SID sid [-USRPWD password] [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE a | i | n]
    Query for help by specifying the following parameters: -? | -h | -help

    An example of creation of a service:
    C:\Oracle\Ora81\bin\oradim -new -sid ORCL -intpwd internal -startmode auto -pfile C:\Oracle\Ora81\admin\orcl\pfile\initORCL.ora




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