Aimstar

AIMSTAR Blog

Configuring LDAP Authentication for Oracle APEX Workspaces

Posted by Theodore Williams on Sep 13, 2017 2:20:00 PM

Configuring LDAP Authentication for Oracle APEX Workspaces


Before APEX 5, APEX workspace administrators and developers had to remember local passwords for each APEX workspace.  This could result in several passwords to remember and become a real problem.  APEX 5 made it possible to use LDAP authentication for APEX workspaces thereby reducing the number of passwords needed.  The administrator or developer only needs to remember his or her LDAP password.  This article details configuring APEX for LDAP workspace authentication.


Relevant Topics: Oracle DBAOracle APEX Development, Oracle Rest Data Services (ORDS), Oracle Support, Oracle Database Development

Read More

Topics: Oracle DBA, Oracle APEX, Oracle database development, Oracle Database Administration, Oracle Support

Deploying Oracle Rest Data Services (ORDS) on WebLogic for APEX

Posted by Theodore Williams on Aug 25, 2017 8:00:00 PM

Deploying Oracle Rest Data Services (ORDS) on WebLogic


A web listener is needed in order to run Oracle APEX.  Oracle Rest Data Services (ORDS), formerly called the APEX listener, is a great option for the web listener.  This article details the configuration and deployment of ORDS on Oracle WebLogic Server.

 

This article assumes that WebLogic has been successfully installed.  See our previous posts for steps in configuring WebLogic.


Relevant Topics: Oracle DBA,  Oracle WebLogic, Managed Server, Oracle APEX, Oracle Rest Data Services, ORDS, Oracle Database Development

Read More

Topics: Oracle DBA, Oracle APEX, Oracle database development, Oracle Database Administration, Oracle Rest Data Services, WebLogic, WebLogic Managed Server, ORDS

Installing APEX 5 for use with Oracle REST Data Services (ORDS)

Posted by Theodore Williams on Jun 1, 2017 1:15:00 PM

Installing APEX 5 in Oracle for use with Oracle Rest Data Services (ORDS)

 

 

Oracle databases come with APEX pre-installed.  But the version installed may not be the version that you want.  This article details how to install APEX 5 in an Oracle database.

Relevant Topics:  Oracle DBA, Oracle APEX, Oracle Database Development, Oracle REST Data Services

Read More

Topics: Oracle DBA, Oracle APEX, Oracle database development, Oracle, Oracle Rest Data Services

An Oracle DBA Performance Case Study

Posted by Theodore Williams on Mar 7, 2017 11:20:00 AM

INTRODUCTION:

This article details the Oracle Database Administration  steps taken to solve a performance issue at a previous client.

Overview:  The client had an application in which much of the processing involved a parent and child table.  The parent table had an “on delete cascade” constraint. 

Problem: The pages in the client application were taking a long time to load and the delete function was taking minutes to finish what should have taken seconds to complete.

Relevant Topics:  Dynamic Sampling, Statistics Generation, Locked Tables, Recursive SQL, Unindexed Foreign Keys, Oracle DBA, database systems, database management

Read More

Topics: Oracle DBA, database systems, database management, Oracle database development, Oracle Database Administration