Jothish,
7.3.4 on Solaris doesn't support file sizes larger
than 2GB except on raw partitions.
I find the following note invaluable for file size
issues. It also contains links to port-specific notes
as well.
Note: 62427.1 "2Gb or Not 2Gb - File limits in Oracle"
HTH,
-- Anita
--- "Manivannan.M" <[EMAIL PROTECTED]>
wrote:
> Hi DBAs,
> We are creating a oracle 7.3.4 database on a sun
> machine with solaris 8
> installed on it.The problem is that when we try to
> create a file thru the
> oracle then it does not allow us to crewate files
> bigger than 2000M
> size.whereas when we do it thru the OS it does
> create bigfiles
>
> created file thru the OS:
> -------------------------
> Now when we do a mkfile -v 3000M testfile it does
> create a big file of
> the required size.But then when i try to create a
> datafile thru oracle
> then it gives an error:
>
>
> creating file thru the oracle:
> ------------------------------
> SVRMGR> create tablespace testb datafile
> '/db1/dbf/test01.dbf' size 3000M;
> create tablespace testb datafile
> '/db1/dbf/test01.dbf' size 3000M
> *
> ORA-01119: error in creating database file
> '/db1/dbf/test01.dbf'
> ORA-07358: sfccf: write error, unable to write to
> file.
> SVR4 Error: 2: No such file or directory
>
>
> what cud be the reason behind this...
> are there any OS specific parameters that need to be
> modified or could
> there be some problem with the installation???
>
> please reply ASAP
>
> thanks in advance,
> Jothish
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Manivannan.M
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
