OraFAQ Forum: Server Administration » data files in oracle7

Home » RDBMS Server » Server Administration » data files in oracle7

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

data files in oracle7 [message #280574]

Wed, 14 November 2007 02:23

dirish
Messages: 232
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

Report message to a moderator

Re: data files in oracle7 [message #280577 is a reply to message #280574]

Wed, 14 November 2007 02:29

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: data files in oracle7 [message #280579 is a reply to message #280574]

Wed, 14 November 2007 02:32

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: data files in oracle7 [message #280585 is a reply to message #280579]

Wed, 14 November 2007 02:46

dirish
Messages: 232
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

Report message to a moderator

Re: data files in oracle7 [message #280600 is a reply to message #280574]

Wed, 14 November 2007 03:34

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.

Report message to a moderator

Re: data files in oracle7 [message #280605 is a reply to message #280600]

Wed, 14 November 2007 04:04

dirish
Messages: 232
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

Report message to a moderator

Re: data files in oracle7 [message #280606 is a reply to message #280605]

Wed, 14 November 2007 04:06

ThomasG
Messages: 3212
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?

Report message to a moderator

Re: data files in oracle7 [message #280609 is a reply to message #280606]

Wed, 14 November 2007 04:09

dirish
Messages: 232
Registered: November 2006

Senior Member

i think that its due to the hardware

Report message to a moderator

Re: data files in oracle7 [message #280610 is a reply to message #280609]

Wed, 14 November 2007 04:12

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

No.

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

Report message to a moderator

Re: data files in oracle7 [message #280614 is a reply to message #280610]

Wed, 14 November 2007 04:14

dirish
Messages: 232
Registered: November 2006

Senior Member

do you have any idea, about what should I check?

Report message to a moderator

Re: data files in oracle7 [message #280616 is a reply to message #280614]

Wed, 14 November 2007 04:17

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

The file size restrictions of your OS and file system.

/forum/fa/1620/0/

/forum/fa/1620/0/

Report message to a moderator

Re: data files in oracle7 [message #280619 is a reply to message #280616]

Wed, 14 November 2007 04:21

dirish
Messages: 232
Registered: November 2006

Senior Member

how can I solve this problem

thx

Report message to a moderator

Re: data files in oracle7 [message #280622 is a reply to message #280619]

Wed, 14 November 2007 04:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

- Check ulimit
- Change file system options (maybe recreate it)
- Change file system type
- Change OS

Regards
Michel

Report message to a moderator

Re: data files in oracle7 [message #280690 is a reply to message #280622]

Wed, 14 November 2007 09:23

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

Smile

Report message to a moderator

Re: data files in oracle7 [message #280989 is a reply to message #280690]

Thu, 15 November 2007 05:52

dirish
Messages: 232
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

Report message to a moderator

Re: data files in oracle7 [message #280990 is a reply to message #280989]

Thu, 15 November 2007 06:02

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

oracle7-startup [message #281164 is a reply to message #280574]

Thu, 15 November 2007 23:27

dirish
Messages: 232
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

Report message to a moderator

Re: oracle7-startup [message #281204 is a reply to message #281164]

Fri, 16 November 2007 01:52

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oracle7-startup [message #281350 is a reply to message #281164]

Fri, 16 November 2007 08:34

joy_division
Messages: 4963
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.

Report message to a moderator

Re: oracle7-startup [message #281353 is a reply to message #281350]

Fri, 16 November 2007 08:38

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You know, I can repeat the same answer as many times as he posts the question. Cool

Cool

Regards
Michel

Report message to a moderator

Re: oracle7-startup [message #281481 is a reply to message #281353]

Sat, 17 November 2007 03:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

God bless copy-paste technique!

Report message to a moderator

Previous Topic:	Oracle Error message ORA:12514 and 12154
Next Topic:	UPDATE OF CONFIGURATION PARAMETER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:35:08 CST 2024