Mailing List
Home
Forum Home
Linux - General Red Hat Linux discussion list
Installation - Getting started with Red Hat Linux
Enterprise Linux 3 - Discussion of Red Hat Enterprise Linux 3 (Taroon)
Red Hat Linux 9 - Discussion of Red Hat Linux 9 (Shrike)
Red Hat Linux 7.2 - Discussion of Red Hat Linux 7.2 (Enigma)
Red Hat Linux 7.3 - Discussion of Red Hat Linux 7.3 (Valhalla)
Apache Web Server
Oracle database, Microsoft SQL server ...
Subjects
• application/x mplayer2 plugin
• RPM error: db4 error(16) from dbenv >remove: Device or resource
   busy
• Command stream end of file while reading
• X Windows problem (xauth)
• Upgrading openoffice 1 1 rpm
• FTP: connection refused
• FTP: connection refused
• mount: /dev/cdrom: is not a valid block device
• Dell Precision 650, RedHat 9, no sound
• how to trace the cause resulting in the crash of bind server
• Virus on the list
• UNINSTALL RPM MYSQL
• usb pen drives: mounting as a user
• broadcom network interface
• make mrproper
• Couldn 't open PID file /var/run/named/named pid Permission denied
• sendmail configuration on redhat
• kernel 2 6 and /dev/sound/mixer not found
• Promise 378 controller
• Problem using up2date
• mrtg step by step howto/configuration for a newbie?
• Compiling and Installing Kernel 2 6
• Can 't locate module ppp0, can 't locate module ppp compress 21
• Lotus Notes under Wine
• HOW I CAN MAKE BOOTABLE FLOPPY DISKET
• /etc/security/limits conf question
• Intel E/1000 driver
• rpm database corrupt
• Command stream end of file while reading
• qla2300 modules
 
Oracle/Red Hat/NetApp

Oracle/Red Hat/NetApp

2007-08-20       - By Troy Knabe

 Back
We have several Oracle instances 10.2 (some RAC, some not, but all are having
the same issue) all running on Red Hat 4.5.  The binaries and data files are
all on the NetApp and mounted via NFS.



Sporadically when we shut the database down, we are unable to restart it.  





/u1/app/oracle/admin/prodrac/bdump/prodrac1_dbw0_10023.trc



Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

ORACLE_HOME = /u1/app/oracle/product/10.2.0

System name:   Linux

Node name:       orarac1

Release:               2.6.9-55.0.2.ELsmp

Version:               #1 SMP Tue Jun 12 17:58:20 EDT 2007

Machine:             x86_64

Instance name: prodrac1

Redo thread mounted by this instance: 1

Oracle process number: 8

Unix process pid: 10023, image: oracle@(protected) (DBW0)



*** SERVICE NAME:() 2007-08-18 02:05:27.878

*** SESSION ID:(1194.1) 2007-08-18 02:05:27.878

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 1 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 1: '/u1/oradata/prod/system/system01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 2 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 2: '/u1/oradata/prod/temp/undotbs01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 3 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 3: '/u1/oradata/prod/system/sysaux01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 4 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 4: '/u1/oradata/prod/table/users01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 5 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 5: '/u1/oradata/prod/temp/undotbs02.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 6 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 6: '/u1/oradata/prod/temp/undotbs03.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 7 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 7: '/u1/oradata/prod/table/esis_codes_data01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 8 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 8: '/u1/oradata/prod/index/esis_codes_indx01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 9 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 9: '/u1/oradata/prod/index/esis_large_indx.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 10 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 10: '/u1/oradata/prod/index/esis_temp_indx.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 11 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 11: '/u1/oradata/prod/index/esis_indx.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 12 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 12: '/u1/oradata/prod/table/school_connects.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 13 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 13: '/u1/oradata/prod/table/esis_temp_data01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 14 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 14: '/u1/oradata/prod/table/esis_large_data01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 15 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 15: '/u1/oradata/prod/table/esis_data01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8

ORA-01157 (See http://ORA-01157.ora-code.com): cannot identify/lock data file 16 - see DBWR trace file

ORA-01110 (See http://ORA-01110.ora-code.com): data file 16: '/u1/oradata/prod/table/tools01.dbf'

ORA-27086 (See http://ORA-27086.ora-code.com): unable to lock file - already in use

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 8



The work around that we have found is to copy all of the files off of that
mount point and then move them back.  We even tried stopping everything and
umounting/remounting the file system, but it still has the same errors.



Oracle and Netapp are both pointing to other as the root of the problem.  But
to me it sounds like an NFS locking issue.  Has anyone else experienced this,
or have any suggestions on a better work around that having to copy the data
files off and move them back?



Thanks

-Troy



--
redhat-list mailing list
unsubscribe mailto:redhat-list-request@(protected)?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list