Tuesday, April 21, 2015

Oracle 11g:OEM grid control 11gR1 installation and configuration on Windows Server (64 Bit)

Oracle 11g:OEM grid control 11gR1 installation and configuration on Windows Server (64 Bit)

This post is mainly written for Installation of Oracle 11gR1( OEM grid control on windows server.

We will install it on separate grid server which OS is windows server 2012. 64 bit.


Oracle Database for repository of OEM grid control.

All servers hosts names added to hosts files on server.

Installation of Weblogic server.

We will go steps by steps to complete grid control configuration.

1.Installation of JDK.

Read on this link..

2.Installation of Weblogic Server for middleware.

Read on this link..

3.Make necessary changes to repository database.

sqlplus / AS SYSDBA

ALTER SYSTEM SET log_buffer=10485760 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;

UNDO tablespace is at least 200M in size.

SQL> alter database datafile 'C:\ORACLE\ORCL\UNDOTBS01.DBF' resize 200m;

Database altered.

bounce DB.

deconfigure Enterprise Manager Database Control. 

emca -deconfig dbcontrol db -repos drop -SYS_PWD syspassword-SYSMAN_PWD sysmanpassword

C:\Users\bhavesh>emca -deconfig dbcontrol db -repos drop -SYS_PWD oracle123 -SYS
MAN_PWD sysman

STARTED EMCA at Apr 21, 2015 4:05:51 PM
EM Configuration Assistant, Version Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521

Do you wish to continue? [yes(Y)/no(N)]: y
Apr 21, 2015 4:06:37 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\Oracle\cfgtoollogs\emca\orcl\emca_201
Apr 21, 2015 4:06:37 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be p
Apr 21, 2015 4:06:38 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForD
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Apr 21, 2015 4:06:38 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Apr 21, 2015 4:11:41 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 21, 2015 4:11:42 PM

3.Grid Installation..

Run setup.exe  as Administrator. & follow steps.

Supply ermail address for security updates.

Skip software updates..

Install new Enterprise manager system..

Check perquisites & ignore if it is not important..

Supply middleware location..

Supply password.Keep password into in txt file.

Repository database connection details.

Supply SYSMAN password..

Supply Registration password..

Check default ports for grid configuration..

Check if any of port already used then changes according to range...

Check summary before go for installation..

Monday, April 20, 2015

Oracle 11g grid control:Weblogic 10.3.2 Installation on windows server 64 Bit

Oracle 11g grid control:Weblogic 10.3.2 Installation on windows server 64 Bit

Today We will learn to installaton of Weblogic installation for middleware in grid control configuration.

This installation requires  JDK with suitable version to support as it will give error while configuration so be careful while choosing JDK to install.

For us, We will use JavaTM Platform, Standard Edition 6 Development Kit.

You can also download it from http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase6-419409.html#jdk-6u18-oth-JPR

Check installed version.

Download the Weblogic server 10.3.2 from oracle.com

Do not download any other versions of Weblogic because other versions doesnt work with grid control configuration.

This version is archived from oracle site .So getting this need to create "Contact US SR" to oracle to provide edelivery link to download the weblogic server.

Once download finish, We will proceed with small easy steps for configuration of Weblogic Server.

1.Click on installer & Run it as Administrator.

Alternately by command.exe

C:>java -jar wls1032_generic.jar 

2.Click next & follow the instructions.

3.Choose the middle ware home.

4.Provide Oracle support identifier or leave without fill.

5.Choose Installation Type-Typical.

6.Browse JDK version

C:\Program Files\Java\jdk1.6.0_18

7.Choose Weblogic Server Installation directory.


9.Installation in progress.Monitor it until finish.

10.Once Installation Completed , Need to apply patches.

We must apply WDJ7 patch through smart patch apply utility.

11.Run bsu.cmd through command prompt.

Click Ok & continue..

12.Unzip patch p9438213_10320_Generic.zip & copy files into C:\Oracle\Middleware\utils\bsu\cache_dir location.

13.Install patch by clicking on apply 

Check all patches installed .