Advertisement

Thursday, October 27, 2016

Oracle OEM 13c OMS and Oracle DB Installation

 
In this blog we are going to discuss OEM 13c Installation

Installing RDMS and EMPRD (EM database): 


1)      Start of installation:
            


2)      Selected option to create and configure database :
                




3)      Choose the option to server class:
               


4)      Choose Single instance database:
             


5)      Choose Advanced installation:
            


6)      Language is auto selected to English:
            




7)      To create Database for OEM, its mandatory to be Enterprise Edition:

          


8)       Create owner which doesn’t have Admin Privileges: (Can’t proceed further if the owner had admin privileges)

Username: xxxxx
Password: xxxxx
    


9)      Select locations for RDBMS installation:
       

10)   Choose option for General purpose:
         


11)   Name the database to EMPRD:
        



12)   Minimum required memory allocation is 6GB:
   




13)   Choose Character set :
      


14)   Choose Datafiles location for EMPRD database:
        


15)   Choose none as OEM is not yet installed:
        


16)   EMPRD database is not mandatory to be in archivelog:
        


17)     SYS, SYSTEM and DBSNMP passwords are kept default with “xxxxxx”
        
    


18)   Check all the configurations given:
       


19)   Progress of RDBMS installation:
       


20)   Progress of EMPRD database:
       

21)   Installation of RDBMS is complete:
       


22)   Creation of EMPRD is complete:

         

23)    Make sure EMPRD had minimum configuration to proceed with OEM installation:


ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;
ALTER SYSTEM SET log_buffer=10485760 SCOPE=SPFILE;
ALTER SYSTEM SET open_cursors=300 SCOPE=SPFILE;

13c: New requirement:
alter system set optimizer_adaptive_features=FALSE scope=both;


Restart the instance.

Those parameters are min. values which mean you can increase those values via your needs.
Oracle recommended to use UNDO tablespace is at least 200M in size. Also, make sure you have 3 redo logs of at least 300M to prevent a warning during the installation.


Installing OMS: 

1)      Start of OEM installation:
     


2)      Select skip option:
      



3)      Check for the prerequisites :
       


4)      Check create a new EM for first time installation:
        





5)      Select Middleware and Agent base directories:
        
       


6)      Provide new Administrator credentials and EMPRD database details:
Password: xxxxxx



7)      Verify all provided configuration:
       


8)      Progress of installation:
      



9)      It takes around 5Hrs at 50% progress:
      




10)   Once installation is complete: https://xxxxx:7799/em    
      



11)   EM login pages with URL: https://xxxxxx1:7799/em
      



12)   Welcome page:
       
        
Adding EMPRD database in OEM:

1)      Add: Setup/Add Target/ Add target Manually/ Add Target Declaratively:.
           


2)      Fill Host name and Database instance for EMPRD:
        

3)      Fill DB details with DBSNMP user and password is “xxxxx”:
         
         

4)      Test the connection to EMPRD:

        







 5)      Review:  


   
       

6)      Save the target in OEM:
 
        

7)      EMPRD status in OEM: