Muhammad Asif

Thursday, January 7, 2021

FRM - 40010: Cannot read form from location.fmx Forms 12c

I am getting FRM - 40010 error when I try to access an .fmx file in Browser.

Oracle Forms : 12.2.1.3.0

Solution:

Go to default.env file location

[root@oraerptest config]# pwd

/u01/app/oracle/product/forms112/user_projects/domains/FormsReports/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config

FORMS_PATH variable move all your forms under ../../../rrl directory

[root@oraerptest config]# cat default.env

FORMS_PATH=/u01/app/oracle/product/forms112/fr_binaries/forms:/u01/app/oracle/product/forms112/instances/FRinst/FormsComponent/forms:/u01/app/oracle/product/forms112/fr_binaries/forms/rrl

Refresh the web logic services.

Tuesday, January 5, 2021

Restore Oracle DB & FMW Cloning (Part 4)

Configure Forms/Reports

The CONFIG_JVM_ARGS is set to speed things up if the system is low on entropy.

export CONFIG_JVM_ARGS="-Djava.security.egd=file:/dev/./urandom"

cd /u01/app/oracle/product/forms112/fr_binaries/bin

./config.sh

Below I have ignored the screens where you can sign up for security updates etc.

If you press Save Installation Configuration you can save a file that contains this:

Type: Oracle Forms and Reports Installation

Configuration Options

Middleware Home Location: /u01/app/oracle/product/forms112

Oracle Home Location: /u01/app/oracle/product/forms112/fr_binaries

Oracle Instance Location: /u01/app/oracle/product/forms112/instances/FRinst

Oracle Instance: FRinst

Domain Option: Create Domain

Domain Name: FormsReports

Domain Home: /u01/app/oracle/domains/FormsReports

Domain Host Name: oraerptest.com

Domain Port No: 7001

User Name: weblogic

Automatic Port Detection: false

Administrator Console: http://oraerptest.com:7001/console

EM Console: http://oraerptest.com:7001/em

EMAgent URL: http://oraerptest.com:5155/emd/main

Forms URL: http://oraerptest.com:8888/forms/frmservlet

Reports URL: http://oraerptest.com:8888/reports/rwservlet

Normally when you are finished with configuring a FMW domain, no processes are running. Forms/Reports works a bit different, so here everything should be up and running.

Have a look.

ps -ef | grep oracle

While it is nice and helpful that the domain configuration wizard has configured the Node Manager and started everything up, it is not without problems. In the following sections we will verify the installation and fix a couple of problems.

Homes overview

There is a wealth of homes in this installation:

Application Home /u01/app/oracle/applications/FormsReports

Domain Home /u01/app/oracle/domains/FormsReports

Instance Home /u01/app/oracle/product/forms112/instances/FRinst

Middleware Home /u01/app/oracle/product/forms112

Oracle Common Home /u01/app/oracle/product/forms112/oracle_common

Oracle Home /u01/app/oracle/product/forms112/fr_binaries

Weblogic Server Home /u01/app/oracle/product/forms112/wlserver_10.3

Verifying the Installation

You should have 4 WebLogic processes, an Admin Server, two Managed Servers and a Node Manager.
Here is the output from a bash script that lists running WebLogic Servers and Node Managers.
################################################################################
# WebLogic Servers
# <owner> <domain> <server> <pid> <ports>
################################################################################
oracle FormsReports AdminServer 26915 7001
oracle FormsReports WLS_FORMS 3277 9001
oracle FormsReports WLS_REPORTS 27859 9002
################################################################################
# Node Managers
# <owner> <mw_home> <pid> <port>
################################################################################
oracle /u01/app/oracle/product/forms112 23674 5556
You should also have some system component processes.
cd /u01/app/oracle/product/forms112/instances/FRinst/bin

./opmnctl status -l
For example.

Processes in Instance: FRinst
------------------------+-------------------+-----+------+----------+-------+----------+-----
ias-component | process-type | pid|status| uid |memused| uptime |ports
------------------------+-------------------+-----+------+----------+-------+----------+-----
emagent_FRinst | EMAGENT |18737|Alive |957811805 | 63884|215:32:43 |N/A
RptSvr_wintermute_FRinst| ReportsServerComp~|18736|Alive |957811804 | 63884|215:32:43 |N/A
ohs1 | OHS |18735|Alive |957811803 | 384152|215:32:43 |https:8889,https:8890,http:8888

Verify that you can use the different URLs (Screenshots):

Administration Server Console – http://oraerptest.com:7001/console

Enterprise Manager Console – http://oraerptest.com:7001/em

Enterprise Manager Agent – http://oraerptest.com:5155/emd/main

Oracle Forms – http://oraerptest.com:8888/forms/frmservlet

Oracle Reports – http://oraerptest.com:8888/reports/rwservlet

If you are not sure which ports are used check this file: /u01/app/oracle/product/forms112/fr_binaries/install/portlist.in

#Sun Feb 09 18:30:56 CET 2014

OPMN_LOCAL_PORT=6700

OHS_LISTEN_PORT=8888

WLS_FORMS_PORT=9001

OHS_SSL_PORT=8890

OHS_PROXY_PORT=8889

WLS_REPORTS_PORT=9002

OPMN_REQUEST_PORT=6702

OPMN_REMOTE_PORT=6701

DOMAIN_PORT=7001

NODE_MANAGER_PORT=-1

EMAGENT_PORT=5155

Summary

==========

Database Restored done

Web logic Installation done.

Forms/Report Installation done.

Form/Report Configuration done.

NOTE: Very Important Steps

Now it's time to Copy FORMS & Report from production and move to clone server..

Default.env define all paths...forms,report,java follow the below file.

Last steps Application side tnsnames.ora change according to enviroment.

[root@oraerptest config]# pwd

/u01/app/oracle/product/forms112/user_projects/domains/FormsReports/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.2/config

[root@oraerptest config]# cat default.env

# default.env - default Forms environment file, Linux version

# This file is used to set the Forms runtime environment parameters.

# If a parameter is not defined here, the value used will be that defined

# in the environment in which the WLS Managed Server was started.

# NOTES

# Configuration assitant will replace all the macro's with

# the actual values.

ORACLE_HOME=/u01/app/oracle/product/forms112/fr_binaries

ORACLE_INSTANCE=/u01/app/oracle/product/forms112/instances/FRinst

# TNS Entry to locate the database

TNS_ADMIN=/u01/app/oracle/product/forms112/instances/FRinst/config

# Search path for Forms applications (.fmx files, PL/SQL libraries)

FORMS_PATH=/u01/app/oracle/product/forms112/fr_binaries/forms:/u01/app/oracle/product/forms112/instances/FRinst/FormsComponent/forms:/u01/app/oracle/product/forms112/fr_binaries/forms/rrl

# WebUtil config file path. WebUtil is available for download from OTN.

WEBUTIL_CONFIG=/u01/app/oracle/product/forms112/instances/FRinst/config/FormsComponent/forms/server/webutil.cfg

# Disable/remove this variable if end-users need access to the query-where

# functionality which potentially allows them to enter arbitrary SQL

# statements when in enter-query mode.

FORMS_RESTRICT_ENTER_QUERY=TRUE

# Java class path

# This is required for the Forms debugger

# You can append your own Java code here)

# frmsrv.jar and ldapjclnt11.jar are required for

# the password expiry feature to work(2213140).

CLASSPATH=/u01/app/oracle/product/forms112/fr_binaries/forms/j2ee/frmsrv.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/ldapjclnt11.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/debugger.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/ewt3.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/share.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/utj.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/zrclient.jar:/u01/app/oracle/product/forms112/fr_binaries/reports/jlib/rwrun.jar:/u01/app/oracle/product/forms112/fr_binaries/forms/java/frmwebutil.jar:/u01/app/oracle/product/forms112/fr_binaries/jlib/start_dejvm.jar:/u01/app/oracle/product/forms112/fr_binaries/opmn/lib/optic.jar:/u01/app/oracle/product/forms112/fr_binaries/forms/rrl:/u01/app/oracle/product/forms112/fr_binaries/reports/rrl

# The PATH setting is not required for Forms if the Forms executables are

# in <ORACLE_HOME>/bin.JDK/bin is also required for dejvm to be

# auto-started by frmweb

PATH=/u01/app/oracle/product/forms112/fr_binaries/bin:/u01/app/oracle/product/forms112/fr_binaries/jdk/bin:/u01/app/oracle/product/forms112/fr_binaries/forms/rrl:/u01/app/oracle/product/forms112/fr_binaries/reports/rrl

# Settings for Reports

# -------------------------------

# NOTE: This setting is only needed if Reports applications

# are called from Forms applications

# However, because of bug 2336698 where a report is started from

# a forms debugger session with an already running JVM, then

# the report's class path should also be included in the forms

# class path.

# We no longer need to set REPORTS_CLASSPATH as forms will

# always start the JVM before calling reports.

# Settings for Forms tracing and logging

# -----------------------------------------------

# Note: By default tracing and logging directory is

# $ORACLE_INSTANCE/FormsComponent/forms/trace

# To change the trace directory this entry has to be uncommented and set to

# desired directory for tracing and logging

#FORMS_TRACE_DIR=%ORACLE_INSTANCE%/FormsComponent/forms/trace

# Settings for Javascript events

# -----------------------------------------------

# Note: If this variable is set to false then the triggers and

# built-ins associated with javascript events are disabled

#FORMS_ALLOW_JAVASCRIPT_EVENTS=TRUE

# System settings

# ---------------

# You should not normally need to modify these settings

# Path for shared library objects

# This is highly platform (if not machine) specific ! At install time

# <percent>LD_LIBRARY_PATH<percent> should be replaced with the

# actual value of the LD_LIBRARY_PATH environment variable (at install

# time). That should ensure we have the paths for such necessities as

# the motif and X11 libraries.

# Explanations:

# - Reports needs the path for libjava.so

# (.../jre/lib/sparc)

# - Forms needs two paths to the jre, for libjvm.so and libhpi.so

# - In JDK 1.4.1 the location of libjvm.so is lib/sparc (there is no

# classic directory) so we do not include the .../classic directory

# below. There are other versions of libjvm.so (in directories server,

# client and hotspot) but we will use the version in lib/sparc for now.

LD_LIBRARY_PATH=/u01/app/oracle/product/forms112/fr_binaries/lib:/u01/app/oracle/product/forms112/fr_binaries/jdk/jre/lib/amd64:/u01/app/oracle/product/forms112/fr_binaries/jdk/jre/lib/amd64/server:/u01/app/oracle/product/forms112/fr_binaries/jdk/jre/lib/amd64/native_threads

# Setting to take care of signal-chaining facility offered by JVM 1.5

# Without this Forms/Reports integration could have issues on Unix/Linux

LD_PRELOAD=/u01/app/oracle/product/forms112/fr_binaries/jdk/jre/lib/amd64/libjsig.so

[root@oraerptest config]#

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

Application Side

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

[root@oraerptest /]# cd /u01/app/oracle/product/forms112/instances/FRinst/config/

[root@oraerptest config]# ls

EMAGENT FRComponent OHS reports ReportsToolsComponent

FormsComponent JPS OPMN ReportsServerComponent tnsnames.ora

[root@oraerptest config]# cat tnsnames.ora

# sample tnsnames.ora file added by the Formsconfiguration assistant.

#sample entry

#<ALIAS> = (DESCRIPTION =(ADDRESS_LIST =

# (ADDRESS = (PROTOCOL = TCP)

# (HOST = <HOST>)(PORT = <PORT)))

# (CONNECT_DATA = (SID = <SID)))

PRODTEST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = oraerptest.com)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = PRODTEST)

)

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

Database Side

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

[oracle@oraerptest admin]$ cat listener.ora

# listener.ora Network Configuration File: /u02/oradb/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oraerptest.com)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

ADR_BASE_LISTENER = /u02/oradb

[oracle@oraerptest admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u02/oradb/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

PRODTEST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = oraerptest.com)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = PRODTEST)

)

[oracle@oraerptest admin]$

Now access the forms using below link

Oracle Forms – http://oraerptest.com:8888/forms/frmservlet

Refer:

https://theheat.dk/blog/?p=1983

Restore Oracle DB & FMW Cloning (Part 3)

Installation Oracle Forms/Report on Clone Server

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

Install Forms/Reports version 11.1.2.2.0

Unzip the install kits.

unzip ofm_frmrpts_linux_11.1.2.2.0_64_disk1_1of2.zip

unzip ofm_frmrpts_linux_11.1.2.2.0_64_disk1_2of2.zip

Start the installer.

cd Disk1

./runInstaller -jreLoc /u01/app/oracle/product/java_current/jre

Below I have ignored the screens where you can sign up for security updates etc.

Setting the inventory to /u01/app/oracle/oraInventory

Setting the group name to oinstall

Creating the Oracle inventory pointer file (/etc/oraInst.loc)

Changing permissions of /u01/app/oracle/oraInventory to 770.

Changing groupname of /u01/app/oracle/oraInventory to oinstall.

The execution of the script is complete

Type: Oracle Forms and Reports Installation

Installed Applications

Forms

Reports

Forms Builder

Reports Builder

Installed System Components

OHS

EM Agent

cd /u01/app/oracle/product/forms112

find . -type f -exec sed -i "s/\/u01\/app\/oracle\/product\/jdk1.7.0_51/\/u01\/app\/oracle\/product\/java_current/g" {} \;

Sunday, January 3, 2021

Restore Oracle DB & FMW Cloning (Part 2)

Installation Oracle Weblogic

Note:

Oracle Database Restored on Clone Server in Part1...Now it's time to install Web logic then Forms, Report and then some configuration.

Download Web logic Server 11g Release 1

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

Installed all required Packages.

[root@oraerptest ~]# uname -r

2.6.32-100.28.5.el6.x86_64

# yum install gcc-c++.x86_64 -y -q

yum install glibc.x86_64 -y -q

yum install glibc.xi686 -y -q

yum install glibc.i686 -y -q

yum install glibc.devel.i686 -y -q

yum install glibc-devel.i686 -y -q

yum install libaio.x86_64 -y -q

yum install libaio-devel.x86_64 -y -q

yum install libgcc.x86_64 -y -q

yum install libstdc++.x86_64 -y -q

yum install libstdc++.i686 -y -q

yum install libstdc++-devel.x86_64 -y -q

yum install openmotif.x86_64 -y -q

yum install openmotif22.x86_64 -y -q

yum install redhat-lsb.x86_64 -y -q

yum install sysstat.x86_64 -y -q

yum install xorg-x11-utils.86_64 -y -q

yum install sysstat.x86_64 -y -q

yum install libstdc++.i686 -y -q

yum install glibc.xi686 -y -q

yum install compat-libstdc++-33.i686 -y -q

yum install glibc.i686 -y -q

yum install glibc-devel.i686 -y -q

yum install glibc.xi686 -y -q

yum install glibc.i686 -y -q

[root@oraerptest Desktop]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 6.0 (Santiago)

[root@oraerptest Desktop]# getconf GNU_LIBPTHREAD_VERSION

NPTL 2.12

[root@oraerptest Desktop]# vi /etc/sysctl.conf

(I checked the shmmax value its less then the requirement so changed after that run below command to effect without reboot)

[root@oraerptest Desktop]#/etc/sysctl -p

[root@oraerptest Desktop]# /sbin/sysctl -a | grep shmmax

kernel.shmmax = 68719476736

[root@oraerptest ~]# cat /etc/hosts

127.0.0.1 localhost.localdomain localhost

::1 oraerptest.com oraerptest localhost6.localdomain6 localhost6

192.168.1.150 oraerptest.com oraerptest

[root@oraerptest ~]#

[root@oraerptest ~]# sed -i '/.*End of file/d' /etc/security/limits.conf

[root@oraerptest ~]# echo "* soft nofile 65536" >> /etc/security/limits.conf

[root@oraerptest ~]# echo "* hard nofile 65536" >> /etc/security/limits.conf

[root@oraerptest ~]# echo "# End of file" >> /etc/security/limits.conf[root@oraerptest ~]# cat /etc/security/limits.conf

[oracle@oraerptest ~]$ echo "umask 027" >> .bash_profile

[oracle@oraerptest ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

export ORACLE_HOME=/u02/oradb/product/11.2.0/dbhome_1

export ORACLE_SID=PROD

PATH=$PATH:$HOME/bin/:$ORACLE_HOME/bin

export PATH

umask 027

[oracle@oraerptest ~]$

[oracle@oraerptest ~]$ echo "export LANG=\"en_US.UTF-8\"" >> .bash_profile

[oracle@oraerptest ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

export ORACLE_HOME=/u02/oradb/product/11.2.0/dbhome_1

export ORACLE_SID=PROD

PATH=$PATH:$HOME/bin/:$ORACLE_HOME/bin

export PATH

umask 027

export LANG="en_US.UTF-8"

[oracle@oraerptest ~]$

Soft Directory having JDK and wls tar files

[applmgr@oraerptest soft]$ ls

Disk1 jdk-7u51-linux-x64.tar.gz

Disk2 ofm_frmrpts_linux_11.1.2.2.0_64_disk1_1of2.zip

Disk3 ofm_frmrpts_linux_11.1.2.2.0_64_disk1_2of2.zip

Disk4 wls1036_generic.jar

jdk1.7.0_51

[applmgr@oraerptest soft]$ mv jdk1.7.0_51 /u01/app/oracle/product/

[applmgr@oraerptest soft]$

[applmgr@oraerptest soft]$ cd /u01/app/oracle/product

[applmgr@oraerptest product]$

[applmgr@oraerptest product]$ ln -s jdk1.7.0_51 java_current

[applmgr@oraerptest product]$

[applmgr@oraerptest product]$ java_current/bin/java -version

java version "1.7.0_51"

Java(TM) SE Runtime Environment (build 1.7.0_51-b13)

Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)

[applmgr@oraerptest product]$

[applmgr@oraerptest soft]$ /u01/app/oracle/product/java_current/bin/java -jar -Djava.io.tmpdir=/u02/soft wls1036_generic.jar -log=wls_install.log

Extracting 0%....................................................................................................100%

Dec 09, 2020 3:05:56 PM java.util.prefs.FileSystemPreferences$1 run

INFO: Created user preferences directory.

[applmgr@oraerptest soft]$

[applmgr@oraerptest soft]$ id

uid=503(applmgr) gid=503(applmgr) groups=503(applmgr),501(oinstall) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023

[applmgr@oraerptest soft]$ cd /u01/app/oracle/product/forms112

[applmgr@oraerptest forms112]$ grep jdk1.7.0_51 *

[applmgr@oraerptest forms112]$ grep -R jdk1.7.0_51 *

utils/uninstall/uninstall.sh:JAVA_HOME="/u01/app/oracle/product/jdk1.7.0_51"

utils/quickstart/quickstart.sh:JAVA_HOME="/u01/app/oracle/product/jdk1.7.0_51"

utils/bsu/bsu.sh:JAVA_HOME="/u01/app/oracle/product/jdk1.7.0_51"

utils/ccr/hosts/oraerptest.com/config/emCCRenv:JAVA_HOME=/u01/app/oracle/product/jdk1.7.0_51

wlserver_10.3/common/bin/commEnv.sh: JAVA_HOME="/u01/app/oracle/product/jdk1.7.0_51"

wlserver_10.3/.product.properties:JAVA_HOME=/u01/app/oracle/product/jdk1.7.0_51

wlserver_10.3/.product.properties:WLS_JAVA_HOME=/u01/app/oracle/product/jdk1.7.0_51

wlserver_10.3/.product.properties:JAVAHOME=/u01/app/oracle/product/jdk1.7.0_51

[applmgr@oraerptest forms112]$

[applmgr@oraerptest forms112]$ find . -type f -exec sed -i "s/\/u01\/app\/oracle\/product\/jdk1.7.0_51/\/u01\/app\/oracle\/product\/java_current/g" {} \;

[applmgr@oraerptest forms112]$

[applmgr@oraerptest forms112]$ mkdir /u01/app/oracle/product/java_current/jre/lib/endorsed

[applmgr@oraerptest forms112]$ cd modules/

[applmgr@oraerptest modules]$ cp javax.annotation_1.0.0.0_1-0.jar /u01/app/oracle/product/java_current/jre/lib/endorsed/

[applmgr@oraerptest modules]$ cp javax.xml.bind_2.1.1.jar /u01/app/oracle/product/java_current/jre/lib/endorsed/

[applmgr@oraerptest modules]$ cp javax.xml.ws_2.1.1.jar /u01/app/oracle/product/java_current/jre/lib/endorsed/

[applmgr@oraerptest modules]$ cd /u01/app/oracle/product/java_current/jre/lib/endorsed/

[applmgr@oraerptest endorsed]$

[applmgr@oraerptest endorsed]$ ls -l

total 124

-rw-rw-r--. 1 applmgr applmgr 6157 Dec 10 09:26 javax.annotation_1.0.0.0_1-0.jar

-rw-rw-r--. 1 applmgr applmgr 79230 Dec 10 09:27 javax.xml.bind_2.1.1.jar

-rw-rw-r--. 1 applmgr applmgr 36491 Dec 10 09:27 javax.xml.ws_2.1.1.jar

[applmgr@oraerptest endorsed]$

[applmgr@oraerptest Disk1]$ ./runInstaller -jreLoc /u01/app/oracle/product/java_current/jre

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 270 MB. Actual 657 MB Passed

Checking swap space: must be greater than 500 MB. Actual 6999 MB Passed

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

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-12-10_09-32-04AM. Please wait ...[applmgr@oraerptest Disk1]$ Log: /u02/oraInventory/logs/install2020-12-10_09-32-04AM.log

[applmgr@oraerptest oracle]$ export CONFIG_JVM_ARGS="-Djava.security.egd=file:/dev/./urandom"

[applmgr@oraerptest oracle]$ pwd

/u01/app/oracle

[applmgr@oraerptest oracle]$ cd /u01/app/oracle/product/forms112/fr_binaries/b

bin/ browser/

[applmgr@oraerptest oracle]$ cd /u01/app/oracle/product/forms112/fr_binaries/bin/

[applmgr@oraerptest bin]$ ./config.sh

Starting Fusion Middleware Configuration Wizard

ORACLE_HOME set as /u01/app/oracle/product/forms112/fr_binaries

PATH set as /u01/app/oracle/product/forms112/fr_binaries/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/applmgr/bin

LD_LIBRARY_PATH set as /u01/app/oracle/product/forms112/fr_binaries/lib

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 270 MB. Actual 908 MB Passed

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

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

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-12-10_04-10-31PM. Please wait ...[applmgr@oraerptest bin]$ Log: /u02/oraInventory/logs/install2020-12-10_04-10-31PM.log

The Java soft link was “ignored” so we have to fix this:

cd /u01/app/oracle/product/forms112

grep -R jdk1.7.0_51 *

find . -type f -exec sed -i "s/\/u01\/app\/oracle\/product\/jdk1.7.0_51/\/u01\/app\/oracle\/product\/java_current/g" {} \;

Refer:

https://theheat.dk/blog/?p=1983

Saturday, January 2, 2021

Restore Oracle DB & FMW Cloning (Part1)

Part1

Restore Oracle DB on Cloning Server

Env: Oracle DB 11g , FMW + Weblogic, Oracle Linux 6.5

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

Oracle Database Backup using RMAN (Online) + Forms + Reports move to Cloning server.

$ export LD_BIND_NOW=1

[Oracle@Clone]$./runInstaller

Installed only database software

SQL> startup nomount pfile='/u02/oradb/product/11.2.0/dbhome_1/dbs/initPROD.ora';

ORACLE instance started.

Total System Global Area 1002127360 bytes

Fixed Size 2259440 bytes

Variable Size 348128784 bytes

Database Buffers 645922816 bytes

Redo Buffers 5816320 bytes

SQL>

[oracle@oraerptest Desktop]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Dec 7 14:16:26 2019

connected to target database: PROD (not mounted)

RMAN> set DBID 351966818

executing command: SET DBID

RMAN> restore controlfile from '/u02/RmanDBbk/PRODc-351966818-20191206-00';

Starting restore at 07-DEC-19

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=20 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u02/oradb/proddata/control01.ctl

output file name=/u02/oradb/proddata/control02.ctl

Finished restore at 07-DEC-19

RMAN> startup mount;

database is already started

database mounted

released channel: ORA_DISK_1

RMAN-03002 Failure of duplicate Db command

RMAN-19505 failed to identify file "/u01/rmanbk/....."

RMAN> show all;

RMAN configuration parameters for database with db_unique_name PROD are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 7;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/rmanbkp/%d%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/rmanbkp/%U';

CONFIGURE MAXSETSIZE TO UNLIMITED;

CONFIGURE ENCRYPTION FOR DATABASE OFF;

CONFIGURE ENCRYPTION ALGORITHM 'AES128';

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/RmanDBbk';

RMAN>

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/oradb/product/11.2.0/dbhome_a/dbs/snapcf_PROD.f';

old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/RmanDBbk';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/oradb/product/11.2.0/dbhome_a/dbs/snapcf_PROD.f';

new RMAN configuration parameters are successfully stored

RMAN> crosscheck backup;

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c9vhbin5_1_1 RECID=6292 STAMP=1058392807

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c8vhbin5_1_1 RECID=6293 STAMP=1058392827

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cavhbin5_1_1 RECID=6294 STAMP=1058392808

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c7vhbin5_1_1 RECID=6295 STAMP=1058392827

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c6vhbin5_1_1 RECID=6296 STAMP=1058392805

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cevhe734_1_1 RECID=6298 STAMP=1058479212

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cfvhe734_1_1 RECID=6299 STAMP=1058479210

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cgvhe735_1_1 RECID=6300 STAMP=1058479212

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cdvhe734_1_1 RECID=6301 STAMP=1058479237

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/ccvhe734_1_1 RECID=6302 STAMP=1058479210

Crosschecked 10 objects