Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Thursday, December 09, 2010

Mismanaged Session Cookie JRE 1.6.0 Update 23

This is great News from oracle, that the new Version of JRE 1.6.0 Update 23 is being certified to use with Oracle EBS.

Those who are all working with JRE for forms, update as soon as possible. (11i and R12)
As seen in

http://blogs.oracle.com/stevanChan

Mismanaged Session Cookie Issue Fixed for EBS in JRE 1.6.0_23

jceecolorlogo2.gifAt last: some good news for those of you affected by the mismanaged session cookie issue in E-Business Suite environments. This issue is resolved by the latest Sun Java Runtime Environment 1.6.0_23 (a.k.a. JRE 6u23, internal version 1.6.0_23-b05).

See the 1.6.0_23 Update Release Notes for details about what has changed in this release. This release is available for download from the usual Sun channels and through the 'Java Automatic Update' mechanism.

This JRE release has been certified with both Oracle E-Business Suite Release 11i and 12. We recommend this release for all E-Business Suite users.

References
Related Articles

Wednesday, December 01, 2010

Apex 4.0.2 Configured with Oracle EBS 12.1.2

This post is about the integration of Oracle Application Express 4.0.2 with Oracle EBS 12.1.2 with oracle Application server 10.1.3.1 in the middle.

Operating System: Redhat - Linux 4 update 5
Database : 10.2.0.4
Application Server 10g: 10.1.3.1.0

Oracle E Business Suite: 12.1.2 with 11g Database (11.1.0.7)

The steps to be done:

1. Install oracle Database (Installed 10.2.0.1 and upgraded to 10.2.0.4)

Oracle Database to be installed with enterprise option.

Oracle Database upgraded to 10.2.0.4.
Detailed Upgrade steps can be obtained from (http://balajiabhi.blogspot.com/2009/02/install-soa-and-bpel-part-1.html) or click here

2. Install and configure Oracle SOA Suite 10g (10.1.3.1)
Installation and configuration Steps are detailed here


3. Oracle Application Express 4.0.2 can be obtained here (download)

4. Unzip the Apex402.zip into a location in the server.

5. Login to the EBS Database owner and connect as sys user.
[oracle@fserver apex]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 1 13:17:13 2010

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace APEX402 datafile '/oracle2/db/apps_st/data/apex402.dbf' size 1G autoextend on;

Tablespace Created.

After creating the tablespace, exit from the sqlplus window, navigate to the folder where we unzipped the Apex402 Zip file.

from that location, again connect as sys user

SQL> @apexins.sql apex402 apex402 temp /i/

here apex402 is the tablespace
apex402 is the datafile,
temp is temporary tablespace by default
/i/ is the location of the image files. (simply specify /i/ at this time)

Once the process started, keep watching the logfile for the errors. Log file will be created at the base location of apex source files (Unzipped location)


...Adjust Oracle APEX Application owner to install owner

13 rows updated.


Commit complete.

...Adjust Application Express (APEX) version

FLOW_VERSION
--------------------------------------------------------------------------------
4.0.2.00.06

1 row selected.


12 rows updated.


1 row updated.


Commit complete.


User altered.


User altered.


PL/SQL procedure successfully completed.

-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
-- Switching builder to new schema -------
-- Migrating SQL Workshop metadata -------
-- Upgrading new schema. -------


PL/SQL procedure successfully completed.

-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
-- Switching builder to new schema -------
-- Migrating SQL Workshop metadata -------
-- Upgrading new schema. -------
-- Copying preferences to new schema. -------
Upgrade completed successfully no errors encountered.
-- Upgrade is complete -----------------------------------------
timing for: Upgrade
Elapsed: 00:01:14.28



Thank you for installing Oracle Application Express.

Oracle Application Express is installed in the APEX_040000 schema.

The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

JOB_QUEUE_PROCESSES: 2

Performing Application Express component validation - please wait...

Completing registration process. 13:35:57
Validating installation. 13:35:57
...Database user "SYS", database schema "APEX_040000", user# "587" 13:35:57

Once you see this message, the Apex installation to the Oracle EBS database is completed.

unlock the APEX_PUBLIC_USER account.
Change the password using @apxchpwd.sql from apex directory.



6. Navigate to the Application server installed directory.

Copy the image files:

Copy the image files from the Apex Base directory to someother directory in the Application server installed directory.

In my case it is APPLICATION_SERVER_BASE/images



7. Move to Apache/modplsql/conf directory and edit the dads.conf file.

Add the entry like this:
Alias /i/ "/home/oraappload/product/10.1.3.1/OracleAS_2/images/"
AddType text/xml xbl
AddType text/x-component htc

<Location /pls/apex_R12>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString fserver.fdomain:1550:VIS1212 [Hostname:DBListenerPort:SID]
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword welcome [Password chosen by running apxchpwd.sql]
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
Allow from all
</Location>

Bounce the opmn using

Application_server_base/opmn/bin/./opmnctl stopall

and

Application_server_base/opmn/bin/./opmnctl startall

Login to the Apex using the URL from Application server:

http://localhost:port/pls/apex_r12/apex_admin

this will bring the Apex login screen, login with the username admin and password as specified during the apex install

then create the workspaces as requested from the admin page.









If You are getting ADMIN/ADMIN_PASSWORD as "Invalid Login Credential Error", then
run

SQL> alter user APEX_040000 identified by welcome account unlock;

User altered.

SQL> conn APEX_040000/welcome;
Connected.
SQL> begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);

wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin2',
p_email_address => 'myemail@mydomain.com', (Change as per req)
p_web_password => 'admin2') ;

end;
/ 2 3 4 5 6 7 8 9 10

PL/SQL procedure successfully completed.


SQL> alter user APEX_040000 account lock;

User altered.

SQL>


Cheers.....

Previous Posts of Application Express from my blog (Complete List)

Apex Installation and configuration:

Apex 3.1 Installation with Oracle Databases:

Apex with Oracle EBS 11i

Apex 3.2 with Oracle EBS 12.0.6

Cheers..
Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Labels

11.5.1. to 11.5.5 Cloning Procedure. 11g 11i 11i and R12 11i Autoconfig 11i Cloning 12.1.1 SSL 2 Node RAC Adconfig.sh errors out adgennls.pl adop Advanced Replication Apache version Apex Apex for Oracle database Apex Installation Apex Installation on Oracle E Business Suite. 11i with Apex Apex on 11i Apex on Oracle 11i Apex402 apexins.sql APPL_TOP Character Application Express Application server Issue APPLSYS password Apps Password Asynchronous Replication Autoconfig Autoconfig Managed Beehive Bit of operating system Block block media corrupt BPEL Central Inventory Character Set Conversion Cloning of 11i Cloning of Oracle Applications Clusterware Concurrent CPU 2011 CPU 2012 April CPU 2012 January. CPU 2012 October CRS custom top Custom Top Creation Database . Database Query Dataguard DBMS_REPAIR Demantra . Domain Name E Business Suite Migration EBS 12.2 EPM exp/imp Oracle Applications Flashback table flows_020200 FND_TOP/resource FNDCPASS FNDCPUCF Forms server upgrade Forms startup FRM-92101 Fusion Middleware Hostname Hot Backup Hot cloning HotBackup Hotbackup Cloning of Oracle Apps hrglobal.drv. NLS Saudi Arabian HRMS hyperion Import and Export Oracle Applications Install Oracle Installation of R12 Installation Steps integration Oracle EBS Issues Database issues Oracle EBS Issues with Upgrade 12.1.1 Java Mission Control Java Upgrade java/sql/SavePoint JInitiator Junk Characters Language Translation Linux Linux Migration listener trace Listner version Local Inventory Login Page Master-Master Replication Memory Tuning Multiple Language NLS Non-Autoconfig Enabled OBIEE 11g Installation OBIEE Issues OIM Opatch version OpenSSL ora-01031 Oracle oracle 11g Oracle Announcement Oracle Application servers Oracle Application services Oracle Applications Oracle Applications 11i oracle applications 12.2 Oracle Applications Cloning Oracle Applications Upgrade Oracle Applications. Oracle Apps cloning Oracle BPEL oracle certifications oracle database Oracle Database RMAN Oracle Database upgradation Oracle DB oracle E Business suite 12.2 Oracle EBS oracle EPM Oracle Forms Logo oracle Fusion Applications Oracle Inventory oracle news Oracle OUI Oracle R12 oracle Sun Solaris Oracle Tuning Oracle Virtual Box Oracle Webgate Oracle WMA configuration orcladmin password for Oracle Applications Pasta Configuration pasta.cfg patch PDF Performance Physical Standby Platform migration Printer Configuration Profile Option R12 RAC Rapid Install Rapidwiz Real Application Clusters 10g Recovery RMAN RMAN Recovery SA Gosi Service Oriented Architecture SOA SQLTXPLAIN SSL Configuration step-by-step upgrade Sun solaris Swap Tablespace Trace Enable Trace file Translation Synchronization Patch transport tablespace tuning Tuning SGA uifont.ali Underscore Universal Content Management updates.oracle.com Upgradation of 12.0.5 to 12.1.1 Upgrade Upgrade 11g Upgrade Apps Upgrade DB Upgrade to 11g UTF8 version of oracle applications versions Web server upgrade weblogic windows workflow version XML Publisher version