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.