Oracle Tricks and Tips.: 12/27/18

Oracle 11g Fusion Middleware Installation (Steps):

1.    First install weblogic server named wls1036_win32 IN DEPLOYMENT MODE

2.    THEN RUN ORACLE FORMS AND REPORT

---- need to install deployment mode ---
--- then configure file

-- STEP 1 ---

FOR ORACLE DATABASE TNS LOCATION

D:\app\Administrator\product\11.2.0\dbhome_2\network\admin\tnsnames.ora
D:\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN

-------

ORCL6688 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = noor-pc)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl6688)
    )
)

=========================================
--- Step 2 for oracle FORM CONNECTION
========================================

D:\Oracle\Middleware\asinst_1\config\tnsnames

ORCL6688 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = noor-pc)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl6688)
    )
)

--- Step 3----

FOR ORACLE FORMS RUN TIME DEFAULT LOCATION AND CONFIGURATION

LOCATION

D:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\AdminServer\applications\formsapp_11.1.2\config\default

or

D:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_11.1.2\config\default

--- a.....

FORMS_PATH=D:\Oracle\Middleware\Oracle_FRHome1\forms;d:\Oracle\Middleware\asinst_1\FormsComponent\forms;D:\dtal\admin\forms;D:\dtal\afd\forms;D:\dtal\pmis\forms;D:\dtal\admin\menu;D:\dtal\afd\menu;D:\dtal\pmis\menu;D:\dtal;D:\dtal\afd\reports;

--- b -----
CLASSPATH=D:\Oracle\Middleware\Oracle_FRHome1\forms\j2ee\frmsrv.jar;D:\Oracle\Middleware\Oracle_FRHome1\jlib\ldapjclnt11.jar;D:\Oracle\Middleware\Oracle_FRHome1\jlib\debugger.jar;D:\Oracle\Middleware\Oracle_FRHome1\jlib\ewt3.jar;D:\Oracle\Middleware\Oracle_FRHome1\jlib\share.jar;D:\Oracle\Middleware\Oracle_FRHome1\jlib\utj.jar;D:\Oracle\Middleware\Oracle_FRHome1\jlib\zrclient.jar;D:\Oracle\Middleware\Oracle_FRHome1\reports\jlib\rwrun.jar;D:\Oracle\Middleware\Oracle_FRHome1\forms\java\frmwebutil.jar;D:\Oracle\Middleware\Oracle_FRHome1\jlib\start_dejvm.jar;D:\Oracle\Middleware\Oracle_FRHome1\opmn\lib\optic.jar;D:\Oracle\Middleware\Oracle_FRHome1\forms\java\frmwebutil.jar;D:\Oracle\Middleware\Oracle_FRHome1\forms\java\mypackage1.jar

--- Step 4-----
FOR ORACLE FORMS RUN TIME FORMSWEB LOCATION AND CONFIGURATION
---------------------------
D:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\AdminServer\applications\formsapp_11.1.2\config\formsweb

or

D:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_11.1.2\config\formsweb

form=d:\dtal\login.fmx
width=100%
height=100%
# Forms applet archive setting for JInitiator
archive_jini=frmall_jinit.jar,GetImageFileName.jar,handleimages.jar, classes12.jar,mypackage1.jar,ftpbean.jar,simpleFTP.jar,handleimage.jar,clientinfos.jar
# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
archive=frmall.jar,clientinfos.jar,GetImageFileName.jar,handleimages.jar, classes12.jar,mypackage1.jar,ftpbean.jar,simpleFTP.jar,handleimage.jar,clientinfos.jar

[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar
archive=frmall.jar
lookAndFeel=oracle

==================================================
--- Step 5 for Forms file ---
==================================================
D:\Oracle\Middleware\Oracle_FRHome1\forms

put following file in forms folder

NREL_PL_LIB.pll, NREL_PL_LIB.plx, webutil.pll

==================================================
--- Step 6 for Java file ---
==================================================
D:\Oracle\Middleware\Oracle_FRHome1\forms\java

Following file need to put in this java folder

mypackage1, jacob, handleimage, GetImageFileName, frmall_jinit

=====================================================================
Start Weblogic Server CMD promt
D:\Oracle\Middleware\user_projects\domains\ClassicDomain\startWebLogic

===========================================================
Configuration Options
        Middleware Home Location: d:\Oracle\Middleware
        Oracle Home Location: d:\Oracle\Middleware\Oracle_FRHome1
        Oracle Instance Location: d:\Oracle\Middleware\asinst_1
        Oracle Instance: asinst_1
        Domain Option: Create Domain
        Domain Name: ClassicDomain
        Domain Home: d:\Oracle\Middleware\user_projects\domains\ClassicDomain
        Domain Host Name: noor-pc
        Domain Port No: 7003
        User Name: weblogic
        Automatic Port Detection: true
        Administrator Console: http://noor-pc:7003/console
        Forms URL: http://noor-pc:7003/forms/frmservlet
        Reports URL: http://noor-pc:7003/reports/rwservlet

====================================================================
----------REPORT ------------------------
D:\Oracle\Middleware\asinst_2\config\reports\bin
D:\Oracle\Middleware\asinst_2\config\reports\bin\rwbuilder.bat
=====================================================================
start weblogic report server

CHECK REPORT SERVER PORT AND IP ADDRESS

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Oracle Classic Instance - asinst_2\Reports Services\Start Weblogic Server - WLS_REPORTS

REPORT SERVER LOCATION

D:\Oracle\Middleware\asinst_2\reports\server\rep_wls_reports_oracleserver_asinst_2

======================================
CHANGE REPORT PROPERTIES NAMED (rwservlet) FOR RUNNING REPORT

D:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.1.2\configuration

L2
rep_wls_reports_noor-pc_asinst_1
=====================================
START BEFORE RUN A REPORT
http://noor-pc:9002/reports/rwservlet/startserver

=================================