Installing Oracle Forms and Reports 12c on Windows 64 Bit machine

This installation will be done in three phases.

1. Java JDK installation
2. Oracle WebLogic Server (FMW Infrastructure) Installation and
3. Oracle Forms and Reports 12c Installation

Java JDK installation

Download JDK from below location and complete the simple installation to java to your desired location

http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Oracle WebLogic Server (FMW Infrastructure) Installation

Download WebLogic Server from the below link and launch installer from java

http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html

Oracle Forms and Reports 12c Installation

Download software from the link mentioned below and run installer as administrator.

http://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html

This completes your installation but, in 12c you have to run "Repository Configuration Utility (RCU)" and "Create the Forms and Reports Services Domain" manually.

Could not create the change tracking file

Error

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-19751: could not create the change tracking file
ORA-19750: change tracking file:
'+DATA_USG/RAREF/CHANGETRACKING/ctf.344.951649823'
ORA-17502: ksfdcre:4 Failed to create file
+DATA_USG/RAREF/CHANGETRACKING/ctf.344.951649823
ORA-15046: ASM file name '+DATA_USG/RAREF/CHANGETRACKING/ctf.344.951649823' is
not in single-file creation form
ORA-17503: ksfdopn:2 Failed to open file
+DATA_USG/RAREF/CHANGETRACKING/ctf.344.951649823

ORA-15012: ASM file '+DATA_USG/RAREF/CHANGETRACKING/ctf.344.951649823' does not exist

Cause

Block change tracking file entry that exists in source controlfile is not found where DB got restored because the directory structure.

Solution

Disable block change tracking and recreate it after opening database.

SQL> alter database disable block change tracking;

Database altered.

SQL> alter database open;

Database altered.

SQL>alter database enable block change tracking using file '+DATA_USG';

Failed to load Media Management Library

Error

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on c1 channel at 06/26/2018 11:28:08
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

Additional information: 2

Cause

Link between Oracle database server software and NetBackup API library wasn't found.

$ ls -l $ORACLE_HOME/lib/libobk.so
/u01/app/oradr/product/12.1.0.2/dbhome_1/lib/libobk.so: No such file or directory

Solution

Create soft link between Oracle database server software and NetBackup API library

$ ln -s /usr/openv/netbackup/bin/libobk.so64.1 $ORACLE_HOME/lib/libobk.so

$ ls -l $ORACLE_HOME/lib/libobk.so
lrwxrwxrwx   1 oradr    oinstall      38 Jun 26 11:30 /u01/app/oradr/product/12.1.0.2/dbhome_1/lib/libobk.so -> /usr/openv/netbackup/bin/libobk.so64.1
$

libsqlplus.so: cannot open shared object file

Error

libsqlplus.so: cannot open shared object file: No such file or directory

Cause

LD_LIBRARY_PATH is not set.

Solution

set the LD_LIBRARY_PATH environment variable to the folder where the “libsqlplus.so” file resides.

For example, 

export LD_LIBRARY_PATH=/DB/app/oracle/product/1124/dbhome_1/lib/

bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on 

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

SQL> 

ORA-01000: maximum open cursors

Error

Retrieving Snapshot Target Data (1) - 14:48:59
Error: Snapshot Get Target Data routine failed. ORA-01000: maximum open cursors
exceeded
ORA-06512: at "SYS.DBMS_SYS_SQL", line 909
ORA-06512: at "SYS.DBMS_SQL", line 39
Running: CREATE TABLE snapshot_temp_data_764_1

Cause

Maximum open cursors limit exhausted.

Solution

If the value of the database parameter "open_cursors" is not set sufficiently high, then it causes the "ORA-01000: maximum open cursors exceeded" error.

SQL> alter  system set open_cursors=600 scope=both sid='*';

If you are using SPFILE to set database parameter, you can change this value by doing the following while logged into SQL*Plus as SYSDBA:

SQL> alter system set open_cursors=<new_value> scope=both;

In case you are not using SPFILE and are instead using init<SID>.ora file, you should change the value for open_cursors by adding a line to that file or changing any existing setting to look like:

OR

If open_cursors values is much enough then involve your developer to validate the code and ask them to close the cursor after processing statements which were left not closed.