configuration

Knowabouts regarding C# webservices connecting Oracle database

First:

A java-progam (.jar) is calling a webservice, written in C#. I’m able to unzip the jarfile or load it in JDeveloper to detect which service it is calling, but how do I know the service is listening to that name? Especially it’s not documented and I don’t have a clue about the name of the wsdl-file.

But, I’m an administrator, and in my case I’m able to log in on the Windows-server where the webservice reside. And I’m looking for a service which might be called ‘HummingBirdService’.
- Start –> run –> inetmgr
- The Internet Information Services (IIS) Manager is started.
- Browse to the tree below the node-name, to ‘Web Sites’ –> ‘Default Web Site’ –>and (yes!)  ‘HummingBirdServices’.
(when you rightclick this by the way, the directory of the files on the right side is shown at the button ‘properties’)
- On the right side of this window the file ‘HummingBirdServiceHost.svc’ resides .
- Right click on this filename (still in the inetmgr !) and choose browse…
A browser opens and the method to call your service is shown by means of an URL.

Second:

A webservice, written in C#, is calling an Oracle Database. Oracle 9i client has been installed.
Message appears: “System.Data.OracleClient requires Oracle client software version 8.1.7 or greater”.

What is missing here is the data provider for .NET. The standard 9.2.0.1-client is missing that option.
To correct this: download the ODAC-install for 9i here (at the bottom of the page the last time I looked). This is a 9.2.0.1-client which includes the data provider for .NET.
Then install (custom option, same home as the standard 9.2.0.1-client) the oracle data provider for .NET in oracle 9.2.0.7

By |September 28th, 2009|App. Server|0 Comments|

Headstart 10g installation/configuration 6.5.4

10 years ago the installation and configuration of Headstart was a lot of sweating, mostly not automated installation-scripts with a lot of faults in it. And thank God it has not changed!! Scripts are Windows-oriented, documentation is not quite self-explainable.

I am not allowed to publish an updated documentation, but sharing experiences is something else.

Maybe still unclear, but 1 different grant or statement in Headstart can make a world of difference…

Situation

- Designer repository-database op Linux, had ooit iemand half Headstart 6.5.0 op geïnstalleerd

- Applicatieserver op Linux (10.2.0.2), idem.

- Windows-clients.

Downloaded:

- PATCH6540_FOR_10G.zip (looks like a patch, maar it isn’t a patch…)

- PATCH65401_FOR_10GR2.zip ( indeed, it is a patch)

- ONE_OFF_QMSOLM65.zip

Install this in this order on your windows-client and on the applicatie-server, check with “unzip –l” where the files will come. Chosen by me: c:/hst10g en /software/hst10g.

Compile the forms, libraries, menu’s against the hst65-user in de designer-repository, will we do this in another step.

Next step

Got the installation document ‘Installation Instructions for Oracle Headstart 6.5.4.0 for 10g (Revision 6.5.4.1 for 10g)’. This document is not in the base-set you download…. Exists of 4 parts, client (1) , application server(2), the development database (3) and the designer repository (4)

1. Client

Put the shortcuts of the directory ‘environment-setup’ on my desktop, updated the properties. The documentation keep mentioning about ‘forms90’ which is not right. Your URL for the serverinstall could be something like ( my case: “LTOA”,domain JOBACLE, de URL ) : http://ltoa.jobacle.nl:7778/forms/frmservlet?config=hsd65_serverinstall .A little bit in the blind, on the application server isn’t installed anything yet.

2. On the application server LTOA

The documentation tells me that you have to update the file <10gasbifhome>\j2ee\OC4J_BI_Forms\config\oc4j.properties (back-slashes, so this will not work..) in order to use hsd65formsweb.cfg.

Advice: don’t do that. Several tools of Oracle, like RDA, will not recognize the configuration in hsd65formweb.cfg.User your own formsweb.cfg in </forms/server. Merge the two files, and update the items being said in the documentation. As this appears also has some difficulties I’ll give hereby a great part of my formsweb.cfg, where the repository is called ‘DES10G’:

[default]

# !!modify here your Headstart settings!!

# baseHTML=<HSD65_HOME>\html\hsd65basejini.htm

baseHTML=/software/hst10g/html/hsd65basejini.htm

# baseHTML=%hsd65_HOME%\html\hsd65basejini.htm

# baseHTMLjinitiator=<HSD65_HOME>\html\hsd65basejini.htm

baseHTMLjinitiator=/software/hst10g/html/hsd65basejini.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

HTMLdelimiter=%

# System parameter: working directory for Forms runtime processes

# WorkingDirectory defaults to <oracle_home>/forms if unset.

workingDirectory=

# System parameter: file setting environment variables for the Forms runtime processes

# envFile=default.env

# !!modify here your Headstart settings!!

envFile=/software/hst10g/html/hsd65default.env

# Forms runtime argument: whether to escape certain special characters

# in values extracted from the URL for other runtime arguments

escapeparams=true

# Forms runtime argument: which form module to run

form=test.fmx

# Forms runtime argument: database connection details

userid=

# Forms runtime argument: whether to run in debug mode

debug=no

# Forms runtime argument: host for debugging

host=

# Forms runtime argument: port for debugging

port=

# Other Forms runtime arguments: grouped together as one parameter.

# These settings support running and debugging a form from the Builder:

otherparams=buffer_records=%buffer% debug_messages=%debug_messages% array=%array% obr=%obr% query_only=%query_only% quiet=%quiet% render=%render% record=%record% tracegroup=%tracegroup% log=%log% term=%term%

# Sub argument for otherparams

buffer=no

# Sub argument for otherparams

debug_messages=no

# Sub argument for otherparams

array=no

# Sub argument for otherparams

obr=no

# Sub argument for otherparams

query_only=no

# Sub argument for otherparams

quiet=yes

# Sub argument for otherparams

render=no

# Sub argument for otherparams

record=

# Sub argument for otherparams

tracegroup=

# Sub argument for otherparams

log=

# Sub argument for otherparams

# term=

# !!modify here your Headstart settings!!

term=/software/hst10g/hst/admin/qmsrf65w.res

# !!modify here your Headstart settings!!

# for AS10g deployment:

# RegistryPath=/forms/hsd65html/

# for Ds10g deployment:

RegistryPath=/forms/hsd65html/

serverApp=hsd65reg

# HTML page title

pageTitle=Oracle Application Server Forms Services

# HTML attributes for the BODY tag

HTMLbodyAttrs=

# HTML to add before the form

HTMLbeforeForm=

# HTML to add after the form

HTMLafterForm=

# Forms applet parameter: URL path to Forms ListenerServlet

serverURL=/forms/lservlet

# Forms applet parameter

codebase=/forms/java

# Forms applet parameter

#imageBase=DocumentBase

# Forms applet parameter

width=1024

# Forms applet parameter

height=768

# Forms applet parameter

separateFrame=true

# Forms applet parameter

splashScreen=

# Forms applet parameter

background=

# Forms applet parameter

lookAndFeel=Oracle

# Forms applet parameter

colorScheme=teal

# Forms applet parameter

logo=

# Forms applet parameter

restrictedURLparams=HTMLbodyAttrs,HTMLbeforeForm,pageTitle,HTMLafterForm,log,allow_debug,allowNewConnections

# Forms applet parameter

formsMessageListener=

# Forms applet parameter

recordFileName=

# Forms applet parameter

serverApp=default

# Forms applet archive setting for JInitiator

# archive_jini=frmall_jinit.jar

# !!modify here your Headstart settings!!

archive_jini=frmall_jinit.jar,hst65.jar

# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)

# archive=frmall.jar

# !!modify here your Headstart settings!!

archive=frmall.jar,hst65.jar

# Number of times client should retry if a network failure occurs. You should

# only change this after reading the documentation.

networkRetries=0

# Page displayed to Netscape users to allow them to download Oracle JInitiator.

# Oracle JInitiator is used with Windows clients.

# If you create your own page, you should set this parameter to point to it.

jinit_download_page=/forms/jinitiator/us/jinit_download.htm

# Parameter related to the version of JInitiator

jinit_classid=clsid:CAFECAFE-0013-0001-0022-ABCDEFABCDEF

# Parameter related to the version of JInitiator

jinit_exename=jinit.exe#Version=1,3,1,22

# Parameter related to the version of JInitiator

jinit_mimetype=application/x-jinit-applet;version=1.3.1.22

# Page displayed to users to allow them to download Sun’s Java Plugin.

# Sun’s Java Plugin is typically used for non-Windows clients.

# (NOTE: you should check this page and possibly change the settings)

jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html

# Parameter related to the version of the Java Plugin

jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA

# Parameter related to the version of the Java Plugin

jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06

# Parameter related to the version of the Java Plugin

jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06

# EM config parameter

# Set this to “1″ to enable Enterprise Manager to track Forms processes

em_mode=1

# Single Sign-On OID configuration parameter

oid_formsid=%OID_FORMSID%

# Single Sign-On OID configuration parameter

oracle_home=/software/oracle/middle

# Single Sign-On OID configuration parameter

formsid_group_dn=%GROUP_DN%

# Single Sign-On OID configuration parameter: indicates whether we allow

# dynamic resource creation if the resource is not yet created in the OID.

ssoDynamicResourceCreate=true

# Single Sign-On parameter: URL to redirect to if ssoDynamicResourceCreate=false

ssoErrorUrl=

# Single Sign-On parameter: Cancel URL for the dynamic resource creation DAS page.

ssoCancelUrl=

# Single Sign-On parameter: indicates whether the url is protected in which

# case mod_osso will be given control for authentication or continue in

# the FormsServlet if not. It is false by default. Set it to true in an

# application-specific section to enable Single Sign-On for that application.

ssoMode=false

# The parameter allow_debug determines whether debugging is permitted.

# Administrators should set allow_debug to “true” if servlet

# debugging is required, or to provide access to the Forms Trace Xlate utility.

# Otherwise these activities will not be allowed (for security reasons).

allow_debug=false

# Parameter which determines whether new Forms sessions are allowed.

# This is also read by the Forms EM Overview page to show the

# current Forms status.

allowNewConnections=true

# EndUserMonitoring

# EndUserMonitoringEnabled parameter

# Indicates whether EUM/Chronos integration is enabled

EndUserMonitoringEnabled=

# EndUserMonitoringURL

# indicates where to record EUM/Chronos data

EndUserMonitoringURL=

# Example Named Configuration Section

# Example 1: configuration to run forms in a separate browser window with

# “generic” look and feel (include “config=sepwin” in the URL)

# You may define your own specific, named configurations (sets of parameters)

# by adding special sections as illustrated in the following examples.

# Note that you need only specify the parameters you want to change. The

# default values (defined above) will be used for all other parameters.

# Use of a specific configuration can be requested by including the text

# “config=<your_config_name>” in the query string of the URL used to run

# a form. For example, to use the sepwin configuration, your could issue

# a URL like “http://myhost.mydomain.com/forms/frmservlet?config=sepwin”.

[sepwin]

separateFrame=True

lookandfeel=Generic

# Example Named Configuration Section

# Example 2: configuration forcing use of the Java Plugin in all cases (even if

# the client browser is on Windows)

[jpi]

baseHTMLJInitiator=basejpi.htm

# Example Named Configuration Section

# Example 3: configuration running the Forms ListenerServlet in debug mode

# (debug messages will be written to the servlet engine’s log file).

[debug]

serverURL=/forms/lservlet/debug

# Sample configuration for deploying WebUtil. Note that WebUtil is shipped with

# DS but not AS and is also available for download from OTN.

[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

form=webu_test.fmx

envFile=default.env

# !!modify here your Headstart settings!!

[hsd65_serverinstall]

form=hsdinst.fmx

logo=menulogo.gif

[hsd65_demo]

form=hsd0000f.fmx

userid=hdemo65/hdemo65@des10g

logo=menulogo.gif

# to find *.gif files in jars

imageBase=codebase

[hsd65_utilities]

form=hsustart.fmx

logo=menulogo.gif

archive_jini=frmall_jinit.jar,hst65.jar,hsu65.jar

userid=

# to find *.gif files in jars

imageBase=codebase

[hsd65_administration]

form=hsu0000f.fmx

logo=menulogo.gif

userid=hsu65/hsu65@des10g

# to find *.gif files in jars

imageBase=codebase

[hsd65_foundation]

form=qfd0000f.fmx

logo=menulogo.gif

userid=hsu65/hsu65@des10g

# to find *.gif files in jars

imageBase=codebase

[hsd65_debug_monitor]

form=qms0002f.fmx

logo=menulogo.gi

#userid=hsu65/hu65@des10g

# to find *.gif files in jars

imageBase=codebase

[run_report_demo]

form=run_report

userid=hdemo65/hdemo65@des10g

logo=menulogo.gif

Then update the <appserver_home>/forms/server/forms.conf.

Here a part of the forms.conf, where /software/hst10g is the home of Headstart :

# !! modify her your headstart settings!!

AliasMatch ^/forms/hsd65java(..*) “/software/hst10g/java/$1″

AliasMatch ^/forms/hsd65html(..*) “/software/hst10g/html/$1″

AliasMatch ^/forms/hsd65icons(..*) “/software/hst10g/html/icons/$1″

AliasMatch ^/forms/hsd65-help(..*) “/software/hst10g/doc/$1″

AliasMatch ^/forms/hsd65-cdm(..*) “/software/hst10g/hsu/cdm/$1″

# forms90temp of formstemp? I think it is not used anymore….

AliasMatch ^/forms/forms90temp(..*) “/software/oracle/middle/temp/$1″

You can test this partly by the url: http://ltoa.jobacle.nl:7778/hsd65html/hsd65basejini.htm .

If you use a default environment file, update the file /software/hst10g/html/hsd65default.env. Be aware that in the several PATH’s the seperation character is a colon (:), instead of a semicolon (;), like the documentation said.

The best you can do is copy the library- , class- and forms-paths from an existing environment-file.

#hsd65default.env

# Please refer to the Forms documentation for details.

#

ORACLE_HOME=/software/oracle/middle

FORMS_MAPPING=/forms/forms-output/

FORMS_OUTPUT=/software/hst10g/output

FORMS_REPFORMAT=html

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

NLS_DATE_FORMAT=DD-MM-YYYY

# Headstart utility environment settings

HSD65_CDM_MAPPING=/forms/hsd65-cdm/

HSD65_HELPFILE_WEB_PATH=/forms/hsd65-help/

HSD65_HOME=/software/hst10g

HSD_REPSERVER=reptest

#

# Search path for Forms applications (.fmx files, PL/SQL libraries)

# If you need to include more than one directory, they should be semi-colon

# separated (e.g. c:\test\dir1;c:\test\dir2)

#

FORMS_PATH=/software/oracle/middle/forms:/software/hst10g/hst/admin:/software/hst10g/hst/fndapp:/software/hst10g/hst/demo:/software/hst10g/hsu/forms:/software/ontw/<applicatie>

REPORTS_PATH=/software/hst10g/hst/admin;/software/hst10g/hst/demo

TNS_ADMIN=/software/oracle/middle/network/admin

# webutil config file path

WEBUTIL_CONFIG=/software/oracle/middle/forms/server/webutil.cfg

# Disable/remove this variable if end-users need access to the query-where

# functionality which potentially allows them to enter arbitrary SQL

# statements when in enter-query mode.

FORMS_RESTRICT_ENTER_QUERY=FALSE

PATH=/software/oracle/middle/bin;/software/oracle/middle/jdk/jre/lib/i386/client;/software/oracle/middle/jdk/bin

FORMS=/software/oracle/middle/forms

CLASSPATH=/software/oracle/middle/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/software/oracle/middle/jlib/repository.jar:/software/oracle/middle/jlib/ldapjclnt10.jar:/software/oracle/middle/jlib/debugger.jar:/software/oracle/middle/jlib/ewt3.jar:/software/oracle/middle/jlib/share.jar:/software/oracle/middle/jlib/utj.jar:/software/oracle/middle/jlib/zrclient.jar:/software/oracle/middle/reports/jlib/rwrun.jar:/software/oracle/middle/forms/java/frmwebutil.jar:/software/oracle/middle/jlib/debugger.jar:/software/oracle/middle/jlib/ewt3.jar:/software/oracle/middle/jlib/share.jar:/software/oracle/middle/jlib/utj90.jar:/software/oracle/middle/jdk/jre/lib/rt.jar:/software/oracle/middle/jlib/zrclient.jar:/software/oracle/middle/reports/jlib/rwrun.jar:/software/oracle/middle/forms/java/comm.jar:/software/webutil/lib/webutil.jar:/software/oracle/middle/jdk/jre/lib/i386/native_threads/

LD_LIBRARY_PATH=:/software/oracle/middle/lib:/software/oracle/middle/jdk/jre/lib/i386:/software/oracle/middle/jdk/jre/lib/i386/native_threads:/software/oracle/middle/jdk/jre/lib/i386/server:/software/oracle/middle/jdk/jre/lib/i386/native_threads/:/software/oracle/middle/jre/1.4.2/lib/i386/native_threads/

3.  Development database

There is a shortcut delivered, named ‘Headstart Serverinstall’ to use on your desktop. Do not use this. It doesn’t work. Instead of this use the downloadable document : ‘How to manually do the Server Side Installation of Headstart Oracle Designer’.

Also don’t try to run the scripts from Linux, does not work. Oracle is working on the release for Linux, is coming somewhere in the future…

So run all the scripts from your Windows-client.

In our situation users were already created by /hst/create_hsd65_users.sql, but after that they did not follow the documentation and are all objects of hst65 (template owner) placed in an owner of an application. Doesn’t matter that much, but for my story I presume that all is made under the user hst65. When you install it from zero, you will have to run /hst/insthst.sql with the parameters c:/hst10g en hst65 draaien.

Between 6.5.0 en 6.5.4 there are very few changes in the table-sctructure, and only in packages, so I’ve been told…

Started with running c:/hst10g/hst/scripts/hstmsgh.sql (messages). When you run this on Linux it won’t work, because the file ‘cg$errors.pkb’ is not there for example. The “‘$” is unknown. There are workarounds, but the smooth way is to run it from your windows-client. Another thing what will be noticed: case-sensitive stuff in the scripts.

While running the scripts, noticed that qms_transaction_mgmt need an extra column, and we missed some grants:

As SYS:

grant execute on DBMS_PIPE to hst65

grant select on v_$session to hst65;

alter table qms_transactions add (STATEMENT_CTR NUMBER(10) DEFAULT 0 NOT NULL);

After that: hsttapi.sql , ins_msg.sql (many errors, because of many unique rows exists, but many rows are inserted), ins_srp.sql, ins_ref.sql as user hst65.

Several forms, libraries, en pll’s needs to be compiled on Linux. Do this against the hst65-user in de designer-repository. Unfortunately this user does not exist in this step – that’s the next one, but when this user exists, you may be able to compile with scripts like this:

Example of compile-scripts:

(frmcmp_batch.sh should normally be in $ORACLE_HOME/bin)

#compile_pll.sh

export FORMS_PATH=.:$FORMS_PATH

oldterm=$TERM

export TERM=vt220

for i in `ls *.pll`

do

echo Compiling fmbs $i ….

frmcmp_batch.sh module=$i userid==<un>/<pw>@<db> module_type=library compile_all=yes

done

export TERM=$oldterm

#compile_forms.sh

export FORMS_PATH=.:$FORMS_PATH

oldterm=$TERM

export TERM=vt220

for i in `ls *.fmb`

do

echo Compiling fmbs $i ….

frmcmp_batch.sh module=$i userid=<un>/<pw>@<db> module_type=form compile_all=yes

done

export TERM=$oldterm

#compile_forms.sh

export FORMS_PATH=$FORMS_PATH:.

oldterm=$TERM

export TERM=vt220

for i in `ls *.mmb`

do

echo Compiling mmbs $i ….

frmcmp_batch.sh module=$i userid=<un>/<pw>@<db> module_type=menu compile_all=yes

done

export TERM=$oldterm

You will notice that 1 menu will not compile: qms65mnt.mmb: error on QMS_MENU.SET_CURRENT_ACTION. Opened the menu in developer (in windows) , added the libraries qmlsib65 and qmsevh65. Seems very sloppy. Then copied the mmb to Linux and compiled.

4. Designer repository

Repeat step 3 on the designer-repository.

After that you need to configure hsu65 (Utilities).

Hier zit al het een en ander in, maar het is het handigste om deze helemaal leeg te gooien en opnieuw te beginnen. We hebben hem maar gedropt:

When it exists, empty or drop it, and start all over again. We dropped the user:

DROP USER HSU65 CASCADE;

CREATE USER HSU65

IDENTIFIED BY VALUES ’3A8E5269C73B1476′

DEFAULT TABLESPACE INSP_SMALL

TEMPORARY TABLESPACE TEMP

PROFILE DEFAULT

ACCOUNT UNLOCK;

– 3 Roles for HSU65

GRANT CONNECT TO HSU65;

GRANT HSU65_USER TO HSU65 WITH ADMIN OPTION;

GRANT RESOURCE TO HSU65;

ALTER USER HSU65 DEFAULT ROLE ALL;

– 9 System Privileges for HSU65

GRANT CREATE TRIGGER TO HSU65;

GRANT CREATE ROLE TO HSU65;

GRANT CREATE TYPE TO HSU65;

GRANT CREATE PROCEDURE TO HSU65;

GRANT CREATE ANY SYNONYM TO HSU65;

GRANT DROP ANY SYNONYM TO HSU65;

GRANT UNLIMITED TABLESPACE TO HSU65;

GRANT CREATE INDEXTYPE TO HSU65;

GRANT CREATE OPERATOR TO HSU65;

– 1 Tablespace Quota for HSU65

ALTER USER HSU65 QUOTA UNLIMITED ON INSP_SMALL;

– 16 Object Privileges for HSU65

GRANT EXECUTE ON DES10G_OWNER.CKMIGFUN TO HSU65;

GRANT SELECT ON DES10G_OWNER.I$RM_ELEMENT_TYPES TO HSU65;

GRANT EXECUTE ON DES10G_OWNER.JR_SYSTEM_UTIL TO HSU65;

GRANT EXECUTE ON DES10G_OWNER.JR_UTIL TO HSU65;

GRANT EXECUTE ON DES10G_OWNER.SDD_ACC_PRIV_LIST TO HSU65;

GRANT SELECT ON DES10G_OWNER.SDD_DEPENDENCY_TYPES TO HSU65;

GRANT SELECT ON DES10G_OWNER.SDD_GLOBAL_NAMES TO HSU65;

GRANT EXECUTE ON DES10G_OWNER.SDD_SYS_PRIV_LIST TO HSU65;

GRANT EXECUTE ON HST65.CG$ERRORS TO HSU65;

GRANT EXECUTE ON HST65.HIL_MESSAGE TO HSU65;

GRANT EXECUTE ON HST65.QMS$ERRORS TO HSU65;

GRANT INSERT, SELECT, UPDATE ON HST65.QMS_MDE_PARAMS TO HSU65;

GRANT SELECT ON HST65.QMS_MESSAGE_PROPERTIES TO HSU65;

GRANT SELECT ON HST65.QMS_MESSAGE_TEXT TO HSU65;

GRANT INSERT, SELECT, UPDATE ON HST65.QMS_MODULES TO HSU65;

GRANT EXECUTE ON HST65.QMS_TRANSACTION_MGT TO HSU65;

But.. we forgot something:

grant create operator to hsu65;

grant create procedure to hsu65;

grant create view to hsu65;

create role hsu65_user;

grant select on dba_role_privs to hsu65;

grant select on dba_tab_privs to hsu65;

grant select on dba_synonyms to hsu65;

grant select on sys.v_$parameter to hsu65;

grant create any synonym,

create role,

drop any synonym to hsu65;

grant hsu65_user to hsu65 with admin option;

Data-import:

C:\hst10g\hsu\scripts\imp_sgl.bat C:\hst10g c: imp.exe hsu65/hsu65@des10g

As SYS:

grant execute on DBMS_PIPE to hsu65

grant select on v_$db_pipes to hsu65;

As HST65:

@C:\hst10g\hst\scripts\hstuserb.grt C:\hst10g hsu65

(with exit at the end!)

As DES10G_OWNER:

@C:\hst10g\hsu\scripts\d6grtsyn.sql C:\hst10g hsu65

As HSU65:

@C:\hst10g\hsu\scripts\insthsu.sql C:\hst10g hst65 hsu65

(with exit at the end)

Problem while executing the script: ‘cannot insert null’ . Filthy solutiong: disable triggers of hsu65.hsu_utilities.

After disabling, run it again:

prompt … installing Quality Check utilities

set termout off

– Applications

execute hsu_qa_app.install

– Domains

execute hsu_qa_dom.install

– Entities

execute hsu_qa_ent.install

– Events

execute hsu_qa_evt.install

– Functions

execute hsu_qa_fun.install

– Table Definitions

execute hsu_qa_tbl.install

– View Definitions

execute hsu_qa_vw.install

– Sequences

execute hsu_qa_osq.install

– Modules

execute hsu_qa_gem.install

– PL/SQL Definitions

execute hsu_qa_plm.install

– Reusable Module Components

execute hsu_qa_mco.install

– Oracle Databases

execute hsu_qa_orc.install

– Non-Oracle Databases

execute hsu_qa_ans.install

set termout on

prompt … installing Productivity Boosters

–set termout off

@c:\hst10g\hsu\scripts\pb\insallpb.sql

set termout on

prompt … adding grants to role HSU65_USER

set termout off

@c:\hst10g\hsu\scripts\hsu_user.rol

set termout on

prompt … creating Utilities Tree Structure

set termout off

@c:\hst10g\hsu\scripts\ins_nod

set termout on

prompt … inserting User Groups

set termout off

@c:\hst10g\hsu\scripts\ins_ugr

set termout on

prompt … resetting sequences

set termout off

@c:\hst10g\hsu\scripts\resetsq.sql HSU_QAS_SEQ1 HSU_QA_SETS ID

@c:\hst10g\hsu\scripts\resetsq.sql OMR_FNA_SEQ1 OMR_FUNCTIONAL_AREAS ID

@c:\hst10g\hsu\scripts\resetsq.sql OMR_ANT_SEQ1 OMR_ANNOTATIONS ID

Then:

create synonym hsu65.CG_REF_CODE for hst65.QMS_REF_CODES;

By the way: ofgtel65.pll points to QMS_REF_CODES instead of CG_REF_CODES.

By |June 8th, 2009|App. Server|0 Comments|