on 03-12-2008 6:33 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.