| Adding maxdatafiles [message #54238] |
Wed, 06 November 2002 08:08  |
deen
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
Hi experts,
I got an error ora-1118. Solution to solve it is to change maxdatafiles at control files.
What are the steps to change the maxdatafiles at control files?
Regards
deen
|
|
|
|
| Re: Adding maxdatafiles [message #54242 is a reply to message #54238] |
Wed, 06 November 2002 10:24  |
Raja
Messages: 57
Registered: March 2000
|
Member |
|
|
Hi,
U need to recreate your controlfile using
1)"create controlfile ..." or
2)"alter dataase backup controlfile to trace"
Hope helps u.
|
|
|
|
| Re: Adding maxdatafiles [message #54245 is a reply to message #54238] |
Wed, 06 November 2002 11:58 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
To fix the ORA-01118 error, you have:
1. backup your db
2. alter database backup controlfile to trace; from svrmgrl.
3. open the trace file from UDUMP. remove everything before STARTUP NOMOUNT; CREATE CONTROLFILE...
4. edit the MAXDATAFILES parameter in this file.
5. shutdown your database
6. run this file from svrmgrl as SYSTEM user.
7. alter database open
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
