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

No comments:

Post a Comment