DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle not available ERROR

  1. 02-20-2001, 02:28 PM #1
    ohgie
    ohgie is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 02-20-2001, 02:33 PM #2
    Halo
    Halo is offline Moderator
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width