Enabling Maintenace Mode without using ADADMIN

No comments
Enabling and Disabling of maintenance mode can be done through ADADMIN.
But the same can be also done from executing SQL scripts as below.


Enabling Maintenance Mode:

sqlplus apps/appspassword

SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

Disabling Maintenance Mode:

sqlplus apps/appspassword 
 
SQL>$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

No comments :

Post a Comment

Overview of appsweb.cfg file

3 comments
appsweb.cfg is an important file for forms configuration. It basically defines the paramater and its values used  by forms.
This file will contain the below information:
Form Server Name,Server Port,Domain Name,Database Connection parameters,Connect mode and JInitiator version.Trace on the forms can be also enabled from appsweb.cfg file.
The same information can also be obtained from context file.

Location of the appsweb.cfg file
$OA_HTML/bin
or 
$COMMON_TOP/html/bin

s_f60webcfg parameter can be checked from context file to find the forms configuration file path.


Below are the some parameter name from appsweb.cfg file and context file to find the details regarding forms.

ContextFileParameter
appsweb.cfg file parameter name
Description
Example Value
s_formshost
serverName
Name of FormsServer
test
s_formsdomain
domainName
Domain name of forms server
mydomain.com
s_frmConnectMode
connectMode
Connecting mode(Socket or Servlet)
socket
s_jinit_ver_comma
jinit_ver_name
Jinitiator Version delimited by ,
1,3,1,18
s_jinit_clsid
jinit_class_id
Jinitiator Class ID
PQRST-0014-0002-0031-ZYXWV

3 comments :

Post a Comment

Finding the Apps password into the Configuration File

No comments
The Apps Password is stored in a flat files other than from being stored in Database.

Files which need to checked for apps password
 
File name: wbdbsvr.app
Location of the file:  $IAS_ORACLE_HOME/Apache/modplsql/cfg/

File name: CGIcmd.dat
Location of the file : $ORACLE_HOME/reports60/server


If you are changing apps password then it would be required to change password in above files in 11i.

 

No comments :

Post a Comment

Overview of the Service Groups in Oracle Apps R12

1 comment
All the services that are running in Oracle Apps R12 are now categorized into Service Groups from R12 version of Apps. According to these services groups different services run on single or multi-node.

Below are the name of the service group and the services associated with it.


Service Group Name
Services Running
Root Service Group
Oracle Process Manager(OPMN)
Web Entry Point Services
HTTP Server
Web Application Services
OACORE OC4J,Forms OC4J,OAFM OC4J
Batch Processing Services
Application TNS Listener, Concurrent Managers, Fulfillment Server
Other Service Group
Oracle Forms Services, Oracle MWA Service


As per the node configuration the  Service Group Associated with the each node might look as below.May vary as per your configuration
 
Node Type
Service Group Enabled
Web Node
Root Service Group, Web Entry Point Services, Web Application Services
Forms Node
Root Service Group, Web Application Services, Other Service Group
Concurrent Processing Node
Root Service Group, Batch Processing Services

1 comment :

Post a Comment