Greetings,
Thank you all in advance for your support! I am not a DBA, so I really appreciate you support!
We are trying to apply the OEM R4 12c Database repository requirements for a small site to our Oracle 12c Database before we install Oracle Enterprise Manager 12c R4. We are unable to getting the redo log files that we create (see below - ALTER DATABASE ADD LOGFILE) to be used by the database during the OEM installation. For example, when installing OEM with the below settings, we get a error message during the database setup complaining that the redo log file are not big enough, i.e. the database is using the default redo log file not the redo log file we created.
Could you please help with the missing sql commands to get the database to actually use the redo log file that we are creating?
Small Site Minimum Database Settings
Post database installation we run the following commands to apply the database requirements for OEM R4:
sqlplus / AS SYSDBA
ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
System altered.
ALTER SYSTEM SET pga_aggregate_target=1024M SCOPE=SPFILE;System altered.
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
System altered.
ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
System altered.
ALTER SYSTEM SET db_securefile=PERMITTED SCOPE=BOTH;
System altered.
ALTER DATABASE force logging;System altered.
ALTER TABLESPACE users FORCE LOGGING;
System altered.
ALTER DATABASE ADD LOGFILE ('/u01/app/oracle/product/redo_logs/log1c.rdo', '/u01/app/oracle/product/redo_logs/log2c.rdo', '/u01/app/oracle/product/redo_logs/log3c.rdo') SIZE 100M;
System altered.
SHUTDOWN IMMEDIATE;
SQL> CREATE SPFILE FROM PFILE;
SQL> STARTUP;
ORACLE instance started.
Total System Global Area 3206836224 bytes
Fixed Size 2217632 bytes
Variable Size 1744832864 bytes
Database Buffers 1442840576 bytes
Redo Buffers 16945152 bytes
Database mounted.
Database opened.
SQL> quit
With this command: ALTER DATABASE ADD LOGFILE ('/u01/app/oracle/product/redo_logs/log1c.rdo', '/u01/app/oracle/product/redo_logs/log2c.rdo', '/u01/app/oracle/product/redo_logs/log3c.rdo') SIZE 100M; the redo log files are indeed created, but the DB does not use them.
Respectfully,
Roddy