Yesterday, I presented at Oracle Day 2011 Istanbul. It was taken place in Swiss Hotel. I found opportunity to talk with my friends in TROUG and some readers of my blog. There was a huge interest to the event which contains 9 parallel sessions. As usual, our (TROUG) sessions were the favorites for the technical staff. Thanks to Oracle Turkey, we gave our presentations at one of the biggest conference rooms in Swiss Hotel, and we managed to fill the room.Read More
Oracle Day 2011 Istanbul will be take place at Swiss Hotel, Istanbul on November 1. It’s the most essential, can’t-miss business and technology event of the year. You will get a chance to see the latest development in Oracle’s public and private cloud computing solutions and how the power of simplicity can change your IT to a force that drives business innovation.
You can find the event details and register at Oracle Events Website.
Thanks to Oracle Turkey, 6 members of TROUG will be presenting in Oracle Day 2011. I’m one of them. I’ll give a presentation about Oracle Application Express. I’ll try to give a brief introduction about Oracle APEX in 30 minutes.
Here’s the agenda (in Turkish).
Presentations of TROUG Members:
- Oracle Cloud G’nin Gidişi C’nin Gelişi by Zekeriya Besiroglu (Oracle ACE)
- Data Mining in 30 Minutes by Husnu Sensoy (Oracle ACE Director, DBA of the year 2009) – Have I mentioned that each presentation will take only 30 mins?
- Rapid Application Development Tool: Oracle APEX by Gokhan Atil (Oracle ACE)
- What has Exadata changed? by Ferhat Sengonul (Oracle ACE)
- Data Integration in Heterogeneous Environments by Gurcan Orhan – Gurcan is honored as Oracle Excellence Awards, Technologist of the Year 2011 Enterprise Architect.
- Forgotten Features by H. Tonguc Yılmaz (Oracle ACE)
6 presentations, 4 Oracle ACEs, 1 ACE Director, 1 Technologist of the Year: Too good to be true All presentations of TROUG members will be in Turkish. I believe that it will be a wonderful event for all Turkish Oracle users.
In my previous post, I tried to show how to install Enterprise Manager Cloud Control 12c, now I’ll show how to add target hosts to our Enterprise Manager system. I assume that you’re in a similar position (installed Cloud Control but haven’t added any target yet).
As you know, we have to install Oracle Management Agent to the targets to be able to manage them via our Enterprise Manager. In OEM Cloud Control 12c, we can “Add Host Targets Wizard” which is accessible from the web interface. We can manually enter required information of host or we can use auto-discovery method.
If we’ll use auto discovery, we need an active agent to discover targets in network. This agent can scan local services or network. “Nmap” is used for scanning network. Nmap requires root privileges to be able to use raw sockets for “Syn Scanning” (a method to detect open ports through firewalls). So we need to configure “privilege delegation” in the host of our agent (which we’ll use for scanning).Read More
Installing Oracle Enterprise Manager Cloud Control 12c is easy and it’s already explained in a video at OTN website and MOS [ID 1359176.1]. Still, I wanted to create a step by step guide, and highlight the important points.
Here are the steps:
1) Installation of Oracle Linux (How to Install Oracle Linux 5.6)
2) Installation of Oracle Database (Repository Database): You can install one of the certified databases: 188.8.131.52, 184.108.40.206, 220.127.116.11, 18.104.22.168 and 10.2.0.5.
Do not forget to apply the latest PSU to the database. It is recommended that you do not use “memory_target” parameter with Enterprise Manager. Run the following commands and bounce the database:
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
ALTER SYSTEM SET shared_pool_size=600M 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;
ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
EXEC dbms_auto_task_admin.disable('auto optimizer stats collection',null,null);
These are minimum values, you can set higher values according to your system resources. It’s also recommend to have at least 3 redo log groups sized 300M. Luckily, the installer will warn you about all these settings.Read More
Yesterday (October 03), Oracle announced Oracle Enterprise Manager 12c (c for cloud). It’s the only complete management solution for enterprise cloud. Oracle Enterprise Manager is the first “12c” Oracle product. I’m sure that we’ll see more “12c” products in future.
You can read the press release of Oracle Enterprise Manager 12c:
I have noticed that Oracle Enterprise Manager Cloud Control is mentioned in all keynotes at Oracle Open World 2011. In my opinion, Oracle Enterprise Manager Cloud Control and Ops Center are the key components of the cloud environment. You can read what Oracle Partners are saying about Oracle Enterprise Manager 12c:Read More