EBS 12,2 code level check

SQL> l
  1  select
  2    substr(abbreviation,1,10)
  3  ,substr(codelevel,1,10)
  4  from
  5    ad_trackable_entities
  6  where
  7    abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' )
  8  order by
  9*   abbreviation
SQL> /

SUBSTR(ABB SUBSTR(COD
---------- ----------
ad         C.10
atg_pf     C.7
fnd        C.7
fwk        C.7
icx        D.3
txk        C.10

6 rows selected.

FND_DIAGNOSTICS Is Invalid (Doc ID 2217255.1)

1. Add grant to DBA_DATAPUMP_JOBS view;
sqlplus / as sysdba
SQL> grant select on dba_datapump_jobs to apps;
SQL> alter package APPS.FND_DIAGNOSTICS compile body;


2. Verify that the FND_DIAGNOSTICS object is valid:

SQL> select object_name,status from dba_objects where object_name like 'FND_DIAGNOSTICS';

APPS.AD_ZD_ADOP invalid (Doc ID 2175698.1)

 $grant execute on DBMS_METADATA_UTIL to apps;
$ alter package APPS.AD_ZD_ADOP compile body;

2. Verify the Status of APPS.AD_ZD_ADOP package is valid.

Data Source Connection Pool Diagnostics

Oracle E-Business Suite 12.2 Data Source Connection Pool Diagnostics (Doc ID 1940996.1)

Diagnostic and Analyzer Scripts

Catalog: Oracle Toolbox: Diagnostic and Analyzer Scripts - Data Collectors - Health Checks - Tools - Utilities - SRDC - All Products - Database - Exadata - EBS - JDE - Fusion - Middleware - Siebel - Sun - Peoplesoft (Doc ID 1987483.2)

OPatch auto

Java Web Start

Using Java Web Start with Oracle E-Business Suite (Doc ID 2188898.1)

R12: Recommended Browsers for Oracle E-Business Suite (Doc ID 389422.1)

E B S Default Port

Table of Ports Used by Oracle E-Business Suite

Variable Name	Description	Default Value	Technology	Component
s_dbport	Port on the database server used by the database listener	1521	RDBMS	TNS listener
s_rpcport	RPC port on the concurrent processing server that receives incoming Report Review Agent requests	1626	Applications	Application tier TNS listener
s_formsport(a)	Port on the Forms server used by the Forms Listener	9000	Forms 10	Forms
s_mwaPortNo	MSCA Server Port Number	10200	Applications	Mobile
s_mwaDispatcherPort	MSCA Dispatcher Port Number	10300	Applications	Mobile
s_webport	Port on the webserver where http server listens for non-SSL requests	8000	Oracle Fusion Middleware	Oracle HTTP Server
s_webssl_port	Port on the webserver where http server listens for SSL requests	4443	Oracle Fusion Middleware	Oracle HTTP Server
s_active_webport	Value of this variable is set to value of s_webport when Listener is configured in non-SSL mode and to the value of s_webssl_port when ssl is configured	8000/4443	Oracle Fusion Middleware	Oracle HTTP Server
s_jtfuf_port	JTF fulfilment server port	11000	Applications	JTF
s_ons_localport	Oracle Notification Service	6100	Oracle Fusion Middleware	OPMN (manages OHS & oc4j)
s_ons_remoteport	Oracle Notification Service	6200	Oracle Fusion Middleware	OPMN
s_ons_requestport	Oracle Notification Service	6500	Oracle Fusion Middleware	OPMN
s_ohs_adminport	OHS Administration Proxy Port	9999		Oracle HTTP Server
s_java_object_cache_port	Java Object Cache Port	12345	Oracle Fusion Middleware	Java Object Cache

(a) Forms server (socket mode) is optional (and not recommended) in Oracle E-Business Suite Release 12. The default is servlet mode.

Table of Ports Used by WebLogic Server

Oracle E-Business Suite Release 12.2 uses WebLogic Server (WLS) as its servlet container. WLS uses the following ports:

Variable Name	Description	Default Value	Firewall Configuration	Technology	Component
s_nm_port	WLS Node Manager Port	5556		Oracle Fusion Middleware	WLS
s_wls_adminport	WLS Admin Server Port	7001	Internal application tiers assumed to be on same subnet	Oracle Fusion Middleware	WLS
s_wls_oacoreport	WLS OACORE Application Port	7201		Oracle Fusion Middleware	WLS
s_wls_formsport	WLS FORMS Application Port	7401		Oracle Fusion Middleware	WLS
s_wls_oafmport	WLS OAFM Application Port	7601		Oracle Fusion Middleware	WLS
s_wls_forms-c4wsport	WLS FORMS-C4WS Application Port	7801		Oracle Fusion Middleware	WLS
s_wls_wcportletport	WLS Portlet Application Port	8889		Oracle Fusion Middleware	WLS
s_wls_oaeaport	WLS OAEA Application Port	6801		Oracle Fusion Middleware	WLS

Oracle E-Business Suite Processes

 Processes Used by Oracle E-Business Suite

Process Name	Description	Script
tnslsnr	Applications RPC listener process	adalnctl.sh
opmn	Process manager (starts httpd)	adopmnctl.sh
httpd	Apache Web Server Listener	adapcctl.sh
java -Dweblogic.Name=AdminServer	WebLogic Administration Server	adadminsrvctl.sh
java weblogic.NodeManager	Node manager	adnodemgrctl.sh
java -Dweblogic.Name=oacore_server1	oacore managed server	admanagedsrvctl.sh start oacore_server1
java -Dweblogic.Name=forms_server1	Forms managed server	admanagedsrvctl.sh start forms_server1
java -Dweblogic.Name=oafm_server1	oafm managed server	admanagedsrvctl.sh start oafm_serverS1
FNDSM FFTM RCVOLTM POXCON INTCM FNDCRM PALIBR MRCLIB FNDLIBR INVLIBR	Concurrent Manager	adcmctl.sh
java oracle.apps.jtf.fm.engine.processor.Processor java oracle.apps.jtf.fm.engine.remote.RemoteCommand	Fulfillment Server process	jtffmctl.sh
	Forms Server (a)	adformsrvctl.sh

How to get your apps password if you forgot

drop FUNCTION apps.decryptappspwd;


create FUNCTION apps.decryptappspwd(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
 RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';

Function created.



 select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME='GUEST';

ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZH15F2D57A9D301A223EF2B428DE8224FE9A3D9165345E7A2A645159435CEC0336E04DF7BCE76CDA
3110B72BE0743CD4576B

SQL> SELECT apps.decryptapps pwd('GUEST/ORACLE','ZH15F2D57A9D301A223EF2B428DE8224FE9A3D9165345E7A2A645159435CEC0336E04DF7BCE76CDA3110B72BE0743CD4576B') from dual;

APPS.DECRYPTAPPSPWD('GUEST/ORACLE','ZH15F2D57A9D301A223EF2B428DE8224FE9A3D91653
--------------------------------------------------------------------------------
APPS

How to restore /etc/inittab file in OL6.9?

Accidentally /etc/inittab file removed.

Cause GUI is not coming up. It goes to single user mode.

How to restore the file?

Once you login into single user mode as root.

#echo "id:5:initdefault:" > /etc/inittab
#reboot

you can see the GUI mode.

Oracle support TLS 1.2 Only

Oracle removing support for legacy Transport Layer Security (TLS) protocols in order to ensure improved security and performance. Beginning on July 31, 2018, Object Storage Classic will no longer support TLS 1.0/1.1 and will support only TLS 1.2 or higher.

we need to update all client-server combinations to use TLS version 1.2. Additionally, we recommend that you update any tooling which connects to Object Storage Classic (e.g., cloudberry, rman backups, etc.) to use TLS 1.2. To help ensure a smooth transition, we recommend using Java Runtime Environment release 7 or higher. Additionally, for those who use File Transfer Manager command-line interface (FTM CLI), we recommend using version 2.4 or higher to address unrelated feature enhancements and fixes; however, updating FTM CLI is not required to accommodate the transition from TLS 1.0/1.1.

How to determine Java version

Java (Unix/Linux) 

Run the following from the command line: 

 java -version

FTM CLI

Run the following from the command line:

 java -jar ftmcli.jar -v
 
 
 

Cipher Options for Oracle Fusion Middleware's

New SSL Protocol and Cipher Options for Oracle Fusion Middleware's OPMN/ONS Component ( Doc ID 1905314.1 )

X11 forwarding

xclock and local forwarding

Make sure xclock is installed.
.profile

MAIL=/usr/mail/${LOGNAME:?}
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/NX/bin:/sbin:/usr/sbin:/usr/local/sbin:.
export EDITOR=vi
HOSTNAME=`hostname|cut -f 1 -d .`

if [[ ! "$SUDO_USER" = "" ]]
then
  export OS_HOME=`dirname $HOME`
  export XAUTHORITY=$OS_HOME/$SUDO_USER/.Xauthority
  echo "XAUTHORITY = $XAUTHORITY"
fi

WHOAMI=`whoami`
export PS1='$WHOAMI@$HOSTNAME$'
set -o vi
umask 027
alias lsf='ls -F'
alias lsa='ls -aF'
alias bdf='df -k'
alias psa='ps -afe|grep $1'
alias cdp='cd /apps/oracle/local/profiles; ls -a'
alias cdo='cd $ORACLE_HOME'

Oracle apps upgrade 11.5.10.2 to 12.2

Oracle® E-Business Suite Upgrade Guide Release 11i to 12.2 Part No. E48834-03

https://docs.oracle.com/cd/E51111_01/current/html/docset.html

Extensions - Log Warning(38,40): The 'requires-ui' attribute is deprecated. Use 'headless' instead Warning(39,40): The 'requires-ui' attribute is deprecated. Use 'headless' instead

Use "Headless" Instead (Doc ID 2030725.1)

OAF For R12.2.7

-rw-r-----.  1 oracle oinstall 960420040 May  9 13:59 p26550226_R12_GENERIC.zip

When you unzip you will see the below folder

drwxr-x---.  3 oracle oinstall      4096 Aug 31  2017 jdevhome
drwxr-x---. 48 oracle oinstall      4096 Aug 31  2017 jdevbin
drwxr-x---.  4 oracle oinstall      4096 Aug 31  2017 jdevdoc
-rw-rw-r--.  1 oracle oinstall      4825 Sep 14  2017 OAEXT_README.txt

cp  /apps2/oracle/product/fs1/inst/apps/DEV_suthakar/appl/fnd/12.0.0/secure/dev.dbc  /apps/oracle/product/oaf/jdevhome/jdev/dbc_files/secure/
cd /apps/oracle/product/oaf/jdevbin/jdev/bin/jdev

.profile
#!/bin/bash

export JAVA_HOME=/apps/oracle/product/JDK/jdk1.8.0_151

export JDEV_HOME=/apps/oracle/product/oaf/jdevbin/jdev/bin/

cd $JDEV_HOME
~
 
when I invoke jdev I was getting this error my jdk version is not set.

Error: JDeveloper can't recognize the JDK version
 

Fix
open the (take backup) jdev.conf file and comment out the line

SetJavaVM hotspot and save it.

Then invoke jdev. works fine.

 

ASM DISK setup

 [root@rac1 ~]# ls /dev/sd*
/dev/sda  /dev/sda1  /dev/sda2  /dev/sdb
[root@rac1 ~]# ls -l /dev/sd*          
brw-rw---- 1 root disk 8,  0 May  4 16:40 /dev/sda
brw-rw---- 1 root disk 8,  1 May  4 16:40 /dev/sda1
brw-rw---- 1 root disk 8,  2 May  4 16:40 /dev/sda2
brw-rw---- 1 root disk 8, 16 May  4 16:40 /dev/sdb
[root@rac1 ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0x3ba15934.                    
Changes will remain in memory only, until you decide to write them.              
After that, of course, the previous content won't be recoverable.                

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
         switch off the mode (command 'c') and change display units to 
         sectors (command 'u').

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-522, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G} (1-522, default 522):
Using default value 522

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac1 ~]# ls -l /dev/sd*
brw-rw---- 1 root disk 8,  0 May  4 16:40 /dev/sda
brw-rw---- 1 root disk 8,  1 May  4 16:40 /dev/sda1
brw-rw---- 1 root disk 8,  2 May  4 16:40 /dev/sda2
brw-rw---- 1 root disk 8, 16 May  4 16:58 /dev/sdb
brw-rw---- 1 root disk 8, 17 May  4 16:58 /dev/sdb1

oracleasm createdisk DISK1 /dev/sdb1
Writing disk header: done
Instantiating disk: done

[root@rac1 ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@rac1 ~]#
 oracleasm listdisks
DISK1
[root@rac1 ~]#vi /etc/scsi_id.config
options=-g

[root@rac1 ~]# /sbin/scsi_id -g -u -d /dev/sdb
1ATA_VBOX_HARDDISK_VB9357ce3b-21d92e85

vi /etc/udev/rules.d/99-oracle-asmdevices.rules

KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB9357ce3b-21d92e85", NAME="asm_disk1", OWNER="oracle", GROUP="dba", MODE="0660"


installation Grid

installation db binary
dbca


. oraenv
ORACLE_SID = [oracle] ? racdb
The Oracle base has been set to /u01/app/oracle
[oracle@rac1 bin]$ srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/RACDB/PARAMETERFILE/spfile.270.975274745
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services:
OSDBA group:
OSOPER group:
Database instance: racdb
[oracle@rac1 bin]$ srvctl status database -d racdb
Database is running.
[oracle@rac1 bin]$
. oraenv
ORACLE_SID = [racdb] ? racdb
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1 bin]$ srvctl stop database -d racdb

$srvctl stop asm -force

SSO setup for OBIEE12c

1. Install Database.

2. Run RCU for oid, OAM,OBIEE

3. Install OID, OAM, OBIEE12c,OHS12(webgates comes alongwith).

4. Configuration. I will write the steps.

-rwxr-x---. 1 oracle oinstall 3032 Aug 17  2017 deployWebGateInstance.sh
oracle@suthakar$./deployWebGateInstance.sh -w $OHS_MASTER_CONFIG -oh $ORACLE_HOME
Copying files from WebGate Oracle Home to WebGate Instancedir
oracle@suthakar$export LD_LIBRARY_PATH=$ORACLE_HOME/lib
oracle@suthakar$pwd
/apps6/oracle/product/obi12c/ohs/webgate/ohs/tools/deployWebGate
oracle@suthakar$cd ..
oracle@suthakar$ls
deployWebGate  openssl  setup  t2p
oracle@suthakar$pwd
/apps6/oracle/product/obi12c/ohs/webgate/ohs/tools
oracle@suthakar$cd setup
oracle@suthakar$ls
InstallTools
oracle@suthakar$cd *
oracle@suthakar$ls
apache_webgate.template  EditHttpConf
oracle@suthakar$ls ltr
ls: cannot access ltr: No such file or directory
oracle@suthakar$ls -lttr
total 2452
-rwxr-x---. 1 oracle oinstall 2502685 Aug 17  2017 EditHttpConf
-rw-r-----. 1 oracle oinstall    2053 Aug 17  2017 apache_webgate.template
oracle@suthakar$export LD_LIBRARY_PATH=$ORACLE_HOME/lib
oracle@suthakar$./EditHttpConf -w $OHS_MASTER_CONFIG -oh $ORACLE_HOME -o Edithttpconf.log
The web server configuration file was successfully updated
/apps6/oracle/product/obi12c/ohs/user_projects/domains/ohs_domain/config/fmwconfig/components/OHS/instances/ohs1/httpd.conf has been backed up as /apps6/oracle/product/obi12c/ohs/user_projects/domains/ohs_domain/config/fmwconfig/components/OHS/instances/ohs1/httpd.conf.ORIG

Virtual Guest Additions on linux 6.9

I had a problem with virtual Guest Addition on oracle linux 6.9 . After I followed the steps it works fine to me.

# yum update
# yum install gcc

# yum install kernel-uek-devel

ORA-65096

SQL> create user test identified by oracle;
create user test identified by oracle
            *
ERROR at line 1:
ORA-65096: invalid common user or role name

SQL> alter session set "_ORACLE_SCRIPT"=true;
Session altered.
SQL> create user test identified by test;
User created.
SQL> drop user test;
User dropped.

SSO for Oracle EBS Application 12.2.7

Active Directory  running on VM virtual Box

Integrating Oracle E-Business Suite Release 12.2 with Oracle Access Manager 11gR2 (11.1.2) using Oracle E-Business Suite AccessGate (Doc ID 1576425.1)


OID

 

DIP synchronization

ODSM

Install webgate on EBS

1. txkrun.pl -script=SetOAMReg -installWebgate=yes 

2.deploy accessGate

 perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-create-oaea_resources -contextfile=$CONTEXT_FILE -deployApps=accessgate -SSOServerURL

3. Register OAM

txkrun.pl -script=SetOAMReg -registeroam=yes

option

4.sync between OID and Oracle eBS,

$FND_TOP/bin/txkrun.pl -script=SetSSOReg -registeroid=yes -ldaphost

5 set profiles in EBS for SSO

 OAM

Ldap authentication

 Resource

EBS 12.2.7

Enter SSO URL http:/suthakar.prince:8087 redirect to OAM Screen

 

 Enter User name and Password It will take you to EBS application

 

Make sure all the server running and AccessGate is active on oearesource

 

 

Adcfgclone On PATCH FS Errors Out with Some directive were removed from moveplan. (Doc ID 2117787.1)

SEVERE : Apr 5, 2018 07:12:36 - ERROR - CLONE-20218   Cloning is not successful.
SEVERE : Apr 5, 2018 07:12:36 - CAUSE - CLONE-20218   An internal operation failed.
SEVERE : Apr 5, 2018 07:12:36 - ACTION - CLONE-20218   Provide the clone log and error file for investigation.
oracle.as.t2p.exceptions.FMWT2PPasteConfigException: oracle.as.t2p.exceptions.FMWT2PCopyConfigException: java.lang.Exception: Some directive were removed from moveplan.
        at oracle.as.clone.ohs.impl.OHSComponentApplyClonerImpl.doPostPasteConfig(OHSComponentApplyClonerImpl.java:269)
        at oracle.as.clone.cloner.component.ComponentApplyCloner.doClone(ComponentApplyCloner.java:193)
        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)
Caused by: oracle.as.t2p.exceptions.FMWT2PCopyConfigException: java.lang.Exception: Some directive were removed from moveplan.
        at oracle.as.clone.ohs.util.OHSPasteConfig.restoreDirectiveFiles(OHSPasteConfig.java:227)
        at oracle.as.clone.ohs.impl.OHSComponentApplyClonerImpl.doPostPasteConfig(OHSComponentApplyClonerImpl.java:175)
        ... 8 more
Caused by: java.lang.Exception: Some directive were removed from moveplan.
        at oracle.as.clone.ohs.util.OHSPasteConfig.restoreFilesForDirectiveType_outOfIH(OHSPasteConfig.java:359)
        at oracle.as.clone.ohs.util.OHSPasteConfig.restoreFilesForDirectiveType(OHSPasteConfig.java:292)
        at oracle.as.clone.ohs.util.OHSPasteConfig.restoreDirectiveFiles(OHSPasteConfig.java:220)
        ... 9 more

solution :
As a workaround, please do the following:
1. On the source system, please comment the include for webgate.conf in the httpd.conf file.
2. Again on source, move the clone directory to a backup location.
3. Run adpreclone. This should recreate the cloning directory, including generating a new moveplan.
4. Continue as normal with the clone.

Domain might be locked by some other WLS user process

Validating configuration on node: [hostname].
    Log: /apps2/oracle/product/fs_ne/EBSapps/log/adop/24/20180404_200441/prepare/validate/hostname
        [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
        [WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.
        [ERROR]: Domain might be locked by some other WLS user process
    [UNEXPECTED]Error occurred running "perl /apps2/oracle/product/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/apps2/oracle/product/fs2/inst/apps/DEV_hostname/appl/admin/DEV_suthakar.xml -patchctxfile=/apps2/oracle/product/fs1/inst/apps/DEV_suthakar/appl/admin/DEV_suthakar.xml -phase=prepare -logloc=/apps2/oracle/product/fs_ne/EBSapps/log/adop/24/20180404_200441/prepare/validate/suthakar -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on hostname

If the EBS Weblogic domain is in EDIT mode, it can cause adop to fail.
Someone with administrator privileges on WLS Admin Console may have locked the Weblogic domain for making changes, and has not released the checkout.
This leaves the domain in edit mode, resulting in the issue

To resolve the issue test the following steps in a development instance and then migrate accordingly:
1. Start the admin server on the run file system (if not started already).
2. Login in to WLS Admin Console (http(s)://hostname.domain:/console)
3. Click on the "Activate Changes" or the "Release Configuration" button (depending on the version) in the "Change Center" region on the top left corner.
4. Logout of the WLS console.
5. Rerun the adop phase=prepare command and confirm adop completes successfully.

doc reference : Doc ID 2042785.1
 

How to check Fusion Middlware version installed in R12.2

export ORACLE_HOME=/apps2/oracle/product/fs1/FMW_Home/webtier
export PATH=/apps2/oracle/product/fs1/FMW_Home/webtier/OPatch:$PATH

opath lsinventory

Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2018, Oracle Corporation.  All rights reserved.

Oracle Home       : /apps2/oracle/product/fs1/FMW_Home/webtier
Central Inventory : /apps2/oracle/oraInventory_127
   from           : /apps2/oracle/product/fs1/FMW_Home/webtier/oraInst.loc
OPatch version    : 11.1.0.12.9
OUI version       : 11.1.0.11.0
Log file location : /apps2/oracle/product/fs1/FMW_Home/webtier/cfgtoollogs/opatch/opatch2018-03-21_15-00-17PM_1.log

OPatch detects the Middleware Home as "/apps2/oracle/product/fs1/FMW_Home"
Lsinventory Output file location : /apps2/oracle/product/fs1/FMW_Home/webtier/cfgtoollogs/opatch/lsinv/lsinventory2018-03-21_15-00-17PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle WebTier and Utilities CD        11.1.1.9.0
There are 1 products installed in this Oracle Home.

RC-50014: Fatal: Execution of AutoConfig was failed adcrdb.sh INSTE8

INSTANTIATE PHASE]
  AutoConfig could not successfully instantiate the following files:
    Directory: /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/install/TEST_suthakar
      adcrdb.sh               INSTE8


AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyDBTechStack

copy adcrdb.sh to $ORACLE_HOME/appsutil/template/adcrdb.sh

rerun the clone.


adcfgclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA  

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password :

Running:
/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/java:/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /scratch/tmp/adpairsfile_9319.lst -stage /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone  2> /scratch/tmp/adcfgclone_9319.err; echo $? > /scratch/tmp/adcfgclone_9319.res                                                                                                             

Log file located at /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0210184905.log

Provide the values required for creation of the new Database Context file.

Target System Hostname (virtual or normal) [suthakar] :

Target Instance is RAC (y/n) [n] :

Target System Database SID : TEST

Target System Base Directory : /apps/oracle

Target System utl_file_dir Directory List : /tmp

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/d01/oracle/TEST/db/apps_st/data] : /apps/oracle/product/1213/TEST/db/apps_st/data

Target System RDBMS ORACLE_HOME Directory [/apps/oracle/db/tech_st/11.1.0] : /apps/oracle/product/1213/TEST/db/tech_st/11.1.0

Do you want to preserve the Display [erp:0.0] (y/n)  : n

Target System Display [suthakar:0.0] :

Do you want the the target system to have the same port values as the source system (y/n) [y] ? :
Complete port information available at /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/out/TEST_suthakar/portpool.lst

Backing up /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/TEST_suthakar.xml to /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/TEST_suthakar.xml8.bak                                                                                                                                               

Creating the new Database Context file from :
  /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
  /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/TEST_suthakar.xml

Log file located at /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0210184905.log
Check Clone Context logfile /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0210184905.log for details.

Running Rapid Clone with command:
perl /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/../jre mode=apply stage=/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/TEST_suthakar.xml showProgress contextValidated=true
Running:
perl /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/../jre mode=apply stage=/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/TEST_suthakar.xml showProgress contextValidated=true
APPS Password :

Beginning database tier Apply - Sat Feb 10 18:49:50 2018

/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/oui -classpath /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc6.jar:/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/java:/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/oui/ewt3.jar:/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/oui/srvm.jar:/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/TEST_suthakar.xml -stage /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/clone   -showProgress
APPS Password : Log file located at /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/log/TEST_suthakar/ApplyDBTier_02101849.log
  |     15% completed

Completed Apply...
Sat Feb 10 18:53:56 2018

Starting database listener for TEST:
Running:
/apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/scripts/TEST_suthakar/addlnctl.sh start TEST
Logfile: /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/log/TEST_suthakar/addlnctl.txt

You are running addlnctl.sh version 120.1.12010000.4


Starting listener process TEST ...


Listener TEST has already been started.


addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /apps/oracle/product/1213/TEST/db/tech_st/11.1.0/appsutil/log/TEST_suthakar/addlnctl.txt for more information ...

oracle@suthakar$

Windows Server 2008 R2 with AD sync to oid (LDAP) to EBS 12.2.7

Database Server
----------------------------------------
RDBMS : 12.1.0.2.0
Oracle Applications : 12.2.7

Install windows server 2008 , Active Directory and create  organization,users

Setup organization and employee for AD

Integration with AD to OID

oracle@suthakar$./ldapbind -p 389 -h 00.0.0.000 -D "Administrator@domain.name" -w "password"
bind successful

syncProfileBootstrap -host hostname -port 7005 -D weblogic -profile ADOID -lp 5
Picked up _JAVA_OPTIONS: -Xms512m -Xmx1024m
[Weblogic user password]
Connection parameters initialized.
Connecting at hostnmae, with userid "weblogic"..
Connected successfully.

The bootstrap operation completed, the operation results are:
entries read in bootstrap operation: 4
entries filtered in bootstrap operation: 0
entries ignored in bootstrap operation: 0
entries processed in bootstrap operation: 3
entries failed in bootstrap operation: 1

 
OID to EBS 12.2

$FND_TOP/bin/txkrun.pl \
-script=SetSSOReg \
-registeroid=yes \
-ldaphost=hostname \
-ldapport=ldapport\
-oidadminuser=cn=orcladmin \
-instpass=password \
-oidadminuserpass=password \
-appspass=apps \
-provisiontype=3 \
-instpass=password\
-appname=SID\
-svcname=SID

Beginning input parameter validation for OID registration.
Input parameters validation for OID registration completed.

BEGIN OID REGISTRATION:
Beginning to register Application and Service containers if necessary.
Application and Service containers were created successfully if necessary.
Beginning to register application in Oracle Internet Directory.
Registration of application in Oracle Internet Directory completed successfully.
[info] -> LOADING:  /apps2/oracle/product/fs1/EBSapps/appl/fnd/12.0.0/admin/template/AppsOIDRegistration.tmp
Feb 27, 2018 2:27:44 PM oracle.ldap.util.LDIFLoader loadOneLdifFile
INFO: -> LOADING:  /apps2/oracle/product/fs1/EBSapps/appl/fnd/12.0.0/admin/template/AppsOIDRegistration.tmp
Beginning to register provisioning profile in Oracle Internet Directory.
Registration of provisioning profile in Oracle Internet Directory completed successfully.
Application is now registered successfully with provisioning in Oracle Internet Directory.

End of /apps2/oracle/product/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkSetSSOReg.pl : No Error



  1  select user_name,creation_date,user_guid,email_address from fnd_user where creation_date>
  2* (SYSDATE - 1)
SQL> /

USER_NAME
--------------------------------------------------------------------------------
CREATION_DATE      USER_GUID
------------------ --------------------------------
EMAIL_ADDRESS
--------------------------------------------------------------------------------
EBS122
27-FEB-18          66369A8AB638AA23E050000A8500658F
orcladmin

 1* select user_name, USER_GUID from fnd_user where creation_date> (SYSDATE - 1)
SQL> /
EBS1
664870D26A3DB26AE050000A8500369C

EBSSAND
664870D26A3FB26AE050000A8500369C

EBS122@SUTHAKAR.PRINCE
664870D26A45B26AE050000A8500369C

EBS122
66369A8AB638AA23E050000A8500658F

EBSUSER@SUTHAKAR.PRINCE
664870D26A47B26AE050000A8500369C

EBSUSER2@SUTHAKAR.PRINCE
664870D26A48B26AE050000A8500369C

EBSUSER3@SUTHAKAR.PRINCE
664870D26A49B26AE050000A8500369C

Recover from a corrupted filesystem when fsck not helped use mkfs.

/dev/mapper/vg_suthakar-lv-oradata block was corrupted. 

FSCK did not help mkfs.ext4 -c helped.

sudo mkfs.ext4 -c /dev/mapper/vg_suthakar-lv-oradata

Information Center: Using EBS Technology Stack OID and SSO (Doc ID 1461466.2)

TXK Technology Inventory Report Apps Tier

source you appstier env

oracle@suthakar$perl TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP

Enter Apps password ? 

Enter Report File name ? r1227.html

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** STDOUT   = /apps2/oracle/product/inst/fs1/inst/apps/VIS_suthakar/logs/appl/rgf/TXK/txkInventory_Wed_Jan_31_13_20_49_2018_stdout.log 

Reportfile /apps2/oracle/product/inst/fs1/inst/apps/VIS_suthakar/appltmp/TXK/r1227.html generated successfully.

oracle@suthakar$