Installing Oracle OTM on Single Machine

How to install Oracle OTM on single Machine.


1)Install oracle database
2)JDK
3)Weblogic 10.3.6 11gr1
4)OHS 11.1.1.7
5)OTM 6.3.x
6)create tablespaces
7)create users
8)run create_all.sh



Installing Oracle Weblogic 10.3.6

Create Tablespace
+++++++++++++++
Go to $OTM_HOME/glog/oracle/script8
[oracle@wlsadmin script8]$ sqlplus "sys/xxxxxx@OTMTEST as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 15 12:33:26 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @create_gc3_tablespaces.sql


Default parameters are:
Initial file size: 1G
If autoextend is on, maxsize: 5G
Review Admin Guide for details
Do you want to use above defaults (Y/N : Y)? N

Please enter file size, you can use K, M, G, or T to specify the size in kilobytes, megabytes, gigabytes, or terabytes
Hit "ENTER" if you use GLOG default:  200M

Please enter maximum file size, it must greater than (file_size + 250M)
Hit "ENTER" if you use GLOG default:  2G

Set auto extend on for data files? (Y/N : Y) Y

Please enter the directory where you want the data files to be located
including trailing "/" or "\" : /u01/oracle/oradata/OTMTEST/

You can create the tablespace now OR you can examine create statements in log file and create later
The SQL statements are either in a log file your utl_file_dir directory or in your current directory.
Creating tablespaces now? (Y/N : N) Y

CREATE TABLESPACE DATA
DATAFILE '/u01/oracle/oradata/OTMTEST/DATA01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE DATA
DATAFILE '/u01/oracle/oradata/OTMTEST/DATA01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE INDX
DATAFILE '/u01/oracle/oradata/OTMTEST/INDX01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE INDX
DATAFILE '/u01/oracle/oradata/OTMTEST/INDX01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE ARCHIVE
DATAFILE '/u01/oracle/oradata/OTMTEST/ARCHIVE01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE ARCHIVE
DATAFILE '/u01/oracle/oradata/OTMTEST/ARCHIVE01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE REPORT
DATAFILE '/u01/oracle/oradata/OTMTEST/REPORT01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE REPORT
DATAFILE '/u01/oracle/oradata/OTMTEST/REPORT01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE REPORTINDX
DATAFILE '/u01/oracle/oradata/OTMTEST/REPORTINDX01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE REPORTINDX
DATAFILE '/u01/oracle/oradata/OTMTEST/REPORTINDX01.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY1
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY1
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY2
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY201.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY2
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY201.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY3
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY301.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY3
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY301.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY4
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY401.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY4
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY401.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY5
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY501.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY5
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY501.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY6
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY601.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY6
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY601.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY7
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY701.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE BPL_DAY7
DATAFILE '/u01/oracle/oradata/OTMTEST/BPL_DAY701.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE PART_1
DATAFILE '/u01/oracle/oradata/OTMTEST/PART_101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE PART_1
DATAFILE '/u01/oracle/oradata/OTMTEST/PART_101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE PART_2
DATAFILE '/u01/oracle/oradata/OTMTEST/PART_201.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE PART_2
DATAFILE '/u01/oracle/oradata/OTMTEST/PART_201.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE PART_3
DATAFILE '/u01/oracle/oradata/OTMTEST/PART_301.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE PART_3
DATAFILE '/u01/oracle/oradata/OTMTEST/PART_301.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE PART_4
DATAFILE '/u01/oracle/oradata/OTMTEST/PART_401.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE PART_4
DATAFILE '/u01/oracle/oradata/OTMTEST/PART_401.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE LOB1
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB1
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB2
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB201.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB2
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB201.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB3
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB301.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB3
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB301.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB4
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB401.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB4
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB401.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB5
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB501.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB5
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB501.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB6
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB601.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB6
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB601.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB7
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB701.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE LOB7
DATAFILE '/u01/oracle/oradata/OTMTEST/LOB701.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE MSG_PART_TBS1
DATAFILE '/u01/oracle/oradata/OTMTEST/MSG_PART_TBS101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE MSG_PART_TBS1
DATAFILE '/u01/oracle/oradata/OTMTEST/MSG_PART_TBS101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
/



CREATE TABLESPACE MSG_LOB_TBS1
DATAFILE '/u01/oracle/oradata/OTMTEST/MSG_LOB_TBS101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/



CREATE TABLESPACE MSG_LOB_TBS1
DATAFILE '/u01/oracle/oradata/OTMTEST/MSG_LOB_TBS101.dbf'
SIZE 200M REUSE
AUTOEXTEND ON NEXT 256000K MAXSIZE 2G
SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M BLOCKSIZE 16K
/


SQL>

Create users

++++++++

SQL> select name,created from v$database;

NAME                        CREATED

--------------------------- ---------------

OTMTEST                     09-SEP-15

SQL> show user

USER is "SYS"

SQL> !ls -l create_glog_users.sql

-rwxrwxr-x. 1 oracle dba 10931 Jan 29  2015 create_glog_users.sql

SQL> @create_glog_users.sql

This script creates following OTM users.

Script will also prompt for the password

for each user which will be used during

create user step.

ARCHIVE

GLOGDBA

GLOGOWNER

GLOGLOAD

REPORTOWNER

GLOBALREPORTUSER

DIR_XML_USER

Make sure that OTM tablespaces have been already created.

If not, hit Ctrl + C to exit this script

Press Enter to continue

Enter Connection ID:

Enter value for 1: OTMTEST

Enter user name (Other than SYS user) who can create new users(Press Enter for default of SYSTEM):

Enter value for 2: system

Enter password for this user:

Enter value for 3: Timepass

Enter password for user SYS to login as SYSDBA:

Enter value for 4: Timepass

Enter password for user ARCHIVE:

Enter value for 5: ARCHIVE

Enter password for user GLOGDBA:

Enter value for 6: GLOGDBA

Enter password for user GLOGOWNER:

Enter value for 7: GLOGOWNER

Enter password for user GLOGLOAD:

Enter value for 8: GLOGLOAD

Enter password for user REPORTOWNER:

Enter value for 9: REPORTOWNER

Enter password for user GLOBALREPORTUSER:

Enter value for 10: GLOBALREPORTUSER

Enter password for user DIR_XML_USER:

Enter value for 11: DIR_XML_USER

Connected.

Connected.

Creating OTM database users...

Connected.

Creating roles...

Dropping and recreating roles... (create_glog_roles)

Completed role creation.

OTM database user creation completed.

12:39:07 SQL>

run create_all.sh

++++++++++++++

/u01/OTM636/otm/glog/oracle/script8

[oracle@wlsadmin script8]$ ./create_all.sh

--*********************************************************

Make sure that OTM database users have been created.

Use create_glog_users.sql script to create OTM database users.

Make sure that OTM tablespaces have been created.

You may use create_gc3_tablespaces.sql to create OTM tablespaces.

--*********************************************************

Hit Ctrl + C to exit this script

Press Enter key to start creating OTM schemas.....

Enter Database Connection ID: OTMTEST

Enter SYS password to log in as SYSDBA:

Enter user name (Other than SYS user) who can create new users(Press Enter for default of SYSTEM): system

Enter password for above user:

Enter the glog properties path (Press Enter for default of ../../config):

Using default property path ../../config

Enter password for ARCHIVE user:

Enter password for GLOGOWNER user:

Enter password for REPORTOWNER user:

OTM Schema installation started....

This script creates OTM database objects.

Enter Connection ID:(Press Enter for default of LOCALDB)

Enter SYS password to login as SYSDBA:

Is this a Unix machine (ie. runs .sh rather than .cmd scripts)? (Y/N : Y)?

Enter Y or N

Enter the glog properties path:

Enter password for user ARCHIVE:

Enter password for user GLOGOWNER:

Enter password for user REPORTOWNER:

Connecting as glogowner to OTMTEST

Creating GLOGOWNER objects...

Creating packages...

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

Creating tables...

   AAR_CAR_EQUIP_TYPE_JOIN

   ACCESSORIAL_BASIS_PRECEDENCE

   ACCESSORIAL_CODE

   ACCESSORIAL_COST

   ACCESSORIAL_COST_UNIT_BREAK

   ACCESSORIAL_DEFAULT

   ACCOUNT_NUMBER

   ACCOUNT_USER_ASSOCIATION

   ACR_ENTRY_POINT

   ACR_ROLE

   ACR_ROLE_ENTRY_POINT

   ACR_ROLE_ROLE

   ACTION

   ACTION_ARG

   ACTION_DEF

   ACTION_DEF_ARG

   ACTION_DEF_SEL_PARAM

   ACTION_DEF_STATE

   ACTION_DRAG

   ACTIVITY

   ACTIVITY_CALENDAR

   ACTIVITY_CALENDAR_OVERRIDE

   ACTIVITY_TIME

   ACTIVITY_TIME_DEF

   ACTIVITY_TYPE

   ADHOC_NOTIFY  (Partitioned)

   ADJUSTMENT_REASON

   ADVANCED_LAYOUT

   AD_REGION

   AD_TIME

   AF_COST_VS_REVENUE

   AGENT

(Call for updating password is sh ./update_password_migration.sh )

 TNSSTR: wlsadmin.com 1521 otmprod

Connecting as glogowner to OTMTEST

OTM Database Object Counts

Connecting as glogowner to OTMTEST

List of first 50 Invalid objects after recompile.

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

Invalid objects before Recompile....

       461

Invalid objects after Recompile....

         0

All objects are now valid.

Marking 6.3 structural changes applied...

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

PACKAGE DBUPDATE_631 has been dropped.

PACKAGE DBUPDATE_631g has been dropped.

PACKAGE DBUPDATE_632 has been dropped.

PACKAGE DBUPDATE_632g has been dropped.

PACKAGE DBUPDATE_633 has been dropped.

PACKAGE DBUPDATE_633g has been dropped.

PACKAGE DBUPDATE_634g has been dropped.

PACKAGE DBUPDATE_635g has been dropped.

PACKAGE DBUPDATE_636g has been dropped.

Marking 6.3 data migrations applied...

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

PACKAGE DBPATCH_631 has been dropped.

PACKAGE DBPATCH_631g has been dropped.

PACKAGE DBPATCH_632 has been dropped.

PACKAGE DBPATCH_632g has been dropped.

PACKAGE DBPATCH_633 has been dropped.

PACKAGE DBPATCH_633g has been dropped.

PACKAGE DBPATCH_634 has been dropped.

PACKAGE DBPATCH_634g has been dropped.

PACKAGE DBPATCH_635 has been dropped.

PACKAGE DBPATCH_635g has been dropped.

PACKAGE DBPATCH_636g has been dropped.

OTM Database Object Counts

ARCHIVE         INDEX                    5

                LOB                      5

                SEQUENCE               461

                TABLE                  461

GLOGLOAD        SYNONYM               2369

                TRIGGER                  1

GLOGOWNER       FUNCTION              9161

                INDEX                 3888

                INDEX PARTITION         73

                JAVA CLASS              11

                JAVA SOURCE              7

                LOB                     45

                LOB PARTITION           61

                PACKAGE                 71

                PACKAGE BODY            69

                QUEUE                   11

                SEQUENCE               301

                SYNONYM                131

                TABLE                 1847

                TABLE PARTITION        473

                TRIGGER               4220

                TYPE                     5

                VIEW                    25

REPORTOWNER     FUNCTION                80

                INDEX                   15

                PACKAGE                 82

                PACKAGE BODY            82

                SEQUENCE                 1

                SYNONYM               2238

                TABLE                   15

                TRIGGER                 16

                VIEW                    33

OTM database users and their objects creation completed.

Check create_all_<dbsid>_<timestamp>.log and import_content_<dbsid>_<timestamp> log files for ORA- or compilation errors.

[oracle@wlsadmin script8]$

[oracle@wlsadmin script8]$

[oracle@wlsadmin script8]$ grep -i ORA create_all_OTMTEST_201509151244.log

   CONTACT_CORPORATION

   CORPORATION

   CORPORATION_INVOLVED_PARTY

   CORPORATION_PROFILE

   CORPORATION_PROFILE_DETAIL

   CORPORATION_VAT_REG_JOIN

   LOCATION_CORPORATION

   ORACLE_ERROR

   TENDER_COLLABORATION

   TENDER_COLLABORATION_STATUS

Check create_all_<dbsid>_<timestamp>.log and import_content_<dbsid>_<timestamp> log files for ORA- or compilation errors.

[oracle@wlsadmin script8]$

[oracle@wlsadmin script8]$ egrep -i 'errors|warnings'  create_all_OTMTEST_201509151244.log

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

No errors.

Check create_all_<dbsid>_<timestamp>.log and import_content_<dbsid>_<timestamp> log files for ORA- or compilation errors.

[oracle@wlsadmin script8]$

Check for error and warning in the logfile.

[oracle@wlsadmin script8]$ egrep -i 'warnings|error|ORA' import_content_OTMTEST_20150915_1317.log

<ErrorCount>0</ErrorCount>

<ErrorCount>0</ErrorCount>

<ErrorCount>0</ErrorCount>

<ErrorCount>0</ErrorCount>

<ErrorCount>0</ErrorCount>

<ErrorCount>0</ErrorCount>

[oracle@wlsadmin script8]$ egrep -i 'Caught|ORA' create_all_OTMTEST_201509151244.log

   CONTACT_CORPORATION

   CORPORATION

   CORPORATION_INVOLVED_PARTY

   CORPORATION_PROFILE

   CORPORATION_PROFILE_DETAIL

   CORPORATION_VAT_REG_JOIN

   LOCATION_CORPORATION

   ORACLE_ERROR

   TENDER_COLLABORATION

   TENDER_COLLABORATION_STATUS

Check create_all_<dbsid>_<timestamp>.log and import_content_<dbsid>_<timestamp> log files for ORA- or compilation errors.

[oracle@wlsadmin script8]$

[oracle@wlsadmin script8]$ grep -i 'Caught exception' import_content_OTMTEST_20150915_1317.log

[oracle@wlsadmin script8]$  grep -i 'SP2' import_content_OTMTEST_20150915_1317.log

[oracle@wlsadmin script8]$