Enable SSL Oracle E-Business Suite Release 12

Enable SSL Oracle Application R12 (Apps R12)

The most significant change for Secure Sockets Layer (SSL) support in E-Business Suite Release 12 is the use of the mod_ossl module for the Oracle HTTP Server. Like mod_ssl, the mod_ossl plug-in enables strong cryptography for Oracle HTTP Server. In contrast to the OpenSSL module, mod_ossl is based on the Oracle implementation of SSL, which supports SSL 3, and is based on Certicom and RSA Security technology.

Secure Sockets Layer (SSL)
SSL is a technology that defines the essential functions of mutual authentication, data encryption, and data integrity for secure transactions. Exchange of data between the client and server in such secure transactions is said to use the Secure Sockets Layer (SSL).

SSL uses 2 types of Certificates:
User certificates
These are Certificates issued to servers or users to prove their identity in a public key/private key exchange.

Trusted certificates
These are Certificates representing entities whom you trust - such as certificate authorities who sign the user certificates they issue.


The main steps for setting up SSL on the Middle Tier are:

Method 1

Set Your Environment.
Create a wallet.
Create a Certificate Request.
Submit the Certificate Request to a Certifying Authority
Import your Server Certificate to the Wallet.
Update the JDK Cacerts File
Update the Context File.
Run Autoconfig.
Restart the middle tier services.


Method 2

User Create or Converting Existing Certificates

$INST_TOP/ora/10.1.3/.env

cd $INST_TOP/certs/Apache

Backup the existing wallet files

Creating user Certificates

Pls See the Post Creating User Certificates.

(OR)

Copy server.key, server.crt, and ca.crt to the $INST_TOP/certs/Apache directory.(Converting Existing Certificates)


$ORACLE_HOME/Apache/Apache/bin/ssl2ossl -cert ./server.crt -key ./server.key -cafile ./ca.crt -wallet . -ssowallet yes

cat ca.crt >> $ORACLE_HOME/sysman/config/b64InternetCertificate.txt

cd $OA_JRE_TOP/lib/security directory
Backup the existing cacerts file.
Copy your ca.crt file to this directory
Add your Apache ca.crt to cacerts:
keytool -import -alias ApacheRootCA -file ca.crt -trustcacerts -v -keystore cacerts

Change the Context File.

$echo $CONTEXT_FILE
/apps/oracle/VIS/inst/apps/VIS_sys33/appl/admin/VIS_sys33.xml

Run adautocfg.sh script in the Middle Tier $ADMIN_SCRIPTS_HOME directory

Restart Middle Tier .

Note:376700.1 Enabling SSL in Release 12

Oracle Application R12.0.4 missing oraInventory Create oraInventory

Oracle Application R12.0.4 missing oraInventory Create oraInventory

I have Install Oracle Application R12.0.4 after i will see oraInventory missing

I will Create oraInventory

Solutions

1.cp /etc/oraInst.loc /etc/oraInst.loc.bak

2.cp $ORACLE_HOME/oraInst.loc $ORACLE_HOME/oraInst.loc.bak

3../runInstaller -silent -attachHome ORACLE_HOME="Oracle_Home_Location" ORACLE_HOME_NAME="Oracle_Home_Name"

4. Check $ORACLE_HOME/OPatch/opatch lsinventory

Steps

[oracle@194150-web1 bin]$ ./runInstaller -silent -attachHome ORACLE_HOME="/db01/oracle/VIS/db/tech_st/10.2.0" ORACLE_HOME_NAME="VIS_DB__db01_oracle_VIS_db_tech_st_10_2_0"
Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /home/oracle/oraInventory
/home/oracle/oraInventory/orainstRoot.sh

[root@194150-web1 10.2.0]# /home/oracle/oraInventory/orainstRoot.sh
Changing permissions of /home/oracle/oraInventory to 770.
Changing groupname of /home/oracle/oraInventory to oinstall.
The execution of the script is complete


[oracle@194150-web1 bin]$ $ORACLE_HOME/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.3.4

Oracle Interim Patch Installer version 10.2.0.3.4
Copyright (c) 2007, Oracle Corporation. All rights reserved.


Oracle Home : /db01/oracle/VIS/db/tech_st/10.2.0
Central Inventory : /home/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.4
OUI version : 10.2.0.3.0
OUI location : /db01/oracle/VIS/db/tech_st/10.2.0/oui
Log file location : /db01/oracle/VIS/db/tech_st/10.2.0/cfgtoollogs/opatch/opatch2008-11-21_18-10-37PM.log

Lsinventory Output file location : /db01/oracle/VIS/db/tech_st/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory2008-11-21_18-10-37PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (4):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Products 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 4 products installed in this Oracle Home.


Interim patches (41) :

Patch 6317866 : applied on Wed Jan 16 12:57:15 CST 2008
Created on 20 Aug 2007, 05:13:31 hrs US/Pacific
Bugs fixed:
5254539, 5842961, 5893501, 6041535, 4587572, 5908594, 6167999, 6317851
5084757, 5095815, 5199213, 4686006, 6317866, 5382842, 5302124, 5119354
5073249, 5371149, 5385629, 5960707

Patch 4932527 : applied on Wed Jan 16 12:56:00 CST 2008
Created on 1 Apr 2007, 22:18:45 hrs US/Pacific
Bugs fixed:
4932527

Patch 4882839 : applied on Wed Jan 16 12:54:16 CST 2008
Created on 10 Sep 2007, 06:25:08 hrs US/Pacific
Bugs fixed:
4882839

Patch 5889331 : applied on Wed Jan 16 12:54:06 CST 2008
Created on 6 Jun 2007, 00:33:12 hrs PST8PDT
Bugs fixed:
5889331

Patch 5959099 : applied on Wed Jan 16 12:53:36 CST 2008
Created on 16 Apr 2007, 05:22:53 hrs US/Pacific
Bugs fixed:
5491132, 5694997, 5959099, 5667235, 5253806

Patch 5746153 : applied on Wed Jan 16 12:51:43 CST 2008
Created on 16 Feb 2007, 10:26:31 hrs US/Eastern
Bugs fixed:
5746153

Patch 5668025 : applied on Wed Jan 16 12:51:12 CST 2008
Created on 2 Apr 2007, 06:21:55 hrs US/Pacific
Bugs fixed:
5668025

Patch 5477912 : applied on Wed Jan 16 12:50:41 CST 2008
Created on 14 May 2007, 04:01:25 hrs US/Pacific
Bugs fixed:
5477912

Patch 5392772 : applied on Wed Jan 16 12:50:31 CST 2008
Created on 2 Apr 2007, 06:32:24 hrs US/Pacific
Bugs fixed:
5392772

Patch 5066528 : applied on Wed Jan 16 12:50:00 CST 2008
Created on 2 Apr 2007, 07:30:03 hrs US/Pacific
Bugs fixed:
5066528

Patch 4967236 : applied on Wed Jan 16 12:49:20 CST 2008
Created on 2 Apr 2007, 05:32:08 hrs US/Pacific
Bugs fixed:
4967236

Patch 5206570 : applied on Wed Jan 16 12:47:37 CST 2008
Created on 19 Jan 2007, 05:54:29 hrs US/Pacific
Bugs fixed:
5206570

Patch 4966417 : applied on Wed Jan 16 12:47:01 CST 2008
Created on 2 Mar 2007, 00:58:29 hrs US/Pacific
Bugs fixed:
4966417

Patch 4733582 : applied on Wed Jan 16 12:46:27 CST 2008
Created on 2 Apr 2007, 02:21:29 hrs US/Pacific
Bugs fixed:
4733582

Patch 4054238 : applied on Wed Jan 16 12:46:17 CST 2008
Created on 5 Mar 2007, 23:15:31 hrs US/Pacific
Bugs fixed:
4054238

Patch 4898580 : applied on Wed Jan 16 12:45:47 CST 2008
Created on 8 Nov 2007, 08:42:45 hrs US/Pacific
Bugs fixed:
4898580

Patch 4592596 : applied on Wed Jan 16 12:45:34 CST 2008
Created on 21 Jan 2007, 22:23:42 hrs US/Pacific
Bugs fixed:
4592596

Patch 6121268 : applied on Wed Jan 16 12:43:31 CST 2008
Created on 17 Jun 2007, 02:48:13 hrs PST8PDT
Bugs fixed:
6121268

Patch 6121267 : applied on Wed Jan 16 12:43:26 CST 2008
Created on 17 Jun 2007, 02:26:19 hrs PST8PDT
Bugs fixed:
6121267

Patch 6121266 : applied on Wed Jan 16 12:43:22 CST 2008
Created on 17 Jun 2007, 02:16:12 hrs PST8PDT
Bugs fixed:
6121266

Patch 6121264 : applied on Wed Jan 16 12:43:18 CST 2008
Created on 17 Jun 2007, 02:11:41 hrs PST8PDT
Bugs fixed:
6121264

Patch 6121263 : applied on Wed Jan 16 12:43:10 CST 2008
Created on 17 Jun 2007, 02:11:04 hrs PST8PDT
Bugs fixed:
6121263

Patch 6121261 : applied on Wed Jan 16 12:43:02 CST 2008
Created on 17 Jun 2007, 01:57:24 hrs PST8PDT
Bugs fixed:
6121261

Patch 6121260 : applied on Wed Jan 16 12:42:58 CST 2008
Created on 17 Jun 2007, 01:50:40 hrs PST8PDT
Bugs fixed:
6121260

Patch 6121258 : applied on Wed Jan 16 12:42:47 CST 2008
Created on 17 Jun 2007, 01:47:05 hrs PST8PDT
Bugs fixed:
6121258

Patch 6121257 : applied on Wed Jan 16 12:42:44 CST 2008
Created on 17 Jun 2007, 01:45:01 hrs PST8PDT
Bugs fixed:
6121257

Patch 6121250 : applied on Wed Jan 16 12:42:35 CST 2008
Created on 17 Jun 2007, 03:08:07 hrs PST8PDT
Bugs fixed:
6121250

Patch 6121249 : applied on Wed Jan 16 12:42:22 CST 2008
Created on 17 Jun 2007, 01:37:51 hrs PST8PDT
Bugs fixed:
6121249

Patch 6121248 : applied on Wed Jan 16 12:42:19 CST 2008
Created on 17 Jun 2007, 01:37:06 hrs PST8PDT
Bugs fixed:
6121248

Patch 6121247 : applied on Wed Jan 16 12:42:08 CST 2008
Created on 17 Jun 2007, 01:27:10 hrs PST8PDT
Bugs fixed:
6121247

Patch 6121246 : applied on Wed Jan 16 12:42:00 CST 2008
Created on 17 Jun 2007, 01:24:45 hrs PST8PDT
Bugs fixed:
6121246

Patch 6121245 : applied on Wed Jan 16 12:41:15 CST 2008
Created on 17 Jun 2007, 01:22:56 hrs PST8PDT
Bugs fixed:
6121245

Patch 6121244 : applied on Wed Jan 16 12:41:05 CST 2008
Created on 17 Jun 2007, 01:21:05 hrs PST8PDT
Bugs fixed:
6121244

Patch 6121243 : applied on Wed Jan 16 12:40:54 CST 2008
Created on 17 Jun 2007, 01:18:48 hrs PST8PDT
Bugs fixed:
6121243

Patch 6121242 : applied on Wed Jan 16 12:40:50 CST 2008
Created on 17 Jun 2007, 01:12:31 hrs PST8PDT
Bugs fixed:
6121242

Patch 6121183 : applied on Wed Jan 16 12:40:42 CST 2008
Created on 17 Jun 2007, 01:43:54 hrs PST8PDT
Bugs fixed:
6121183

Patch 6079591 : applied on Wed Jan 16 12:40:38 CST 2008
Created on 17 Jun 2007, 02:51:31 hrs PST8PDT
Bugs fixed:
6079591

Patch 5240469 : applied on Wed Jan 16 12:39:44 CST 2008
Created on 13 Feb 2007, 01:18:47 hrs US/Eastern
Bugs fixed:
5240469

Patch 4247037 : applied on Wed Jan 16 12:38:08 CST 2008
Created on 08 JAN 2008, 14:14:14 hrs US/Pacific
Bugs fixed:
4247037

Patch 5556081 : applied on Fri Oct 26 01:24:56 CDT 2007
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081

Patch 5557962 : applied on Fri Oct 26 01:24:49 CDT 2007
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974



--------------------------------------------------------------------------------

OPatch succeeded.

Upgrade Oracle Financial Services Applications (OFSA) 4.5.2 to Oracle Financial Services Applications (OFSA) 4.5.39

Upgrade Oracle Oracle Financial Data Manager(Oracle FDM) 4.5.2 and Oracle Financial Services Applications(OFSA) 4.5.2 to Oracle Oracle Financial Data Manager(FDM) 4.5.39 and Oracle

Upgrade Oracle Oracle Financial Data Manager(Oracle FDM) 4.5.2 to Oracle Oracle Financial Data Manager(FDM) 4.5.39
1.Download Discoverer Administration Edition, Version 4.1.37

http://download.oracle.com/otn/nt/discoverer/10241_admin.zip

2. Install Discoverer Administration Edition, Version 4.1.37

3.Download Patch Discoverer Administration Edition, Version 4.1.48 (3201601)

4.Upgrade Discoverer Administration Edition Version 4.1.37 to 4.1.48

5.Download Patch 2902123 (OFSA 4.5.39 DATABASE DCP) Selecting a Platform of "Linux x86"

unzip p2902123_450_LINUX.zip

run dbs/patch_4538/patch_4538.sql

6.Download Patch Oracle Financial Services Applications (OFSA) 4.5.39 (2902123) Selecting a Platform of "MicroSoft Windows"

Oracle Financial Services Applications (OFSA) 4.5.2 to Oracle Financial Services Applications (OFSA) 4.5.39

7.Install 16 Bit and 32 Bit Oracle Financial Services Applications (OFSA) 4.5.39

General Protection Fault in Module SQL16W95.DLL Logging In to OFSA 4.5 From Windows 2000 or XP

General Protection Fault in Module SQL16W95.DLL Logging In to OFSA 4.5 From Windows 2000 or XP

Installing OFSA 4.5.39 ,After connect any application get error


Solutions

Remove or rename sql16w95.dll (it is not needed)

(or)

Start->Run box->Regedit

The script adds the following values to the key:
\HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Windows NT\CurrentVersion\Compatibility

OFSPA:REG_SZ:0x00200000
OFSBC:REG_SZ:0x00200000
OFSPORTA:REG_SZ:0x00200000
OFSTP:REG_SZ:0x00200000
OFSRM:REG_SZ:0x00200000
PLUS33:REG_SZ:0x00200000
ORPING:REG_SZ:0x00200000

(or)

Create Regsitry file w2kofsa.reg and Add Bellow lines..

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Compatibility]
"OFSPA"="0x00200000"
"OFSBC"="0x00200000"
"OFSPORTA"="0x00200000"
"OFSTP"="0x00200000"
"OFSRM"="0x00200000"
"PLUS33"="0x00200000"
"ORPING"="0x00200000"

Oracle Application Upgrade 12.0.6 (6728000) Patch Error for Demantra

Oracle E-Business Suite R12 Upgrade 12.0.6 (6728000) Patch Error for Demantra

Error

/u02/oracle/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log

The following Oracle Forms objects did not generate successfully:

au resource MSCDSPOP.pll
au resource MSCFNORD.pll
au resource MSCFPPSC.pll
au resource MSCIOPOP.pll

An error occurred while generating Oracle Forms library files.
Continue as if it were successful [No] :

Case:

Dermatra db link not working ..

Solutions

Fix the Dermantra db link

After run

frmcmp_batch module=$AU_TOP/resource/MSCDSPOP.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCDSPOP.plx module_type=library batch=no compile_all=special

frmcmp_batch module=$AU_TOP/resource/MSCFNORD.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCFNORD.plx module_type=library batch=no compile_all=special

frmcmp_batch module=$AU_TOP/resource/MSCFPPSC.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCFPPSC.plx module_type=library batch=no compile_all=special

frmcmp_batch module=$AU_TOP/resource/MSCIOPOP.pll userid=apps/welcome123 output_file=$AU_TOP/resource/MSCIOPOP.plx module_type=library batch=no compile_all=special

Continue as if it were successful [No] : Yes

Report Builder:Warning: REP-0004: Unable to open user preference file.

Oracle E-Business Suite R12 Report Builder:Release 10.1.2.2.0 Warning: REP-0004: Unable to open user preference file.

Error:

REP-0004: Warning: Unable to open user preference file.

Report Builder: Release 10.1.2.2.0 - Production on Mon Nov 17 14:43:42 2008


Solution

Copy prefs.ora from $ORACLE_HOME/tools/admin to $HOME

cp $ORACLE_HOME/tools/admin/prefs.ora $HOME/prefs.ora

FNDCAPSS Oracle E-Business Suite Change Password

FNDCAPSS Oracle E-Business Suite Change Password
FNDCAPSS Oracle Apps Change Password
[applmgr@sys38 7305220]$ FNDCPASS
Usage: FNDCPASS logon 0 Y system/password mode username new_password
where logon is username/password[@connect]
system/password is password of the system account of that database
mode is SYSTEM/USER/ORACLE
username is the username where you want to change its password
new_password is the new password in unencrypted format
example FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1
FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME

-- Sysadmin Password Change .( eg Sysadmin)

FNDCPASS apps/apps 0 Y system/manager USER sysadmin welcome123

-- Apps Password Change..(eg Apps user)

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS welcome123

-- Oracle Apps User Password Change (eg.. GL,AR,AP)

FNDCPASS apps/apps 0 Y system/manager ORACLE GL gl123

-- ALLORACLE mode changes all oracle schema passwords (11i Need patch 4745998)

FNDCPASS apps/apps 0 Y system/manager ALLORACLE welcome123

The existing ORACLE mode can change only one oracle
schema password. ALLORACLE mode changes all oracle schema passwords at one time
using this command: FNDCPASS apps/apps 0 Y system/manager ALLORACLE welcome1
"All oracle schemas" does not include APPLSYS, APPS, external account, public
account. The effected schema name is based on read_only_flag='A'or'D' inside
fnd_oracle_userid table. We don't touch other accounts with a different
read_only_flag. 'A' means enabled, 'D' means disabled. If the actual oracle
account doesn't exist for a disabled account the "alter user" command to change
password will fail. This will be recorded in the log and is perfectly ok.



Note 363523.1 - Stand Alone Patch For FNDCPASS With 'ALLORACLE' Functionality
Note:398942.1 - FNDCPASS Utility New Feature ALLORACLE

Upgrade Oracle E-Businees Sutie R12.0.6

Upgrade ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6)

The 12.0.6 Release Update Pack (RUP6) combines patches created across the E-Business Suite after the initial release of Oracle Applications 12.0 into a thoroughly tested, high-quality release pack. You apply it only to an existing Release 12.0, 12.0.1, 12.0.2, 12.0.3, 12.0.4, or FIN and HRMS family RUP5 system. Note that RUP6 is cumulative and delivers error corrections and system updates included in RUP1 (12.0.1), RUP2 (12.0.2), and RUP3 (12.0.3), RUP4 (12.0.4), FIN and HRMS family RUP5, along with those included in RUP6 (12.0.6), to bring your 12.0 system to the full 12.0.6 Release Update level.

1.OFF-CYCLE PRODUCTS ===> 6767273

2.R12.AD.A.DELTA.6 (7305220)
3.ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6) (6728000)
4.CONSOLIDATED ONLINE HELP FOR 12.0.6(7109200)


Patch Applying Steps

Pre-install Tasks
1.Apply the Patch R12.AD.A.DELTA.6
R12.AD.A.DELTA.6 (7305220)
Pre-install Tasks for R12.AD.A.DELTA.6
Run perl $AD_TOP/bin/admsi.pl -patch_top=/home/applmgr/patch/7305220 -appspass=apps

[applmgr@sys38 patch]$ perl $AD_TOP/bin/admsi.pl -patch_top=/home/applmgr/patch/7305220 -appspass=apps
Gathering Information..
Logfile for this session is located at admsi.log
Generating installation instructions for patch 7305220..
Updating database....
install_7305220.html generated successfully
install_7305220.txt generated successfully

You must shut down all Application tier services before performing the tasks in this section. Instructions for running AD Grants Run the adgrants.sql script as a user that can connect as
SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
Usage:
1. Create $ORACLE_HOME/appsutil/admin on the database server.
2. Copy adgrants.sql (UNIX) from this patch directory to
$ORACLE_HOME/appsutil/admin.
Or, copy adgrants_nt.sql (Windows) from this patch directory to
%ORACLE_HOME%\appsutil\admin.
3. Set the environment to point to ORACLE_HOME on the database server.
4. Use SQL*Plus to run the script:
UNIX:
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
Windows:
C:\> sqlplus /nolog
SQL> connect / as sysdba
SQL> @%ORACLE_HOME%\appsutil\admin\adgrants_nt.sql

Apply The Patch 7305220

Patch Apply
2. Apply the Patch RUP6
ORACLE E-BUSINESS SUITE 12.0.6 RELEASE UPDATE PACK (RUP6) (6728000)
i)Apply the Patch 6728000
ii)Run Autoconfig.

Post-install Tasks
3. Apply the Patch CONSOLIDATED ONLINE HELP FOR 12.0.6
CONSOLIDATED ONLINE HELP FOR 12.0.6(7109200)
Apply the Patch 7109200

4. Update database tier nodes with the RUP6 code level.
After you have updated to Release 12.0.6, perform the following post-update steps to update all database tier nodes with the code level provided by RUP6:

Application tier:
Run AutoConfig on the APPL_TOP.
Run the admkappsutil.pl utility to create the file appsutil.zip in the /admin/out directory.
perl /bin/admkappsutil.pl

Database tier:
Copy or FTP the appsutil.zip file to the .
Uncompress appsutil.zip under the .
cd unzip -o appsutil.zip
Run AutoConfig on the .

ORA-12705: Cannot access NLS data files or invalid environment specified

Upgare Oracle E-Business Suite R12.0.0 to R12.0.4 After runing adautocfg.sh geting Error ORA-12705: Cannot access NLS data files or invalid environment specified

Autoconfig Log

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:


[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/VIS/db/tech_st/10.2.0/appsutil/install/VIS_sys38
afdbprf.sh INSTE8_PRF 1

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/VIS/db/tech_st/10.2.0/appsutil/install/VIS_sys38
adcrobj.sh INSTE8_APPLY 1


AutoConfig is exiting with status 2


adcrobj.sh started at Sun Nov 16 02:21:23 IST 2008

Parameters passed are : -nopromptmsg

The environment settings are as follows ...

ORACLE_HOME : /u01/oracle/VIS/db/tech_st/10.2.0
ORACLE_SID : VIS
TWO_TASK :
PATH : /u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/VIS/db/tech_st/10.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/perl/bin:/u01/oracle/VIS/db/tech_st/10.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/VIS/db/tech_st/10.2.0/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin
Library Path : /u01/oracle/VIS/db/tech_st/10.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/VIS/db/tech_st/10.2.0/lib:/usr/dt/lib:/u01/oracle/VIS/db/tech_st/10.2.0/ctx/lib

SQLPLUS Executable : /u01/oracle/VIS/db/tech_st/10.2.0/bin/sqlplus


SQL*Plus: Release 10.2.0.2.0 - Production on Sun Nov 16 02:21:23 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified


adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.


Solution:


1.Check $ORA_NLS10
2.Check ORACLE_HOME/nls/data/9idata
3.Check xml file in the Parameter s_db_oranls
/u01/oracle/VIS/db/tech_st/10.2.0/ocommon/nls/admin/data
Change $ORA_NLS10 Path
/u01/oracle/VIS/db/tech_st/10.2.0/nls/data/9idata

or

Create $ORACLE_HOME/nls/data/old/cr9idata.pl

Create nls/data/9idata directory

cd $ORACLE_HOME/nls/data/old

perl cr9idata.pl

Creating directory /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata ...
Copying files to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /u01/app/oracle/product/10.2.0/db_1/nls/data/9idata!

export ORA_NLS10=$ORACLE_HOME/nls/data/9idata

Oracle E-Business Suite 11i Cloning Steps

Oracle E-Business Suite 11i Cloning Steps

PreClone Steps:

1.Pre-clone for db Tier

In the Location :

/u01/app/oracle/uatdb/9.2.0/appsutil/scripts/UAT_apps/

perl adpreclone.pl dbTier

2. Pre-clone for appsTier

In the Location:

/u01/app/apps/uatcomn/admin/scripts/UAT_apps/

perl adpreclone.pl appsTier

Note: While running the preclone in the apps Tier its better to be down and database can be Up and Running.But the Order must be dbTier and then appsTier.


Post Clone Steps:

Post Clone for dbTier :

1.Install the Necessary RPM's
2.Check for the Network
3.Make sure the user and Groups.
4.Check for the ORACLE_HOME and PATH
5.Check for Permissions for folders.
5.Now run the post clone from the following location.

Location : /u01/app/oracle/uatdb/9.2.0/appsutil/clone/bin

6.[oracle@apps bin]$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]: xxxx

First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:


Provide the values required for creation of the new Database Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:

Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:

Target System database name [UAT]:

Target system RDBMS ORACLE_HOME directory [/u01/app/oracle/uatdb/9.2.0]:

Target system utl_file accessible directories list [/usr/tmp]:

Number of DATA_TOP's on the target system [1]:

Target system DATA_TOP 1 [/u01/app/oracle/uatdata]:

Do you want to preserve the Display set to apps:0.0 (y/n) [y] ?:

Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:
10

Checking the port pool 10
done: Port Pool 10 is free
Database port is 1531

Backing up /u01/app/oracle/uatdb/9.2.0/appsutil/UAT_apps.xml to /u01/app/oracle/ uatdb/9.2.0/appsutil/UAT_apps.xml1.bak

Creating the new Database Context file from :
/u01/app/oracle/uatdb/9.2.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
/u01/app/oracle/uatdb/9.2.0/appsutil/UAT_apps.xml

Log file located at /u01/app/oracle/uatdb/9.2.0/appsutil/clone/bin/CloneContext_ 06020557.log

Running Rapid Clone with command:
perl /u01/app/oracle/uatdb/9.2.0/appsutil/clone/bin/adclone.pl java=/u01 /app/oracle/uatdb/9.2.0/appsutil/clone/bin/../jre mode=apply stage=/u01/app/orac le/uatdb/9.2.0/appsutil/clone/bin/.. component=dbTier method=CUSTOM dbctxtg=/u01 /app/oracle/uatdb/9.2.0/appsutil/UAT_apps.xml showProgress contextValidated=tru e

Beginning database tier Apply - Mon Jun 2 17:57:29 2008
Log file located at /u01/app/oracle/uatdb/9.2.0/appsutil/log/UAT_apps/ApplyDBTie r_06020557.log


Completed Apply...
Mon Jun 2 18:02:27 2008

Beginning APPSDB_UAT registration to central inventory...

ORACLE_HOME NAME : APPSDB_UAT
ORACLE_HOME PATH : /u01/app/oracle/uatdb/9.2.0
Using Inventory location in /etc/oraInst.loc
Log file located at /home/oracle/oraInventory/logs/OracleHomeCloner_06020602.log
ORACLE_HOME /u01/app/oracle/uatdb/9.2.0 was registered successfully.

Starting database listener for UAT:
Running:
/u01/app/oracle/uatdb/9.2.0/appsutil/scripts/UAT_apps/addlnctl.sh start UAT

You are running addlnctl.sh version 115.6

Logfile: /u01/app/oracle/uatdb/9.2.0/appsutil/log/UAT_apps/addlnctl.txt

Starting listener process UAT ...


Listener UAT has already been started.


addlnctl.sh: exiting with status 0

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

Note:While Running post clone both the Tier will be down and first run the dbTier, Now it will automatically up and running after the end of dbtier cloning and then run for appsTier.

Location :/u01/app/apps/uatcomn/clone/bin

[applmgr@apps bin]$ perl adcfgclone.pl appsTier
Enter the APPS password [APPS]: xxxx
First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:


Provide the values required for creation of the new APPL_TOP Context file.

Do you want to use a virtual hostname for the target node (y/n) [n] ?:

Target system database SID [UAT]:

Target system database server node [apps]:

Target system database domain name [doyen.com]:

Does the target system have more than one application tier server node (y/n) [n] ?:

Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:

Target system APPL_TOP mount point [/u01/app/apps/uatappl]:

Target system COMMON_TOP directory [/u01/app/apps/uatcomn]:

Target system 8.0.6 ORACLE_HOME directory [/u01/app/apps/uatora/8.0.6]:

Target system iAS ORACLE_HOME directory [/u01/app/apps/uatora/iAS]:

Do you want to preserve the Display set to apps:0.0 (y/n) [y] ?:

Clone Context uses the same port pool mechanism as the Rapid Install
Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:
10

Checking the port pool 10
done: Port Pool 10 is free
Web Listener port is 8010
Complete port information available at /u01/app/apps/uatappl/admin/out/UAT_apps/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /u01/app/oracle/uatdb/9.2.0/appsutil/outbound/UAT_apps
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:3

Backing up /u01/app/apps/uatappl/admin/UAT_apps.xml to /u01/app/apps/uatappl/admin/UAT_apps.xml2.bak

Creating the new APPL_TOP Context file from :
/u01/app/apps/uatappl/ad/11.5.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
/u01/app/apps/uatappl/admin/UAT_apps.xml

Log file located at /u01/app/apps/uatcomn/clone/bin/CloneContext_06020611.log

Running Rapid Clone with command:
perl /u01/app/apps/uatcomn/clone/bin/adclone.pl java=/u01/app/apps/uatcomn/clone/bin/../jre mode=apply stage=/u01/app/apps/uatcomn/clone/bin/.. component=appsTier method=CUSTOM appctxtg=/u01/app/apps/uatappl/admin/UAT_apps.xml showProgress contextValidated=true

/etc/oraInst.loc points to an Inventory that does not exist:
/home/applmgr/oraInventory
Inventory Directory created...
Beginning application tier Apply - Mon Jun 2 18:12:07 2008
Log file located at /u01/app/apps/uatappl/admin/UAT_apps/log/ApplyAppsTier_06020612.log


Completed Apply...
Mon Jun 2 18:21:15 2008

Beginning APPSIAS_UAT registration to central inventory...

ORACLE_HOME NAME : APPSIAS_UAT
ORACLE_HOME PATH : /u01/app/apps/uatora/iAS
Using Inventory location in /etc/oraInst.loc
Log file located at /home/applmgr/oraInventory/logs/OracleHomeCloner_06020621.log
ORACLE_HOME /u01/app/apps/uatora/iAS was registered successfully.

Starting application Services for UAT:
Running:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/adstrtal.sh APPS/

You are running adstrtal.sh version 115.14

Executing service control script:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/adapcctl.sh start
script returned:
****************************************************

adapcctl.sh version 115.43

Starting Apache Web Server Listener (dedicated HTTP) ...
Starting Apache Web Server Listener (dedicated PLSQL) ...

adapcctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version

Checking for FNDFS executable.
Starting listener process APPS_UAT.

adalnctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 115.20

Starting concurrent manager for UAT ...
Starting UAT_0602@UAT Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/adfrmctl.sh start
script returned:
****************************************************

You are running adfrmctl.sh version 115.34

Starting forms server for UAT on port 9010.

adfrmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/adrepctl.sh start
script returned:
****************************************************

You are running adrepctl.sh version 115.29

starting Reports Server for UAT on port 7010.

adrepctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/adfmcctl.sh start
script returned:
****************************************************

You are running adfmcctl.sh version 115.17

Starting forms load balancing client for UAT.

adfmcctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/adfmsctl.sh start
script returned:
****************************************************

You are running adfmsctl.sh version 115.13

starting forms metrics server for UAT.

adfmsctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 115.16

Validating Fulfillment patch level via /u01/app/apps/uatcomn/java
Fulfillment patch level validated.
Starting Fulfillment Server for UAT on port 9310 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/app/apps/uatcomn/admin/scripts/UAT_apps/addisctl.sh start
script returned:
****************************************************

addisctl.sh version 115.14

/u01/app/apps/uatora/8.0.6/vbroker/bin/osagent
Started osagent.
Osagent logs messages to the file /u01/app/apps/uatora/8.0.6/discwb4/util/osagent.log.
Waiting for OAD to start...
Started OAD.
OAD logs messages to the file /u01/app/apps/uatora/8.0.6/discwb4/util/oad.log.
Discoverer Locator Started.
Locator logs messages to the file /u01/app/apps/uatora/8.0.6/discwb4/util/locator.log.

addisctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


All enabled services for this node are started.
Check logfile /u01/app/apps/uatcomn/admin/log/UAT_apps/06021821.log for details

Exiting with status 0


Note:

By Default all the services are started at the end of that Tier cloning. And while it asks for oraInst.loc mention the old path when we give in database creation. If it asks to run a script then edit and see the script, It may have mentioned the different path. so edit that and save what we have given while running database.

Install Oracle E-Business Suite R12 Required Space

Oracle Application R12(EBS) Required Space for Vision Database.

Application Tier File System Architecture

Oracle DB Server

Oracle Home The location of the 10g R2 ORACLE_HOME (database home), which contains files for running and maintaining the RDBMS.

Data Top (SYS) ==> Derived from the Base Install directory, this is the mount point for all database system files.
Data Top (LOG) ==> Derived from the Base Install directory, this is the mount point for all database log files.
Data Top (TXN) ==> Derived from the Base Install directory, this is the mount point for all transaction data and index files.
Data Top (ARCHIVE) ==>Derived from the Base Install directory, this is the mount point for all archive, media, advanced queue, summary,and undo files.

ORACLE_HOME(tech_st) = 4.2G
DATA_TOP(apps_st) = 128G

Oracle Application Server

Base Install directory ==> The top-level directory that Rapid Install uses to install the Applications node technology stack . All subdirectory names are derived from this directory.

Instance directory ==> The top-level directory for an Applications instance. This directory is referred to as the Instance Home, and denoted by the environment variable $INST_TOP.

COMMON_TOP ==> Holds directories for files used across products or in conjunction with third-party products. It contains the following subdirectories:
• admin - contains several subdirectories used for concurrent manager log and out directories, scripts used during installation,and scripts used for daily maintenance of the instance.
• html - contains files used by html-based products such as JSP files, java scripts, xml files, and style sheets.
• java - location of all JAR files. Also holds third-party Java files and other zip files.
• portal - contains Rapid Install Portal files.The Rapid Install Portal is a web page thatprovides access to post-installation tasks,Server Administration scripts, installation documentation, and online help.
• temp - used for caching by certain processes such as Oracle Reports.
• util - contains third-party utilities such as JDK, JRE, and Unzip.

Tools ORACLE_HOME ==> The AS 10.1.2 ORACLE_HOME directory, used for the Developer 10i products (Forms and Reports).

Web ORACLE_HOME ==> The AS 10.1.3 ORACLE_HOME directory, used for the Oracle HTTP Server. Sometimes also referred to as the Java ORACLE_HOME. Temp Directory Contains temporary files. This directory is not used during installation.

APPL_TOP(apps_st)=19G
COMMON_TOP(apps_st)=3.1G
ORACLE_HOME(tech_st)=2.6G

INST_TOP=474M

Total Requried =159G

Oracle R12 Installing Error Part-I

Oracle R12 Installing Error
Error:

$./rapidwiz

I found this error " Exception in thread "main" java.lang.UnsatisfiedLinkError:

/app03/StageR12/startCD/Disk1/rapidwiz/jre/Linux_x64/1.5.0/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory".

Workaround:

Run ldd libmawt.so

[root@194150-web1 xawt]# ldd libmawt.so
linux-gate.so.1 => (0xffffe000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0xf7fa4000)
libm.so.6 => /lib/tls/libm.so.6 (0xf7f81000)
libmlib_image.so => not found
libawt.so => not found
libXext.so.6 => not found
libX11.so.6 => not found
libdl.so.2 => /lib/libdl.so.2 (0xf7f7c000)
libjava.so => not found
libjvm.so => not found
libc.so.6 => /lib/tls/libc.so.6 (0xf7e4d000)
/lib/ld-linux.so.2 (0x56555000)

Solution:

Install X11 packages and Install Below all the RPMS WITH THEIR PREQUISTIES for Oracle R12.

binutils-2.15.92.0.2-21.x86_64.rpm
compat-db-4.1.25-9.i386.rpm (32-bit)
compat-db-4.1.25-9.x86_64.rpm
control-center-2.8.0-12.rhel4.5.x86_64.rpm
gcc-3.4.6-3.x86_64.rpm
gcc-c++-3.4.6-3.x86_64.rpm
glibc-2.3.4-2.25.i686.rpm (32-bit)
glibc-2.3.4-2.25.x86_64.rpm
glibc-devel-2.3.4-2.25.i386.rpm (32-bit)
glibc-devel-2.3.4-2.25.x86_64.rpm
glibc-common-2.3.4-2.25.x86_64.rpm
gnome-libs-1.4.1.2.90-44.1.x86_64.rpm
libstdc++-3.4.6-3.i386.rpm (32-bit)
libstdc++-3.4.6-3.x86_64.rpm
libstdc++-devel-3.4.6-3.i386.rpm (32-bit)
libstdc++-devel-3.4.6-3.x86_64.rpm
libgcc-3.4.6-3.i386.rpm (32-bit)
libgcc-3.4.6-3.x86_64.rpm
make-3.80-6.EL4.x86_64.rpm
pdksh-5.2.14-30.3.x86_64.rpm
setarch-1.6-1.x86_64.rpm
sysstat-5.0.5-11.rhel4.x86_64.rpm
xscreensaver-4.18-5.rhel4.11.x86_64.rpm
openmotif21-2.1.30-11.RHEL4.6.i386.rpm**
libaio-0.3.105-2.x86_64.rpm
libaio-0.3.105-2.i386.rpm (32-bit)
libaio-devel-0.3.105-2.x86_64.rpm

After Installed Check

ldd libmawt.so
[root@sys38 xawt]# ldd libmawt.so
/usr/lib/libcwait.so (0x001dd000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x0055d000)
libm.so.6 => /lib/tls/libm.so.6 (0x00915000)
libmlib_image.so => not found
libawt.so => not found
libXext.so.6 => /usr/X11R6/lib/libXext.so.6 (0x002db000)
libX11.so.6 => /usr/X11R6/lib/libX11.so.6 (0x001df000)
libdl.so.2 => /lib/libdl.so.2 (0x00f78000)
libjava.so => not found
libjvm.so => not found
libc.so.6 => /lib/tls/libc.so.6 (0x002e9000)
/lib/ld-linux.so.2 (0x00456000)

Native PL/SQL compilation

Native PL/SQL compilation

Native compilation is a way of speeding up PL/SQL procedures by compiling them into native code residing shared libraries. The procedures are translated into C code and then compiled with an by Oracle certified C-compiler and linked into the Oracle process.Procedures compiled this way will work in all server environments as dedicated connections, shared connections (formerly known as MTS) and starting with 10g even within a Real Application Cluster (RAC) environment.


connect scott/tiger
CREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
IF (n = 1) OR (n = 2) THEN
RETURN 1;
ELSE
RETURN fib(n - 1) + fib(n - 2);
END IF;
END fib;
/

connect / as sysdba
alter system set plsql_native_library_dir='/home/oracle/native10g' scope=both;

connect scott/tiger
alter session set plsql_code_type = 'INTERPRETED';
alter function fib compile;
select object_name,param_name,param_value
from user_stored_settings
where object_name = 'FIB';
set serveroutput on
set timing on
declare
x number;
begin
x := fib(40);
dbms_output.put_line(x);
end;
/

set timing off
connect / as sysdba
alter system flush shared_pool;

connect scott/tiger
alter session set plsql_code_type = 'NATIVE';
alter function fib compile;
select object_name,param_name,param_value
from user_stored_settings
where object_name = 'FIB';
set serveroutput on
set timing on
declare
x number;
begin
x := fib(40);
dbms_output.put_line(x);
end;
/

INTERPETED
Elapsed: 00:02:05.08
NATIVE
Elapsed: 00:01:12.39



SQL> connect scott/tiger
Connected.
SQL> CREATE OR REPLACE FUNCTION fib (n POSITIVE) RETURN INTEGER IS
BEGIN
IF (n = 1) OR (n = 2) THEN
RETURN 1;
ELSE
RETURN fib(n - 1) + fib(n - 2);
END IF;
END fib;
/ 2 3 4 5 6 7 8 9

Function created.

SQL> connect / as sysdba
Connected.
SQL> alter system set plsql_native_library_dir='/home/oracle/native10g' scope=both;

System altered.

SQL> connect scott/tiger
Connected.
SQL> alter session set plsql_code_type = 'INTERPRETED';
alter function fib compile;

Session altered.

SQL>
Function altered.

SQL> set serveroutput on
set timing on
declare
x number;
begin
x := fib(40);
dbms_output.put_line(x);
end;
/SQL> SQL> 2 3 4 5 6 7

102334155

PL/SQL procedure successfully completed.

Elapsed: 00:02:05.08
SQL> SQL> set timing off
connect / as sysdba
alter system flush shared_pool;SQL> Connected.
SQL>

System altered.

SQL>

SQL> connect scott/tiger
Connected.
SQL> alter session set plsql_code_type = 'NATIVE';
alter function fib compile;
Session altered.

SQL>

Function altered.

SQL> set serveroutput on
set timing on
declare
x number;
begin
x := fib(40);
dbms_output.put_line(x);
end;
/SQL> SQL> 2 3 4 5 6 7
102334155

PL/SQL procedure successfully completed.

Elapsed: 00:01:12.39

After IP Change Oracle APPS R12 Web Application Services Failed

After IP Change Oracle APPS R12 Web Application Services Failed

oafm,forms,oacore status down

ERROR Message...

Oracle Apps stratup Log

Root Service Oracle Process Manager for VIS_sys38 adopmnctl.sh Started
Web Entry Point Services Oracle HTTP Server VIS_sys38 adapcctl.sh Failed
Web Application Services OACORE OC4J Instance VIS_sys38 adoacorectl.sh Failed
Web Application Services FORMS OC4J Instance VIS_sys38 adformsctl.sh Failed
Web Application Services OAFM OC4J Instance VIS_sys38 adoafmctl.sh Failed
Batch Processing Services OracleTNSListenerAPPS_VIS_sys38 adalnctl.sh Started
Batch Processing Services OracleConcMgrVIS_sys38 adcmctl.sh Started
Batch Processing Services Oracle ICSM VIS_sys38 ieoicsm.sh Disabled
Batch Processing Services Oracle Fulfillment Server VIS_sys38 jtffmctl.sh Started
Other Services Disabled
Other Services OracleFormsServer-Forms VIS_sys38 adformsrvctl.sh Disabled
Other Services Oracle Metrics Client VIS_sys38 adfmcctl.sh Disabled
Other Services Oracle Metrics Server VIS_sys38 adfmsctl.sh Disabled
Other Services Oracle MWA Service VIS_sys38 mwactlwrpr.sh Disabled


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

APPS R12 Web Application Services Logs..

11/10/08-19:18:43 :: adoacorectl.sh version 120.11.12000000.2


11/10/08-19:18:43 :: adoacorectl.sh: starting OPMN if it is not running

opmnctl: opmn is already running.

11/10/08-19:18:43 :: adoacorectl.sh: Starting OPMN managed OACORE OC4J instance

opmnctl: starting opmn managed processes...
================================================================================
opmn id=sys38.doyen.in:6200
0 of 1 processes started.

ias-instance id=VIS_sys38.sys38.doyen.in
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
OC4J/oacore/default_group/

Error
--> Process (index=1,uid=1832654593,pid=29902)
failed to start a managed process after the maximum retry limit
Log:
/u02/oracle/VIS/inst/apps/VIS_sys38/logs/ora/10.1.3/opmn/OC4J~oacore~default_group~1


11/10/08-19:19:14 :: adoacorectl.sh: exiting with status 204


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

OPMN managed OACORE OC4J instance Logs..


[applmgr@sys38 ~]$ sh /u02/oracle/VIS/inst/apps/VIS_sys38/admin/scripts/adoacorectl.sh status

You are running adoacorectl.sh version 120.11.12000000.2

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: VIS_sys38.sys38.doyen.in
-------------------+--------------------+---------+---------
ias-component process-type pid status
-------------------+--------------------+---------+---------
OC4J oafm N/A Down
OC4J forms N/A Down
OC4J oacore N/A Down
HTTP_Server HTTP_Server 29760 Alive


adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /u02/oracle/VIS/inst/apps/VIS_sys38/logs/appl/admin/log/adoacorectl.txt for more information ...


Solution


1.Stop Oracle Apps Tier (Stop Oracle Apps Servies)

2. cd $INST_TOP/ora/10.1.3/j2ee

rm -fr oacore/persistence/*
rm -fr oafm/persistence/*
rm -fr forms/persistence/*

3.Start Oracle Apps Tier (Start Oracle Apps Servies)

4.adoacorectl.sh status

[applmgr@sys38 persistence]$ sh /u02/oracle/VIS/inst/apps/VIS_sys38/admin/scripts/adoacorectl.sh status

You are running adoacorectl.sh version 120.11.12000000.2

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: VIS_sys38.sys38.doyen.in
-------------------+--------------------+---------+---------
ias-component process-type pid status
-------------------+--------------------+---------+---------
OC4J oafm 31945 Alive
OC4J forms 31874 Alive
OC4J oacore 31780 Alive
HTTP_Server HTTP_Server 29760 Alive


adoacorectl.sh: exiting with status 0

Oracle Application Express Authentication with Oracle E-Business Suite (EBS)

Oracle Application Express Authentication with Oracle E-Business Suite (Apps 11i)

1.Login Oracle Application Express Workspace.

http://192.168.0.9:7777/pls/apex

2.Click SQl Workshop

3.Click SQL Commands

a.Create DB link in Oracle E-Business Suite (Apps 11i)
b.Create function apex_ebs_login



create or replace function apex_ebs_login (p_username IN VARCHAR2, p_password IN VARCHAR2)
return boolean
as
begin
if fnd_web_sec.validate_login@apps(p_username, p_password) = 'Y' then
return true;
else
return false;
end if;
end;

Note :- DB Link Name (@apps)

4.Select Application (exiting Application)

5.Click Shared Components

Select Authentication Schemes
6.Click Create
7.Select For scratch and Click Next

8.Name : EBS_APEX_LOGIN
Description :Oracle Application Express Authentication with Oracle E-Business Suite (Apps 11i) Click Next
9.Click Next
10.Click Next
11.Select Application Express Built-in Login Page Click Next
12.Click Next
13. Select Use my custom function to authenticate
Authentication Function : return apex_ebs_login;
14.Click Next
15.Click Next
15.Logout URL
wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1:&SESSION
Click Next
16.Click Create Scheme
17.Click Chanage current
18.Available Authentication Schemes: EBS_APEX_LOGIN
19.Click Make Current
20.Click Run Application
21. Username : sysadmin Password : xxxxxx

PDF Printing in Oracle Application Express

PDF Printing in Oracle Application Express (APEX)
Configuring Oracle Application Express to use BI Publisher
To use BI Publisher as your Report Server, first, access the Report Printing parameters:

Access the Administration Services home page
Select Manage Service
Select Instance Settings, under Manage Environment Settings
Click Report Printing to focus on just the Report Printing attributes

Now, specify the following attributes:

Oracle BI Publisher: Advanced Support
Print Server Protocol: HTTP or HTTPS (depends on your configuration)
Print Server Host Address: the hostname for the machine where you installed BI Publisher - e.g. sys9.doyen.in (or) 192.168.0.9
Print Server Port: the port given at the end of the BI Publisher installation - e.g. 9704
Print Server Script: /xmlpserver/convert