Home » RDBMS Server » Server Administration » ORA-00059: maximum number of DB_FILES exceeded (10g)
ORA-00059: maximum number of DB_FILES exceeded [message #365102] Thu, 11 December 2008 00:06 Go to next message
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365108 is a reply to message #365102] Thu, 11 December 2008 00:30 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365116 is a reply to message #365102] Thu, 11 December 2008 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365124 is a reply to message #365116] Thu, 11 December 2008 01:03 Go to previous messageGo to next message
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365126 is a reply to message #365124] Thu, 11 December 2008 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365199 is a reply to message #365126] Thu, 11 December 2008 01:21 Go to previous messageGo to next message
dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon
Member
Its version is 10.2.0.1.0

Regards
Vipin
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365200 is a reply to message #365199] Thu, 11 December 2008 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK, now the other points.

Regards
Michel
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365206 is a reply to message #365200] Thu, 11 December 2008 01:51 Go to previous messageGo to next message
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365215 is a reply to message #365206] Thu, 11 December 2008 02:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365231 is a reply to message #365215] Thu, 11 December 2008 03:03 Go to previous messageGo to next message
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365233 is a reply to message #365231] Thu, 11 December 2008 03:10 Go to previous messageGo to next message
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365242 is a reply to message #365233] Thu, 11 December 2008 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365310 is a reply to message #365242] Thu, 11 December 2008 06:45 Go to previous messageGo to next message
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #365313 is a reply to message #365310] Thu, 11 December 2008 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #376124 is a reply to message #365310] Tue, 16 December 2008 03:10 Go to previous messageGo to next message
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.

Re: ORA-00059: maximum number of DB_FILES exceeded [message #376231 is a reply to message #376124] Tue, 16 December 2008 09:16 Go to previous messageGo to next message
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #376241 is a reply to message #376231] Tue, 16 December 2008 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #376250 is a reply to message #376241] Tue, 16 December 2008 11:15 Go to previous messageGo to next message
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
Re: ORA-00059: maximum number of DB_FILES exceeded [message #376639 is a reply to message #376124] Thu, 18 December 2008 02:47 Go to previous message
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:
  


Current Time: Thu Dec 08 06:32:21 CST 2016

Total time taken to generate the page: 0.07127 seconds