Post Installation Required Database Configuration

After you install a new Oracle database for exclusive use by Cloud Control 12c, the Cloud Control documentation recommends you configure your database using this procedure.

1. Drop the management repository using this line command:

   emca -deconfig dbcontrol db -repos drop

   A sample of the resulting console session is shown below.

   [oracle@denlx01 bin]$ ./emca -deconfig dbcontrol db -repos drop
    
   STARTED EMCA at Aug 10, 2011 11:44:38 AM
   EM Configuration Assistant, Version 11.2.0.0.2 Production
   Copyright (c) 2003, 2005, Oracle.  All rights reserved.
    
   Enter the following information:
   Database SID: emrep
   Listener port number: 1521
   Password for SYS user:
   Password for SYSMAN user:
    
   Do you wish to continue? [yes(Y)/no(N)]: Y
   Aug 10, 2011 11:44:55 AM oracle.sysman.emcp.EMConfig perform
   INFO: This operation is being logged at /home/oracle/cfgtoollogs/emca/emrep/emca_2011_08_10_11_44_37.log.
   Aug 10, 2011 11:44:55 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
   INFO: Stopping Database Control (this may take a while) ...
   Aug 10, 2011 11:45:19 AM oracle.sysman.emcp.EMReposConfig invoke
   INFO: Dropping the EM repository (this may take a while) ...
   Aug 10, 2011 11:47:10 AM oracle.sysman.emcp.EMReposConfig invoke
   INFO: Repository successfully dropped
   Enterprise Manager configuration completed successfully
   FINISHED EMCA at Aug 10, 2011 11:47:14 AM
   You have new mail in /var/spool/mail/oracle
   [oracle@denlx01 bin]$
   

2. Per requirements for Cloud Control, you must change the Oracle database init parameters.

   Connected to the Oracle database as sysdba, use this command sequence:

   alter system set session_cached_cursors=200 scope=spfile;
   alter system set remote_login_passwordfile=SHARED scope=spfile;
   alter system set aq_tm_processes=1 scope=spfile;
   alter system set processes=500 scope=spfile;
   alter system set log_buffer=10485760 scope=spfile;
   shutdown immediate
   startup