Regenerate Secure DBC file in Oracle EBS R12, R12.x

Most blog posts that I’ve seen have the directory listed incorrectly. As you’ll see in the following example, you will need to venture down $INST_TOP and not $COMMON_TOP to locate adgendbc.sh.  This instance was recently upgraded from 11.5.10.2 to 12.1.3

Navigate to $INST_TOP/admin/install/

mt-test1[test1 /mttest1/oracle/test1/apps/apps_st/comn]> cd $INST_TOP/admin/install

 

mt-test1[test1 /mttest1/oracle/test1/inst/apps/test1_vm-mt-test1/admin/install]> ls

adadmat.pl     adupdlobs.sql  bisadmprf.sql    gui_key.ini     txkConfigAppsOcm.pl

adadmprf.sh    afadmprf.sh    bisdblrp.sql     ibywebprf.sh    txkEBSWrapper.pl

adadmprf.sql   afadmprf.sql   cctclean.sh      ibywebprf.sql   txkExecSetJaznCredentials.pl

adadmrat.sql   afchgpwd.sh    cctclean.sql     icxwebprf.sql   txkGenDefaultEnv.pl

adapperms.sh   afcpclean.sh   clnadmprf.sql    igccmprf.sh     txkInstSystemJazn.pl

adatccnv.sh    afcpctx.sh     cncmprf.sql      igccmprf.sql    txkJavaMailerCfg.sh

adgendbc.sh    afcpgsm.sh     cooper.sh        jtfictx.sh      txkJavaMailerCfg.sql

adgenjky.sh    afcpgsm.sql    cseadmprf.sql    jtfirip.sql     txkMapViewerDataMerge.pl

admk80ln.sh    afcpnode.sh    csfadmprf.sql    jtfsvfm.sh      txkSystemJAZNDataMerge.pl

admk80ln.sql   afcpnode.sql   csiadmprf.sql    mwa.cfg         txkWebServicescfg.sh

admkpltfrm.sh  afgcsreg.sh    default_key.ini  mwamscasvc.sh   txkWebServicesCfg.sql

admkxdir.sh    afgcsreg.sql   device.cfg       mwamscasvc.sql  txkWfClone.sh

adsvcm.sh      afwebprf.sql   deviceIP.ini     okladmprf.sh    txkWfClone.sql

adupdbid.sql   amscmprf.sql   eamadmprf.sql    okladmprf.sql   wshadmprf.sql

adupdlobs.pl   amswebprf.sql  fteadmprf.sql    oksfrmprf.sql

mt-test1[test1 /mttest1/oracle/test1/inst/apps/test1_vm-mt-test1/admin/install]> ./adgendbc.sh

 

adgendbc.sh started at Thu Dec  5 09:06:13 CST 2013

 

Enter the APPS username: apps

 

Enter the APPS password:

 

SQL*Plus: Release 10.1.0.5.0 – Production on Thu Dec 5 09:06:16 2013

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

Enter value for 1: Enter value for 2: Enter value for 3: Connected.

[ APPS_DATABASE_ID ]

Application Id : 0

Profile Value  : test1

Level Name: SITE

INFO           : Updated/created profile option value.

.

 

PL/SQL procedure successfully completed.

 

Commit complete.

 

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production

With the Partitioning and OLAP options

 

==============================

* * * * DBC PARAMETERS * * * *

==============================

fnd_jdbc_buffer_min=1

fnd_jdbc_buffer_max=5

fnd_jdbc_buffer_decay_interval=300

fnd_jdbc_buffer_decay_size=5

fnd_jdbc_usable_check=false

fnd_jdbc_context_check=true

fnd_jdbc_plsql_reset=false

 

====================================

* * * * NO CUSTOM PARAMETERS * * * *

====================================

 

Unique constraint error (00001) is OK if key already exists

 

Creating the DBC file…

Application server ID already exists for this host – loading..

ADD executed successfully – /mttest1/oracle/test1/inst/apps/test1_vm-mt-test1/appl/fnd/12.0.0/secure/test1.dbc

 

Updating Server Security Authentication

ignoring @test1 specification, using DBC file

AUTHENTICATION SECURE executed successfully – /mttest1/oracle/test1/inst/apps/test1_vm-mt-test1/appl/fnd/12.0.0/secure/test1.dbc

 

adgendbc.sh ended at Thu Dec  5 09:06:25 CST 2013

 

adgendbc.sh exiting with status 0

ERRORCODE = 0 ERRORCODE_END

mt-test1[test1 /mttest1/oracle/test1/inst/apps/test1_vm-mt-test1/admin/install]>

 


Now you have a secure authentication file that you can propagate to the other servers in your environment.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s