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

Index SKIP SCAN???

Index Skip Scan nada mais é que o "split" logico de um indice composto, ou seja, se sua clausula WHERE não tiver todos os campos do indice composto, ele é dividido em menores sub-indices Exemplo: -------- SQL> create table teste(a number,b number); Table created. SQL> begin 2 for i in 1..1000 3 loop 4 insert into teste values(i, 56); 5 end loop; 6 end; 7 / PL/SQL procedure successfully completed. SQL> create index idx_teste on teste(a,b); Index created. SQL> analyze table teste compute statistics; Table analyzed. SQL> explain plan for select /*+ index_ss(teste idx_teste) */ * from teste where b=56; Explained. SQL> start ?\rdbms\admin\utlxpls.sql -------------------------------------------------------------------------------- | Operation | Name | Rows | Bytes| Cost | Pstart| Pstop | -------------------------------------------------------------------------------- | SELECT STATEMENT | | 1...
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

OHS 12c noprompt password when stop/start component

cd $OHS_DOMAIN/bin $ ./stopComponent.sh ohs1 Stopping System Component ohs1 ... Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Reading domain from /u01/oracle/domains/ohs_domain Please enter your password : password Connecting to Node Manager ... Successfully Connected to Node Manager. Killing server ohs1 ... Successfully killed server ohs1 Successfully disconnected from Node Manager. Exiting WebLogic Scripting Tool. Done $ OHS_HOME/oracle_common/common/bin $ wlst.sh readDomain('/u01/oracle/domains/ohs_domain') ohs_domain>cd('/SecurityConfiguration/ohs_domain') set('NodeManagerUsername','weblogic') set('NodeManagerPasswordEncrypted','password') updateDomain() closeDomain() exit() $ ./startComponent.sh ohs1  Starting system Component ohs1 ... Initializing WebLogic Scripting Tool (WLST) ... Welco...
Postar um comentário
Leia mais