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

Securing WebLogic Servers Part 3 – Configuring a Managed Server and Node Manager

Posted by Theodore Williams on Aug 23, 2017 10:00:00 AM

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

Read More

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

Securing WebLogic Servers Part 2 - Configuring the Admin Server

Posted by Theodore Williams on Aug 22, 2017 5:30:00 PM

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

Read More

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

Securing WebLogic Servers Part 1 - Configuring Keystores

Posted by Theodore Williams on Aug 22, 2017 3:00:00 PM

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

Read More

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

Creating a WebLogic Managed Server

Posted by Theodore Williams on Aug 3, 2017 3:00:00 PM

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

Read More

Topics: Oracle DBA, Oracle APEX, Oracle Database Administration, Oracle WebLogic, Node Manager, WebLogic Managed Server

Configuring Oracle WebLogic Node Manager

Posted by Theodore Williams on Aug 2, 2017 11:50:00 AM

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

Read More

Topics: Oracle DBA, Oracle Database Administration, Oracle WebLogic, WebLogic, Node Manager, WebLogic Managed Server

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