Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2003
    Posts
    5

    Unanswered: Oracle9i Startup fromWindows 2002 command prompt

    Dear All,

    I would like to know, how to start Oracle9i Database from Windows Dos command Prompt.

    If I starting Oracle9i From windows 2000 as service, it's working, But when I want to handle startup/shutdown from DOS Prompt. It's gives Error.


    Thanks
    Sunil sharma

  2. #2
    Join Date
    Sep 2003
    Location
    Colombo, Sri Lanka
    Posts
    63

    Re: Oracle9i Startup fromWindows 2002 command prompt

    Could you post the errors it gives?

  3. #3
    Join Date
    Nov 2003
    Posts
    5

    Re: Oracle9i Startup fromWindows 2002 command prompt

    Originally posted by tm_suren
    Could you post the errors it gives?
    Dear Mr. Suren,

    Assum that no Oracle9i database Started automaticaly at OS startup. Now at C:\> I'm giving the following command.

    sqlplus /nolog

    sql>connect sys/sys as sysdba

    then it's gives error ORA-12560 TNS:Protocol Adapter Error.

    if i give direct Startup command like.

    sql>startup

    It's give same above error.

    Thankx agains,

  4. #4
    Join Date
    Sep 2003
    Location
    Colombo, Sri Lanka
    Posts
    63

    Re: Oracle9i Startup fromWindows 2002 command prompt

    This is some sort of a bug in Oracle it seems. I got to know this about 1 month back I'll try to get more information about this. I think there is a patch for it, but not sure.

    Cheers,
    Suren.

  5. #5
    Join Date
    Nov 2003
    Posts
    5

    Re: Oracle9i Startup fromWindows 2002 command prompt

    Originally posted by tm_suren
    This is some sort of a bug in Oracle it seems. I got to know this about 1 month back I'll try to get more information about this. I think there is a patch for it, but not sure.

    Cheers,
    Suren.
    Yeah!!
    Thankx,

  6. #6
    Join Date
    Oct 2003
    Posts
    5

    Re: Oracle9i Startup fromWindows 2002 command prompt

    Originally posted by sunilbrh
    Dear All,

    I would like to know, how to start Oracle9i Database from Windows Dos command Prompt.

    If I starting Oracle9i From windows 2000 as service, it's working, But when I want to handle startup/shutdown from DOS Prompt. It's gives Error.


    Thanks
    Sunil sharma

    Hi,
    Set the oracle environment variable on DOS Command prompt :-

    SET ORACLE_SID = your_oracle_sid

    Please don't put semicolon at end. Use sqlplus, it will work.

  7. #7
    Join Date
    Nov 2003
    Posts
    5

    Re: Oracle9i Startup fromWindows 2002 command prompt

    Originally posted by shiv_rasi
    Hi,
    Set the oracle environment variable on DOS Command prompt :-

    SET ORACLE_SID = your_oracle_sid

    Please don't put semicolon at end. Use sqlplus, it will work.
    Thankx for reply,
    But it's not working. It's Gives same error

    ORA:12560 TNS: Protocal adapter error.

  8. #8
    Join Date
    Oct 2003
    Posts
    26

    Re: Oracle9i Startup fromWindows 2002 command prompt

    Hi Sunil,

    In the windows environment, you need to have the Oracle service started before you can connect as sysdba.
    While creating the Oracle service, it can be configured to either to start the database along with it, or just itself (i.e the service)

    In your case the service is configured to bring up the db also.

    Do the following,
    start the service
    sqlplus /nolog
    connect / as sysdba
    startup
    (Here Oracle will say that db is already started)
    shutdown
    startup

    HTH
    Arvind

  9. #9
    Join Date
    Sep 2003
    Location
    Colombo, Sri Lanka
    Posts
    63

    Re: Oracle9i Startup fromWindows 2002 command prompt

    If you set the oracle_sid from the commang prompt and then try to start I think it will start. Don't know the reason

    C:\> SET ORACLE_SID=prod
    C:\>sqlplus /nolog
    SQL> CONNECT / as sysdba
    SQL>startup

    Cheers,
    Suren.

Posting Permissions

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