[bscyadav]

Hi All,
As a learning / new commer to OTM biggest challenge was to install OTM, When ever I was installing OTM the biggest problem was with the DB scripts which were never getting installed fully as there was allways an error not sure if it was only my issue, infact I had tracked many issues posted with same errors.
This post is to create a short cut on reducing the script running problem

This is only for people who want to install OTM for learning or Training purpose and not for any

This for 5.5v CU5
Files listed
OTM-DB-OLD.doc -> Old steps as mentioned in Admin Guide
OTM-DB-NEW.doc -> modified by me.
TABLE_SPACE.sql -> in case you encounter the problem with standard file use this.
imp_otmv55.par -> DB import file.
otmDUMP_04012010.dmp -> database dump file

hope this helps!!

[josephliang]

Nice work of putting everthing together.
However, I found some parts you are missing or misunderstood.

Here are my tips for OTM DB Installation:
Create Database
Make sure DB parameter O7_DICTIONARY_ACCESSIBILITY=true
This is the most important step. Without this, you might encounter all kind of problems later.

Create Tablespace
Make sure you have at least 4GB for DATA and INDX tablespaces to import OTM seeded DB dump (otmv55_partition.dmp)

Import Database
Based on my experiences, it's better to import DB by sys (despite OTM Admin Guide says to use system)

OTM DB Scripts
Make sure all scripts in Admin Guide are executed without error.

dbpatch_55.sql
- No matter for fresh installation or upgrade, dbpatch_55.sql MUST be applied.
- Before execute the script, make sure the following classes are in CLASSPATH, if you are using OAS
[OTM]/oas/j2ee/home/lib/ejb.jar
[OTM]/oas/j2ee/home/lib/jta.jar
[OTM]/oas/jdbc/lib/ojdbc14dms.jar
[OTM]/oas/lib/dms.jar
- After the script is completed, check the log files (dbpatch_xxx.log and update_content_xxx.log) to ensure they are error free before proceeding to the next step

Export Database
For backup or DB transfer purpose, you might need to export DB. Based on my experiences, you must export DB by sys with FULL=Y option or using exp_GC3.par

Re-import Database
For restore or DB transfer purpose, you might need to re-import DB. After DB is imported, re-apply OTM DB scripts including insert_security_roles.sql, but NO need to re-apply dbpatch_55.sql

[bscyadav]

Hi Joseph,
Thanks for the input,

Actaully the .dmp was taken after the execution of dbpatch_55.sql and insert_security_roles.sql

sorry to ask a dumb question as I am a semi technical guy and not a DBA what difference does it make if i don't run these scripts as already the dump contains the executed scripts and i simply import the .dmp as when i test the same the object count and the DB structure remained same.
or am i missing smething?
Thanks

[josephliang]

See OTM Admin Guide (http://download.oracle.com/docs/cd/B...nistration.pdf) - Oracle Export/Import Utility section

8. After the import finished successfully, there are post-import SQL scripts to be run in the target database. The steps to run these scripts are described in the Installing Oracle Transportation Management on the Database Server section. It is important to follow the instructions to run the scripts. Ensure you log in to the database as right users when running the scripts.

[nick.polites]

Originally Posted by josephliang

Here are my tips for OTM DB Installation:
Create Database
Make sure DB parameter O7_DICTIONARY_ACCESSIBILITY=true
This is the most important step. Without this, you might encounter all kind of problems later.

Just a note that in 6.1 this is changed to false. You will need to login as sysdba before any of your connect strings to import/export a database going forward. Also insert_security_roles.sql is no longer used.

[josephliang]

Need to start learning 6.x after this project

[bscyadav]

Hi
I am not sure if this is a valid request,
Is it possible for any member to upload a DB dump as i have done for 5.5 CU5 for 6.0 as i want to compare the same.
Actually I amworking on OTM SeedDB concept where we generally used to upload to create all the setups in our previous ERP application and instead of running the scripts for every new customer we just use to import this dump.
Above request is for testing in my personal meachine and not for any commercial use
Thanks in advance

[bscyadav]

When I am trying to install Db for OTM 6.0 I am not ale to set O7_DICTIONARY_ACCESSIBILITY to true
It is allways returning false

I tried below command at SQLPROMPT
alter system set o7_dictionary_accessibility=true scope=spfile;
and also
set the same in init.ora file

but still I am getting error : O7_DICTIONARY_ACCESSIBILITY is false.
is there any other way to make it as true

[bscyadav]

got the ans from a DBA
after executing the
alter system set o7_dictionary_accessibility=true scope=spfile;
we need to execute
startup force command in SQLPROMPT

[chrisplough]

Don't worry - even I keep a note doc with some of the install differences. It's funny how much changes with v6.1

--Chris