RE: file 24, couldnot online from a node (rac 9)

Ujang,

My guess is that the directory structure is different on the two
machines.

What does the following show you?  Look closely at the soft links you
created to make sure they are correct.

select name from v$datafile
where file#=24;

Tom


--------------------------------------------------------
This transmission may contain confidential, proprietary, or privileged 
information which is intended solely for use by the individual or entity to 
whom it is addressed.  If you are not the intended recipient, you are hereby 
notified that any disclosure, dissemination, copying or distribution of this 
transmission or its attachments is strictly prohibited.  In addition, 
unauthorized access to this transmission may violate federal or State law, 
including the Electronic Communications Privacy Act of 1985.  If you have 
received this transmission in error, please notify the sender immediately by 
return e-mail and delete the transmission and its attachments.


-----Original Message-----

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ujang Jaenudin
Sent: Friday, May 25, 2007 8:26 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: file 24, couldnot online from a node (rac 9)

some strange:
oracle 9i 9.2.0.6
fujitsu primecluster
solaris 9

on node 2, i could not online file 24, due to file not found, but it
really there (i'm using softlink to /dev/rdsk)

ORA-01157: cannot identify/lock data file 24 - see DBWR trace file
ORA-01110: data file 24: '/oradata/PRSMA/prsma_raw_system_10g'
ORA-27041: unable to open file
SVR4 Error: 6: No such device or address
Additional information: 2
ORA-01186: file 24 failed verification tests
ORA-01157: cannot identify/lock data file 24 - see DBWR trace file
ORA-01110: data file 24: '/oradata/PRSMA/prsma_raw_system_10g'

from node 1, it is OK.

node 2

SQL> select status,error,format from v$datafile_header where file#=24;

STATUS  ERROR                    FORMAT
------- -------------------- ----------
ONLINE  FILE NOT FOUND                0


node 1:

SQL> select status,error,format from v$datafile_header where file#=24;

STATUS  ERROR                    FORMAT
------- -------------------- ----------
ONLINE                                8


-- 
regards
ujang
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l


Other related posts: