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;
/

How to check or get the oid version

How to check or get the Oracle Internet Directory server version

To confirm the OID version use the following command:
 > ldapsearch -h <OID host> -p <OID port> -s base -b "" "(objectclass=*)" "orcldirectoryversion"

To confirm the versions of the installed schemas:
  > ldapsearch -h <OID host> -p <OID port> -D "cn=orcladmin" -w <OID superuser password>               -L -s sub -b "cn=OracleSchemaVersion" "(objectclass=*)" "*"

To check the version of the OID binaries:
 > oidldapd -version

How to start and stop Single Sign-On Components in oracle apps server

We can use either the command line or the Oracle Enterprise Manager Application
Server Control console to start and stop single sign-on components. The console offers
the benefit that you can stop or start several components at once. The command line
requires several commands for the same tasks.
Using the Application Server Control Console
Use these steps to stop and start single sign-on components with the console:
1. Go to the standalone console for the infrastructure instance of Oracle Enterprise
Manager that you want to administer. This is effected by entering the host name of
the computer hosting the OracleAS instance and the port number of Oracle
Enterprise Manager. The default port number is 1810, but it may be configured in
increments of one, up to 1816.
2. Log in using the credentials of an OracleAS administrator.
3. From the Standalone Instances section of the Farm page, choose the appropriate
OracleAS instance.
4. From the System Components list of the Application Server page, select the check
boxes for the components that you want to stop, start, or restart; then click the
appropriate button at the top of the list. n-On Middle Tier



Using the Command Line
You can issue separate commands to stop and start just the Oracle HTTP Server or the
entire single sign-on middle tier. Another command stops and starts just the OC4J_
SECURITY instance. Still another command stops and starts all infrastructure
components.
Stopping and Starting the Oracle HTTP Server:

Issue these two commands to stop and then start the Oracle HTTP Server:
ORACLE_HOME/opmn/bin/opmnctl stopproc process-type=HTTP_Server
ORACLE_HOME/opmn/bin/opmnctl startproc process-type=HTTP_Server
You can also stop and start the server by issuing this command:

ORACLE_HOME/opmn/bin/opmnctl restartproc process-type=HTTP_Server
Stopping and Starting the OC4J_SECURITY Instance
Issue these two commands to stop and then start the OC4J_SECURITY instance:
ORACLE_HOME/opmn/bin/opmnctl stopproc process-type=OC4J_SECURITY
ORACLE_HOME/opmn/bin/opmnctl startproc process-type=OC4J_SECURITY

You can also stop and start the OC4J_SECURITY instance by issuing this command:
ORACLE_HOME/opmn/bin/opmnctl restartproc process-type=OC4J_SECURITY

Stopping and Starting the Single Sign-On Middle Tier
To stop and then start the single sign-on middle tier, stop and start both the Oracle
HTTP Server and the OC4J_SECURITY instance:

ORACLE_HOME/opmn/bin/opmnctl stopproc process-type=HTTP_Server
ORACLE_HOME/opmn/bin/opmnctl startproc process-type=HTTP_Server
ORACLE_HOME/opmn/bin/opmnctl stopproc process-type=OC4J_SECURITY
ORACLE_HOME/opmn/bin/opmnctl startproc process-type=OC4J_SECURITY