Home » RDBMS Server » Server Administration » Oracle Processes crashing on VMS -- Critical (open vms V6.2)
Oracle Processes crashing on VMS -- Critical [message #464695] Thu, 08 July 2010 20:01 Go to next message
sunnys_neil
Messages: 9
Registered: July 2010
Location: KY
Junior Member
We have an oracle db V7.1 running on Open VMS V6.2. Lately we are having problems with oracle processes crashing...When I do a 'show sys' on VMS...I dont see any oracle processes running on it.....It should show 4 oracle processes....The trace is turned off on DB and alert.log has older info...We have another log which says the following

======================================
Wed 19:32:26 NoFLT
Wed 19:32:26 P19: (SendDelays) ORA-01092: (Cnct err, can't get err txt. See Servr Msgs & Codes Manua
Wed 19:32:26 ORA_NAS_PMON, ORA_NAS_LGWR, ORA_NAS_SMON, ORA_NAS_RECO are DEAD
Wed 19:32:26 P19: (GetNumDelaysNotFilled) ORA-03114: (Cnct err, can't get err tx
t. See Servr Msgs & Codes Manua
Wed 19:32:26 10
====================================
one of the drives has lot of errors but not sure how to check those errors....

I tried to restart the server and sometimes it comes backup. I have backups but really like to solve this issue.

I know where the control files are located but not sure what would be good point to start this.....Any help would be appreciated....

Re: Oracle Processes crashing on VMS -- Critical [message #464696 is a reply to message #464695] Thu, 08 July 2010 20:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What is the migration plan to get off of VMS & on to a supported OS & supported Oracle version?

I suggest you do an export & move the dump file onto external media ASAP.

[Updated on: Thu, 08 July 2010 20:22]

Report message to a moderator

Re: Oracle Processes crashing on VMS -- Critical [message #464697 is a reply to message #464696] Thu, 08 July 2010 20:30 Go to previous messageGo to next message
sunnys_neil
Messages: 9
Registered: July 2010
Location: KY
Junior Member
Migrating to different version of OS/db might be a while. Do you mean just creating a whole database backup (dump files) ?
Re: Oracle Processes crashing on VMS -- Critical [message #464699 is a reply to message #464697] Thu, 08 July 2010 20:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>one of the drives has lot of errors but not sure how to check those errors....
If the hardware dies & can not be fixed, your options will be extremely limited.
Re: Oracle Processes crashing on VMS -- Critical [message #464718 is a reply to message #464699] Fri, 09 July 2010 01:12 Go to previous messageGo to next message
Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you, perhaps, purchase another hard disk (and either move contents of the old disk to the new one, or perform backup (using VMS's backup utility) to a tape, switch disks and restore backup to that disk)?

These are ... what? 2GB or 4GB disks on a Digital Alpha server? I don't think there are new ones available, but company that maintains the server should be able to get a "better" one than the one you have now.
Re: Oracle Processes crashing on VMS -- Critical [message #464776 is a reply to message #464718] Fri, 09 July 2010 07:27 Go to previous messageGo to next message
sunnys_neil
Messages: 9
Registered: July 2010
Location: KY
Junior Member
I have backups sets of HDD (2 GB's) but not just oracle db backup alone....Its on Digital Alpha 2100.


In my initial post, I was referring to those errors from 'sh dev dk' command...The error count was 4...Is that an hardware error or software error...I was assuming an software error....The errors are from the drive where the table space files are located...
Re: Oracle Processes crashing on VMS -- Critical [message #464833 is a reply to message #464776] Fri, 09 July 2010 15:28 Go to previous message
Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I have backups sets of HDD (2 GB's) but not just oracle db backup alone

So all you need is a new disk. Shut the database down, replace disks, restore backup and startup the database.
Previous Topic: OFFINE DROP
Next Topic: Shared pool Free percentage greater than 100
Goto Forum:
  


Current Time: Sun May 19 15:20:01 CDT 2024