Pages

Wednesday, January 5, 2022

Oracle Reports 12c: First Step to Complete After a New Forms/Reports 12c Install and Configuration Environment ?

Oracle Reports 12c: First Step to Complete After a New Forms/Reports 12c Install and Configuration Environment ?


An Example 12c Directory Structure:

Windows:

ORACLE_HOME=C:\Oracle\Middleware\Oracle_Home 
MW_HOME=C:\Oracle\Middleware 
WL_HOME= C:\Oracle\Middleware\Oracle_Home\wlserver 
DOMAIN_HOME= C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain

Unix:

ORACLE_HOME=/Oracle/Middleware/Oracle_Home 
MW_HOME=/Oracle/Middleware 
WL_HOME=/Oracle/Middleware/Oracle_Home/wlserver
DOMAIN_HOME=/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain


The first step after running the Configuration Wizard in a new environment with Oracle Reports 12c is to run the WLST command createReportsToolsInstance(). This command will create all the components at file system level needed for Oracle Reports.

** Make sure AdminServer Managed server is running

** Make sure WLS_REPORTS is not running

For Example:

1- Execute wlst.cmd/wlst.sh from ORACLE_HOME/oracle_common/common/bin

2- Connect to AdminServer. 

    connect("weblogic","weblogic_<PASSWORD>","hostname:7001")

3- Run the following wlst command. 

    createReportsToolsInstance(instanceName='reptools1',machine='AdminServerMachine')

** In above createReportsToolsInstance() command example, 'AdminServerMachine' value is the logical machine name that hosts the WebLogic Server instance.

** To log out of WLST, use "exit()".

The following folders are some of the key folders created for Reports 12c after above steps.

DOMAIN_HOME/reports/bin  
DOMAIN_HOME/reports/cache
DOMAIN_HOME/reports/fonts
DOMAIN_HOME/reports/plugins
DOMAIN_HOME/reports/server

Now the Oracle Reports environment is complete and ready to be used.


Reference metalink Doc ID 2072671.1

How to enable and check Maintenance mode status - (11i & R12)

How to enable and check Maintenance mode status - (11i & R12)


Use the Query below:

To Enable maintenance mode from SQLPLUS on MT node

sqlplus apps/*****

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

PL/SQL procedure successfully completed.

Commit complete.


To Disable maintenance mode from SQLPLUS on MT node

sqlplus apps/*****

SQL> @$AD_TOP/patch/115/sql/adsetmmd DISABLE

PL/SQL procedure successfully completed.

Commit complete.


To check status:

SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

FND_PROFILE.VALUE('APPS_MAINTENANCE_MODE')

--------------------------------------------------------------------------------

MAINT/NORMAL


How to create startup & shutdown scripts form Oracle forms & reports ?

How to create startup & shutdown scripts form Oracle forms & reports ?


Startup Script:

cat start_services.sh

export ORACLE_BASE=/u01/oraclefrs
export MW_HOME=$ORACLE_BASE/middleware
export WLS_HOME=$MW_HOME/wlserver
export WL_HOME=$WLS_HOME
export DOMAIN_HOME=$ORACLE_BASE/middleware/user_projects/domains/basenew_domain
export OHS_INST=$DOMAIN_HOME/config/fmwconfig/components/OHS/instances/ohs1

# Start NodeManager
nohup $DOMAIN_HOME/bin/startNodeManager.sh > /dev/null 2>&1 &

sleep 15

# Start WebLogic Domain
nohup $DOMAIN_HOME/bin/startWebLogic.sh > /dev/null 2>&1 &

sleep 60

# Start the managed Servers

nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_FORMS > /dev/null 2>&1 &
nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_REPORTS > /dev/null 2>&1 &
sleep 15

# Start the web tier.

$DOMAIN_HOME/bin/startComponent.sh ohs1
echo " All services are up and Running.... "


Shutdown Script:

cat stop_services.sh

# Adjust paths and domain name to suit your installation.

export ORACLE_BASE=/u01/oraclefrs
export MW_HOME=$ORACLE_BASE/middleware
export WLS_HOME=$MW_HOME/wlserver
export WL_HOME=$WLS_HOME
export DOMAIN_HOME=$ORACLE_BASE/middleware/user_projects/domains/basenew_domain
export OHS_INST=$DOMAIN_HOME/config/fmwconfig/components/OHS/instances/ohs1

# Stop the web tier.

$DOMAIN_HOME/bin/stopComponent.sh ohs1

# Stop the managed Servers

$DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_FORMS
$DOMAIN_HOME/bin/stopManagedWebLogic.sh WLS_REPORTS

# Stop WebLogic Domain

$DOMAIN_HOME/bin/stopWebLogic.sh

# Stop NodeManager

$DOMAIN_HOME/bin/stopNodeManager.sh

How to save the password for 12 OHS during startup and shutdown of services ?

How to save the password for 12 OHS during startup and shutdown of services ?


Stop the OHS services:

$DOMAIN_HOME/bin/stopComponent.sh ohs1

Run the below command, It will prompt for password once and it will generate and store the password in nm-cfg-basenew_domain.props and nm-key-basenew_domain.props location:             

./startComponent.sh ohs1 storeUserConfig

$DOMAIN_HOME/bin/startComponent.sh ohs1 storeUserConfig
Starting system Component ohs1 ...

Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Reading domain from /u01/oraclefrs/middleware/user_projects/domains/basenew_domain

Please enter Node Manager password:
Creating the key file can reduce the security of your system if it is not kept in a secured location after it is created. Creating new key...
The username and password that were used for this WebLogic NodeManager connection are stored in /export/home/testapps/.wlst/nm-cfg-basenew_domain.props and /export/home/testapps/.wlst/nm-key-basenew_domain.props.
Connecting to Node Manager ...
<Jan 5, 2022 12:26:54 PM AST> <Info> <Security> <BEA-090905> <Disabling the CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true.>
<Jan 5, 2022 12:26:54 PM AST> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG128 to HMACDRBG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true.>
<Jan 5, 2022 12:26:54 PM AST> <Info> <Security> <BEA-090909> <Using the configured custom SSL Hostname Verifier implementation: weblogic.security.utils.SSLWLSHostnameVerifier$NullHostnameVerifier.>
Successfully Connected to Node Manager.
Starting server ohs1 ...
Successfully started server ohs1 ...
Successfully disconnected from Node Manager.
Exiting WebLogic Scripting Tool.
Done

Start the OHS services:

$DOMAIN_HOME/bin/startComponent.sh ohs1