LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 05-05-2010, 07:17 PM   #1
camron
LQ Newbie
 
Registered: Nov 2009
Location: Everett, WA
Posts: 8

Rep: Reputation: 0
Cron service and oracle service stopped unexpectedly. Can't restart oracle.


I am running Fedora 11 with an Oracle 11g database installed. I came to check on it and found out that the oracle service had stopped.

I also have a script that gets run by cron every minute. I noticed that the last entry in the log /var/log/cron was March 24 at 4:26. Which was really close (not exactly to the second but within a few minutes) of the last log entry in the database translator logs (the database was processing data and it outputs a log).

I rebooted the machine and cron started running again, but I can't get the oracle service to start again. Normally it runs at startup, but if I need to run it or check it, I use
Code:
/sbin/service oracle restart
Is there another log that I could look at to see what would be the cause of the stoppage?

Any suggestions on how to get the oracle service started again?

What further details would be helpful to post here for a better description of the problem?

Thanks to anyone who can help.
 
Old 05-05-2010, 07:52 PM   #2
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
try /var/log/messages ... how does your disk space look ?
 
Old 05-06-2010, 11:06 AM   #3
camron
LQ Newbie
 
Registered: Nov 2009
Location: Everett, WA
Posts: 8

Original Poster
Rep: Reputation: 0
I have about 800 GB free on a 1 terabyte drive.

I have learned more since yesterday and it might be helpful if I tell a little history.

I had been having trouble with the screen resolution when logging in from windows remote desktop from Windows XP SP3 and xrdp installed in Fedora 11. Soon it stopped letting me in all together. After it quit letting me in, I rebooted the fedora computer. It took longer than 10 mins to boot and never made it past the white progress bar(May 4th). We did a hard shutdown and tried again. When it still took forever, I just let it sit overnight thinking that it would be the same when I came in the morining.
So when I showed up (May 5th), it was at the login screen. I logged in and it never showed the desktop... only the blue fedora background wallpaper (logging-in in person at the machine...no remote desktop).

When I rebooted, it gave me a screen that said that there were hard disk inconsistencies and that I had to do a fsck (or go through the endless loop of automatic restart if I selected to not do the fsck).

So I did it. Took about a half an hour and now it boots again.

------------------------
Here's the real puzzler:
Everything from March 24th until May 4th (the day of that first reboot) is erased. All the log entries in the cron log, messages, my oracle database logger, maillog, and secure are all missing. They just end on March 24th at about 3:22 and then pick up again on May 4th when we rebooted the computer.
All the test data files we created during that time are gone.

It seems like it has been restored to a previous date. Does fedora have restore points or some mechanism to select a certain date and revert?

But I still can't restart the oracle service. And I don't understand why I have all this missing data.
 
Old 05-06-2010, 06:12 PM   #4
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,758

Rep: Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643Reputation: 643
Hard drive might be on the way out .... what partition was the missing data on ?
 
Old 05-11-2010, 10:57 AM   #5
ramram29
Member
 
Registered: Jul 2003
Location: Miami, Florida, USA
Distribution: Debian
Posts: 848
Blog Entries: 1

Rep: Reputation: 47
Have you tried starting the Oracle database manually through sqlplus? What does the alert.log say?
 
Old 06-10-2010, 12:35 PM   #6
camron
LQ Newbie
 
Registered: Nov 2009
Location: Everett, WA
Posts: 8

Original Poster
Rep: Reputation: 0
There was too much data loss to try and recover from there.. It seemed like everything was gone as if the computer hadn't been turned on since March.
I am sorry to say that the solution was to reinstall the database on Oracle's Enterprise Linux and add the data again. However, now it's running smoothly.

I highly recommend to anyone trying to use Oracle on Fedora to just put it on OEL and many of your problems will be magically solved.
 
Old 06-10-2010, 06:00 PM   #7
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,287

Rep: Reputation: 2034Reputation: 2034Reputation: 2034Reputation: 2034Reputation: 2034Reputation: 2034Reputation: 2034Reputation: 2034Reputation: 2034Reputation: 2034Reputation: 2034
Fedora is the (bleeding edge) R&D distro for things that may appear later in RHEL. OEL, Centos and others are copies of RHEL.
 
  


Reply

Tags
cron, oracle, oracle11g, restart, service


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Restart Service malickhat Solaris / OpenSolaris 1 02-02-2010 03:02 PM
what is the difference between service network reload and service network restart ? markraem Linux - Networking 3 11-21-2007 03:08 PM
need a script to run oracle service shipon_97 Linux - Enterprise 5 03-02-2007 07:43 AM
How do I set the regulatory daemon to restart when I restart the network service? zahadumy Linux - Networking 0 11-05-2006 11:24 AM
SMPPPD closing named Service unexpectedly Last Attacker Linux - Networking 1 06-13-2006 05:20 AM


All times are GMT -5. The time now is 05:22 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration