Oracle 12.2 New Feature: SQL*Plus History

While playing with Oracle 12.2 Database on the Oracle Cloud, I noticed that SQL*Plus has a new feature which would be very useful for all DBAs. Now SQL*Plus can keep history of the commands executed, and let you see and run these commands from the history. Its usage and functionality is very similar to Unix history tool, but do not think that pressing the UP arrow will return to previous commands 🙂

The history feature (more...)

EM13c: SQL Monitoring Raises ORA-06553

After I have installed the EM13c R2, I noticed that I couldn’t access the SQL Monitoring page. I tested the SQL monitoring page for 11g to 12c database targets, and it gave the same error: ORA-06553: PLS-306: wrong number or types of arguments in call to ‘REPORT_SQL_MONITOR_LIST’. As you can guess I hit a bug, good thing is someone else already raised a service request and Oracle released Patch 24914115 to fix the bug. When (more...)

EM13c: Unauthorized Access to Performance Pages

I noticed an interesting security problem (exploit?) on Oracle Enterprise Manager Cloud Control 13cR2 (I tested on EM13cR1 and it also exists on there). When you create an Enterprise Manager administrator, you need to grant some special privileges to that administrator if you want them to access the performance pages, but it seems there’s an alternative way to access the performance pages without requiring extra privileges.

Let’s say I created a new administrator with (more...)

Oracle Database Cloud Service: Set up Access Rules

I’ve started to test Oracle Database Cloud Services. I applied for trial, it’s accepted (you can also get a trial account, there’s no special requirement for it). After I got my welcome emails, I created a database service. As expected, it was very easy. All I needed is to click a couple of times, enter mandatory information and then wait until my Database is provisioned.

Oracle creates a VM for each database because they provide (more...)

EM13c: Get List of URLs Monitored by Beacons

When you need to monitor web services, you can use EM beacons. A beacon is a target that allows the EM Agent to remotely monitor services. You can add beacons to any EM agent using “Add Non-Host Targets by Specifying Target Monitoring Properties” option in the Add Targets Manually page. After adding a beacon, you can configure it to fetch a web page and test the status of the service according to the result of (more...)

EM13c: Is It Possible to Delete a Job Run with EMCLI?

Enterprise Manager Cloud Control provides a centralized job scheduling system and it’s possible to control it through both web interface and EMCLI. On the other hand, it seems web interface provides more control over the past jobs, for example it’s not possible to delete a job run with EMCLI, while it’s possible to do it on web interface:


EMCLI verb “get_jobs” reports all runs of the jobs, and “delete job” can delete job and its (more...)

OTN Appreciation Day: Oracle Wait Interface

Thanks to Tim Hall, lots of people from Oracle community, shared their favourite Oracle feature as blog posts. I’ve decided to dedicate my OTN Appreciation Day blog post to Oracle Wait Interface. I know that the topic was not limited to Oracle database, and I could share something about Oracle Enterprise Manager (my main focus area), but Oracle database is the entry point for me and it’s the reason why I started to use (more...)

Oracle Enterprise Manager Cloud Control: Write Powerful Scripts with EMCLI

Last week, I attended the Oracle Open World and did a presentation about writing scripts with EMCLI. If you’re not familiar with EMCLI, it’s the command line interface for Oracle Enterprise Manager Cloud Control. Here’s my presentation:

Although EMCLI is a very specific topic which appeals only to advanced users, a lot of people attended my session. I would like to thank Ray Smith (IOUG Director (more...)

EM13c: Unique Database Service Names on DBaaS

When creating Database through Oracle Enterprise Manager Self Service Portal, we need to enter a “unique” value as database service name. After I set up DBaaS on EM13c, I made several tests until I fix the provision problems (based on my own faults). On each test, I cleaned up failed request, entered a unique service name and submitted a new request. I thought there’s no validation about the service name but then I got an (more...)

Speaking at OOW 2016: Write powerful scripts with EMCLI

This will be my first time to attend Oracle Open World, and I’ll speak about Enterprise Manager Command-Line Interface (EMCLI) Scripting” on User Group Sunday. I already presented it on several conferences, heard people’s feedback and modified the content to improve my presentation. Now I will focus more on practical information, share sample scripts that can be used in real world scenarios. Hope to see you there!

Session ID: UGF3543
Session Title: Oracle Enterprise Manager (more...)