Results 1 to 3 of 3

Thread: db

  1. #1
    Join Date
    Feb 2004
    Location
    inida
    Posts
    62

    Unanswered: db

    hi,

    where can i execute these commands before creating a database
    platform is windows

    Set ORACLE_SID = {SID}

    CREATE DATABASE ShepIT
    Maxinstances 1
    Maxloghistory 1
    Maxlogfiles 10
    Maxlogmembers 15
    Maxdatafiles 100
    Datafile ‘<directory>\datafile_01.dbf’
    size 300M reuse autoextend on next 15M maxsize unlimited
    character set WE8MSWIN1252
    national character set AL16UFT16
    logfile
    group 1 (‘<directory>\redo_01.log’) size 75M
    group 2 (‘<directory>\redo_02.log’) size 75M
    group 3 (‘<directory>\redo_03.log’) size 75M
    default temporary tablespace TEMP
    tempfile ‘<directory>\temp_01.dbf’
    extent management local uniform size 1M
    undo tablespace UNDO_TS datafile ‘<directory>\datafile_01.dbf’
    size 125M reuse autoextend on next 15M maxsize unlimited;

  2. #2
    Join Date
    Mar 2004
    Location
    Singapore
    Posts
    2

    Re: db

    Please try this,

    go to the command prompt,

    run "sqlplus \nolog"

    then you get a sqlplus cmd prompt and place your DB cmd and run it.

    this is for Oracle 9i and need to start and mount instance.

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    First and foremost thing u need to create an instance using oradim utility of oracle.U have the option to create the password for the sys(9i) in that command it self or u can also create it later using orapwd utility.

    Start the instance from services dialog.
    >Set ORACLE_SID=<service_name>
    >sqlplus sys/passwd@tnsservicename as sysdba--for 9i only

    Shutdown the instance and restart it to check for any errors.

    sql>Startup nomount
    sql>issue ur db creation command.

    After successfully creating DB donot forge to execute the sql files like catalog.sql,catproc.sql

    All the best
    Kaushik

Posting Permissions

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