Tuesday, May 22, 2018

Oracle APEX, ORDS Deployment on Apache Tomcat

Steps of Oracle APEX, ORDS Deployment on Apache Tomcat

1. Install Oracle Database

2. Create a tablespace.

CREATE TABLESPACE APEX_DATA DATAFILE '/u01/APEX/db/data/apex_001.dbf' SIZE 500M AUTOEXTEND ON NEXT 1M;

3. Download Oracle appex and unzip ( Also ORACLE_HOME/apex directory can be used )

sqlplus / as sysda

SQL> -- @apexins.sql tablespace_apex tablespace_files tablespace_temp images
SQL>
SQL> @apexins.sql APEX_DATA APEX_DATA TEMP /i/

SQL> @apxchpwd.sql

SQL> @apex_rest_config.sql

SQL> @apex_epg_config.sql /u01/APEX/db/11.2.0

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

Check the port setting for XML DB Protocol Server.

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT
-----------
          0

1 row selected.

SQL>

If it is set to "0", you will need to set it to a non-zero value to enable it.

SQL> EXEC DBMS_XDB.sethttpport(8080);

PL/SQL procedure successfully completed.

4. Check the APEX URL is working fine. http://<server-name>:<port>/apex

5. Download and unzip Apache Tomcat

# su - tomcat

export JAVA_HOME=/home/tomcat/jdk1.8.0_77
export CATALINA_HOME=/home/tomcat/apache-tomcat-7.0.68
export CATALINA_BASE=$CATALINA_HOME

Start and stop Tomcat using the following scripts.

$ $CATALINA_HOME/bin/startup.sh
$ $CATALINA_HOME/bin/shutdown.sh


6. Configure ORDS using following steps.

ALTER USER APEX_LISTENER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;

-- The next one will fail if you've never installed ORDS before. Ignore errors.
ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY manager#123 ACCOUNT UNLOCK;

# su - tomcat
$ mkdir /home/tomcat/ords
$ cd /home/tomcat/ords
$ unzip /tmp/ords.3.0.11.180.12.34.zip /home/tomcat/ords

mkdir -p /home/tomcat/ords/conf

Edit the "/u01/ords/params/ords_params.properties

-------------------------------------------------------------------------------
db.hostname=oracle.test.com
db.port=1521
db.servicename=ords
#db.sid=
db.username=APEX_PUBLIC_USER
db.password=manager#123
migrate.apex.rest=false
rest.services.apex.add=true
rest.services.ords.add=true
schema.tablespace.default=APEX_DATA
schema.tablespace.temp=TEMP
standalone.mode=false
#standalone.use.https=true
#standalone.http.port=8080
#standalone.static.images=/home/oracle/apex/images
user.apex.listener.password=manager#123
user.apex.restpublic.password=manager#123
user.public.password=manager#123
user.tablespace.default=APEX_DATA
user.tablespace.temp=TEMP
sys.user=SYS
sys.password=manager#123
-------------------------------------------------------------------------------

$ $JAVA_HOME/bin/java -jar ords.war configdir /home/tomcat/ords/conf

$JAVA_HOME/bin/java -jar ords.war configdir /u01/ords/                                                                                        conf
Jun 15, 2018 5:21:32 PM
INFO: Set config.dir to /u01/ords/conf in: /u01/ords/ords.war

$ $JAVA_HOME/bin/java -jar ords.war

$ $JAVA_HOME/bin/java -jar ords.war
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must en                          ter 1 [1]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Jun 15, 2018 5:23:24 PM
INFO: Updated configurations: defaults, apex, apex_pu, apex_al, apex_rt
Installing Oracle REST Data Services version 3.0.12.263.15.32
... Log file written to /u01/ords/logs/ords_install_core_2018-06-15_172324_00763.log
... Verified database prerequisites
... Created Oracle REST Data Services schema
... Created Oracle REST Data Services proxy user
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /u01/ords/logs/ords_install_datamodel_2018-06-15_172341_00566.log
Completed installation for Oracle REST Data Services version 3.0.12.263.15.32. Elapsed time: 00:00:18.614


7. Deploy on Tomcat using following steps.

Copy the APEX images to the Tomcat "webapps" directory.

$ mkdir $CATALINA_HOME/webapps/i/
$ cp -R /home/oraapex/apex/images/* $CATALINA_HOME/webapps/i/
Copy the "ords.war" file to the Tomcat "webapps" directory.

$ cd /u01/ords
$ cp ords.war $CATALINA_HOME/webapps/

8. ORDS should now be accessible using the following type of URL.

http://<server-name>:<port>/ords/

Thursday, April 19, 2018

ERP Cloud On-Site Printing Documents

How To Configure Printers In Fusion Applications (Doc ID 1447191.1)
Setup Instructions for Printing from Oracle Cloud (Doc ID 1964157.1)
How to Set Up Printer Configuration For Cloud/SaaS and Customer On-Site For Fusion Applications (Doc ID 1554333.1)
Oracle Fusion BI: How to Add the BI Administrator Role to a user in Release 12. (Doc ID 2238277.1)
Troubleshooting Guide For Cloud Printer (Doc ID 2140116.1)
How To Install End Point URL SSL Certificates In Default Fusion Truststore (Doc ID 2120300.1)

Saturday, April 7, 2018

Configure Oracle Database Backup Cloud Service

Download opc_installer.zip from OTN and unzip.

[oracle@db-cld-inst-001 opc]$ unzip opc_installer.zip
[oracle@db-cld-inst-001 opc]$ ls
opc_installer.zip  opc_install.jar  opc_readme.txt
[oracle@db-cld-inst-001 opc]$ mkdir lib
[oracle@db-cld-inst-001 opc]$ mkdir wallet
[oracle@db-cld-inst-001 opc]$ ls
lib  opc_installer.zip  opc_install.jar  opc_readme.txt  wallet

[oracle@db-cld-inst-001 opc]$ java -jar opc_install.jar -serviceName Storage -identityDomain gse00112591 -opcId 'your account id' -opcPass 'unFair@5FOrd' -walletDir /u01/app/oracle/opc/wallet -libDir /u01/app/oracle/opc/lib
Oracle Database Cloud Backup Module Install Tool, build 12.2.0.1.0DBBKPCSBP_2017-11-28
Oracle Database Cloud Backup Module credentials are valid.
Oracle Database Cloud Backup Module wallet created in directory /u01/app/oracle/opc/wallet.
Oracle Database Cloud Backup Module initialization file /u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora created.
Downloading Oracle Database Cloud Backup Module Software Library from file opc_linux64.zip.
Download complete.

[oracle@db-cld-inst-001 lib]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Apr 6 17:31:44 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: KTSDB02 (DBID=2214310033)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name KTSDB02 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2 G PARMS  'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE ON;
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/snapcf_KTSDB02.f'; # default

RMAN> configure default device type to sbt;

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters are successfully stored


RMAN>  configure device type sbt parallelism 4;

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 5 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored


RMAN> configure channel device type sbt parms='SBT_LIBRARY=/u01/app/oracle/opc/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 2 G PARMS  'SBT_LIBRARY=libopc.so, ENV=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=/u01/app/oracle/opc/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
new RMAN configuration parameters are successfully stored


RMAN> configure compression algorithm 'MEDIUM';

new RMAN configuration parameters:
CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
new RMAN configuration parameters are successfully stored

RMAN> set encryption on identified by "Manager#123" only;

executing command: SET encryption

RMAN> show all;

RMAN configuration parameters for database with db_unique_name KTSDB02 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'SBT_LIBRARY=/u01/app/oracle/opc/lib/libopc.so,SBT_PARMS=(OPC_PFILE=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/opcKTSDB02.ora)';
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE ON;
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/snapcf_KTSDB02.f'; # default

RMAN> backup database plus archivelog;

Starting backup at 07-APR-18
current log archived
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=40 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=12.2.0.1
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=252 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Database Backup Service Library VER=12.2.0.1
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=31 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Database Backup Service Library VER=12.2.0.1
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=49 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Database Backup Service Library VER=12.2.0.1
skipping archived logs of thread 1 from sequence 1 to 50; already backed up
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=51 RECID=51 STAMP=972812031
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4hsvnrp0_1_1 tag=TAG20180407T093424 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
Finished backup at 07-APR-18

Starting backup at 07-APR-18
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
skipping datafile 5; already backed up 1 time(s)
skipping datafile 6; already backed up 1 time(s)
skipping datafile 8; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u02/app/oracle/oradata/KTSDB02/system01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_2: starting full datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00013 name=/u02/app/oracle/oradata/KTSDB02/PDB1/sysaux01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_3: starting full datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=/u02/app/oracle/oradata/KTSDB02/sysaux01.dbf
channel ORA_SBT_TAPE_3: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_4: starting full datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00012 name=/u02/app/oracle/oradata/KTSDB02/PDB1/system01.dbf
input datafile file number=00015 name=/u02/app/oracle/oradata/KTSDB02/PDB1/PDB1_users01.dbf
input datafile file number=00019 name=/u02/app/oracle/oradata/SP390751824_svctbl.dbf
channel ORA_SBT_TAPE_4: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_4: finished piece 1 at 07-APR-18
piece handle=4lsvnrq5_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:55
channel ORA_SBT_TAPE_4: starting full datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00014 name=/u02/app/oracle/oradata/KTSDB02/PDB1/undotbs01.dbf
input datafile file number=00018 name=/u02/app/oracle/oradata/SP390751824_wlsservices.dbf
input datafile file number=00020 name=/u02/app/oracle/oradata/SP390751824_ias_opss.dbf
channel ORA_SBT_TAPE_4: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_2: finished piece 1 at 07-APR-18
piece handle=4jsvnrq4_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:12
channel ORA_SBT_TAPE_2: starting full datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00004 name=/u02/app/oracle/oradata/KTSDB02/undotbs01.dbf
channel ORA_SBT_TAPE_2: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_3: finished piece 1 at 07-APR-18
piece handle=4ksvnrq4_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:11
channel ORA_SBT_TAPE_3: starting full datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00016 name=/u02/app/oracle/oradata/SP390751824_mds.dbf
input datafile file number=00021 name=/u02/app/oracle/oradata/SP390751824_UMS.dbf
input datafile file number=00017 name=/u02/app/oracle/oradata/SP390751824_iau.dbf
channel ORA_SBT_TAPE_3: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4isvnrq4_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:15
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u02/app/oracle/oradata/KTSDB02/users01.dbf
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_4: finished piece 1 at 07-APR-18
piece handle=4msvnrrt_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4psvnrsf_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_2: finished piece 1 at 07-APR-18
piece handle=4nsvnrsc_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:28
channel ORA_SBT_TAPE_3: finished piece 1 at 07-APR-18
piece handle=4osvnrsc_1_1 tag=TAG20180407T093459 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:28
Finished backup at 07-APR-18

Starting backup at 07-APR-18
current log archived
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=52 RECID=52 STAMP=972812201
channel ORA_SBT_TAPE_1: starting piece 1 at 07-APR-18
channel ORA_SBT_TAPE_1: finished piece 1 at 07-APR-18
piece handle=4qsvnrt9_1_1 tag=TAG20180407T093641 comment=API Version 2.0,MMS Version 12.2.0.1
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
Finished backup at 07-APR-18

Starting Control File and SPFILE Autobackup at 07-APR-18
piece handle=c-2214310033-20180407-18 comment=API Version 2.0,MMS Version 12.2.0.1
Finished Control File and SPFILE Autobackup at 07-APR-18

Thursday, March 22, 2018

Can't Connect to PDB User in Oracle Database 12c RAC Instance

Error :

SQL> alter session set container=DEV1;

Session altered.

SQL> conn DEV1_ADMIN@DEV1
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Warning: You are no longer connected to ORACLE.


Analysis

Database Node 1

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TEST                            READ WRITE NO
         4 DEV1                           READ WRITE NO

Database Node 2

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TEST                            READ WRITE NO
         4 DEV1                           MOUNTED NO


Resolution

Restart the DEV1 PDB on both database nodes.

Database Node 1

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TEST                            READ WRITE NO
         4 DEV1                           READ WRITE NO

Database Node 2

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TEST                            READ WRITE NO
         4 DEV1                           READ WRITE  NO

Then DEV1_ADMIN user could be connected and issue resolved.

Monday, February 26, 2018

Error in Oracle EBS 12.2.5 Application Tier Cloning in Oracle Compute Cloud Server

Application Tier Cloning Errors

Configuring: Run file system....
LogFile located at /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone/run/RCloneApplyAppstier_02250759.log

ERROR: Failed to configure the target system,
please check the logfile in : /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone

-------------------------------------------------------------------------------

START: Creating new WLS domain.
Running /u01/TEST/fs2/FMW_Home/oracle_common/bin/pasteConfig.sh -javaHome /u01/TEST/fs2/EBSapps/comn/util/jdk64 -al /u01/TEST/fs2/EBSapps/comn/clone/FMW/WLS/EBSdomain.jar -tdl /u01/TEST/fs2/FMW_Home/user_projects/domains/EBS_domain_TEST -tmw /u01/TEST/fs2/FMW_Home -mpl /u01/TEST/fs2/EBSapps/comn/clone/FMW/WLS/plan/moveplan.xml -ldl /u01/TEST/fs2/inst/apps/TEST_oftest/admin/log/clone/run/wlsT2PApply -silent true -debug true -domainAdminPassword /u01/TEST/fs2/EBSapps/comn/clone/FMW/tempinfo.txt
Script Executed in 2102 milliseconds, returning status 255
ERROR: Script failed, exit code 255

--------------------------------------------------------------------------------

SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20372 Server port validation failed.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20372 Possible causes were :Ports of following servers - AdminServer(7021),oacore_server1(7221),forms_server1(7421),oafm_server1(7621),forms-c4ws_server1(7821) - were not available.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20372 Provide valid free ports or if those servers are targeted to non admin host, then use temporary port range mechanism.
java.lang.Exception: Error in validating "SERVER_CONFIG" parameters in "moveplan".
at oracle.as.clone.cloner.component.j2ee.util.J2EEGenericValidationUtil.validateServerConfig(J2EEGenericValidationUtil.java:218)
at oracle.as.clone.cloner.component.j2ee.config.GenericPasteConfigSteps.getServerConfig(GenericPasteConfigSteps.java:922)
at oracle.as.clone.cloner.component.j2ee.config.GenericPasteConfigSteps.executeGenericPasteConfig(GenericPasteConfigSteps.java:385)
at oracle.as.clone.cloner.component.J2EEComponentApplyCloner.doClone(J2EEComponentApplyCloner.java:259)
at oracle.as.clone.cloner.Cloner.doFinalClone(Cloner.java:63)
at oracle.as.clone.request.ApplyCloneRequest.applyArchive(ApplyCloneRequest.java:198)
at oracle.as.clone.request.ApplyCloneRequest._clone(ApplyCloneRequest.java:77)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:131)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:114)
at oracle.as.clone.client.CloningClient.executeT2PCommand(CloningClient.java:236)
at oracle.as.clone.client.CloningClient.main(CloningClient.java:124)
oracle.as.t2p.exceptions.FMWT2PPasteConfigException: PasteConfig failed. Make sure that the move plan and the values specified in moveplan are correct.
at oracle.as.clone.cloner.component.J2EEComponentApplyCloner.doClone(J2EEComponentApplyCloner.java:314)
at oracle.as.clone.cloner.Cloner.doFinalClone(Cloner.java:63)
at oracle.as.clone.request.ApplyCloneRequest.applyArchive(ApplyCloneRequest.java:198)
at oracle.as.clone.request.ApplyCloneRequest._clone(ApplyCloneRequest.java:77)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:131)
at oracle.as.clone.process.CloningExecutionProcess.execute(CloningExecutionProcess.java:114)
at oracle.as.clone.client.CloningClient.executeT2PCommand(CloningClient.java:236)
at oracle.as.clone.client.CloningClient.main(CloningClient.java:124)
SEVERE : Feb 23, 2018 11:32:19 - SEVERE - CLONE-20937 "pasteConfig" operation of J2EE domain failed. Check clone log and error files for more details.
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20237 Restoring the sourceid "J2EECOMPONENT@EBS_domain_PROD" has failed.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20237 An internal operation failed.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20237 Check the clone log for more details.
SEVERE : Feb 23, 2018 11:32:19 - ERROR - CLONE-20218 Cloning is not successful.
SEVERE : Feb 23, 2018 11:32:19 - CAUSE - CLONE-20218 An internal operation failed.
SEVERE : Feb 23, 2018 11:32:19 - ACTION - CLONE-20218 Provide the clone log and error file for investigation.

Relevance to the Issue 

Script failed because the following ports weren't available:

AdminServer(7021),oacore_server1(7221),forms_server1(7421),oafm_server1(7621),forms-c4ws_server1(7821)

Cause 

Clone was configured with a public ip address in /etc/hosts.

Solution 

Generally, a public ip address is not bindable in cloud setup.
Only private ip addresses are bindable.

1. Ensure a valid backup exists of the /etc/hosts file.
2. Configure /etc/hosts with PRIVATE ip addresse and redo the application tier cloning.

Reference

12.2 E-Business Suite Cloud Administration Task Running 'perl adcfgclone.pl appsTier dualfs' on Oracle Cloud Reports Ports were not Available (Doc ID 2278401.1)

Saturday, February 24, 2018

Important Docs of Oracle Compute Cloud Service

Creating an Oracle E-Business Suite Development Environment in Oracle Cloud Infrastructure Compute Classic

http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/creating_ebs_dev/03devinstall.html

Creating an SSH-Enabled User on an Oracle Compute Cloud Service Instance

http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute/creating_an_ssh_enabled_user/creating_an_ssh_enabled_user.html#section1

Managing Oracle E-Business Suite on Oracle Cloud Infrastructure Classic Using the EBS Cloud Admin Tool

http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/managing_ebs_on_cloud_using_cloud_admin_tool/14manage_env/14manage_env.html

Cloning Oracle E-Business Suite From On-Premises to Oracle Cloud Infrastructure Classic Using EBS Cloud Tools

http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/compute-iaas/cloning_ebs_from_on-prem_to_oracle_cloud/10cloning/10cloning.html#section1

Friday, February 23, 2018

Wednesday, February 21, 2018

Oracle Database 18c

Release Schedule of Current Database Releases (Doc ID 742060.1)
Release Update Introduction and FAQ (Doc ID 2285040.1)





Oracle 18c New Feature: “Read Only Oracle Home”.. !!

Thursday, January 25, 2018

Oracle Standby Database Issue - ORA-16191: Primary log shipping client not logged on standby

Error : ORA-16191: Primary log shipping client not logged on standby

Resolution:

Issue can be resolved after creating password files in both primary and standby databases.

orapwd file=orapwPROD password=oracle entries=10 ignorecase=Y

Then start the synchronization again with below.
SQL> alter database recover managed standby database disconnect from session;  

Wednesday, November 15, 2017

Oracle EBS 12.2.7 Docs

Installation
=========
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 ( Doc ID 1330701.1 )
Troubleshooting Rapid Install for E-Business Suite Release 12.2 ( Doc ID 1378579.1 )

ETCC Patches
===============
1) How To Run The 12.2 EBS Technology Code Level Checker (ETCC) ? ( Doc ID 2008451.1 )
2) Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes ( Doc ID 1594274.1 )
3) Oracle E-Business Suite 12.2 Patching Technology Components Guide ( Doc ID 1355068.1 )
4) For post-install steps for RDBMS Patches, run "datapatch"

Upgrading AD/TXK
================
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 ( Doc ID 1617461.1 )

12.2.7
=====
Oracle E-Business Suite Release 12.2.7 Readme ( Doc ID 2230783.1 )

Additional Resources
=================
Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Useful E-Business Suite 12.2 Documents ( Doc ID 1585889.1 )
Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)


Friday, August 4, 2017

Kill Oracle EBS Database Sessions

Issue : Oracle EBS Database does not shutdown properly during the scheduled backup script.

Solution : Schedule below command to kill the Oracle database sessions few minutes after database shutdown initiation.

ps -ef|grep 'oraclePROD (LOCAL=NO)'|grep -v grep|awk '{print$2}'|xargs kill -9

Monday, May 8, 2017

EBS 12.2 Apps Cloning Error in OEL 6.7

Error 

 txkWfClone.sh exited with status 127 ERROR: txkWfClone.sh execution failed, exit code 127

Solution

 yum install glibc-devel.i686

Friday, May 5, 2017

After 12.2.5 upgrade adop phase=fs_clone fails ( adop exiting with status = 1 (Fail) )

Error

Use of uninitialized value $result in split at /u01/UAT/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1291.
No such file or directory at /u01/UAT/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.

Solution 

Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)

Thursday, March 23, 2017

SLA Hot Patch for After Upgrade Data Migration

a. Run this SQL script:
select * from gl_period_statuses where migration_status_code='P'
-- this script should return zero rows, only then should you consider running the SLA Hot Patch.

b. Take a backup of the xla_upgrade_dates table before running the SLA Hot Patch

c. Set a realistic date for the SLA: Initial Date for Historical Upgrade profile.

    (i)  Change the SLA: Initial Date for Historical Upgrade profile to 01-OCT-2015
    (ii) Then run the Hot Patch

adop phase=apply options=nocopyportion patchtop=$XLA_TOP/patch/115          patches=driver:xla5584908.drv hotpatch=yes options=forceapply

    (iii) Repeat the above steps for 6-month increments until all the data from start has been upgraded. 

    The 6-month increment is not a rule because it depends of the amount of history to be upgraded.


Friday, March 17, 2017

Important Queries to check Oracle EBS users logged

select count(distinct d.user_name) from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1);

select * from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1)

select last_connect, usr.user_name, resp.responsibility_key, function_type, icx.*
  from apps.icx_sessions icx
  join apps.fnd_user usr on usr.user_id=icx.user_id
  left join apps.fnd_responsibility resp on resp.responsibility_id=icx.responsibility_id
  where last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24
and disabled_flag != 'Y' and pseudo_flag = 'N'
AND USER_NAME <>'GUEST'

select count(distinct user_id) "users" from icx_sessions where  last_connect > sysdate - 1/24 and user_id != '-1';

select * from v$license;

Monday, December 12, 2016

After Upgrading Oracle FMW WebTier of Oracle EBS 12.2 to 11gR1 PatchSet 6 (11.1.1.7) adop phase=fs_clone fails

Error in adop phase=fs_clone after following below document

Upgrading the Oracle Fusion Middleware WebTier of Oracle E-Business Suite Release 12.2 to 11gR1 PatchSet 6 (11.1.1.7) (Doc ID 2002603.1)


Beginning application tier FSCloneStage - Mon Dec 12 03:50:20 2016

/u01/PROD/fs1/EBSapps/comn/util/jdk32/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/PROD/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/PROD/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/PROD/fs1/EBSapps/comn/java/classes:/u01/PROD/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/PROD/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/PROD/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/PROD/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/PROD/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/PROD/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/PROD/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.FSCloneStageAppsTier -e /u01/PROD/fs1/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -targ /u01/PROD/fs2/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -stage /u01/PROD/fs1/EBSapps/comn/adopclone_ebis -tmp /tmp -component appsTier -nopromptmsg
Log file located at /u01/PROD/fs1/inst/apps/PROD_ebis/admin/log/clone/FSCloneStageAppsTier_12120350.log
Exception in thread "main" java.lang.NoSuchMethodError: oracle.jdbc.driver.PhysicalConnection.getDefaultAutoRefetch()Z
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:762)
at oracle.jdbc.driver.T4CStatement.<init>(T4CStatement.java:1255)
at oracle.jdbc.driver.T4CDriverExtension.allocateStatement(T4CDriverExtension.java:48)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:3460)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:3425)
at oracle.apps.ad.clone.util.CloneUtil.getServerNamesFromDB(CloneUtil.java:950)
at oracle.apps.ad.clone.util.CloneUtil.getAllServerNamesFromDB(CloneUtil.java:903)
at oracle.apps.ad.clone.FSCloneStageAppsTier.doStage(FSCloneStageAppsTier.java:362)
at oracle.apps.ad.clone.FSCloneStageAppsTier.<init>(FSCloneStageAppsTier.java:149)
at oracle.apps.ad.clone.FSCloneStageAppsTier.main(FSCloneStageAppsTier.java:667)

ERROR while running FSCloneStage...
Mon Dec 12 03:50:23 2016
*******FATAL ERROR*******
PROGRAM : (/u01/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)
TIME : Mon Dec 12 03:50:24 2016
FUNCTION: main::runFSCloneStage [ Level 1 ]
ERRORMSG: /u01/PROD/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl did not go through successfully.

[UNEXPECTED]Error occurred while executing "perl /u01/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/PROD/fs1/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -patchcontextfile=/u01/PROD/fs2/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -promptmsg=hide -console=off -mode=create -sessionid=31 -timestamp=20161212_034649 -outdir=/u01/PROD/fs_ne/EBSapps/log/adop/31/fs_clone_20161212_034649/PROD_ebis"
[UNEXPECTED]Error occurred while CLONE Patch File System from Run File System using command: "perl /u01/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/PROD/fs1/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -patchcontextfile=/u01/PROD/fs2/inst/apps/PROD_ebis/appl/admin/PROD_ebis.xml -promptmsg=hide -console=off -mode=create -sessionid=31 -timestamp=20161212_034649 -outdir=/u01/PROD/fs_ne/EBSapps/log/adop/31/fs_clone_20161212_034649/PROD_ebis".
Releasing the managed servers ports...
Log: /u01/PROD/fs_ne/EBSapps/log/adop/31/fs_clone_20161212_034649/PROD_ebis/txkCloneAcquirePort.log
Stopping services on patch file system...
Stopping admin server...

Solution

1.  Download JDBC driver (ojbdc6.jar) from below URL,  relevant to the database version.

Getting Version of JDBC jar File Reports Invalid Or Corrupt Jarfile Ojdbc6.jar Error Message ( Doc ID 1665927.1 )

2.  Copy  ojbdc6.jar to following directories.

/u01/PROD/fs1/FMW_Home/webtier/jdbc/lib
/u01/PROD/fs2/FMW_Home/webtier/jdbc/lib

3. Then execute adop phase=fs_clone again.

adop exiting with status = 0 (Success)

Monday, November 14, 2016

Upgraded 12.2.5 Instance Database Tier Cloning Issue Resolution - fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.

Database Tier Cloning Issue

ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.
at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:281)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:332)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:757)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:228)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1721)
at oracle.apps.ad.clone.ApplyDatabase.runCVM(ApplyDatabase.java:3108)
at oracle.apps.ad.clone.ApplyDatabase.runCVMAndAutoConfig(ApplyDatabase.java:3050)
at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:678)
at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:493)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:384)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
 
Solution

drop synonym apps.fnd_nodes;
create synonym apps.fnd_nodes for applsys.fnd_nodes;
drop synonym apps.fnd_oam_context_files;
create synonym apps.fnd_oam_context_files for applsys.fnd_oam_context_files;

[oraprdcl@r1225td PRDCL_r1225td]$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/PRDCL/db/tech_st/11.2.0/appsutil/log/PRDCL_r1225td/11140209/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/PRDCL/db/tech_st/11.2.0
Classpath : :/u01/PRDCL/db/tech_st/11.2.0/jdbc/lib/ojdbc6.jar:/u01/PRDCL/db/tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/u01/PRDCL/db/tech_st/11.2.0/appsutil/java:/u01/PRDCL/db/tech_st/11.2.0/jlib/netcfg.jar:/u01/PRDCL/db/tech_st/11.2.0/jlib/ldapjclnt11.jar

Using Context file : /u01/PRDCL/db/tech_st/11.2.0/appsutil/PRDCL_r1225td.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

Tuesday, August 9, 2016

New Feature on AD/TXK 7 - Oracle EBS 12.2.5 Application Tier Cloning With Dualfs Option

In Oracle EBS 12.2.2, 12.2.3 & 12.2.4, application tier cloning has to be done for each RUN & PATCH file systems separately.

But now in Oracle EBS 12.2.5, with AD/TXK 7 application tier cloning for both RUN & PATCH file systems can be done at once by using the new feature option dualfs as follows. This is very useful in reducing the time required for cloning.

Let's assume source instance RUN file system is fs2.
Then copy the source instance fs2 RUN file system EBSapps directory to target instance fs2 directory. After the cloning, fs2 will become the RUN file system of the instance and fs1 will become PATCH file system  automatically.

$ perl adcfgclone.pl appsTier dualfs

Saturday, July 16, 2016

Patch Timeout in Jsp Compilation During the TXK delta 7 Upgrade

Error

During the TXK delta 7 upgrade while applying following patches below error occurs in jsp compilation.
adop phase=apply patches=20784380,22363475,22495069 merge=yes
   
[root@test Desktop]# tail -f /u01/TEST/fs2/inst/apps/TEST_ebis/logs/appl/rgf/ojsp/ojspc_error.log
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 7s elapsed, 50 successful 0 failed
[14052] compiling: 6s elapsed, 50 successful 0 failed
[14052] !!SEVERE WARNING!! TIMEOUT[600 seconds] EXPIRED DURING COMPILATION

Solution
Set ojspCompile.conf files in fs1 and fs2 java_home to respective values as below.

/u01/TEST/fs1/inst/apps/TEST_ebis/appl/admin/ojspCompile.conf
/u01/TEST/fs2/inst/apps/TEST_ebis/appl/admin/ojspCompile.conf

java_home = /u01/TEST/fs1/EBSapps/comn/util/jdk64
java_home = /u01/TEST/fs2/EBSapps/comn/util/jdk64

Then execute below to proceed with jsp compilation;

[oratest@test TEST]$ strace -t -o jspcompile.txt perl -x $FND_TOP/patch/115/bin/ojspCompile.pl --compile -p 6 -log /tmp/ojspCompile.log
logfile set: /tmp/ojspCompile.log
starting...(compiling delta)
using 10i internal ojsp ver: 10.3.6.0
synchronizing dependency file:
  loading deplist...7829
  enumerating jsps...7829
  updating dependency...0
initializing compilation:
  eliminating children...5954 (-1875)
  searching uncompiled...4529
translating and compiling:
  searching untranslated...0  
  compiling jsps...4529/4529 in 11m55s                
Finished!

Then execute the adop phase=apply patches=20784380,22363475,22495069 merge=yes restart=yes

Sunday, July 10, 2016

Upgrade Oracle FMW WebTier of Oracle EBS 12.2 to 11gR1 PatchSet 6 (11.1.1.7)

Upgrading the Oracle Fusion Middleware WebTier of Oracle E-Business Suite Release 12.2 to 11gR1 PatchSet 6 (11.1.1.7) (Doc ID 2002603.1)

Friday, July 8, 2016

Exception in thread "main" java.lang.OutOfMemoryError: Java heap space in Weblogic Patch application


$ sh bsu.sh -prod_dir=/u01/TEST/fs2/FMW_Home/wlserver_10.3 -patchlist=EJUW -verbose -install
Checking for conflicts....
Conflict(s) detected - resolve conflict condition and execute patch installation again
Conflict condition details follow:
Patch EJUW is mutually exclusive and cannot coexist with patch(es): Y5AP,BLTG,FCX7,1LRI,VKXF,2GYW,CW9T
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
    at java.util.AbstractCollection.toArray(AbstractCollection.java:136)
    at java.util.ArrayList.addAll(ArrayList.java:530)
    at org.apache.xmlbeans.impl.schema.SchemaTypeImpl.getProperties(SchemaTypeImpl.java:705)
    at com.bea.cie.common.dao.xbean.XBeanDataHandler.loadPropertyMap(XBeanDataHandler.java:775)
    at com.bea.cie.common.dao.xbean.XBeanDataHandler.<init>(XBeanDataHandler.java:99)
    at com.bea.cie.common.dao.xbean.XBeanDataHandler.createDataHandler(XBeanDataHandler.java:559)
    at com.bea.cie.common.dao.xbean.XBeanDataHandler.getComplexValue(XBeanDataHandler.java:455)
    at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:442)
    at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getPatchDependencies(PatchCatalogHelper.java:464)
    at com.bea.plateng.patch.dao.cat.PatchCatalog.getPatchDependencies(PatchCatalog.java:56)
    at com.bea.plateng.patch.dao.cat.PatchCatalogHelper.getInvalidatedPatchMap(PatchCatalogHelper.java:1621)
    at com.bea.plateng.patch.PatchSystem.updatePatchCatalog(PatchSystem.java:436)
    at com.bea.plateng.patch.PatchSystem.refresh(PatchSystem.java:130)
    at com.bea.plateng.patch.PatchSystem.setCacheDir(PatchSystem.java:201)
    at com.bea.plateng.patch.Patch.main(Patch.java:306)

Solution:
1.  Go to /%FMW_Home%/utils/bsu/
2.  Edit the bsu.sh
3.  Here you will find the following: MEM_ARGS="-Xms256m -Xmx512m"
4.  Increase these values to "-Xms1024m -Xmx1024m"

Reference:
Java.lang.OutOfMemoryError" Error When Applying Oracle Weblogic Server Patch (Doc ID 2007492.1)

Wednesday, May 11, 2016

Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit - Docs

Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit (Doc ID 471566.1)
Cloning Oracle Applications Release 12 with Rapid Clone (Doc ID 406982.1)
Using Oracle EBS R12 with a Database Tier Only Platform on Oracle 11gR1 (Doc ID 762669.1)
Migrating OLAP From 32 Bits to 64 Bits or Across Platforms (Doc ID 352306.1)

Wednesday, May 4, 2016

Oracle EBS 12.2.5 Reference Docs

Oracle E-Business Suite Release Notes, Release 12.2 (Doc ID 1320300.1)
Oracle E-Business Suite Release 12.2.5 Readme (Doc ID 1983050.1)
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

Oracle EBS Workflow Notification Mailer with Cloud E-Mail Servers

Configuring an Oracle Workflow Notification Mailer with Cloud E-Mail Servers (Doc ID 2077434.1)

Query to get the workflow notification mailer logfile to troubleshoot issues.

select fl.meaning,fcp.process_status_code,
decode(fcq.concurrent_queue_name,'WFMLRSVC','mailer container','WFALSNRSVC','listener container',fcq.concurrent_queue_name) "CONTAINER",
fcp.concurrent_process_id,os_process_id, fcp.logfile_name
from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups fl
where fcq.concurrent_queue_id=fcp.concurrent_queue_id and fcp.process_status_code='A'
and fl.lookup_type='CP_PROCESS_STATUS_CODE' and
fl.lookup_code=fcp.process_status_code
and concurrent_queue_name in('WFMLRSVC','WFALSNRSVC')
order by fcp.logfile_name;


Inbound Connection Setup

$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=143 -Dsecurity=STARTTLS -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap1.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap2.log 2>&1


$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=143 -Dsecurity=SSL -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap3.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap4.log 2>&1


$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=993 -Dsecurity=STARTTLS -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap5.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap6.log 2>&1


$AFJVAPRG -classpath $AF_CLASSPATH -Dprotocol=imap -Ddbcfile=$FND_SECURE/DEV.dbc -Dserver=mail.test.lk -Dport=993 -Dsecurity=SSL -Dtruststore=$AF_JRE_TOP/lib/security/cacerts -Daccount=oracle@mail.lk -Dpassword=pass -Dconnect_timeout=120 -Djavax.net.debug=all -Ddebug=Y -Dlogfile=/tmp/imap7.log -DdebugMailSession=Y oracle.apps.fnd.wf.mailer.Mailer > /tmp/imap8.log 2>&1

Saturday, March 5, 2016

How to find Oracle EBS Weblogic Server Admin Port Number and URL

Web Logic Server Admin Port 

 Method 1:

Open the EBS domain config file in following location.
$EBS_DOMAIN_HOME/config/config.xml

Then check for Admin Server Port.

Method 2:

Open the application tier context file
$CONTEXT_FILE

Then check the value of variable "s_wls_adminport" in the for the correct Web Logic Server Admin port number

Web Logic Server Console URL

http://<server name>. <domain name> : < WLS Admin Port>/console
For example. http://oracle.test.com:7003/console

Steps to Change Oracle Weblogic Server Node Manager & Administration User Password



The option to set the Oracle WebLogic Server Administration User password to a
non-default value is available during Oracle E-Business Suite installation. This section
describes the procedure to use (on the run file system) if you need to change the
password at a later time.


The EBS WebLogic Domain uses Node Manager to control the Administration Server
and the managed servers. For the EBS WebLogic Domain, the Node Manager and
WebLogic Server Administration User passwords must be same, otherwise the AD
control scripts will not work properly.


Important: 

If you need to change the Administration User password, you must change the Node Manager password first, If you do not do this, the WebLogic Server configuration change will not be detected and the next online patching cycle may fail.

The instructions that follow should be performed on the run file system. The password

change will be automatically propagated to the patch file system during the next adop

prepare phase or fs_clone operation.


1.Shut down all application tier services except the Admin Server.

On the primary node, run the command:
$ <ADMIN_SCRIPTS_HOME>/adstpall.sh -skipNM -skipAdmin

2. Change the Oracle WebLogic Server Node Manager and Administration User passwords by performing the following steps on weblogic console

Changing the Oracle WebLogic Server Node Manager Password

-Login to weblogic to server console: 


 

- Login using the current weblogic admin username and  password.

- Click on the lock and edit button



- Click on Domain link
- Click on Security TAB
   


- Click on "Advanced" Tab
- Provide the new node manager  password which you want to configure for weblogic admin user



- Click on "save"

 

- Verify settings updated successfully and then click on "Activate changes"