Tuesday, March 18, 2014

Enable SSH On Windows EM12C Purpose

Uploading Agent to windows/Linux needs ssh Port to be open and enabled, ssh not enabled on windows by default and do it Cygwin should be installed.

Configure Cygwin so simple, follow the below steps :-

Download Cygwin from Here, Upload File to the windows Server and Run the setup.







SSH Package should be chosen while installation.

After Installation Run cygwin terminal as Administration ( Right click on the icon and Choose the option )

Now Enable ssh should be done by run below command :-

/usr/bin/ssh-host-config
Should privilege separation be used? (yes/no) yes
new local account ‘sshd’? (yes/no) yes
Do you want to install sshd as a server? Yes
Enter the value of CYGWIN for the daemon: [] (DON’T ENTER ANYTHING, PRESS ENTER)
Do you want to use a different name? (yes/no) no
Create new privileged user account ‘cyg_server’? (yes/no) yes
Please enter the password: ENTER YOUR PASSWORD HERE
Reenter: RE-ENTER YOUR PASSWORD

Using Command Prompt ( cmd )
Start ssh by --> net start sshd
Stop ssh by --> net stop sshd

Another way posted by my friend Maaz you can check it here.

Thank you 
Osama Mustafa






Download Agent in EM12C manually

Adding target to EM12C needs to install agent to the Target Host Depend on Operating system, the agent is now always available which mean install Agent for this operating system is necessary, the below picture describe the above case :-


Enterprise manager cloud 12c contains two different type of Connection mode online and offline, this blog describe how to install manually :-

From Setup --> extensibility --> Self Update

Press On Agent Software., The below screen will appear :-


By pressing any of those agent new pop up will open included with link to download, copy the link and upload the file to OMS Host and run the below command :-

[oracle@EM12C emcli]$ ./emcli import_update -omslocal -file=....

File Path should be provided in the above command.

The output :-

Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows x64 (64-bit)
Successfully uploaded the update to Enterprise Manager. Use the Self Update Console to manage this update.


After Run the above command Successfully, Back to Self Update screen --> Agent Software and Apply the Download Catalog by press apply.


Thank you
Osama mustafa



Monday, March 17, 2014

Install EMCLI For EM12C

The Enterprise Manager Command Line Interface (EM CLI) enables users to access Enterprise Manager functionality through a command-line interface or scripts. It is accessible through classic programming language constructs, enabling tasks to be created and run either from the command-line or programatically. EM CLI enables you to access Enterprise Manager Cloud Control functionality from text-based consoles (shells and command-line windows) for a variety of operating systems.

For Overview and concept about it Read Oracle Documentation Here


The Setup to enable emcli so simple and already provided with Enterprise manager 12c,




From Setup --> Command Line Interface.


After Access Command Line Interface you should be able to install emcli kit by press the below :


Jar File will be installed,Upload it to the server.

Create New Folder On the Server Using :
mkdir /u01/emcli 
Set The Variable:-
export JAVA_HOME=/u01/app/fmw/jdk
export PATH=$JAVA_HOME/bin:$PATH 
Run the Below Command
java -jar emcliadvancedkit.jar client -install_dir=/u01/emcli 
cd /u01/emcli  
emcli setup -url=https://EM12c:7802/em -username=sysman -trustall -autologin

Thank you
Osama Mustafa

Thursday, March 13, 2014

OUG Ireland 2014

11/03 it's Date For Oracle User Group Ireland.
Location : Dublin Convention Center.



Like any other Flights it's took me 10 hours to be in Dublin,After Checked in the hotel First thing I did is attending Oracle ACE dinner and meet some Folks.

There was lot of Oracle Experts Speaker, Once the conference started I spent most of my day in RAC ATTACK Location and I would thank Mina Zadeh for this amazing Arrangement. it was really nice to meet her in person.



 Presentations was really amazing and useful, I would thank Oracle User Group Ireland for organizing and running this event so well.


Thank you
Osama Mustafa

Saturday, March 1, 2014

oracle 11g database architecture

While i was checking my old files on my laptop i found this, I found oracle 11g database architecture in details you can download it from my slideshare account here


Thank you
Osama mustafa