GRC CCG Configuration of Metabuilder 551 on 11g database

             Configuration of Metabuilder 551 on 11g database


Configuration on Windows
Requirement: Oracle forms 10.1.2 on windows

1. Extract the downloaded CCG_551_metabuilder.zip file in ‘C’ drive
Ex: C:\CCG_551_metabuilder

2. Take the back up of existing tnsnames.ora.
i. Copy the ccg_schema’s tns-name from ccg instance
ii. Paste it in forms repository,  Loc: <forms_repository>\NETWORK\ADMIN

3. Take the back up of default.env and add the below text.
Loc: <oas_repository>/forms/server/default.env
i. Add the value for ORACLE_HOME = <oas_repository/forms>
Ex: ORACLE_HOME=C:\DevSuiteHome_1
ii.  Add FORMS_PATH = <metabuilder_repository>\mb_ui
      Ex: FORMS_PATH=D:\DevSuiteHome_1\forms; C:\ CCG_551_metabuilder\mb_ui

4. Take the back up of registry.dat and add the below text.
Loc: <forms_repository>/forms/java/oracle/forms/registry/registry.dat

i. Add the value default.icons.iconpath=
ii. Add the value default.icons.iconextension=gif

5. Take the back up of existing formsweb.cfg and add the below text at the end of page.
       Loc: <forms_repository>\forms\server\formsweb.cfg
      Ex: D:\DevSuiteHome_1\forms\server\formsweb.cfg
-----------------------------
[metabuilder]
form=metabuilder.fmx
otherparams=param_dbinstance=orcl param_gwyuid=amhome/amhome
separateFrame=True
lookandfeel=Oracle
logo=amwind
pageTitle=Oracle Metabuilder 5.5.1
webUtilArchive=/forms/java/frmwebutil.jar,/forms/java/jacob.jar
archive_jini=frmall_jinit.jar,ico.jar
imagebase=codebase
---------------------------------

Edit this line(3rd) from above:
otherparams=param_dbinstance=<Sid> param_gwyuid=<ccg_home username>/<ccg_home pwd>

6. Copy the ico.jar from CCG_551_metabuilder /mb_ui/java directory to <forms_repository>/forms/java

7. Run the startinst.bat to start the application instance. Need to run every time when the Metabuilder starts.
    Loc: D:\DevSuiteHome_1\j2ee\DevSuite\startinst.bat

8. Open the Internet Explorer (IE) and type the below URL:
URL like http://myhost.mydomain.com/forms/frmservlet?config=metabuilder

Ex: http://127.0.0.1:8889/forms/frmservlet?config=metabuilder
Ex: http://abulle-lap:8889/forms/frmservlet?config=metabuilder


coming issue

# System parameter: default base HTML file
baseHTML=basejpi.htm
# System parameter: base HTML file for use with JInitiator client
baseHTMLjinitiator=basejpi.htm
# System parameter: base HTML file for use with Sun's Java Plug-In
baseHTMLjpi=basejpi.htm
# System parameter: delimiter for parameters in the base HTML files


add the TNS Entry all

LISTENER_A2GRCDB =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.05.96)(PORT = 1908))
 )
)

FINDEV=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=cpnqmedaotzp15.)(PORT=1522))
            (CONNECT_DATA=
                (SERVICE_NAME=FINDEV)
                (INSTANCE_NAME=FINDEV)
            )
        )
A2GRCDB=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =10.0.45)(PORT = 1908)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =A2GRCDB)))
ADR_BASE = /oracle_home/app
ADR_BASE_LISTENER_A2GRCDB = /oracle_home/app