OraFAQ Forum: Server Administration » ORA-00059: maximum number of DB_FILES exceeded

Home » RDBMS Server » Server Administration » ORA-00059: maximum number of DB_FILES exceeded (10g)

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

ORA-00059: maximum number of DB_FILES exceeded [message #365102]

Thu, 11 December 2008 00:06

dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon

Member

Hi All,
I am getting following error during creating of tablespace.

I tried to reset this parameter but still facing the same issue-

I followed the following steps-

sql> connect sys as sysdba;
sql> show parameter db_files;

its showing 200.

sql> alter system set db_files = 256 scope = spfile sid ='emqa80';
SQL> shutdown immediate
SQL> startup
SQL> sho parameter db_files

now its showing 256 as i m logged in as sys.

now if again login to my SID(emqa80)
sql> connect system/emqa80@emqa80
sql>show parameter db_files;

Its again shwoing 200 and not 256.
I am still facing problem in dbf file creation.

could you please help me in this regards

Regards
Vipin

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365108 is a reply to message #365102]

Thu, 11 December 2008 00:30

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Reported By: dhimanvipin On: Thu, 11 December 2008 17:27 In: RDBMS Server � Server Administration � ORA-00059: maximum number of DB_FILES exceeded
Reason I am not getting any resoponse on this. Could you please help me out. Regards Vipin Kumar
[Delete Report]

You posted at Thu, 11 December 2008 17:06 ([my time]

This is not a paid site. Wait more than 21 minutes before yelling from the rooftops. Someone should get to you in the next day or so.

David

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365116 is a reply to message #365102]

Thu, 11 December 2008 00:47

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

In the meantime you can read OraFAQ Forum Guide, especially "How to format your post?" section to know how to properly format and use code tags.
Also always post your Oracle version (4 decimals).

Use SQL*Plus and copy and paste your session.

"connect sys as sysdba;"
"connect system/emqa80@emqa80"
No proof you are connected to the same database.

Regards
Michel

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365124 is a reply to message #365116]

Thu, 11 December 2008 01:03

dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon

Member

Thanks for your response.

how would i ensure that i m connected to emqa80?

Regards
Vipin Kumar

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365126 is a reply to message #365124]

Thu, 11 December 2008 01:07

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Compare v$sdatabase.dbid and v$instance.host_name name when connected in both way.
And answer my question: "post your Oracle version (4 decimals)."

Regards
Michel

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365199 is a reply to message #365126]

Thu, 11 December 2008 01:21

dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon

Member

Its version is 10.2.0.1.0

Regards
Vipin

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365200 is a reply to message #365199]

Thu, 11 December 2008 01:27

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

OK, now the other points.

Regards
Michel

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365206 is a reply to message #365200]

Thu, 11 December 2008 01:51

dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon

Member

Hi Michel,
Do you need more formatting from myside?

I don't know how will i increase this parameter for EMQA80 SID?

Regards
Vipin Kumar

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365215 is a reply to message #365206]

Thu, 11 December 2008 02:24

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I need:

Quote:

v$sdatabase.dbid and v$instance.host_name when connected in both way.

Regards
Michel

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365231 is a reply to message #365215]

Thu, 11 December 2008 03:03

dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon

Member

Pls find the requested info below

SQL> SELECT dbid, name FROM v$database;

DBID NAME
---------- ---------
3351882876 EMQA80

SQL> connect sys as sysdba;
Enter password: ****
Connected.
SQL> SELECT dbid, name FROM v$database;

DBID NAME
---------- ---------
3570175450 DWPROD02

Regards
Vipin Kumar

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365233 is a reply to message #365231]

Thu, 11 December 2008 03:10

dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon

Member

Have I given you the right information if not could you please tell me how to get those info.

Thanks
Vipin

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365242 is a reply to message #365233]

Thu, 11 December 2008 03:51

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I help for free, I have many other things to do and other people to help so wait and be patient.

In addition, you didn't follow what I posted:

Quote:

In the meantime you can read OraFAQ Forum Guide, especially "How to format your post?" section to know how to properly format and use code tags.

Now you can see by yourself that you are NOT working on the same database.

Regards
Michel

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365310 is a reply to message #365242]

Thu, 11 December 2008 06:45

dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon

Member

Sorry for being Impatient.

I will format my query by reading that guide.

could you please guide me further?

I would be thankful to you.

REgards
Vipin Kumar

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #365313 is a reply to message #365310]

Thu, 11 December 2008 06:56

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I can't as I don't what is your problem now.

Regards
Michel

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #376124 is a reply to message #365310]

Tue, 16 December 2008 03:10

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

@dhimanvipin

You can see from the results that you posted that when you connect using

CONNECT SYS AS SYSDBA

you connect to the database DWPROD02, not the EMQA02 database that you think you're connecting to.

All you need to do is to connect to the correct database using

connect system/emqa80@emqa80

and then issue the ALTER SYSTEM command.

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #376231 is a reply to message #376124]

Tue, 16 December 2008 09:16

samg4ug
Messages: 33
Registered: July 2007
Location: India

Member

Hi Vipin,

Please let me know about your OS and why there are different database names if you are connecting to the same database .

Regards,
Sam G

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #376241 is a reply to message #376231]

Tue, 16 December 2008 10:05

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

why there are different database names if you are connecting to the same database

Because he connects to different database.

Regards
Michel

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #376250 is a reply to message #376241]

Tue, 16 December 2008 11:15

samg4ug
Messages: 33
Registered: July 2007
Location: India

Member

Hi,

That I understand, and that's why I am asking.
Unless we are aware of the OS we cannot tell Vipin the way to set ORACLE_SID.

Naturally he wont be able to see the changes made to the database.

Regards,
Sam G

Report message to a moderator

Re: ORA-00059: maximum number of DB_FILES exceeded [message #376639 is a reply to message #376124]

Thu, 18 December 2008 02:47

dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon

Member

Hi,
Sorry for late response.Today only I came to office and did as written by JRowbottom(16-Dec-08)

It is working now.

It is on Windows -XP.

Thanks for the support.

Thanks
Vipin Kumar

[Updated on: Thu, 18 December 2008 02:50]

Report message to a moderator

Previous Topic:	send & receive email through oracle
Next Topic:	How to move TS of table having column with long datatype

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 05:33:32 CDT 2024