Oracle® Enterprise Data Quality for Product Data R12 PIM Connector Installation Guide Release 5.6.2 Part Number E23407-01 |
|
|
View PDF |
dls
User and SchemaThis chapter describes how to create the dls
user, install the R12 PIM Connector database schema, and associate the installed database schema with the dls
user.
Note:
This chapter presents one EBS environment. Your EBS environment may be different so the computer responses will differ though the commands you execute do not.dls
UserThe R12 PIM Connector API components are installed on the EBS using Oracle Database user account, dls
. Create the dls
user:
Log into your EBS database server as user, applmgr
or the user installed the original EBS instance.
Ensure that your login user environment is sourced.
Following is an example of how to source the applmgr
environment file:
. /d01/oracle/VIS/apps/apps_st/appl/APPSVIS_system1.env
Check that the environment is set correctly:
echo $TWO_TASK
The return value should be the SID of the EBS database server.
Copy the dls_pim_connector_install.zip
file that you extracted from the patch set to a temporary directory on your EBS database server.
Unzip dls_pim_connector_install.zip
.
Change directories to the dls_pim_connector_install
directory.
For example, cd /tmp/dls_pim_connector_install
Create the R12 PIM Connector dls
user in the EBS database server:
sqlplus system/manager@VIS < dls_user_creation.sql
Ensure that the dls
user creation successfully completes and no errors are displayed.
The main installation script, dls_pim_connector_install.sh
, installs tables, views, packages, etc. into the EBS dls
database user. The necessary grants and privileges to the tables accessed by the Enterprise DQ for Product R12 PIM Connector are configured in the apps
/apps
schema.
The installation script uses the existing Transaction tablespace and for the installation of the DLS tables in indexes such as the semantic key cache. This is consistent with current Oracle practice (see MetaLink note 248857.1 under the Product tablespaces link).
The temporary tables used by the Enterprise DQ for Product will be written to the Interface tablespace (see MetaLink note 248857.1 under the Product tablespaces link).
The installation script creates a new schema called dls
that is granted quota on the Transaction and Interface table spaces.
While still logged into the EBS Server as applmgr
and in the dls_pim_connector_install
directory, change the file permissions of the R12 PIM Connector installation script:
chmod +x *.sh
Install the database schema:
./dls_pim_connector_install.sh
Note:
You may have to change the file permissions to execute this script.Please enter Apps Schema Name for VIS:
Enter:
apps
Please enter Apps Password for VIS:
Enter:
apps
Please enter DLS Schema Name for VIS:
Enter:
dls
Please enter DLS Password for VIS:
Enter:
dls
The dls
database schema has now been populated with the tables, views, packages, synonyms and triggers. The apps
schema has also been populated with the grants and synonyms needed to run the Enterprise DQ for Product R12 PIM Connector.
A log file is written to the tmp
directory of the applmgr
user.
Review the installation log file, dls_inst_####.log
, and ensure that there were no errors.
The following erroneous error message should be ignored:
Warning: Package created with compilation errors. . Errors for PACKAGE DLS_CONNECTOR_PVT: . LINE/COL ERROR -------- ----------------------------------------------------------------- 49/3 PL/SQL: Declaration ignored 51/66 PLS-00201: identifier 'DLS_CONNECTOR_PUB.G_SEMANTICATTR' must be declared