Saturday, February 10, 2018

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$

Monday, February 5, 2018

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


Saturday, February 3, 2018

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