AIMSTAR Blog

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 DBA,  Oracle APEX Development, Oracle Rest Data Services (ORDS), Oracle Support, Oracle Database Development

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

Configuring a Managed Server and Node Manager

This article is the third in a three-part series that details how to secure a WebLogic server.   

In general, the WebLogic Admin Server is used for administrative duties and the managed servers are used to deploy applications on WebLogic.  Managed servers can be configured to use keystores and run on a secure port in a manner similar to that used to secure Admin Servers. 

The WebLogic Node Manager can be used to start and stop WebLogic managed servers.  This article details how to configure a WebLogic managed server to run on a secure port and allow WebLogic Node Manager to start and stop the managed server.

Relevant Topics: Oracle DBA,  Oracle WebLogic, Managed Server, Node Manager, Keystores, WebLogic Security,  NIST SP 800-53

Configuring the Admin Server

This article is the second in a three-part series that details how to secure a WebLogic server.  

The Oracle WebLogic Admin Server can be configured through the Admin Console to run on a secure port.  WebLogic provides default keystores that can be used to simulate SSL access in a test environment.  This article details the steps in configuring the WebLogic Admin Server to use keystores with certificates that can be used in a production environment.

Relevant Topics: Oracle DBA,  Oracle WebLogic, Admin Server, Keystores, WebLogic Security,  NIST SP 800-53

Configuring Keystores for WebLogic Servers

This article is the first in a three-part series that details how to secure a WebLogic server.  Keystores can be used to add a certificate to a WebLogic server.  There are two types of keystores – Trust and Identity.  A trust keystore contains certificates from a trusted Certificate Authority (CA) and does not contain sensitive information.  An identity keystore contains the certificate for the WebLogic server and contains sensitive information used to verify the server.

Relevant Topics: Oracle DBA,  Oracle WebLogic, Keystores, WebLogic Security,  NIST SP 800-53

Creating a Managed Server in WebLogic 12c

An Oracle WebLogic domain is a collection of WebLogic Server resources.  Although you can create a domain when WebLogic is installed, there may be instances where you wish to create a new domain after WebLogic installation.  This article details how to create a new WebLogic domain.

Relevant Topics: Oracle DBA, Oracle WebLogic, Node Manager, WebLogic Managed Server

Configuring the Script Node Manager in WebLogic 12c

The Oracle WebLogic Node Manager can be used to start and stop WebLogic managed servers on a host.  In general, the WebLogic Admin Server is used for administrative duties and the managed servers are used to deploy applications on WebLogic.  This article details how to configure WebLogic Node Manager.

Relevant Topics: Oracle DBA,  Oracle WebLogic, Node Manager, WebLogic Managed Server

Creating a Domain in WebLogic 12c

A WebLogic domain is a collection of WebLogic Server resources.  Although you can create a domain when WebLogic is installed, there may be instances where you wish to create a new domain after WebLogic installation.  This article details how to create a new WebLogic domain.

Relevant Topics:  Oracle DBA, WebLogic

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

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