ORACLE DBA'S: December 2016

Thursday, 15 December 2016

runinstall error 11gr2

[oracle@apps15 database]$ ./runInstaller

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 46314 MB Passed

Checking swap space: must be greater than 150 MB. Actual 7999 MB Passed

Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-12-15_05-30-16PM. Please wait ...[oracle@apps15 database]$ #

# An unexpected error has been detected by HotSpot Virtual Machine:

# SIGSEGV (0xb) at pc=0x00000039b4c14d70, pid=4124, tid=140279675725584

# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_30-b03 mixed mode)

# Problematic frame:

# C [ld-linux-x86-64.so.2+0x14d70]

# An error report file with more information is saved as hs_err_pid4124.log

# If you would like to submit a bug report, please visit:

# http://java.sun.com/webapps/bugreport/crash.jsp

solution:-

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

[oracle@apps15 database]$ export LD_BIND_NOW=1

[oracle@apps15 database]$ ./runInstaller

Wednesday, 14 December 2016

How to create context files in apps R12

Database saide:-
=======================================================================

SQL> select name,status from v$database,v$instance;

NAME STATUS
--------- ------------
PROD OPEN

[oracle@apps15 11.1.0]$ lsnrctl status prod

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 14-DEC-2016 15:23:45

Copyright (c) 1991, 2008, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=apps15.com)(PORT=1536)))
STATUS of the LISTENER
------------------------
Alias prod
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 14-DEC-2016 14:19:52
Uptime 0 days 1 hr. 3 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/PROD/db/tech_st/11.1.0/network/admin/PROD_apps15/listener.ora
Listener Log File /u01/oracle/PROD/db/tech_st/11.1.0/log/diag/tnslsnr/apps15/prod/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=apps15.com)(PORT=1536)))
Services Summary...
Service "PROD" has 1 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[oracle@apps15 bin]$ perl adbldxml.pl appsuser=apps appspass=apps

Starting context file generation for db tier..
Using JVM from /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/jre/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/log/adbldxml_12141531.log
UnsatisfiedLinkError exception loading native library: njni11

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

Enter Hostname of Database server: apps15.com

Enter Port of Database server: 1536

Enter SID of Database server: PROD

The context file has been created at:
/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml

( OR )

Database context file creation:-
=======================================================================

[applmgr@apps15 admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adclonectx Version 120.23.12010000.1

Running:
/u02/Apps/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/Apps/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext

Log file located at /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141552.log

Database Host [apps15]:

Database Host Domain [com]:

Database Port [1521]:1536

Database SID:PROD

APPS Schema Name [APPS]:

APPS Schema Password:apps

The following context files are available:

[1] PROD_apps15 (APPL_TOP Context)
[2] PROD_apps15 (Database Context)

Select the context to retrieve [1]:2

Destination file path [/u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml]:

Retrieved context file to /u01/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_apps15.xml

Log file location: /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141552.log

Application Context file creation:-
=================================================================

[applmgr@apps15 admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adclonectx Version 120.23.12010000.1

Running:
/u02/Apps/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u02/Apps/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/u02/Apps/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext

Log file located at /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141549.log

Database Host [apps15]:

Database Host Domain [com]:

Database Port [1521]:1536

Database SID:PROD

APPS Schema Name [APPS]:

APPS Schema Password:apps

The following context files are available:

[1] PROD_apps15 (APPL_TOP Context)
[2] PROD_apps15 (Database Context)

Select the context to retrieve [1]:1

Destination file path [/u02/Apps/inst/apps/PROD_apps15/appl/admin/PROD_apps15.xml]:

Retrieved context file to /u02/Apps/inst/apps/PROD_apps15/appl/admin/PROD_apps15.xml

Log file location: /u02/Apps/inst/apps/PROD_apps15/appl/admin/RetrieveContext_12141549.log

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]$