Change in Oracle Parameters and Log file size

[Former Member]

Hello All,

We have scheduled DB Check job and the log file showed few errors and warnings in the oracle parameter that needs to be corrected. We have also gone through the SAP Note #830576 – Oracle Parameter Configuration to change these parameters accordingly. However we need few clarifications on the same.

1.Can we change these parameters directly in init<SID>.ora file or only in SP file. If yes can we edit the same and change it or do we need to change it using BR tools.

2.We have tried to change few parameters using DB26 tcode. But it prompts for maintaining the connection variables in DBCO tcode. We try to make change only in default database but it prompts for connection variables.

Also we get check point error. As per note 309526 can we create the new log file with 100MB size and drop the existing one. Or are there any other considerations that we need to follow for the size of log file and creating new log file. Kindly advise on this. Our Environment is as follows.

OS: Windows 2003 Server

DB: Oracle 10g

regards,

Madhu

[Former Member · Accepted solution]

Make sure you have enough space in the file system where your log files are located other wise you will end up in a bad situation

follow this :

sqlplus / as sysdba

sql> select * from v$logfile

sql> select * from v$log

The above command will give you the log file name, size...etc

sql> alter database add logfile group 3 ('c:\.........' size 100M, 'd:\........' size 100M

Add new groups 3 to 6 or 7 or 10

sql> drop logfile group 1

repeat this command to drop the old groups