how to start oracle9i
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: how to start oracle9i

  1. #1
    Join Date
    May 2001
    Location
    London
    Posts
    149

    how to start oracle9i

    please inform me the steps of how to start Oracle9i

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    sqlplus
    conect sys as sysdba
    startup
    --

    Better RTFM.

    Sanjay

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Re: how to start oracle9i

    Originally posted by pareshg
    please inform me the steps of how to start Oracle9i
    Hi,
    Which System/OS?

    Orca

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Oracle DBA
    hmmm

  5. #5
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Originally posted by davey23uk
    hmmm

    Hi, the reason is :
    under WIN2K i start as follow :

    Code:
      net start OracleService[SID]
      sqlplus /nolog @dbstart.sql
    So only when i use the db really i start the NT-Service
    The same with shutdown.

    Orca

  6. #6
    Join Date
    Aug 2002
    Posts
    35
    if its unix
    login to os with dba group os user id
    then
    sqlplus /nolog

    then
    connec / as sysdba;

    startup

    same for shutdown
    "Be not afraid of growing slowly. Be afraid only of standing still."

  7. #7
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Originally posted by davey23uk
    hmmm
    It is somewhat concerning.
    OCP 8i, 9i DBA
    Brisbane Australia

  8. #8
    Join Date
    May 2002
    Posts
    2,645
    <--recusing myself from this one

  9. #9
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Originally posted by pgoenka
    if its unix
    login to os with dba group os user id
    Under WinK the DBA-Group_name is ORA_DBA

    Orca

  10. #10
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    Hello

    FYI Pls........
    Login as DBA grup user
    goto dos prompt.
    start an oracle service as
    1.oradim -new -sid SERVICE_NAME -intpwd PASSWORD -startmode a
    -pfile "< Path for ur initSID.ora file>"
    2.set oracle_sid=SERVICE_NAME
    3.sqlplus /nolog
    4.connect /as sysdba
    5.startup


    Regards,
    Sudheer,
    Project Lead,India

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