Do you come here often? 12.2 change in behavior for DBA_USERS.LAST_LOGIN with Proxy Authentication

The behavior of the LAST_LOGIN field on DBA_USERS has changed with respect to proxy authentication (for the better I think). Proxy authentication is an feature of the Oracle Database that effective allows you to be connected as one user (the client user to use Oracle’s terminology), but using the credentials of another user (the proxy …

Do you come here often? 12.2 change in behavior for DBA_USERS.LAST_LOGIN with Proxy Authentication Read More »

WordPress Resources at SiteGround

WordPress is an award-winning web software, used by millions of webmasters worldwide for building their website or blog. SiteGround is proud to host this particular WordPress installation and provide users with multiple resources to facilitate the management of their WP websites: Expert WordPress Hosting SiteGround provides superior WordPress hosting focused on speed, security and customer …

WordPress Resources at SiteGround Read More »

“WARNING: too many parse errors”: dbms_rai_owner

We’ve just upgraded the database containing our recovery catalog to 12.2. Although rman operations seemed to be completing OK, we noticed the following slightly worrying error message in the alert log: PDB(3):WARNING: too many parse errors, count=44106 SQL hash=0x2473a808 PDB(3):PARSE ERROR: ospid=398064, error=6550 for statement: 2018-07-22T17:06:22.313262+08:00 PDB(3):BEGIN :owner := dbms_rai_owner; END; PDB(3):Additional information: hd=0x26ee29a560 phd=0x26ee122418 …

“WARNING: too many parse errors”: dbms_rai_owner Read More »

Problems with Kerberos Credentials to 12.2 Databases in Enterprise Manger

Just a quick note in case anyone else hits this issue. We use make extensive use of Kerberos to give us Windows single-sign on. For database connections via Enterprise Manger we use “Database Kerberos Credentials” credential type and have no problems connecting to 11.2 and 12.1 databases (apart from slight pain points that it’s not …

Problems with Kerberos Credentials to 12.2 Databases in Enterprise Manger Read More »

Windows Single Sign-On to an Oracle database using Kerberos

I’ve recently been investigating Kerberos authentication as a means for providing Windows Single Sign On from Windows clients into an Oracle database servers. Maybe you are wondering one of the following questions. What on earth does Kerberos authentication have to do with Microsoft Windows? Don’t you have to pay extra money to Oracle for such …

Windows Single Sign-On to an Oracle database using Kerberos Read More »