Home » RDBMS Server » Server Administration » Oracle Not Available
icon8.gif  Oracle Not Available [message #179882] Thu, 29 June 2006 03:34 Go to next message
iftikhar_79
Messages: 5
Registered: August 2005
Location: karachi
Junior Member

I have problem with "ORACLE NOT AVAILABLE". I have installed oracle 8i with developer 6i and create registry key oracle_sid and forms, report connect to database but when i restart the system and connet to oracle sql or form or report then message display "ORACLE NOT AVAILABLE". Than i go to server manager and start database manually.
Please inform me how can we start database automatically. Please inform me asap please.
Re: Oracle Not Available [message #179891 is a reply to message #179882] Thu, 29 June 2006 04:10 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
run regedit (Registry Edit) then click hkey_local_machine then click software then oracle then home0 and set the parameter ora_dbname_autostart to true and then restart ur pc. then ur database will be start automatically.
icon11.gif  Re: Oracle Not Available [message #179909 is a reply to message #179891] Thu, 29 June 2006 04:56 Go to previous messageGo to next message
iftikhar_79
Messages: 5
Registered: August 2005
Location: karachi
Junior Member

There is windows xp and service of db name is showing "starting" in services. and parameter is already set to TRUE in registry. How can it posible in this senerio. Please help me please.
Re: Oracle Not Available [message #179911 is a reply to message #179909] Thu, 29 June 2006 05:04 Go to previous messageGo to next message
prlzuby
Messages: 35
Registered: June 2006
Location: Pakistan
Member
from which user u connect and issue command startup
Re: Oracle Not Available [message #179914 is a reply to message #179911] Thu, 29 June 2006 05:12 Go to previous message
iftikhar_79
Messages: 5
Registered: August 2005
Location: karachi
Junior Member

I have connected as internal/oracle on server manager. and on windows connected as administrator.
Previous Topic: Selecting from MS SQL Server
Next Topic: temporary tablespace
Goto Forum:
  


Current Time: Fri Sep 20 10:30:31 CDT 2024