Merhaba Arkadaşlar,
Bu yazımda sizlere önceki yazımda anlattığım EBS Klon işlemini kolaylaştıran dualfs yöntemini ve burda çıkan Autoconfig hatasının çözümünü anlatıyor olacağım. Bu yazıyı okumadan önce birönceki yazımı okumanız gerekmektedir.
Bir önceki yazıda Klon işleminde Post Clone adımında önce run editionda post clone çalıştırıp run edition ı hazırlıyorduk sonra Run editionda PreClone çalıştırıp EBSapps klasörünü fs2 altına kopyalayıp patch editionı oluşturup fs2 altında post Clone çalıştırıyorduk.
Bu işlemlerin tamamını dualfs yöntemiyle aşağıdaki gibi yapabilirsiniz.
[applmgr@ebstest2 bin]$
[applmgr@ebstest2 bin]$ perl adcfgclone.pl appsTier dualfs
Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.56
Enter the APPS password :
Enter the Weblogic AdminServer password :
Do you want to add a node (yes/no) [no] :
Running: Context clone...
Log file located at /u01/ebs/fs1/EBSapps/comn/clone/bin/CloneContext_1218064848.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [ebstest2] :
Target System Database SID : CLONE
Target System Database Server Node [ebstest2] :
Target System Database Domain Name [localdomain.local] :
Target System Base Directory : /u01/ebs
Target System Base Directory set to /u01/ebs
Target System Current File System Base set to /u01/ebs/fs1
Target System Other File System Base set to /u01/ebs/fs2
Target System Fusion Middleware Home set to /u01/ebs/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /u01/ebs/fs2/FMW_Home
Target System Web Oracle Home set to /u01/ebs/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /u01/ebs/fs2/FMW_Home/webtier
Target System Appl TOP set to /u01/ebs/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /u01/ebs/fs2/EBSapps/appl
Target System COMMON TOP set to /u01/ebs/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /u01/ebs/fs2/EBSapps/comn
Target System Instance Home Directory [/u01/ebs] :
Target System Current File System Instance Top set to /u01/ebs/fs1/inst/apps/CLONE_ebstest2
Do you want to preserve the Display [ebstest:0.0] (y/n) : n
Target System Display [ebstest2:0.0] :
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 2
Checking the port pool 2
done: Port Pool 2 is free
Report file located at /u01/ebs/fs1/inst/apps/CLONE_ebstest2/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1
The new APPL_TOP context file has been created :
/u01/ebs/fs1/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml
Check Clone Context logfile /u01/ebs/fs1/EBSapps/comn/clone/bin/CloneContext_1218064848.log for details.
Creating Patch file system context file.....
Log file located at /u01/ebs/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1218064922.log
Target System Other File System Instance Top set to /u01/ebs/fs2/inst/apps/CLONE_ebstest2
Target System Port Pool [0-99] : 3
Checking the port pool 3
done: Port Pool 3 is free
Report file located at /u01/ebs/fs2/inst/apps/CLONE_ebstest2/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/ebs/fs2/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml
Check Clone Context logfile /u01/ebs/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1218064922.log for details.
FMW Pre-requisite check log file location : /u01/ebs/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check...
Configuring: Run file system....
LogFile located at /u01/ebs/fs1/inst/apps/CLONE_ebstest2/admin/log/clone/run/RCloneApplyAppstier_12180649.log
Configuring: Patch file system....
LogFile located at /u01/ebs/fs1/inst/apps/CLONE_ebstest2/admin/log/clone/patch/RCloneApplyAppstier_12180727.log
AutoConfig has completed with errors for .patch
Do you want to startup the Application Services for CLONE? (y/n) [n] : n
Services not started
[applmgr@ebstest2 bin]$
Yukarda logdada görüldüğü gibi dualfs li post clone sonucunda patch editionda Autoconfig yaparken hata aldık. Bu hatayı Oracle Supportda araştırdığımız zaman bu dökümanı (How to Synchronize the AD tables FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES in 12.2 when adop fails. (Doc ID 2064223.1)) buldum çözüm yöntemi olarak ve uyguladığımız zaman sorunumuz gerçektende çözülmektedir.
İlk adım olarak adop phase=prepare çalıştırıyoruz aşağıdaki gibi hata aldığımızı görüyoruz.
[applmgr@ebstest2 scripts]$ adop phase=prepare
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/ebs/fs1/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml
Patch edition context: /u01/ebs/fs2/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml
Patch file system free space: 317.41 GB
Validating system setup.
Node registry is valid.
[ERROR] ETCC not run in the database node ebstest2
The EBS Technology Codelevel Checker needs to be run on the database node.
It is available as Patch 17537119.
[WARNING] MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.
Encountered the above errors when performing database validations.
Resolve the above errors and restart adop.
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 1 (Fail)
Yine patch editionda autoconfig çalıştırdığımız zaman aşağıdaki gibi hata aldığımızı görüyoruz.
[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$ . /u01/ebs/EBSapps.env patch
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/ebs/fs1/EBSapps/appl
PATCH File System : /u01/ebs/fs2/EBSapps/appl
Non-Editioned File System : /u01/ebs/fs_ne
DB Host: ebstest2.localdomain.local Service/SID: CLONE
Sourcing the PATCH File System ...
[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$
[applmgr@ebstest2 ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@ebstest2 scripts]$
[applmgr@ebstest2 scripts]$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/ebs/fs2/inst/apps/CLONE_ebstest2/admin/log/12221337/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/ebs/fs2/inst/apps/CLONE_ebstest2
Classpath : /u01/ebs/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/ebs/fs2/EBSapps/comn/java/classes
Using Context file : /u01/ebs/fs2/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring CZ_TOP........COMPLETED
Configuring SHT_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring GMF_TOP.......COMPLETED
Configuring PON_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed with errors.
[applmgr@ebstest2 scripts]$
Çözüm olarak fnd_oam_context_files, fnd_nodes ve adop_valid_nodes tablolarını yedekleyip truncate ediyoruz aşağıdaki gibi.
[oracle@ebstest2 etcc]$ sqlplus applsys/apps SQL*Plus: Release 12.1.0.2.0 Production on Sat Dec 22 13:45:36 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Last Successful login time: Sun Dec 02 2018 03:28:42 -05:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files; Table created. SQL> create table fnd_nodes_bk as select * from fnd_nodes; Table created. SQL> create table adop_valid_nodes_bk as select * from adop_valid_nodes; Table created. SQL> create table ad_nodes_config_status_bk as select * from ad_nodes_config_status; Table created. SQL> truncate table fnd_oam_context_files; Table truncated. SQL> truncate table fnd_nodes; Table truncated. SQL> truncate table adop_valid_nodes; Table truncated. SQL> truncate table ad_nodes_config_status; Table truncated.
Şimdi DB tarafında autoconfig aşağıdaki gibi çalıştırıyoruz.
[oracle@ebstest2 CLONE_ebstest2]$ ./adautocfg.sh Enter the APPS user password: The log file for this session is located at: /u01/database/12.1.0/appsutil/log/CLONE_ebstest2/12221347/adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present. Using ORACLE_HOME location : /u01/database/12.1.0 Classpath : :/u01/database/12.1.0/jdbc/lib/ojdbc6.jar:/u01/database/12.1.0/appsutil/java/xmlparserv2.jar:/u01/database/12.1.0/appsutil/java:/u01/database/12.1.0/jlib/netcfg.jar:/u01/database/12.1.0/jlib/ldapjclnt12.jar Using Context file : /u01/database/12.1.0/appsutil/CLONE_ebstest2.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 db121 Updating rdbms type in Context file to 64 bits Configuring templates from ORACLE_HOME ... AutoConfig completed successfully. [oracle@ebstest2 CLONE_ebstest2]$
Database tarafında autoconfig düzgün bittiğini görüyoruz şimdi EBS tarafında run edition ve patch editionda ayrı ayrı autoconfig çalıştırıyoruz.
[applmgr@ebstest2 ~]$ . .bash_profile E-Business Suite Environment Information ---------------------------------------- RUN File System : /u01/ebs/fs1/EBSapps/appl PATCH File System : /u01/ebs/fs2/EBSapps/appl Non-Editioned File System : /u01/ebs/fs_ne DB Host: ebstest2.localdomain.local Service/SID: CLONE Sourcing the RUN File System ... [applmgr@ebstest2 ~]$ [applmgr@ebstest2 ~]$ cd $ADMIN_SCRIPTS_HOME [applmgr@ebstest2 scripts]$ [applmgr@ebstest2 scripts]$ ./adautocfg.sh Enter the APPS user password: The log file for this session is located at: /u01/ebs/fs1/inst/apps/CLONE_ebstest2/admin/log/12221348/adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using CONFIG_HOME location : /u01/ebs/fs1/inst/apps/CLONE_ebstest2 Classpath : /u01/ebs/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/ebs/fs1/EBSapps/comn/java/classes Using Context file : /u01/ebs/fs1/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Configuring templates from all of the product tops... Configuring AD_TOP........COMPLETED Configuring FND_TOP.......COMPLETED Configuring ICX_TOP.......COMPLETED Configuring MSC_TOP.......COMPLETED Configuring IEO_TOP.......COMPLETED Configuring BIS_TOP.......COMPLETED Configuring CZ_TOP........COMPLETED Configuring SHT_TOP.......COMPLETED Configuring AMS_TOP.......COMPLETED Configuring CCT_TOP.......COMPLETED Configuring WSH_TOP.......COMPLETED Configuring CLN_TOP.......COMPLETED Configuring OKE_TOP.......COMPLETED Configuring OKL_TOP.......COMPLETED Configuring OKS_TOP.......COMPLETED Configuring CSF_TOP.......COMPLETED Configuring IBY_TOP.......COMPLETED Configuring JTF_TOP.......COMPLETED Configuring MWA_TOP.......COMPLETED Configuring CN_TOP........COMPLETED Configuring CSI_TOP.......COMPLETED Configuring WIP_TOP.......COMPLETED Configuring CSE_TOP.......COMPLETED Configuring EAM_TOP.......COMPLETED Configuring GMF_TOP.......COMPLETED Configuring PON_TOP.......COMPLETED Configuring FTE_TOP.......COMPLETED Configuring ONT_TOP.......COMPLETED Configuring AR_TOP........COMPLETED Configuring AHL_TOP.......COMPLETED Configuring IES_TOP.......COMPLETED Configuring OZF_TOP.......COMPLETED Configuring CSD_TOP.......COMPLETED Configuring IGC_TOP.......COMPLETED AutoConfig completed successfully. [applmgr@ebstest2 scripts]$
Run editionda autoconfig yukardaki gibi düzgün tamamlandı, şimdi patch editiondada aşağıdaki gibi autoconfig çalıştırıyoruz.
[applmgr@ebstest2 ~]$ . /u01/ebs/EBSapps.env patch E-Business Suite Environment Information ---------------------------------------- RUN File System : /u01/ebs/fs1/EBSapps/appl PATCH File System : /u01/ebs/fs2/EBSapps/appl Non-Editioned File System : /u01/ebs/fs_ne DB Host: ebstest2.localdomain.local Service/SID: CLONE Sourcing the PATCH File System ... [applmgr@ebstest2 ~]$ cd $ADMIN_SCRIPTS_HOME [applmgr@ebstest2 scripts]$ [applmgr@ebstest2 scripts]$ ./adautocfg.sh Enter the APPS user password: The log file for this session is located at: /u01/ebs/fs2/inst/apps/CLONE_ebstest2/admin/log/12221354/adconfig.log AutoConfig is configuring the Applications environment... AutoConfig will consider the custom templates if present. Using CONFIG_HOME location : /u01/ebs/fs2/inst/apps/CLONE_ebstest2 Classpath : /u01/ebs/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/ebs/fs2/EBSapps/comn/java/classes Using Context file : /u01/ebs/fs2/inst/apps/CLONE_ebstest2/appl/admin/CLONE_ebstest2.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Configuring templates from all of the product tops... Configuring AD_TOP........COMPLETED Configuring FND_TOP.......COMPLETED Configuring ICX_TOP.......COMPLETED Configuring MSC_TOP.......COMPLETED Configuring IEO_TOP.......COMPLETED Configuring BIS_TOP.......COMPLETED Configuring CZ_TOP........COMPLETED Configuring SHT_TOP.......COMPLETED Configuring AMS_TOP.......COMPLETED Configuring CCT_TOP.......COMPLETED Configuring WSH_TOP.......COMPLETED Configuring CLN_TOP.......COMPLETED Configuring OKE_TOP.......COMPLETED Configuring OKL_TOP.......COMPLETED Configuring OKS_TOP.......COMPLETED Configuring CSF_TOP.......COMPLETED Configuring IBY_TOP.......COMPLETED Configuring JTF_TOP.......COMPLETED Configuring MWA_TOP.......COMPLETED Configuring CN_TOP........COMPLETED Configuring CSI_TOP.......COMPLETED Configuring WIP_TOP.......COMPLETED Configuring CSE_TOP.......COMPLETED Configuring EAM_TOP.......COMPLETED Configuring GMF_TOP.......COMPLETED Configuring PON_TOP.......COMPLETED Configuring FTE_TOP.......COMPLETED Configuring ONT_TOP.......COMPLETED Configuring AR_TOP........COMPLETED Configuring AHL_TOP.......COMPLETED Configuring IES_TOP.......COMPLETED Configuring OZF_TOP.......COMPLETED Configuring CSD_TOP.......COMPLETED Configuring IGC_TOP.......COMPLETED AutoConfig completed successfully. [applmgr@ebstest2 scripts]$
Patch editiondada yukardaki gibi autoconfig in düzgün bittiğini görüyoruz böylece sorunumuz çözülmüş oldu. Bu yazınında sonuna gelmiş bulunmaktayız bir sonraki yazıda buluşmak dileğiyle esen kalın.
Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda aşağıdaki konularda 7×24 Uzman Danışmanlara yada Eğitimlere mi
İhtiyacınız var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle iletişime geçebilirsiniz.
– Oracle Veritabanı Danışmanlığı
– Oracle Veritabanı Bakım ve Destek
– Exadata Danışmanlığı
– Exadata Bakım ve Destek
– SQL Server Veritabanı Danışmanlığı
– SQL Server Veritabanı Bakım ve Destek
– Goldengate Danışmanlığı
– Goldengate Bakım ve Destek
– Linux Danışmanlığı
– Linux Bakım ve Destek
– Oracle EBS Danışmanlığı
– Oracle EBS Bakım ve Destek
– Weblogic Danışmanlığı
– Weblogic Bakım ve Destek
– Oracle Veritabanı Eğitimleri
– Oracle VM Server Danışmanlığı
– Oracle VM Server Bakım ve Destek
– Oracle EPPM Danışmanlığı
– Oracle EPPM Bakım ve Destek
– Oracle Primavera Danışmanlığı
– Oracle Primavera Bakım ve Destek
– Oracle Eğitimleri
– SQL Server Eğitimleri
– Goldengate Eğitimleri
– Exadata Eğitimleri
– Linux Eğitimleri
– Oracle EBS Eğitimleri
– Oracle VM Server Eğitimleri
– Weblogic Eğitimleri
– Oracle EPPM Eğitimleri
– Oracle Primavera Eğitimleri