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

Thread: error on oracle

  1. 02-20-2001, 02:00 PM #1
    ohgie
    ohgie is offline Junior Member
    Join Date
    Feb 2001
    Posts
    23
    hi
    im haveng problem logging on to oracle
    it gives me error >oracle not available<
    heres what i did....
    i connect internal...then i set oracle_sid to new db name that i create...startup the pfile <path>
    gives me error that oracle is running then i issue shutdown immediate command...
    i exit the internal...then try log log on oracle sql/plus n get error that oracle is not available ...how can i fix this <NT>


    thank for ur time
    Reply With Quote Reply With Quote
  2. 02-20-2001, 02:10 PM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Work around: try svrngr system/manager@xyz syntax where xyz is connect string you are trying to connect.

    [Edited by sreddy on 02-20-2001 at 01:43 PM]
    Reddy,Sam
    Reply With Quote Reply With Quote
  3. 02-20-2001, 02:29 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You need to set ORACLE_SID BEFORE you get into server manager...
    Jeff Hunter
    Reply With Quote Reply With Quote
  4. 02-20-2001, 02:40 PM #4
    sridharm18
    sridharm18 is offline Junior Member
    Join Date
    Feb 2001
    Posts
    1

    Arrow

    At first set up the SID then startup ...pfile. Then Svrmgr startup. If it says oracle is running type in
    shutdown and after it shutsdown type in startup.
    Now try logging onto sqlplus as system/manager.
    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