Table of Contents
Overview
This document is for informatica administration team, providing the detailed steps on installation of Power Center 8.6.1 on Linux & Oracle Environment.
Download Software
Download Software from informatica Corporation and make sure to get proper keys based on
environment (Dev/ Prod).
Setup of Database Parameters, Users & Tablespace
Database Parameter
Set the open_cursors parameter to 1000
SQL> SHOW parameter open_cursor;
NAME TYPE VALUE
————————————
———– ——————————
open_cursors integer 300
SQL> ALTER system SET open_cursors=1000;
System altered.
SQL>
ALTER system SET open_cursors=1000 SCOPE=BOTH;
System altered.
SQL> SHOW parameter open_cursors;
NAME TYPE VALUE
————————————
———– ——————————
open_cursors integer 1000
Repository Account
At least two database user accounts
(Domain and Repository) are required to host repository, Taking sample names as
USER_REP for the repository Database
USER_DOM for the domain
Configuration Database
Both user need to create with the
CONNECT, RESOURCE, and CREATE VIEW privileges.
For
Oracle, you must perform the following instruction:
CREATE USER UAER_REP IDENTIFIED BY USER_REP
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
GRANT CONNECT, resource, CREATE VIEW TO USER_REP;
CREATE USER UASER_DOM IDENTIFIED BY USER_DOM
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
GRANT CONNECT, resource, CREATE VIEW, SELECT ANY dictionary TO USER_DOM;
The
grant “select dictionary privilege” to the user INFA_DOM is only needed to
verify the parameter Open_Cursor during the prerequisite check.
Repository Tablespace
Set
the storage size for the tablespace to a small number to prevent the repository
from using an excessive amount of space.
Also
verify that the default tablespace for the user that owns the repository tables
is set to a small size. The following example shows how to set the recommended
storage parameter for a tablespace named PC_TABLESPACE.
ALTER
TABLESPACE "PC_TABLESPACE" DEFAULT STORAGE ( INITIAL 10K NEXT 10K
MAXEXTENTS UNLIMITED PCTINCREASE 50 );
Operating System
Processor
Verify
that the process match the software (x86_64)
Display the Linux platform = uname
– p
List the basic system information, OS release, and OS
version = uname -orv
-bash-3.2$ uname -p
x86_64
-bash-3.2$ uname –arv
Linux ServerName 2.6.18-164.el5 #1 SMP Thu
Sep 3 04:15:13 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
Temporary Disk Space Requirements
The
installer writes temporary files to the hard disk. When the installation
completes, the installer deletes the temporary files and releases the disk
space.
| Installer UNIX | 1 GB |
| Informatica Services UNIX | 2 GB |
Verification
of the temporary space with the df
-bash-3.2$ df -h /tmp
UNIX User Account
On UNIX, create a user account -bash-3.2$
specifically to run the Informatica daemon required for installation having
group privileges’ on Oracle and java groups
Port Validation
Verify that the port numbers are available on the machines
where you install Informatica Services.
-bash-3.2$
netstat -tulpn|grep 6005
The
installer validates the port numbers that you specify to ensure that there will
be no port conflicts in the domain.
-bash-3.2$ netstat -tulpn|grep 6001
(Not
all processes could be identified, non-owned process info will not be shown,
you would have to be root to see it all.)
tcp 0
0 :::6001
:::* LISTEN 4935/java
-bash-3.2$ netstat -tulpn|grep 6002
(Not
all processes could be identified, non-owned process info will not be shown, you would have to be root
to see it all.)
tcp 0
0 ::ffff:127.0.0.1:6002
:::* LISTEN 4935/java
-bash-3.2$ netstat -tulpn|grep 6003
(Not
all processes could be identified, non-owned process info will not be shown,
you would have to be root to see it all.)
-bash-3.2$ netstat -tulpn|grep 6004
(Not
all processes could be identified, non-owned process info will not be shown,
you would have to be root to see it all.)
Environment Variables
Most UNIX
systems use the LANG variable to specify the desired locale
but you can use also the set locale function.
Obtain the locale values
To obtain the locale names for your UNIX system, enter
the following:
infa@chetltst201 $ locale -a | grep -i en
en_AU
en_AU.iso88591
en_AU.utf8
en_BW
en_BW.iso88591
en_BW.utf8
en_CA
en_CA.iso88591
en_CA.utf8
en_DK
en_DK.iso88591
en_DK.utf8
en_GB
en_GB.iso88591
en_GB.iso885915
en_GB.utf8
en_HK
en_HK.iso88591
en_HK.utf8
en_IE
File Descriptor
Informatica
service processes can use a large number of files. Set the Linux – File Descriptor limit per process to 3000
or higher.
In the
file /etc/security/limits.conf, add this
line:
# PowerCenter
-bash-3.2$ hard nofile
3001
-bash-3.2$ soft nofile
2500
And verify
with the ulimit
function logged as the powercenter system user account:
-bash-3.2$
ulimit -Hn
3001
The limit
is set to 3001 to prevent an error with the value 300 during the prerequisites
check
As root,
create the installation base directory:
Pwd
/infa
mkdir /informatica
chown 755 informatica
cd informatica
mkdir pc86
chown 755 pc86
cd /infa
mkdir software
chmod 755 software
IUnzip Software
-rw-r--r--
1 -bash-3.2$ infadmin 880824320 May 21
18:30 pc861_linux_em64t.tar
-rw-r--r--
1 -bash-3.2$ infadmin 1219901440 May 21 18:30 pc861_HotFix14_linux_em64t.tar
-bash-3.2$@ServerName
$ tar -xf pc861_linux_em64t.tar
-bash-3.2$@ServerName
$ ls -ltr
drwxr-xr-x
3 -bash-3.2$ infadmin 4096 Nov
17 2008 Update
-rwxr-xr-x
1 -bash-3.2$ infadmin 4169 Nov
17 2008 jpsjis.msg
-rwxr-xr-x
1 -bash-3.2$ infadmin 4347 Nov
17 2008 english.msg
drwxr-xr-x
4 -bash-3.2$ infadmin 4096 Dec 1 2008
sapsolutions
drwxr-xr-x
4 -bash-3.2$ infadmin 4096 Dec 1 2008
saptrans
-rwxr-xr-x
1 -bash-3.2$ infadmin 4378 Dec 5 2008
ko_euckr.msg
-rwxr-xr-x
1 -bash-3.2$ infadmin 3451 Dec 5 2008
zh_gbk.msg
-rwxr-xr-x
1 -bash-3.2$ infadmin 3640 Dec
12 2008 jpeuc.msg
drwxr-xr-x
3 -bash-3.2$ infadmin 4096 Dec
19 2008 Server
-rwxr-xr-x
1 -bash-3.2$ infadmin 10364 Dec
19 2008 install.sh
-rwxr-xr-x
1 -bash-3.2$ infadmin 343 Dec
19 2008 infa_install_version.properties
-rw-r--r--
1 -bash-3.2$ infadmin 880824320 May 21
18:30 pc861_linux_em64t.tar
-rw-r--r--
1 -bash-3.2$ infadmin 1219901440 May 21 18:30 pc861_HotFix14_linux_em64t.tar
Server Software Installation
-bash-3.2$@ServerName $ ./install.sh
***************************************************************************
* Welcome to the
Informatica PowerCenter 8.6.1 Installer.
*
***************************************************************************
Before
you continue, read the PowerCenter Installation Guide and Release Notes.
You
can find the PowerCenter documentation in the Documentation Center at
http://my.informatica.com
Do
you want to continue? (Y/N)Y
Installer
requires operating system Linux version 2.4 and later.
Current
operating system Linux version 2.6.
Current
operating system meets minimum requirements.
———————————————————–
Checking
for existing PowerCenter product installation.
Unset
the INFA_HOME,INFA_NODE_NAME and INFA_DOMAINS_FILE before continuing
the
installation. Continuing the installation with the environment variables set
will
cause the installation to fail.
Installer
will exit now.
-bash-3.2$@ServerName
$ unset
INFA_HOME
-bash-3.2$@ServerName
$ unset
INFA_NODE_NAME
-bash-3.2$@ServerName
$ unset
INFA_DOMAINS_FILE
-bash-3.2$@ServerName
$ ./install.sh
***************************************************************************
*
Welcome to the Informatica PowerCenter 8.6.1 Installer. *
***************************************************************************
Before
you continue, read the PowerCenter Installation Guide and Release Notes.
You
can find the PowerCenter documentation in the Documentation Center at
http://my.informatica.com
Do
you want to continue? (Y/N)Y
Installer
requires operating system Linux version 2.4 and later.
Current
operating system Linux version 2.6.
Current
operating system meets minimum requirements.
———————————————————–
Checking
for existing PowerCenter product installation.
Select
(G)UI mode (needs X Window support) or (C)onsole mode (G/C):C
Launching
installer in console mode …
Preparing
to install…
Extracting
the JRE from the installer archive…
Unpacking
the JRE…
Extracting
the installation resources from the installer archive…
Configuring
the installer for this system’s environment…
Launching
installer…
Preparing
CONSOLE Mode Installation…
===============================================================================
Choose
Locale…
———————————————————————————————————————————-
->1- English
CHOOSE
LOCALE BY NUMBER: 1
===============================================================================
PowerCenter
8.6.1 (created with
InstallAnywhere by Macrovision)
———————————————————————————————————————————
===============================================================================
Welcome
———————————————————————————————————————————-
Welcome to Informatica PowerCenter 8.6.1.
Use this wizard to install Informatica
PowerCenter 8.6.1.
Copyright 1998-2008 Informatica
Corporation. All rights reserved.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Configure Environment Variables
———————————————————————————————————————————-
Required UNIX Environment Variables, You
must set the following environment variables to continue with the installation
on UNIX machines:
DISPLAY variable: Configure the DISPLAY
variable to run the GUI-based installation program using X Windows on Solaris,
AIX, HP-UX, and Linux.
Locale variables: Configure the LANG,
LANG_C, LC_TYPE, and LC_ALL variables to generate appropriate code pages and
create and connect to repositories and Repository Services.
If any of the required variables are not
configured, quit the installation program, configure the variables, and restart
the installation program. If you are not sure that the environment is correctly
configured, quit the installation and verify environment settings. For more
information about configuring environment variables and testing database
connections, see the PowerCenter Installation Guide.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Choose Installation Type
—————————————————————————————————————————————–
Please choose the Install Set to be
installed by this installer.
->1- Install PowerCenter 8.6.1
2- Upgrade to PowerCenter 8.6.1
ENTER THE NUMBER FOR THE INSTALL SET, OR
PRESS <ENTER> TO ACCEPT THE DEFAULT
: 1
===============================================================================
PowerCenter License Key
—————————————————————————————————————————————-
<Type ‘back’ for the previous panel or
‘quit’ to exit the installer.>
License key file
Select the license key file: (DEFAULT:
/home/-bash-3.2$/license.key):
/infa/informatica/pc86/LicenceKey_Lin64_V861.key
===============================================================================
Installation Prerequisites
—————————————————————————————————————————————-
Verify the installation prerequisites and
complete the pre-installation tasks before continuing with the installation.
Prerequisites
Domain Configuration Database
– Oracle, Microsoft SQL Server, Sybase ASE,
or IBM DB2
– At least one database user account is
required to complete the installation.
Disk Space Requirements
–
2 GB
Pre-installation
Tasks
Create
a system user account and configure the web browser for the PowerCenter Administration
Console, Metadata Manager & Business Glossary, and Data Analyzer applications.
Determine the port numbers to use for nodes in the domain. Optionally,
configure environment variables and set up a keystore file for HTTPS support.
For more information, see the PowerCenter Installation Guide.
PRESS
<ENTER> TO CONTINUE:
===============================================================================
Installation
Directory
———————————————————————————————————————————-
<Type
‘back’ for previous screen and ‘quit’ to exit installer>
Choose
the installation directory:
Default Install Folder: /home/-bash-3.2$/Informatica/PowerCenter8.6.1
ENTER
AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
:
/infa/informatica/pc86
INSTALL
FOLDER IS: /infa/informatica/pc86
IS THIS CORRECT? (Y/N): Y
===============================================================================
PowerCenter
HTTPS Configuration
———————————————————————————————————————————–
1- Do not enable https
->2- Use a keystore generated by the
installer
3- Use existing keystore file
ENTER
THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:
: 2
===============================================================================
PowerCenter
HTTPS Configuration
———————————————————————————————————————————–
HTTPS
Port Number: (DEFAULT: 8443): 8443
===============================================================================
Pre-Installation
Summary
———————————————————————————————————————————–
Review
the following information before continuing. Enter ‘Back’ to go back and change
settings.
Product
Name: PowerCenter 8.6.1
Install
Folder: /infa/informatica/pc86
Disk
Space Requirements
Required
Space :
1,386 MB
Available
Space :
77,604 MB
HTTPS
status
HTTPS enabled
PRESS
<ENTER> TO CONTINUE:
===============================================================================
Installing…
———————————————————————————————————————————–
[==================|==================|==================|==================]
[——————|——————|——————|——————]
===============================================================================
Create
or Join Domain
———————————————————————————————————————————–
<Type
‘back’ for the previous panel or ‘quit’ to exit the installer.>
For
more information about creating or joining a domain, see the PowerCenter Installation
Guide.
Note:
PowerCenter is licensed on a CPU basis. Consult your licensing agreement for
details about your licensed configuration.
->1- Create New Domain (If you are
installing PowerCenter for the first time or you want to create a new domain.)
2- Join Existing Domain (If you are
installing PowerCenter on multiple machines and you already created a domain on
another machine.)
Enter
an option:: <Default:1>: 1
===============================================================================
Configure
Domain Database
———————————————————————————————————————————–
<Type
‘back’ for the previous panel or ‘quit’ to exit the installer.>
Enter
the account information for the database to store PowerCenter domain configuration
metadata. Each PowerCenter domain must store configuration metadata in a
separate database account.
->1- Oracle
2- DB2
3- SQLServer
4- Sybase
Database
type:: <Default:1>: 1
->1- Default
2- Custom string
Database
URL type:: <Default:1>: 2
Database
user ID:: USER_DOM
Database
user password::
Custom
string: (DEFAULT: jdbc:informatica:databasetype://hostname:portno….): :jdbc:informatica:Oracle://11.22.333.111:1521;SID=pc86
===============================================================================
Configure
Domain
———————————————————————————————————————————-
<Type
‘back’ for the previous panel or ‘quit’ to exit the installer.>
Enter
the information for the PowerCenter domain to create.
Domain
name: (DEFAULT: Domain_ServerName): domain_abc_dev
Domain
host name: (DEFAULT: ServerName): servername
Node name: (DEFAULT: node01_ServerName): node1_abc_dev
Domain
port no: (DEFAULT: 6001): 6001
Domain
user name: (DEFAULT: admin): Administrator
Domain
password:: Administrator
Confirm
password:: Administrator
Configure
minimum and maximum port numbers? (Y/N) (DEFAULT: N)
===============================================================================
Post-Installation
Summary
———————————————————————————————————————————-
Installation
Status : SUCCESS
The
PowerCenter 8.6.1 installation completed successfully. The information
below
summarizes the location of the installed products .
For
more information, see the debug log file at
/infa/informatica/pc86/Informatica_Installation_Server_Debug.log
Product
Name :
————————
PowerCenter 8.6.1
Components
:
————————
PowerCenter
Services
PowerCenter
Data Analyzer
PowerCenter
Metadata Manager Business Glossary
Installation
Directory :
————————
/infa/informatica/pc86
PowerCenter
Services Configuration
PRESS
<ENTER> TO CONTINUE:
——————————————–
Administration
Console URL : http://ServerName:6001/adminconsole
Domain
Name : domain_abc_dev
Gateway Host Name : ServerName
Administrator
User Name : Administrator
Node
Name : node1_abc_dev
Node
Port Number : 6001
Domain Tables List
Repo Creation Log
Contents operation on repository [REPO_DEV_ABC] started at 05/21/2012 19:08:30.
DROP TABLE OPB_REPOSIT
DROP TABLE OPB_SUBJECT
DROP TABLE OPB_PICDSC
DROP TABLE OPB_SRC_FLD
DROP TABLE OPB_SCHEMA
DROP TABLE OPB_SRC
DROP TABLE OPB_SELINFO
DROP TABLE OPB_TARG
DROP TABLE OPB_TARG_FLD
DROP TABLE OPB_FLDLINK
DROP TABLE OPB_TARGINDEX
DROP TABLE OPB_TARGINDEXFLD
DROP TABLE OPB_RTSEQ
DROP TABLE OPB_DBD
DROP TABLE OPB_LOAD_SESSION
DROP TABLE OPB_LOAD_FILES
DROP TABLE OPB_BATCH_SESSION
DROP TABLE OPB_LOAD_BATCH
DROP TABLE OPB_BATCH_OBJECT
DROP TABLE OPB_DATABASES
DROP TABLE OPB_LOAD_SESS_CMDS
DROP TABLE OPB_SESSION_LOG
DROP TABLE OPB_SESS_TARG_LOG
DROP TABLE OPB_RECOVERY
DROP TABLE OPB_KEYWORD
DROP TABLE OPB_SESSION_PARAMS
DROP TABLE OPB_CC_INSTANCE
DROP TABLE OPB_CC_MAPPINGS
DROP TABLE OPB_CC_SRC_TBLS
DROP TABLE OPB_CC_REF_TABLES
DROP TABLE OPB_CC_SRCDB_ATTR
DROP TABLE OPB_TARGET_OPT
DROP TABLE OPB_SOURCE_OPT
DROP TABLE OPB_TARG_TEMP
DROP TABLE OPB_TARGFLD_TEMP
DROP TABLE OPB_FLDLINK_TEMP
DROP TABLE OPB_LOADSEQ_TEMP
DROP TABLE OPB_DEFERRED_TASKS
DROP TABLE OPB_MAPPING
DROP TABLE OPB_DBDS
DROP TABLE OPB_TDS
DROP TABLE OPB_WIDGET_DEP
DROP TABLE OPB_WIDGET
DROP TABLE OPB_WIDGET_EXPR
DROP TABLE OPB_EXPRESSION
DROP TABLE OPB_WIDGET_INST
DROP TABLE OPB_MAP_TARG_INFO
DROP TABLE OPB_WIDGET_FIELD
DROP TABLE OPB_OBJECT_TYPE
DROP TABLE OPB_ATTR
DROP TABLE OPB_WIDGET_ATTR
DROP TABLE OPB_MAP_OPTIONS
DROP TABLE OPB_USERS
DROP TABLE OPB_GROUPS
DROP TABLE OPB_USER_GROUPS
DROP TABLE OPB_USER_GROUP
DROP TABLE OPB_ROLE
DROP TABLE OPB_OBJECT_ACCESS
DROP TABLE OPB_REPOSIT_INFO
DROP TABLE OPB_SHORTCUT
DROP TABLE OPB_NORM_FLD
DROP TABLE OPB_SERVER_INFO
DROP TABLE OPB_OBJECT_LOCKS
DROP TABLE OPB_REPOSIT_LOG
DROP TABLE OPB_GEN_OBJECT
DROP TABLE OPB_GEN_OBJ_REFS
DROP TABLE OPB_MD_HIER_GRAPH
DROP TABLE OPB_MD_FACT_FIELD
DROP TABLE OPB_MD_LEVEL_FIELD
DROP TABLE OPB_MD_CUBE_FIELD
DROP TABLE OPB_MD_LVL_HRCHY
DROP TABLE OPB_MD_FACT_LEVEL
DROP TABLE OPB_MD_CUBE_HRCHY
DROP TABLE OPB_MD_HIERARCHY
DROP TABLE OPB_MD_FACT
DROP TABLE OPB_MD_LEVEL
DROP TABLE OPB_MD_DIMENSION
DROP TABLE OPB_MD_CUBE
DROP TABLE OPB_SCHEMA_IDS
DROP TABLE OPB_SCHEMA_DEPLOY
DROP TABLE OPB_SRV_LOC_VARS
DROP TABLE OPB_WIDGET_INIT
DROP TABLE OPB_WIDG_FLD_ATTR
DROP TABLE OPB_PROGRAM_INFO
DROP TABLE OPB_LOAD_MAPPING
DROP TABLE OPB_LOAD_DBDS
DROP TABLE OPB_LOAD_SDS
DROP TABLE OPB_LOAD_TDS
DROP TABLE OPB_LOAD_OPTIONS
DROP TABLE OPB_FLD_MAPPING
DROP TABLE OPB_LOAD_FLD_SCRUB
DROP TABLE OPB_LOAD_TBL_SCRUB
DROP TABLE OPB_SQL_OVERRIDE
DROP TABLE OPB_LOAD_SEQ
DROP TABLE OPB_SRC_TBL_INFO
DROP TABLE OPB_SPS
DROP TABLE OPB_LOAD_SPS
DROP TABLE OPB_DBD_TEMP
DROP TABLE OPB_SRC_TEMP
DROP TABLE OPB_SRCFLD_TEMP
DROP TABLE OPB_PICDSC_TEMP
DROP TABLE OPB_INDEX_TEMP
DROP TABLE OPB_INDEXFLD_TEMP
DROP TABLE OPB_WIDGET_TEMP
DROP TABLE OPB_EXPR_TEMP
DROP TABLE OPB_SELINFO_TEMP
DROP TABLE OPB_MAPPING_TEMP
DROP TABLE OPB_KEYWORD_TEMP
DROP TABLE OPB_ANALYZE_DEP
DROP TABLE OPB_SESS_DSQ
DROP TABLE OPB_SS_TEMP
DROP TABLE OPB_TARG_FLD_EXPR
DROP TABLE OPB_TARG_TBL_EXPR
DROP TABLE OPB_SS_SCHEMA
DROP TABLE OPB_SS_TABLES
DROP TABLE OPB_SS_RELATIONS
DROP TABLE OPB_SS_DIMENSIONS
DROP TABLE OPB_BCF_TREE
DROP TABLE OPB_BCF_BUSCOMPS
DROP TABLE OPB_SESS_WIDG_INST
DROP TABLE OPB_TABLE_GROUP
DROP TABLE OPB_XML_INFO
DROP TABLE OPB_SAP_FUNC
DROP TABLE OPB_SAP_FUNC_PARAM
DROP TABLE OPB_SAP_STRUCT
DROP TABLE OPB_SAP_STRUCT_FLD
DROP TABLE OPB_SAP_FUNC_INST
DROP TABLE OPB_SAP_DSQ_OPRT
DROP TABLE OPB_SAP_FUNC_VARS
DROP TABLE OPB_SAP_CODEBLK
DROP TABLE OPB_SAP_PGMFLOW
DROP TABLE OPB_PARTITION
DROP TABLE OPB_SESS_PARMVAR
DROP TABLE OPB_MAP_PERVAL
DROP TABLE OPB_MAP_PARMVAR
DROP TABLE OPB_SEBL_MVL_LREL
DROP TABLE OPB_SEBL_MVL_ATTR
DROP TABLE OPB_SEBL_JOIN_ATTR
DROP TABLE OPB_SEBL_LINK
DROP TABLE OPB_SEBL_LINKX
DROP TABLE OPB_MMD_DOMAIN
DROP TABLE OPB_MMD_METAEXT
DROP TABLE OPB_METAEXT_VAL
DROP TABLE OPB_TASK
DROP TABLE OPB_TASK_INST
DROP TABLE OPB_TASK_ATTR
DROP TABLE OPB_WORKFLOW
DROP TABLE OPB_WFLOW_DEP
DROP TABLE OPB_WFLOW_EXPR
DROP TABLE OPB_WFLOW_VAR
DROP TABLE OPB_WFLOW_PERVAL
DROP TABLE OPB_EVENT
DROP TABLE OPB_SCHEDULER
DROP TABLE OPB_SCHEDULE_LOGIC
DROP TABLE OPB_SESSION
DROP TABLE OPB_SESSION_CONFIG
DROP TABLE OPB_CFG_ATTR
DROP TABLE OPB_COMPONENT
DROP TABLE OPB_SWIDGET_INST
DROP TABLE OPB_EXTN_ATTR
DROP TABLE OPB_CNX
DROP TABLE OPB_CNX_ATTR
DROP TABLE OPB_SESS_CNX_REFS
DROP TABLE OPB_SESS_EXTNS
DROP TABLE OPB_SESS_FILE_REF
DROP TABLE OPB_FILE_DESC
DROP TABLE OPB_PARTITION_DEF
DROP TABLE OPB_KEY_RANGE
DROP TABLE OPB_MMD_TASK_ATTR
DROP TABLE OPB_MMD_TATTR_VAL
DROP TABLE OPB_MMD_CFG_ATTR
DROP TABLE OPB_MMD_CFGAT_VAL
DROP TABLE OPB_MMD_SESS_EXTNS
DROP TABLE OPB_MMD_LIBS
DROP TABLE OPB_MMD_EXTN_ATTR
DROP TABLE OPB_MMD_EATTR_VAL
DROP TABLE OPB_MMD_DBTYP2EXTN
DROP TABLE OPB_MMD_EXTN_CNXN
DROP TABLE OPB_MMD_ECNXN_REF
DROP TABLE OPB_MMD_CNX
DROP TABLE OPB_MMD_CNX_ATTR
DROP TABLE OPB_MMD_CATTR_VAL
DROP TABLE OPB_MMD_CATALOG
DROP TABLE OPB_MMD_PLGCOMP
DROP TABLE OPB_MMD_DBTYPE
DROP TABLE OPB_MMD_DBSUBTYPE
DROP TABLE OPB_MMD_KEYTYPE
DROP TABLE OPB_MMD_DATATYPE
DROP TABLE OPB_MMD_FLDATTR
DROP TABLE OPB_SESS_TASK_LOG
DROP TABLE OPB_SWIDGINST_LOG
DROP TABLE OPB_WFLOW_RUN
DROP TABLE OPB_TASK_INST_RUN
DROP TABLE OPB_WFLOW_VAR_RUN
DROP TABLE OPB_WFLOW_DEP_RUN
DROP TABLE OPB_WFLOW_CACHE
DROP TABLE OPB_MAP_PERSISVAL
DROP TABLE OPB_MMD_EXTN_WATTR
DROP TABLE OPB_TASK_VAL_LIST
DROP TABLE OPB_HASH_KEY
DROP TABLE OPB_MMD_CATTR2EXTN
DROP TABLE OPB_MMD_EATTR2CNX
DROP TABLE OPB_MMD_EXTN_FILE
DROP TABLE OPB_SESS_CNX_VALS
DROP TABLE OPB_SESS_FILE_VALS
DROP TABLE OPB_SESS_PER_FILES
DROP TABLE OPB_UPGRADE_HIST
DROP TABLE OPB_DTL_SWIDG_LOG
DROP TABLE OPB_REPO_PARAM
DROP TABLE OPB_VERSION_PROPS
DROP TABLE OPB_CM_QUERY
DROP TABLE OPB_CM_QUERY_PARAM
DROP TABLE OPB_CM_LABEL
DROP TABLE OPB_CM_LABEL_REF
DROP TABLE OPB_CM_DEPLOY
DROP TABLE OPB_CM_DEPLOY_REF
DROP TABLE OPB_CM_DEPLOY_LOG
DROP TABLE OPB_CM_DEPDETAIL
DROP TABLE OPB_SERVER_NET
DROP TABLE OPB_SERVER_NET_REF
DROP TABLE OPB_WFLD_ATTR
DROP TABLE OPB_WFLD_ATTR_DEF
DROP TABLE OPB_WFLD_INOUTDEP
DROP TABLE OPB_SWIDG_GROUP
DROP TABLE OPB_VALIDATE
DROP TABLE OPB_XML_QUAL
DROP TABLE OPB_PROF_RULESET
DROP TABLE OPB_PROF_METADATA
DROP TABLE OPB_PROF_SRC_REF
DROP TABLE OPB_MMD_TEMPLATE
DROP TABLE OPB_MMD_TMPL_ATTR
DROP TABLE OPB_MMD_TMPL2EXTN
DROP TABLE OPB_ATTR_CATEGORY
DROP TABLE UPGRADE_STATE
DROP TABLE OPB_PROF_RESOURCE
DROP TABLE OPB_PROF_RES_DATA
DROP TABLE OPB_PROF_RES_REF
DROP TABLE OPB_MMD_DBTY2WATTR
DROP TABLE OPB_MMD_DBTY2WAVAL
DROP TABLE OPB_TASK_STATS
DROP TABLE OPB_SERVICE_LEVEL
DROP TABLE OPB_SLEVEL_ATTR
DROP TABLE OPB_MMD_SLVL_ATTR
DROP TABLE OPB_MMD_FUNC_GRP
DROP TABLE OPB_MMD_FUNCTION
DROP TABLE OPB_MACRO
DROP TABLE OPB_MACRO_EXPR
DROP TABLE OPB_MACRO_ARGS
DROP TABLE OPB_MACRO_REF
DROP TABLE OPB_WIDG_MCR_DEP
DROP TABLE OPB_LINK_MCR_DEP
DROP TABLE OPB_TASK_MCR_DEP
DROP TABLE OPB_TASK_RES_REFS
DROP TABLE OPB_OPB_OBJECT_LOCKS
DROP TABLE OPB_SERVICED_REQ
DROP TABLE OPB_CLIENT_CONN
DROP TABLE OPB_REQ_AUX
DROP TABLE OPB_WFLOW_RUN_BRK
DROP TABLE OPB_TASK_INST_BRK
DROP TABLE OPB_REQ_REPLY
DROP TABLE OPB_REQ_AUX
DROP TABLE OPB_PROXYUSER_INFO
DROP TABLE OPB_NOTIF_MSG
DROP TABLE OPB_OBJECT_NOTIF
DROP TABLE OPB_SERVER_NODE
DROP TABLE OPB_PERF_COUNT
DROP TABLE OPB_SWIDGET_ATTR
DROP TABLE OPB_WF_RUNINFO
DROP VIEW REP_SEG_FLDS
DROP VIEW REP_SRC_FILE_FLDS
DROP VIEW REP_SRC_TBL_FLDS
DROP VIEW REP_DATABASE_DEFS
DROP VIEW REP_SRC_FILES
DROP VIEW REP_SRC_TBLS
DROP VIEW REP_TBL_MAPPING
DROP VIEW REP_FLD_MAPPING
DROP VIEW REP_SCHEMA
DROP VIEW REP_TARG_TBLS
DROP VIEW REP_TARG_TBL_COLS
DROP VIEW REP_TARG_MAPPING
DROP VIEW REP_TARG_FLD_MAP
DROP VIEW REP_SRC_MAPPING
DROP VIEW REP_SRC_FLD_MAP
DROP VIEW REP_TARG_TBL_JOINS
DROP VIEW REP_WORKFLOWS
DROP VIEW REP_LOAD_SESSIONS
DROP VIEW REP_SESSION_CNXS
DROP VIEW REP_SESSION_INSTANCES
DROP VIEW REP_SESS_LOG
DROP VIEW REP_SESS_TBL_LOG
DROP VIEW REP_SSCHEMA
DROP VIEW REP_SSCHEMA_TBLS
DROP VIEW REP_SSCHEMA_CARD
DROP VIEW REP_SESSION_FILES
DROP VIEW REP_SESSION_INST_FILES
DROP TABLE REP_PIC_USAGE
DROP TABLE REP_FLD_DATATYPE
DROP TABLE REP_SRC_KEY_TYPES
DROP TABLE REP_TARG_KEY_TYPES
DROP TABLE REP_DB_TYPES
DROP TABLE REP_CARD_TYPE
DROP TABLE REP_TARG_TYPE
DROP VIEW REP_ALL_SOURCES
DROP VIEW REP_ALL_SOURCE_FLDS
DROP VIEW REP_ALL_TARGETS
DROP VIEW REP_ALL_TARGET_FLDS
DROP VIEW REP_ALL_MAPPINGS
DROP VIEW REP_ALL_MAPPLETS
DROP VIEW REP_ALL_TRANSFORMS
DROP VIEW REP_WIDGET_INST
DROP VIEW REP_WIDGET_DEP
DROP VIEW REP_WIDGET_ATTR
DROP VIEW REP_WIDGET_FIELD
DROP VIEW REP_MAPPING_UNCONN_PORTS
DROP VIEW REP_MAPPING_CONN_PORTS
DROP VIEW REP_METADATA_EXTNS
DROP VIEW REP_METADATA_EXTN_DEFINES
DROP VIEW REP_ALL_TASKS
DROP VIEW REP_ALL_SCHEDULERS
DROP VIEW REP_WFLOW_VAR
DROP VIEW REP_EVENT
DROP VIEW REP_TASK_INST
DROP VIEW REP_WORKFLOW_DEP
DROP VIEW REP_TASK_ATTR
DROP VIEW REP_SESS_WIDGET_CNXS
DROP VIEW REP_COMPONENT
DROP VIEW REP_SESS_PARTITION_DEF
DROP VIEW REP_SESS_CONFIG_PARM
DROP VIEW REP_WFLOW_RUN
DROP VIEW REP_TASK_INST_RUN
DROP VIEW REP_DEPLOY_GROUP
DROP VIEW REP_DEPLOY_GROUP_DETAIL
DROP VIEW REP_LABEL
DROP VIEW REP_LABEL_REF
DROP VIEW REP_USERS
DROP VIEW REP_USER_GROUPS
DROP VIEW REP_GROUPS
DROP VIEW REP_REPOSIT_INFO
DROP VIEW REP_SERVER_INFO
DROP VIEW REP_SUBJECT
DROP VIEW REP_SERVER_NET
DROP VIEW REP_SERVER_NET_REF
DROP VIEW REP_VERSION_PROPS
——————————————————————————–
— Conversion Views Drop
——————————————————————————–
DROP VIEW V_PC8x_MASTER_ELEMENT
DROP VIEW V_PC8x_MASTER_ELMNT_ATTR
DROP VIEW V_PC8x_MASTER_ELMNT_ATTR_1
DROP VIEW V_PC8x_MASTER_ELMNT_ATTR_2
DROP VIEW V_PC8x_MASTER_ELMNT_ASOC
DROP VIEW V_PC8x_MASTER_EXPRESSION
DROP VIEW V_PC8x_MASTER_CONNECTION
DROP VIEW V_PC8x_MASTER_DEFILE_CNX
DROP VIEW V_PC8x_MASTER_RUN
DROP VIEW V_PC8x_MASTER_TSK_LOG
DROP VIEW V_PC8x_MASTER_EVENT
DROP VIEW V_PC8x_MASTER_PARTITION
——————————————————————————–
— Master Views Drop
——————————————————————————–
DROP VIEW V_PC8x_ELEMENT
DROP VIEW V_PC8x_ELMNT_ATTR_1
DROP VIEW V_PC8x_ELMNT_ATTR_2
DROP VIEW V_PC8x_ELMNT_ASOC
DROP VIEW V_PC8x_CONNECTION
DROP VIEW V_PC8x_DEFILE_CNX