Pular para o conteúdo principal

Copy Autoconfig from EBS to Database

APPLICATION

1. as the APPLMGR user source the environment file:
$. /u01/visappl/APPSORA.env

2. Create appsutil.zip file
$perl $AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /u01/visappl/admin/log/MakeAppsUtil_05072343.log
output located at /u01/visappl/admin/out/appsutil.zip
MakeAppsUtil completed successfully.

3. Copy the appsutil.zip to Database ORACLE_HOME

DATABASE

-- Clear nodes
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;

$export TNS_ADMIN=$ORACLE_HOME/network/admin/

$ hostname
rac1

1. Generate your Database Context File
$ perl adbldxml.pl appsuser=apps appspass=oracle
Starting context file generation for db tier..
Using JVM from /u01/app/oracle/product/11.2.0/db_1/jdk/jre/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/u01/app/oracle/product/11.2.0/db_1/appsutil/log/adbldxml_06151633.log

Could not Connect to the Database with the above parameters, Please answer the Questions below

Enter Hostname of Database server: rac1

Enter Port of Database server: 1522

Enter SID of Database server: DEV1

Enter the value for Display Variable: rac1:0.0

The context file has been created at:
/u01/app/oracle/product/11.2.0/db_1/appsutil/DEV1_rac1.xml

2. Review and Resolve Manual Configuration Changes
$./adchkcfg.sh contextfile=/u01/app/oracle/product/11.2.0/db_1/appsutil/DEV1_rac1.xml
Enter the APPS password:

The log file for this session is located at: /u01/app/oracle/product/11.2.0/db_1/appsutil/log/DEV1_rac1/06151635/adconfig.log

AutoConfig is running in test mode and building diffs...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/app/oracle/product/11.2.0/db_1
Classpath : :/u01/app/oracle/product/11.2.0/db_1/jdbc/lib/ojdbc5.jar:/u01/app/oracle/product/11.2.0/db_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/11.2.0/db_1/appsutil/java:/u01/app/oracle/product/11.2.0/db_1/jlib/netcfg.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/ldapjclnt11.jar

Using Context file : /u01/app/oracle/product/11.2.0/db_1/appsutil/out/DEV1_rac1/06151635/DEV1_rac1.xml

Context Value Management will now update the test Context file

Updating test Context file...COMPLETED

[ Test mode ]
No uploading of Context File and its templates to database.

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

Differences text report is located at: /u01/app/oracle/product/11.2.0/db_1/appsutil/out/DEV1_rac1/06151635/cfgcheck.txt

Generating Profile Option differences report...COMPLETED
Differences text report for the Database is located at: /u01/app/oracle/product/11.2.0/db_1/appsutil/out/DEV1_rac1/06151635/ProfileReport.txt
Generating File System differences report......COMPLETED
Differences html report is located at: /u01/app/oracle/product/11.2.0/db_1/appsutil/out/DEV1_rac1/06151635/cfgcheck.html

Differences Zip report is located at: /u01/app/oracle/product/11.2.0/db_1/appsutil/out/DEV1_rac1/06151635/ADXcfgcheck.zip

AutoConfig completed successfully.


3. Generate and Apply AutoConfig Configuration files
./adconfig.sh contextfile=/u01/app/oracle/product/11.2.0/db_1/appsutil/DEV1_rac1.xml
Enter the APPS user password:
The log file for this session is located at: /u01/app/oracle/product/11.2.0/db_1/appsutil/log/DEV1_rac1/06151641/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/app/oracle/product/11.2.0/db_1
Classpath : :/u01/app/oracle/product/11.2.0/db_1/jdbc/lib/ojdbc5.jar:/u01/app/oracle/product/11.2.0/db_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/11.2.0/db_1/appsutil/java:/u01/app/oracle/product/11.2.0/db_1/jlib/netcfg.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/ldapjclnt11.jar

Using Context file : /u01/app/oracle/product/11.2.0/db_1/appsutil/DEV1_rac1.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.


Marcadores:

Comentários

  1. Rayen2 de janeiro de 2020 às 08:42

    Brilliant work done. You didn't disappoint the people who reads this blog. Also from my research about Rapido Clone App, Appdupe gives good response and on time delivery for the customers. People who are expecting to develop your own can contact them for further process.

    ResponderExcluir
  2. Anônimo26 de maio de 2021 às 10:17

    Realmente muito útil... só algo que percebi, posso estar errado, mas quando as dependências em uma procedure encontra-se dentro de um CURSOR ele não identifica, correto?

    ResponderExcluir

Postar um comentário

Postagens mais visitadas deste blog

Webcenter Content - Cache Configuration for JdbcFileStore configuration

The configuration values below, control the temporarily cached files keep in FileCache table. FsCacheThreshold Specifies the maximum cache size, in megabytes (default=100) Once the threshold is met, Content Server starts deleting files that are older than the minimum age, as specified by the FsMinimumFileCacheAge parameter FsMaximumFileCacheAge The age at which files are deleted, expressed in days. The default is 365 days FsMinimumFileCacheAge The minimum age at which cached files can be deleted This parameter is used in conjunction with the FsCacheThreshold parameter to determine when to delete cached files FsCleanUpCacheDuringIndexing This parameter activates vault cache cleaning, while FsCacheThreshold, FsMaximumFileCacheAge and FsMinimumFileCacheAge are controling its behaviour.  Expect, when this is enabled on a system that currently has a large number of files in the FileCache table, the first cycle will take a long time to complete. How to Confi...
Postar um comentário
Leia mais

Assign Backup Policy for Boot and Block Volumes - OCI

To get Availability Domain oci iam availability-domain list  #!/bin/bash OCI_AD="hQsi:SA-SAOPAULO-1-AD-1" OCI_COMPARTMENT="ocid1.compartment.oc1..aaaaaaaavgyjpoffz5qliieawamjaksfb6juxejurtduclqjkvv66ookcxja" #Get Silver policy ocid funct_get_policy(){ OCI_POL_OCID=$(oci bv volume-backup-policy list | jq -r '.data[] | select(."display-name"|contains("silver"))' | jq -r '.id') } funct_boot_vol (){ #Create a file with all boot volume ocid oci bv boot-volume list --availability-domain ${OCI_AD} -c  ${OCI_COMPARTMENT} | jq -r '.data[].id' > boot-vol.txt while IFS="" read -r p || [ -n "$p" ] do   printf 'Seeting backup policy for %s\n' "$p"   oci bv volume-backup-policy-assignment create  --asset-id  $p  --policy-id ${OCI_POL_OCID} done < boot-vol.txt } funct_block_vol (){ #Create a file with all block volume ocid oci bv volume list  -c ${OCI_COMPARTMENT} | jq -r '.data[].id' ...
Postar um comentário
Leia mais

Configurar Tamanho de UNDO e tempo de RETENÇÃO (UNDO_RETENTION)

-- Tamanho Undo Atual SELECT SUM(a.bytes) "UNDO_SIZE" FROM v$datafile a, v$tablespace b, dba_tablespaces c WHERE c.contents = 'UNDO' AND c.status = 'ONLINE' AND b.name = c.tablespace_name AND a.ts# = b.ts#; -- Blocos de UNDO por Seg. SELECT MAX(undoblks/((end_time-begin_time)*3600*24)) "UNDO_BLOCK_PER_SEC" FROM v$undostat; --Tamanho do Bloco SELECT TO_NUMBER(value) "DB_BLOCK_SIZE [KByte]" FROM v$parameter WHERE name = 'db_block_size'; -- Select calcula UNDO RETENTION SELECT d.undo_size/(1024*1024) "ACTUAL UNDO SIZE [MByte]", SUBSTR(e.value,1,25) "UNDO RETENTION [Sec]", ROUND((d.undo_size / (to_number(f.value) * g.undo_block_per_sec))) "OPTIMAL UNDO RETENTION [Sec]" FROM ( SELECT SUM(a.bytes) undo_size FROM v$datafile a, v$tablespace b, dba_tablespaces c WHERE c.contents = 'UNDO' ...
2 comentários
Leia mais