Author: DB

Beginner Series, Logger, Oracle

PL/SQL Instrumentation: Installing Logger

If you are writing PL/SQL, the open source tool Logger, started by Tyler Muth and now owned and maintained by Martin D’Souza is instrumental in error identification and debugging. While I am sure that there are other resources that can provide the same information, this post will show you how to get Logger installed and …

OEM 13c, Oracle, Security

OEM13c Roles and AD Groups

Managing OEM13c Roles and AD Groups. In my last post, we explored how to enable LDAP (using Windows Active Directory) authentication within OEM 13c. Now that we can centrally manage basic user access to OEM, we need to apply some security constraints around these users.   If you are familiar with Active Directory (AD), then …

Configuration, LDAP, OEM, OEM 13c, Oracle

OEM 13c and LDAP Authentication

Using LDAP to provide Oracle Enterprise Manager authentication was quite an interesting task. The biggest challenge was finding resources that did a decent job of mapping the elements of an LDAP tree to where Enterprise Manager needed them. I could find stuff about LDAP and then stuff about OEM, but never together in a way …

Database, Fun Stuff, SQLDev

SQL Developer, MySQL, and a Raspberry Pi

  This post will probably not contain anything new, but maybe it will all just be in one place. Recently I decided to do something with my Raspberry Pi (RPi), as for some time now, it has been sitting on my desk acting as an XBMC server. Well no more. But what should I do? How …

Error, OEM 12c

OEM 12c set_target_property_value error

I ran across this error today while testing a script for OEM 12c emcli. Error: The command name “set_target_property_value” is not a recognized command. Run the “help” command for a list of recognized commands. You may also need to run the “sync” command to synchronize with the current OMS. Everything looked correct, I even copied …

Kscope16, Oracle

#KScope16 Blog Hop: EPM Sessions Not To Miss

Kscope 16 EPM Sessions You Don’t Want To Miss. It’s that time of year again. #Kscope16 is upon us and there are so many excellent sessions it will be tough to make it to everything I want to attend. Therefore this year, being someone who’s aligned with the Traditional side which includes APEX, Database and …

TimesTen

TimesTen: Parallel Thread Reads from Checkpoint Files – More is not always better

I wanted to get around to to some performance improvements with Oracle TimesTen Database. As you know, the Oracle TimesTen database creates a checkpoint file for persistence of the In-Memory database. In the event you need to load the database into memory, depending upon the size of the checkpoint, this can take some time. In …

TimesTen

TimesTen: Failed to retrieve IP address of the system

In my quest to understand TimesTen a bit more, I built a VM with VirtualBox, OL 6.5, and TimesTen 11.2.2. I verified that I could connect to TimesTen from the VM instance, but when I tried to connect to the TimesTen database from my host (MacBook Pro), I received the following error:

I even tried …

Oracle, TimesTen

Oracle TimesTen not using Large Pages

 Oracle TimesTen Database, was not using Huge/Large pages. Well at least when I executed a ttStatus command, I saw the following: Shared Memory KEY 0x0c0504dd ID 1838710795 (LOCKED) when I expected to see Shared Memory KEY 0x0c0504dd ID 1838710795 (Large Pages,LOCKED)

My ttendaemon.options file was configured correctly (see snippet below): -linuxLargePageAlignment 2

Memory …