Top 5 Solution Documents for Oracle Forms/Reports and APEX – Feb 2014

Thanks to Oracle Support

https://blogs.oracle.com/proactivesupportDevTools/entry/top_5_solution_documents_for

 

Oracle Forms

1594575.1
JRE Security Warning – UNKNOWN Publisher Blocked in Future Releases – JAR File Manifest Missing Permissions Attribute  Note that in this particular instance, the “UNKNOWN publishers” Security Warning is being thrown because the jacob.jar file from SourceForge has been self-signed using the Oracle provided courtesy script, sign_webutil.sh(bat). You will also see this warning if you have other custom jar files (icons, java beans, etc) that are signed with this script or not signed with a certificate from a Trusted Certificate Authority.

1093985.1
How to Configure Webutil in Forms 11g How to Configure Webutil in Forms 11g

1542463.1
Jar File Code Signing Changes Related to JRE 1.7.0_21 or Higher and the Impact on Oracle Forms Related Self-Signed Jar Files (sign_webutil.sh or sign_webutil.bat)  The purpose of this document is to explain what impact the upcoming Java Applet jar file signing changes  will have on Oracle Forms users.

1583119.1
How to Add Manifest Entries into Custom Jar Files Such as jacob.jar or Jar Files Containing Icons With  the release of JRE 1.7.0_25 permissions and codebase attributes are expected to be included in the JAR Manifest File. Please see Note 1563023.1. Oracle provided jar files such as frmall.jar, frmwebutil.jar etc are included with these manifest entries through Patch 17448420 .

1563023.1
Release of JRE 1.7.0_25 & 1.6.0_51 and Impact on Oracle Forms The release of JRE 1.7.0_25 & 1.6.0_51 will result in noticeable changes in behavior that impact Java applets (i.e. Oracle Forms).  All users of Forms are encouraged to read the release notes in order to be fully aware of the impact of the changes.

Oracle Reports

1395965.1
ALERT : 64-Bit Reports Builder 11gR2 (11.1.2) Problems on 64-bit Windows Operating Systems Starting from version 11gR2 (11.1.2), 64-bit installation of Forms and Reports Builder tools are supported on 64-bit Operating Systems. However a number of problems are reported on such installation on MS Windows 64 bit operating systems (aka x86_64 or x64). This document describes the reported problems and their solutions / workarounds.

856664.1
Logging and Tracing in Reports 11g. A Quick Reference Guide How to enable trace in reports inprocess/standalone/servlet/tools and where do they log? This will help in enabling trace from EM interface. Also Command line steps has been included to  help troubleshoot Install/Config issue related to report server instance failures while product is still being installed.

852698.1
How to Use TTF Fonts for Font Metrics On Unix With Reports 11g Reports 11g introduced an important enhancement on Unix platforms which lets the Reports Server use the TTF files for Font Metrics on unix platforms, just like the Windows platform. In earlier versions only AFM/TFM files were used for font metrics information.

200474.1
Master Note : Comprehensive REP-3000 Troubleshooting and Overview Guide WRunning a report using Reports Runtime (rwrun60), using Reports Builder (rwbld60), using Reports Server Client (rwcli60), accessed over the Web (rwcgi or rwservlet), or called from Oracle Forms results in the following error:
REP-3000: INTERNAL ERROR STARTING ORACLE TOOLKIT

881712.1
How to Enable Namingservice Discovery Mechanism for all Reports Server in Reports 11gThe process to enable Namingservice (COS) discovery mechanism for the out of the box Report Servers is as follows:

APEX

1254932.1
APEX Installation Verification Script  The primary purpose of this script is to verify the validity of an APEX installation after an installation has occurred or before an upgrade.  However, since it checks a number of APEX installation prerequisites, it may be useful to run prior to an APEX installation.

1535263.1
APEX Listener FAQ for APEX Listener Versions 2.0 This FAQ discusses information specific to the APEX 2.0 Listener. For additional information related to the APEX Listener see Note 1536052.1 – APEX Listener FAQ for APEX Listener.

1552900.1
How to Run the APEX Listener 2.0 in Standalone Mode This document discusses how to create the the 2.0 Oracle Application Express (APEX) Listener configuration files and run standalone mode, as well as various command line options.

1418234.1
Application Express (APEX) Performance Tuning and Scalability Factors The purpose of this document is to aid in the understanding and diagnosis of APEX application performance and scalability related issues.

558340.1
How to Uninstall Oracle HTML DB / Application Express from the Database This document discusses how to remove all versions of Application Express from a database instance.

Install Oracle 11G 11.2.0.3 on Windows 8

Dear Friends,

The below link is having useful information. Thanks to Tomasz.

http://dbaora.com/install-oracle-11g-11-2-0-3-on-windows/

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

This article presents how to quickly install Oracle Database 11G Release 2 (11.2.0.3) and as Oracle Grid 11G Release 2(11.2.0.3) on Windows.

Software used:

  • Oracle Database 11G Release 2(11.2.0.3) – 64 bit for Windows
  • Oracle Grid 11G Release 2(11.2.0.3) – 64 bit for Windows
  • Windows 8 Pro 64 bit

You can download Oracle Database 11G Release 2(11.2.0.3) and Oracle Grid 11G Release 2(11.2.0.3). You can download them on Oracle support formerly MetaLink.

p10404530_112030_MSWIN-x86-64_1of7.zip - database software
p10404530_112030_MSWIN-x86-64_2of7.zip - database software
p10404530_112030_MSWIN-x86-64_1of7.zip - grid software

Hardware and software requirements for database and grid software:

  • at least 4GB ram as minimum,  20G space for binaries and 40G for ASM devices
  • Windows Server 2003 – all x64 editions
  • Windows Server 2003 R2 – all x64 editions
  • Windows XP Professional x64 Edition
  • Windows Vista x64 – Business, Enterprise, and Ultimate editions
  • Windows Server 2008 x64 and Windows Server 2008 R2 x64 – Standard, Enterprise, Datacenter, Web, and Foundation editions
  • Windows 7 x64 – Professional, Enterprise, and Ultimate editions

In case you are not planning to install grid 2GB ram is enough.

ASM devices

To run ASM on Windows you need to create at least one RAW logical partition. For this presentation I have created 2 logical partitions each 20GB using diskpart.exe program.

RAW means not formated partition and without assigned letter.

Another option is to use “Computer management” interface which is user graphical interface. It includes “Disk management” tool to manage partitions.

It’s just example for diskpart.exe

1. List available disks on computer. There is only one disk with 40GB free space.

DISKPART> list disk

Disk ###  Status      Size     Free     Dyn  Gpt
 --------  ----------  -------  -------  ---  ---
 * Disk 0  Online      80 GB    40 GB

2. As first step you need to select disk before making any changes on it. In my case there is only one disk so it’s not necessary step but I wanted to show how to do it.

DISKPART> select disk 0

Disk 0 is now the selected disk.

3. List partitions. There is only one primary partition on disk.

DISKPART> list partition

Partition ###  Type             Size     Offset
 -------------  ----------------  -------  -------
 Partition 1    Primary           40 GB  1024 KB

4. Add new extended partition and 2 logical partitions.

DISKPART> create partition extended

DiskPart succeeded in creating the specified partition.

DISKPART> list partition

Partition ###  Type              Size     Offset
 -------------  ----------------  -------  -------
 Partition 1    Primary           40 GB  1024 KB
 * Partition 0  Extended         40 GB    40 GB

DISKPART> create partition logical size=20480

DiskPart succeeded in creating the specified partition.

DISKPART> create partition logical size=20480

DiskPart succeeded in creating the specified partition.

5. Verify new partitions.

DISKPART> list partition

Partition ###  Type              Size     Offset
-------------  ----------------  -------  -------
Partition 1    Primary             40 GB  1024 KB
Partition 0    Extended            40 GB    40 GB
Partition 2    Logical             20 GB    40 GB
* Partition 3  Logical             20 GB    60 GB

Install grid software

This presentation shows how to install grid software as standalone version which is nice to have to find out how ASM works. Unzip grid binaries to a directory and run setup.exe.

unzip p10404530_112030_MSWIN-x86-64_1of7.zip
cd grid
setup.exe

1. You should see following screen. Select “Skip software updates” and click “Next” button.

11gr2_win_grid1

2. Select “Configure Oracle Grid Infrastructure for Standalone Server” and click “Next” button.

11gr2_win_grid2

3. Select language and click “Next” button.

11gr2_win_grid3

4. It’s time to create ASM diskgroup DATA. First you need to make created earlier partitions with diskpart.exe visible by ASM binaries. Click “Stamp Disk” button.

11gr2_win_grid4

5. It will start asmtool. The tool is used to stamp devices(partitions) to be visible by Oracle binaries. Stamp means write some raw informations on the beginning of selected partition. Click “Next” button. Ye ye ye my bad “Dalej” ;).  I use Polish windows :).

11gr2_win_grid5

6. Select device which you want to stamp and enter label “DATA” for it. Then click “Next” button.

11gr2_win_grid6

7. ASM will see this partition as “ORCLDISKDATA0″. Just click “Next” button.

11gr2_win_grid7

8. Just click “OK”(Polish “Zakoncz”) button.

11gr2_win_grid8

9. Repeat step 5,6,7,8 for another device and stamp it with label “BACKUP”. Once it’s done you should see 2 devices. Select redundancy to “External” and select device “ORCLDISKDATA0″ and click “Next” button.

11gr2_win_grid9

10. From security point of view you should specify separate password for user SYS and ASMSNMP. I set for both user the same password. Click “Next” button.

11gr2_win_grid9a

11. On this screen you can specify directory for grid binaries. If you have already some Oracle binaries it makes sense to select already defined Oracle Base.

11gr2_win_grid10

12. Summary screen just before installation begin. Click “Install” button.

11gr2_win_grid11

13. Boring installation …

11gr2_win_grid12

11gr2_win_grid13

15. Installation completed. Just click “Close” button.

11gr2_win_grid14

ASM configuration assistant ASMCA

So far we have created only one ASM group DATA. I want to show how-to quickly add extra group to ASM instance.

1. Run “Automatic Storage Management Configuration Assistant” from Windows menu. Once it’s started click “Create” button.

11gr2_win_grid15

2. Enter disk group name BACKUP, select redundancy to “External”, check checkbox for “\\.\ORCLDISKBACKUP0″ device and click “OK” button.

11gr2_win_grid16

3. Soon new disk group should be created.

11gr2_win_grid17 11gr2_win_grid18

4. Two ASM disk groups “BACKUP” and “DATA” should be visible. Click “Exit” button.

11gr2_win_grid19

Verify in sqlplus that two ASM diskgroups exist.

d:\app\oracle\product\11.2.0\grid\BIN>set ORACLE_SID=+ASM

d:\app\oracle\product\11.2.0\grid\BIN>sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 17 20:41:40 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: / as sysasm

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 
- 64bit Production With the Automatic Storage Management option

SQL> select name from v$asm_diskgroup;

NAME
------------------------------
BACKUP
DATA

Install database software

Unzip database software to a directory and run setup.exe

unzip p10404530_112030_MSWIN-x86-64_1of7.zip
unzip p10404530_112030_MSWIN-x86-64_2of7.zip
cd database
setup.exe

1. Uncheck checkbox “I wish to recive security updates via My Oracle Support” and click “Next” button.

11gr2_win_db1

2. Ignore this message and click “Yes”

11gr2_win_db2

3. Select “Skip software updates” and click “Next” button.

11gr2_win_db3

4. Select “Create and configure a database” and click “Next” button.

11gr2_win_db4

5. Select “Server Class” and click “Next” button.

11gr2_win_db5

6. Select “Single instance database installation” and click “Next” button.

11gr2_win_db6

7. Select “Advanced install” and click “Next” button.

11gr2_win_db7

8. Select language and click “Next” button.

11gr2_win_db8

9. You can select here type of binaries to install. Once it’s done click “Next” button.

11gr2_win_db9

10. Define directories for database binaries and click “Next” button. The best is to select the same ORACLE_BASE as for grid software.

11gr2_win_db10

11. Accept default settings “General Purpose/Transaction Processing” and click “Next” button.

11gr2_win_db11

12. Enter global database name and SID for your database. Once it’s done click “Next” button.

11gr2_win_db12

13. Specify more details about your database on 4 tabs where you can define memory settings, character set, security settings and if to install sample schema on your database. Once you are happy with your settings click “Next” button.

11gr2_win_db13

11gr2_win_db14

11gr2_win_db15

11gr2_win_db16

17. On this page you can register your database in Oracle Enterprise Manager or create local EM version like in the example below. Click “Next” button.

11gr2_win_db17

18. Select “Oracle Automatic Storage Management” to install database on ASM devices and enter password for user ASMSNMP(the password was defined during grid binaries installation). If you have skipped ASM grid installation select first option “File System” and specify directory where database files should be installed.

11gr2_win_db18

19. Here you can define automatic backups and directory or ASM where backups should be stored. Once you are happy with your selection click “Next” button.

11gr2_win_db19

20. Select diskgroup “DATA” for database datafiles. click “Next” button.

11gr2_win_db20

21. Specify password for each user or enter the same for all. Once it’s done click “Next” button.

11gr2_win_db21

22. If everything is right click “Install” button. It’s the last moment to come back to each of previous point and make changes.

11gr2_win_db22

23. Installation in progress … it will take some time so talk to your girlfriend or pet :)

11gr2_win_db23

24. Database Configuration Assistant will start automatically and create database for you.

11gr2_win_db24

25. When database is ready you should see summary window. You can click “Password Management” to change passwords for many accounts in database. Once it’s done click “OK” button to continue.

11gr2_win_db25

26. You are lucky 11G installation is completed. Click “Close” button.

11gr2_win_db26

Have a fun :)

Tomasz

Oracle Application Express 5.0 Early Adopter 1 is available now

Thanks to Oracle
Oracle Application Express 5.0 Early Adopter 1 is available now :

http://apexea.oracle.com

Major Enhancements include :

  • A new “Page Designer”: a completely new IDE designed to greatly improve developer’s productivity, allowing you to very quickly enhance and maintain pages within Application Express.
  • Modal Dialogs: Now you can easily define modal (and non-modal) pages complete with the ability to utilize standard page processes.
  • Navigation Lists: The Application Builder has used navigation lists for years.. and now you can, too!
  • Interactive Report Enhancements: In Early Adopter 1, end users can now define a pivot report at runtime, which is similar to defining a group report.
  • All New Calendar: The new calendar component comes with built in support for Month, Week, Day, and Agenda views and is much easier to customize.
  • Shared Components File Upload: Files uploaded into shared components can be cached by your browser and are now referenced using relative file urls.
  • Reimagined User Interface: A competely reimagined user interface for Application Express which is focused on simplicity and removing clutter.

You can find more information and videos on Enhancements and Request a Workspace to test. Visit http://apexea.oracle.com