Skip to Content
0

ORA-01503: Create control file failed

Dec 29, 2016 at 02:46 PM

77

avatar image

Hi,

Can anyone help me out regarding this.

I am performing system refresh procedure, I'm facing the below issue.

ORA-01503: Create control file failed

ORA-00059: Maximum number of DB_FILES exceeded.

ORA-01110: data file 201: '/oracle/ACC/sapdata10/sr3_181/sr3.data181'

10 |10000 characters needed characters left characters exceeded

Manoj,

Please post the solution you found, so that others can benefit who might run into the same problem.

Cheers,
Matt

2
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Manoj Deverapalli Dec 29, 2016 at 06:02 PM
1

I have used the below command to increase value of "DB_FILES"

alter system set db_files=40 scope=spfile;

Share
10 |10000 characters needed characters left characters exceeded