Uncategorized

mysql_clear_password & authentication_ldap_simple password encryption

Preparing for my talk at the HK Open Source Conference I wanted to confirm some of the things I had read about these plugins, mostly from Matthias Crauwels excellent article on the subject. My lab environment consists of Windows 2016 Domain controller and client machines, with MySQL 8 running on Oracle Linux 7. First I …

mysql_clear_password & authentication_ldap_simple password encryption Read More »

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 »