Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Oracle Development
Reload this Page

Oracle Database Shutdown

Discuss Oracle Database Shutdown in the Oracle Development forum on Dev Shed.
Oracle Database Shutdown Oracle Development forum discussing administration, Oracle queries, and other Oracle-related topics. Oracle is known as one of the most robust multi-platform relational databases available.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old March 23rd, 2004, 01:30 AM
ipi ipi is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2004
Posts: 3 ipi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Angry Oracle Database Shutdown
Hello,

I know this may sound like a silly question, but please bear with me. I am running ORACLE 9i on a Win 2K Server machine and I am having a problem with my database automatically shutting down on a daily basis. Each morning in order to retrieve information from the database, I have to Startup and Mount the database. This happens without logging any events. Why is this? Can anyone help me with this?

Thanks!
Reply With Quote
  #2  
Old March 24th, 2004, 05:35 AM
galith_haham galith_haham is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2004
Posts: 64 galith_haham User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 25 m 17 sec
Reputation Power: 5
Check the sqlnet.ora file if it contains the string:

sqlnet.authentication_services = (NTS)

then you are probably running into a bug. change the nts to none should solve the problem + check the registry and see if autostart is set.

bye.
Reply With Quote
  #3  
Old March 24th, 2004, 07:08 AM
ipi ipi is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2004
Posts: 3 ipi User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks for the info. It was in fact set to that value and I did change it to none. Can you please provide some more info on what you mean about checking the registry? Where?

Thanks!
Reply With Quote
  #4  
Old March 24th, 2004, 09:53 AM
hedge hedge is offline
Contributing User
Dev Shed Novice (500 - 999 posts)
  
Join Date: Apr 2002
Posts: 692 hedge User rank is Sergeant (500 - 2000 Reputation Level)hedge User rank is Sergeant (500 - 2000 Reputation Level)hedge User rank is Sergeant (500 - 2000 Reputation Level)hedge User rank is Sergeant (500 - 2000 Reputation Level)hedge User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 4 Days 21 h 49 m 55 sec
Reputation Power: 19
Also check any backup software. The database files can't just be backed up with the db open, if they are this can cause the db to go down.
Reply With Quote
  #5  
Old March 25th, 2004, 01:46 AM
galith_haham galith_haham is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Feb 2004
Posts: 64 galith_haham User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 h 25 m 17 sec
Reputation Power: 5
Hi,

go to the registry
hkey_local_machine->software->oracle->homeXXXX

you should find a parameter there called ora_<dbname>_autostart - this should be set to true.

also another problem can be that the database get confused by the init/spfile so if you are using spfile edit the init to direct to the spfile: spfile=c:\.....

Regards,

Galit.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Oracle Development > Oracle Database Shutdown

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.