WLS Console Timeout

The WebLogic console timeout is a great feature for security, yet a horrible feature during development. Logging in over and over again gets to be annoying. This is very easy to change, but I would never do this on a production system!

http://blogs.oracle.com/johngraves/2011/03/wls_console_timeout.html

WebLogic Silent Install 11.1.1.4 (WLS 10.3.4) - Linux

install.sh

!/bin/bash
./wls1034_oepe111161_linux32.bin -mode=silent -silent_xml=./silent.xml

silent.xml

xml version="1.0" encoding="UTF-8"?>

<bea-installer>

<input-fields>

    <data-value name="BEAHOME" value="/opt/app/wls10.3.4" />

    <data-value name="WLS_INSTALL_DIR" value="/opt/app/wls10.3.4/wlserver_10.3" />

input-fields>

bea-installer> 

Note about Oracle_Home: Since all products are moving to a common WLS base, I simply use the WLS version as my Oracle Home. In this case wls10.3.4. Also, I keep my user_projects outside my Oracle_Home directory to keep things clean. I typically use /opt/app/user_projects or a variation of that.

opmnctl Commands

opmnctl

opmnctl is the supported tool for starting and stopping all components in an Oracle instance, with the exception of the Fusion Middleware Control Console. opmnctl provides a centralized way to control and monitor system components from the command line.

The opmnctl command exists in two distinct directory location paths:

* ORACLE_HOME/opmn/bin/opmnctl: The opmnctl command ORACLE_HOME/opmn/bin/opmnctl location can only be used to create an Oracle instance or a component for an Oracle instance on the local system. opmnctl commands generated from this location cannot be used to manage system processes
* ORACLE_INSTANCE/bin/opmnctl: The other opmnctl command which is located in the ORACLE_INSTANCE/bin/ directory location provides a per Oracle instance instantiation of opmnctl. The opmnctl command in this location must be used for managing processes for this Oracle instance and can also be used for creating components for the Oracle instance.


opmnctl Command Quick Reference

opmnctl help

usage: opmnctl [verbose] [] []

verbose: print detailed execution message if available

Permitted // combinations are:

scope command options
------- --------- ---------
start - Start opmn
startall - Start opmn & all managed processes
stopall - Stop opmn & all managed processes
shutdown - Shutdown opmn & all managed processes
[] startproc [= ..] - Start opmn managed processes
[] restartproc [= ..] - Restart opmn managed processes
[] stopproc [= ..] - Stop opmn managed processes
[] reload - Trigger opmn to reread opmn.xml
[] status [] - Get managed process status
[] metric [= ..] - Get DMS metrics for managed processes
[] dmsdump [] - Get DMS metrics for opmn
[] debug [= ..] - Display opmn server debug information
[] set [= ..] - Set opmn log parameters
[] query [=] - Query opmn log parameters
launch [= ..] - Launch a configured target process
phantom [= ..] - Register phantom processes
ping [] - Ping local opmn
validate [] - Validate the given opmn xml file
help - Print brief usage description
usage [] - Print detailed usage description
createinstance - Create an Oracle Instance
createcomponent - Create a specified component
deleteinstance - Delete an instance and components
deletecomponent - Delete a specified component
registerinstance - Register with admin server
unregisterinstance - Unregister with admin server
updateinstanceregistration - Update instance registration
updatecomponentregistration - Update component registration




Ref- http://download.oracle.com/docs/cd/E12839_01/doc.1111/e14007/opmnctl.htm

FORMS_BUILDER_CLASSPATH not set after Installation of Oracle Forms Builder 11.1.1.2.0

To add Forms 11 support to my application Forms Toolkit, I needed to install Oracle WebLogic and Oracle Developer Tools (see download information).

While the installer reported “installation complete” after a couple of minutes, it really spent about 5 hours (on my machine) installing and configuring the software. It’s best to watch the installation log file using a tool like BareTail, because the installer won’t give you much information whether it is still active and what it is doing.

After completion, I tried to start Oracle Forms Builder, but got this error message:

FRM-91129: fatal error in runtime process: no value specified for required environment variable FORMS_BUILDER_CLASSPATH

FRM-91129: Abbruchfehler: Kein Wert für erforderliche Umgebungsvariable FORMS_BUILDER_CLASSPATH angegeben

Forms 11 does not seem to be administered by earlier versions of the Oracle Home Selector, so I had to look for some clues where Forms would get its startup information from.

Open the Registry Editor (regedit.exe) and navigate to HKLM\SOFTWARE\ORACLE\ and find a number of subkeys starting with “KEY_OH”. Navigate to the key holding values for ORACLE_HOME and ORACLE_HOME_KEY that point to your installation directory.

In Explorer, navigate to the forms\templates\registry directory of your installation (C:\oracle\Middleware\as_1\forms\templates\registry in my case), and open the file formsbuilder.reg in your favorite editor and save under a different name (e.g. my_formsbuilder.reg).

Delete all lines between “REGEDIT4″ and the first line containing the %ORACLE_HOME_REG_KEY% macro. The file now looks like this:

REGEDIT4

[HKEY_LOCAL_MACHINE\%ORACLE_HOME_REG_KEY%]
"FORMS_SCCONVERT"="false"

[HKEY_LOCAL_MACHINE\%ORACLE_HOME_REG_KEY%]
"FORMS_SCDRIVER"="d2scrw32.dll"

[HKEY_LOCAL_MACHINE\%ORACLE_HOME_REG_KEY%]
"FORMS_SCVIEWER"="NOTEPAD.EXE"

[HKEY_LOCAL_MACHINE\%ORACLE_HOME_REG_KEY%]
"FORMS_ORACLE_INSTANCE"="%ORACLE_INSTANCE%"

[HKEY_LOCAL_MACHINE\%ORACLE_HOME_REG_KEY%]
"FORMS_BUILDER_CLASSPATH"="%ORACLE_HOME%\\a\\number\\of\\jars"

Replace all occurrences of %ORACLE_HOME_REG_KEY% with the value of the registry key ORACLE_HOME_KEY, e.g.

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OH377519060]

Save the file, and double-click from Explorer. Acknowledge the warning that the .reg file will be merged into the registry, and the successful merge.

You can now start Oracle Forms Builder.

Reference- http://devio.wordpress.com/2010/09/22/forms_builder_classpath-not-set-after-installation-of-oracle-forms-builder-11-1-1-2-0/

How to run a dos command (.bat) from Oracle Forms

For less then or equal 6i version

HOST('CMD /C C:\batch_file_name.bat');

For the web based...
The same above command will work for AS level. If you need on client side then

CLIENT_HOST('CMD /C C:\batch_file_name.bat');

Difference between restricted and unrestricted package procedure

Restricted package procedure that affects the basic functions of SQL * Forms. It cannot used in all triggers except key triggers. Unrestricted package procedure that does not interfere with the basic functions of SQL * Forms it can be used in any triggers.

Difference between OPEN_FORM and CALL_FORM

When one form invokes another form by executing open_form the first form remains displayed,
and operators can navigate between the forms as desired.
when one form invokes another form by executing call_form,
the called form is modal with respect to the calling form.
That is, any windows that belong to the calling form are disabled,
and operators cannot navigate to them until they first exit the called form.

Eg:

When we invoke a form from OPEN_FORM built-in, we can freely move to calling form and called form.
When we invoke a form from CALL_FORM built-in, we cannot move to the calling form unless we complete our work in the called form and close it.

We have FormA, FormB.
We open the formB from FormA.
OPEN_FOR('FormB');
We can move the focus to FormA and FormB without closing FormB.

CALL_FORM('FormB');
In this case, when FormB os opened, we have to complete the required work in FormB and have to close FrmB before moving the focus to FormA.

We cannot move the focus to FormA unless we close FormB