oracle not available ERROR
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle not available ERROR

  1. #1
    Join Date
    Feb 2001
    Posts
    23

    Unhappy

    hi
    how can i fix this problem <error: oracle not available>
    when i try to log on oracle sql/plus i get that error
    i issue a shutdown command and dont know how to start tha database ..is this because i issue shutdown immediate command ...if so how can i start the database oracle

    thank again
    helppppp

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    To start the db:
    export/set ORACLE_SID=db_name
    svrmgrl
    connect internal
    startup pfile=path_of_init.ora
    -
    Yes, if the db has been shutdown, you will not be able to connect to the db. Start it up and then try to connect using SQL*Plus.

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