Home » RDBMS Server » Server Administration » data files in oracle7
data files in oracle7 [message #280574] Wed, 14 November 2007 02:23 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi,

I have oracle 7.3.

when I try to add a data file i have this error:

ERROR at line 1:
ORA-01118: cannot add any more database files: limit of 30 exceeded


In my init.ora I changed the parameter:

db_files = 31

I have the same error.

Plz Adv,

Thx
Re: data files in oracle7 [message #280577 is a reply to message #280574] Wed, 14 November 2007 02:29 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Have you bounced the database after changing the parameter?

And please don't use SMS speak in the forum.
Re: data files in oracle7 [message #280579 is a reply to message #280574] Wed, 14 November 2007 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Number of datafiles is limited by:
- db_files
- maxdatafiles given at database creation time.

The second one cannot be modified without recreating the control file.

Regards
Michel
Re: data files in oracle7 [message #280585 is a reply to message #280579] Wed, 14 November 2007 02:46 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Thx Guys,

Also, do you have any idea on the maximum size a data file can be in oracle 7.3


Thx
Re: data files in oracle7 [message #280600 is a reply to message #280574] Wed, 14 November 2007 03:34 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

This thread is not related with main one. I have not experience on oracle7. I think data file max size is OS dependent.
Re: data files in oracle7 [message #280605 is a reply to message #280600] Wed, 14 November 2007 04:04 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
I have this error:

ERROR at line 1:
ORA-01237: cannot extend datafile 15
ORA-01110: data file 15: '/data3/mmp01pup2.dbf'
ORA-09972: sfsfs: unable to resize a file smaller
IBM AIX RISC System/6000 Error: 27: File too large
Additional information: 512000
Additional information: 4096


Thx
Re: data files in oracle7 [message #280606 is a reply to message #280605] Wed, 14 November 2007 04:06 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
And what part of

IBM AIX RISC System/6000 Error: 27: File too large

don't you understand?
Re: data files in oracle7 [message #280609 is a reply to message #280606] Wed, 14 November 2007 04:09 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
i think that its due to the hardware
Re: data files in oracle7 [message #280610 is a reply to message #280609] Wed, 14 November 2007 04:12 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
No.

It's due to OS and/or file system restrictions on file size.



Re: data files in oracle7 [message #280614 is a reply to message #280610] Wed, 14 November 2007 04:14 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
do you have any idea, about what should I check?
Re: data files in oracle7 [message #280616 is a reply to message #280614] Wed, 14 November 2007 04:17 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The file size restrictions of your OS and file system.

./fa/1620/0/
Re: data files in oracle7 [message #280619 is a reply to message #280616] Wed, 14 November 2007 04:21 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
how can I solve this problem

thx
Re: data files in oracle7 [message #280622 is a reply to message #280619] Wed, 14 November 2007 04:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Check ulimit
- Change file system options (maybe recreate it)
- Change file system type
- Change OS

Regards
Michel
Re: data files in oracle7 [message #280690 is a reply to message #280622] Wed, 14 November 2007 09:23 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

OP After solved this problem please think for upgrade...
now 11g is also released.
you know where you are know ?
Oracle Version Avaliable options
11g            *****************
10g            **************
9i             *********
8i             ****
8              **
7              *  


Note: * represents for New feature comes with new release. Smile
Re: data files in oracle7 [message #280989 is a reply to message #280690] Thu, 15 November 2007 05:52 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi Friends,

when I startup my oracle instance I have this error:

ORA-00059: maximum number of DB_FILES exceeded

The db_files parameter has been set to 20


Thank you,
Dirish
Re: data files in oracle7 [message #280990 is a reply to message #280989] Thu, 15 November 2007 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Set your db_files parameter to a greater value.
It was at 30 in your previous post, why did you decrease it?

Regards
Michel
oracle7-startup [message #281164 is a reply to message #280574] Thu, 15 November 2007 23:27 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hi Friends,

when am starting my oracle database, am having this error:

SVRMGR> startup
ORACLE instance started.
Total System Global Area 24504624 bytes
Fixed Size 38992 bytes
Variable Size 11194592 bytes
Database Buffers 13107200 bytes
Redo Buffers 163840 bytes
ORA-00059: maximum number of DB_FILES exceeded


I have set db_files parameter to 20.

Thank you,
Dirish
Re: oracle7-startup [message #281204 is a reply to message #281164] Fri, 16 November 2007 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 15 November 2007 13:02


Set your db_files parameter to a greater value.
It was at 30 in your previous post, why did you decrease it?

Regards
Michel


Re: oracle7-startup [message #281350 is a reply to message #281164] Fri, 16 November 2007 08:34 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
dirish wrote on Fri, 16 November 2007 00:27

Hi Friends,

when am starting my oracle database, am having this error:

SVRMGR> startup
ORACLE instance started.
Total System Global Area 24504624 bytes
Fixed Size 38992 bytes
Variable Size 11194592 bytes
Database Buffers 13107200 bytes
Redo Buffers 163840 bytes
ORA-00059: maximum number of DB_FILES exceeded


I have set db_files parameter to 20.

Thank you,
Dirish


Yes, you told us this three times already. don't try to trick us by making new posts with the same question.
Re: oracle7-startup [message #281353 is a reply to message #281350] Fri, 16 November 2007 08:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You know, I can repeat the same answer as many times as he posts the question. Cool

Regards
Michel
Re: oracle7-startup [message #281481 is a reply to message #281353] Sat, 17 November 2007 03:47 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
God bless copy-paste technique!
Previous Topic: Oracle Error message ORA:12514 and 12154
Next Topic: UPDATE OF CONFIGURATION PARAMETER
Goto Forum:
  


Current Time: Sat Dec 03 22:24:05 CST 2016

Total time taken to generate the page: 0.15310 seconds