Oracle Corporate Support
                                 Problem Repository

1. Prob# 1008318.6  HOW TO CHANGE MAXDATAFILES, MAXLOGFILES AFTER CREATING 
2. Soln# 2056331.6  CREATE TRACE, ALTER DATABASE


1. Prob# 1008318.6  HOW TO CHANGE MAXDATAFILES, MAXLOGFILES AFTER CREATING 

Problem ID          : 1008318.6
Affected Platforms  : Generic: not platform specific
Affected Products   : Oracle7 Server
Affected Components : RDBMS V07.XX
Affected Oracle Vsn : V07.XX

Summary:
HOW TO CHANGE MAXDATAFILES, MAXLOGFILES AFTER CREATING DATABASE

+=+

Problem Description:  
====================  
 
How can you change maxdatafiles, maxlogfiles after creating database? 
 
 
Search words: 
kernel parameters

+==+

Diagnostics and References:

 * {6660.6,Y,100}     RECOMMENDED KERNEL PARAMETERS
 * {7342.6,Y,100}     AFTER CREATING NEW DATABASE

 ref: {7261.6}     PRE-1006481.6

2. Soln# 2056331.6  CREATE TRACE, ALTER DATABASE

Solution ID         : 2056331.6
For Problem         : 1008318.6
Affected Platforms  : Sun Solaris V2 Sparc
Affected Products   : Oracle7 Server
Affected Components : RDBMS V07.01.03.XX
Affected Oracle Vsn : V07.01.03.XX

Summary:
CREATE TRACE, ALTER DATABASE

+=+

Solution Description:  
====================  
 
 1) Trace the controlfile: 
     Run sqlplus (or sqldba) and enter: 
     alter database backup controlfile to trace ; 
 2) Modify this file: 
    a) remove from the first line to the line before "STARTUP NOMOUNT" 
    b) remove line "ALTER DATABASE OPEN" to the end of the file 
    c) Change value of maxdatafiles, maxlogfiles, and other parameters 
    d) rename the file to something .sql (such as cntl.sql) 
 3) shutdown database 
 4) backup database 
 5) Run 'sqldba' : 
    sqldba > connect internal 
    sqldba > @cntl.sql    (sql script that you creates in step 2) 
    sqldba > alter database open noresetlogs ; 


+==+

References:

 ref: {6626.6}     PRE-1008744.6