(Oren Nakdimon) One of the first posts I wrote in this blog (almost five years ago) was about the FIRST and LAST aggregate functions.
Tag: Oracle
Upgrading to Oracle Database 12cR2 Using Transient Logical Standby Method
(Arun Gupta) Rolling upgrade with Transient Logical Standby is known as a MAA (Maximum Availability Architecture) technique, to minimize downtime during upgrade of Oracle database.
Emulating touch devices for Oracle APEX
(Scott Wesley) In my Exploring AJAX presentation I had a frame that mentioned the ability for the Chrome browser to emulate the behaviour of a mobile device.
Find In Cache By Key ADF BC API Method Usage
(Andrejus Baranovskis) What if you need to verify – if row with given key exists in fetched rowset? This could be useful while implementing validation logic. ADF BC API method findByKey – will trigger SQL call and fetch row from DB, if row with given key doesn’t exist in fetched rowset.
MONITORING ALERT LOG
(Anuradha Mudgal) Today we are going to have look at the “MONITORING ALERT LOG ORA-ERRORS”. With help of this script DBA can monitor all the ORA-Errors from the alert log and used to send to our mailboxes, he schedules this through a cronjob.
ESRI’s ST_GEOMETRY and SDO_GEOMETRY
(Simon Greener) The following article results from customers downloading the free source code (eg for Oracle SDO_GEOMETRY) on this site without fully understanding that the code is not for ESRI’s ST_GEOMETRY spatial type and then requesting changes to the source code to support that foreign type.
Oracle 18c – ALTER USER RENAME
(Dirk Nachbar) 2 years ago, I have published an article series about the undocumented feature “ALTER USER RENAME”:
ORA-19527: physical standby redo log must be renamed
(Syed Jaffar Hussain) Data Guard was configured a few days back at one of the customers site. An ORA-19527 error is continuously reported in the standby database alert.log (database name is changed)
An Interesting Problem with ODI: Unable to retrieve user GUID
(Gokhan Atil) One of my customers had a problem about logging in to Oracle Data Integrator (ODI) Studio. Their ODI implementation is configured to use external authentication (Microsoft Active Directory).
Changing Security Role Password in Oracle GoldenGate 12.3 Microservices
(Bobby Curtis) One of the nice things about Oracle GoldenGate 12.3 Microserivces, is the flexibility we now have to interact with Oracle GoldenGate. Additionally, what comes with Oracle GoldenGate 12.3 Microservices is a new role based security frame work.
