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/