Results 1 to 6 of 6

Thread: Quick question

  1. #1
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Unanswered: Quick question

    Hi guys.
    This is my first time working with 9.2.0.4. And I notice SERVER MANAGER (svrmgrl) "disapear"... or change it name?
    Is there any similar app in 9i? How can I shutdown/startup the db?
    Thanks in advance. Regards,

    Manf

  2. #2
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    I found the answer.

    Changes In Oracle9i To Be Aware Of

    CONNECT INTERNAL and Server Manager are gone. Oracle has been saying for a long time that these would be desupported someday, and now they have.
    - Use CONNECT / AS SYSDBA or CONNECT username/password AS SYSDBA instead of CONNECT INTERNAL.
    - Use SQL*Plus to startup and shutdown Oracle from the command line instead of Server Manager.

    Regards,

    Manf

  3. #3
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    To startup/shutdown your DB :

    Make sure your ORACLE_SID environment variable is correct (it matches the Oracle Instance you want to start up / shut down). Then execute :

    sqlplus /nolog
    connect sys as sysdba
    startup (or shutdown)

  4. #4
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    That's right ! You were quicker to find than me to answer

  5. #5
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Yeah, a but a little lazy... ja!
    One more answer: in "sqlplus /nolog", what does the NOLOG means? what kind of login is that?
    Thanks again!
    Regards,

    Manf

  6. #6
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    You're welcome.

    "/nolog" means that you start sqlplus, but don't connect to Oracle yet. You have to issue a "connect" command in order to connect afterwards. That's all.

    Regards,

    RBARAER
    Last edited by RBARAER; 08-12-04 at 16:12.

Posting Permissions

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