Wednesday, 14 December 2016

How to create DBC file if it is deleted

database and application is running 

[applmgr@apps15 install]$ cd $FND_SECURE

[applmgr@apps15 install]$ pwd

/u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure

[applmgr@apps15 secure]$ ls


[applmgr@apps15 secure]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@apps15 scripts]$ pwd
/u02/Apps/inst/apps/PROD_apps15/admin/scripts

[applmgr@apps15 scripts]$ cd ../install/
[applmgr@apps15 install]$ pwd
/u02/Apps/inst/apps/PROD_apps15/admin/install

[applmgr@apps15 install]$ sh adgendbc.sh

adgendbc.sh started at Wed Dec 14 14:50:46 IST 2016


Enter the APPS username: apps

Enter the APPS password:

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Dec 14 14:50:53 2016

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  : PROD
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.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Params=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


Unique constraint error (00001) is OK if key already exists
Application server ID already exists for this host - loading..
ADD executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc

Trying to update information ...

Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc
Updating parameters:  fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5 fnd_jdbc_buffer_decay_interval=300
Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc
Updating parameters:  fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable_check=false fnd_jdbc_context_check=true
Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc
Updating parameters:  fnd_jdbc_plsql_reset=false
Changed GUEST_USER_PWD to GUEST/ORACLE
UPDATE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc

Updating Server Security Authentication
AUTHENTICATION SECURE executed successfully - /u02/Apps/inst/apps/PROD_apps15/appl/fnd/12.0.0/secure/PROD.dbc
adgendbc.sh exiting with status 0
ERRORCODE = 0 ERRORCODE_END


[applmgr@apps15 install]$ cd $FND_SECURE

[applmgr@apps15 secure]$ ls
PROD.dbc
[applmgr@apps15 secure]$

No comments:

Post a Comment