How do I keep track of the SSO (Single Sign On) users' transactions in Oracle Apps

How do I keep track of the SSO (Single Sign On) users' transactions in Oracle Apps?

We can use the WWSSO_AUDIT_LOG_TABLE_T on ssoschema  table to keep track of my SSO transactions in the Oracle Apps like Portal or EBS. We can made some queries and use them most of the time to report any suspicious activities if the login failed to trigger or any other activities on my application server..

How do you establish high availability concepts in the Oracle Application Server

How do you establish high availability concepts in the Oracle Application Server?
High availability is defined by the percentage of time that your server works normally.
You can use hardware cluster for failover to build High availability.
Hardware cluster is a collection of loosely coupled computers where a load balancer
provides a single view of services.
Failover is a process to relocate an application from failed node to a standby node.
You can install as many redundant infrastructures in many servers.
You can install as many J2EE and Web Cache Middle-Tier instance.


How can you create a J2EE and Web Cache Cluster?
Assuming you have two J2EE and web caches installed.
$ORACLE_HOME/webcache1
$ORACLE_HOME/webcache2
Their port assignments are in the
$ORACLE_HOME/webcache(1 or 2)/install/portlist.ini files.
Go to webcache1 to create cluster:
<http://hostname1:4000/> -- log on as the “administrator” userid.
Click Clustering under Properties. In the new page, select the cluster member and
click Edit Selected, enter a new name, submit and restart web cache.
Go to webcache2 to add the web cache to cluster.
Click Clustering under Properties and then click “Add.” Enter information and submit.
In Cache operations, select the new cache cluster and then click Propagate. Then
select all cache and click Restart.

How to use IP-Based or Name-Based Virtual Hosts

What is directive?
Directives are files to use for configuring the server. For example, the web master of an Oracle HTTP Server contains more than 120 directives at his or her disposal for configuring the server. It contains container directives. The containers have opening and closing tag. Any directive that doesn’t appear within a container applies to the entire serve.

What is the <Directory> directive and how do you maintain it?
It is a group of directives that apply to the named directory and subdirectories.
Examples of how to maintain the <Directory> directive:
<Directory /> -- refers to the whole file system.
Options none
AllowOverride none
</Directory>
<Directory /home/myfiles/*> --refers to the myfiles subdirectory under home.
AllowOverride none
</Directory>
<DirectoryMatch “/u0[1-6]/”> --refers to directories that start with u0 and end with a number from 1 to 6
AllowOverride none
</Directory>

How to use IP-Based or Name-Based Virtual Hosts?
<VirtualHost 200.200.200.2 200.200.200.3>
DocumentRoot /usr/virtual/htdocs/home
ServerName www.ivan.com <http://www.ivan.com/>
ErrorLog /usr/virtual/logs/error_log
</VirtualHost>
<VirtualHost www.ivan.com>
DocumentRoot /usr/virtual/htdocs/home
ServerName www.ivan.com 
<http://www.ivan.com/>
ErrorLog /usr/virtual/logs/error_log
</VirtualHost>

How do you allow access from specific IP addresses or machine name

How do you allow access from specific IP addresses or machine name?
Change your httpd.conf file to add the following lines:
<Location /server-status>
SetHandler server-status
Order deny,allow
Deny from all
Allow from xxx.xxx.xxx.xxx
</Location>
Configuring Directives and Virtual Hosts

How to Start and Stop the Oracle Internet directory server

How to Start the Oracle Internet directory server
 
INFRA_HOME/opmn/bin/opmnctl startproc ias-component=OID




How to stop the Oracle Internet Directory processes:
INFRA_HOME/opmn/bin/opmnctl stopproc ias-component=OID

How to create a portal public schema

How to create a portal public schema:

Create the PORTAL_PUBLIC schema.
Change to the PRODUCTION_MIDTIER_HOME/portal/admin/plsql/wws directory and run the following script from SQL*Plus as the SYS user:
SQL> CONNECT SYS/password AS SYSDBA@tnservice_name
@cruser.sql PORTAL PORTAL portal_default_tablespace portal_temporary_tablespace

The response looks similar to the following output:
SQL> @cruser.sql PORTAL PORTAL PORTAL PORTAL_TMP
old   1: select ('&&1'||'_public') t1 from dual
new   1: select ('PORTAL'||'_public') t1 from dual
...
User altered.

How to resolve IMP-00003: ORACLE error 30510 encountered while importing portal or any other oracle application schema:

How to resolve IMP-00003: ORACLE error 30510 encountered while importing portal or any other oracle application schema:

As the PORTAL or application user, manually re-create the logoff trigger:
SQL> CREATE TRIGGER logoff_trigger
before logoff on schema
begin    -- Call wwsec_oid.unbind to close open OID connections if any.
wwsec_oid.unbind;
exception
when others then
-- Ignore all the errors encountered while unbinding.
null;
end logoff_trigger;
/