Home

Administration Guide - Oracle Documentation

Contents

1. 11 2 AVA SERVI CE WRAPPER 11 2 12 APPENDIX TROUBLESHOOTING KNOWN 1550 5 12 1 INSTALLATION cs scwscecdtewstedd cewstenetewwecadtewstendtewssead atwsteddtewsvestsawsteddtewseatsewavocaewsbecsete 12 1 STARTING ORACLE TRANSPORTATION MANAGEMENT sssssuuuuuuuuuuuuuuRRRRRRRRRRRRRRRRRRRRRRRR 12 1 503 SERVICE UNAVAILABLE ERRORS 12 1 UNINSTALLING ORACLE TRANSPORTATION MANAGEMENT ssss22222222222222222222223324 334444343 12 1 BROWSERS iasusasuaarRRRRRRRREERSERRSRRRRRRESRERRHRRRRRSRSRRRSRRSERRRRRERSERRRRRASRARNARRSRARERRERSERERSEEEEAR 12 2 Copyright 2001 2009 Oracle rights reserved vii Send Us Your Comments Oracle Transportation Management Administration Guide Release 5 5 Part No B28768 09 Oracle welcomes your comments and suggestions on the quality and usefulness of this publication Your input is an important part of the information used for revision e Did you find any errors e 15 the information clearly presented e Do you need more information If so where e Are examples correct Do you need more examples
2. If the result is TRUE then run the command below listed to disable it EGIN BMS SCHEDULER DISABLE GATHER STATS JOB ND This will ensure Oracle Transportation Management database has up to date statistics with full compute on all objects 10 4 Copyright 2001 2009 Oracle rights reserved Copy Database Data When moving from initial implementation to production or duplicate production to development there are needs to copy the whole database or part of Oracle Transportation Management data between production and development test environment Depending on the purpose and requirement copying an Oracle Transportation Management database data can be achieved using different methods It is recommended that Technical Support be consulted to decide the best way of moving data Copy Database Files An Oracle database can be cloned by copying datafiles and other configuration files to the destination environment usually another server Procedures of this method can be found from Oracle DB support document Features Limitations e Simple and straightforward There is no need to pre create an Oracle database in the destination machine e Fast The total time needed is governed by physically transferring datafiles from source machine to destination machine e Whole database copy If there are data in the source database that t
3. 27 1 WINDOWS 2000 2003 SERVER I NSTALLATI ON REQUIREMENTS 2 1 MINIMUM HARDWARE REQUIREMENTS ccccccscssesecetcsseeecseuevecveeseereereesserserstettegggeuugeureurtarterrernersess 2 1 SOFTWARE REQUIREMENTS FOR ORACLE TRANSPORTATION MANAGEMENT SERVER CONFIGURATIONS 2 1 PREPARING TO INSTALL ORACLE TRANSPORTATION MANAGEMENT sscseeeeeeeeeeeeeeeeeeeeeeeeeeeeeessseeeerttteteteggs 2 2 SOLARIS NSTALLATI ON 2 4 MINIMUM HARDWARE REQUIREMENTS 2 5 SOFTWARE REQUIREMENTS ceste HQ E er a e d ER ec a Fi ct n c ib a 2 5 PREPARING TO INSTALL ORACLE TRANSPORTATION MANAGEMENT menn 2 6 AIX NSTALLATI ON REQUIREMENTS awcccccccccceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 2 9 MINIMUM HARDWARE REQUIREMENTS ana nra aenea 2 9 SOFTWARE REQUIREMENTS sai tits cet ca fet dees a ta et ese cede Dae ati cess puoi reu eta sess ee ea e a ds 2 10 PREPARING TO INSTALL ORACLE TRANSPORTATION MANAGEMENT nene nene 2 10 HP UX INSTALLATION REQUIREMENTS wccccccscccccceeeeennnececeeneeeneneeeeeeeennaneeeeeeennanneeennnanas 2 14 MINIMUM HARDWARE REQUIREMENTS c cccccescctsceteesseeceeueeeveeseeceeenesneensenteetegguggursureartererrtertertees 2 15 SOFTWARE REQUIREMENTS WAGs Ae Parade
4. Select 0 and press enter 22 Overwrite palette cxml in OBI EE OracleBI web app res s_oraclel0 chartsupport With lt otm_install_path gt fti palette cxml 23 From the OBI EE Oracle Bl server Schema directory login to the database as hdowner hdowner rptapp 24 Run the SAJ OBS Oracle sql and then exit sqlplus 25 Create a new System DSN under ODBC connections a Name the DSN as rptapp b Point it to the ROD database c Use hdowner and its password 26 Restart the OBI EE services Oracle Transportation Management FTI Properties The following will be set if you chose to integrate with FTI during the Oracle Transportation Management installation If not you will need to set them manually in the lt otm_install_path gt glog config glog properties file Fusion Transportation Intelligence formerly Advanced Analytics optional aa_webserver http otmfti us oracle com 8081 ALLOW_ADVANCED_ANALYTICS true 1 Remove the symbol and enter the correct URL and PORT for the FTI Server Fusion Transportation Intelligence formerly Advanced Analytics optional aa webserver http otm sp55rpt us oracle com 80 ALLOW ADVANCED ANALYTICS true If there are any other entries besides the two above delete them and copy the entries as they are above You need to either enter http or https depending on what protocol is used for the web server Note that since Oracle Transportat
5. 2 1 INSTALLING FAXMAKER FOR FAX NOTIFICATIONS 444s42222222222222333333333 333333333 33 33 33 83 833333 5 1 START FAXMAKER CONFIGURATION MMC CONSOLE iiess I messen nennen aree nn nn 5 1 INSTALLING RIGHTFAX FOR FAX NOTIFICATIONS 4444422222222222233333333333333 3333 3 3 3 83 REA AAA 5 2 FAX GENERATION IN ORACLE TRANSPORTATION MANAGEMENT sssss2222222222222222222222222243 5 3 INSTALLING PCMI LER 2 435 a RR RRRNRRNRRRNRRRSRRERNRRSRRRARNRRRRENERRNNRRARNNRENRERNRENNNRENENRRERER 5 4 INSTALLING RAND MCNALLY I NTELLI ROUTE 44444n5222222222222233333333 333333333 33 33 8X 4 333ARARGA AA 5 4 INSTALLING RAND MCNALLY MILEMAKER sssss233333333 33333333 33 3 3 3 333 33 3 33 38 333323 5 5 INSTALLING SMC RATEWARE 52 255 a a nirsRRRaRRSRRRRARERRRRRRARRRRSRRRRRERRNRRRRNRRNSNRERESERREANNENNENENR 5 5 INSTALLING PYTHON ON A CLIENT 4444522222222 2333 3 ARR RR RRRRRRRRXRXRARXRARARRRRRARARARARARARAARAXAA 5 6 INSTALLING PYTHON 2 525 nnn tre ED ERI a DA aa ERRARE 5 6 PYTHON NTERNATIONAL CHARACTER SET CONFIGURATION isssss He eee nemen nemen 5 6 6 STARTING ORACLE TRANSPORTATI ON MANAGEMENT AFTER INSTALLATION IS nnne nnns 6 1 STARTING AND STOPPING THE ORACLE TRANSPORTATION MANAGEMENT SERVERS 6 1 STARTING THE WINDOWS SERVER rt rere e ro n Pe d pe e aed P el
6. 5 On the application server edit the file otm install path gt oas bin oc4j conf at the top of the file is a line that looks like this 6 set OAS_PW CHANGEME 7 Change it to the value of the new password 8 Restart Oracle Transportation Management In addition the following Oracle Transportation Management users are used to communicate between the tiers User ID Default Password Notes system CHANGEME May not be deleted guest CHANGEME May not be deleted In order to change the system user s password do the following 1 Login to Oracle Transportation Management as DBA ADMIN and use the Oracle Transportation Management User Manager to change the password for the system user refer to the online help for details Copyright 2001 2009 Oracle All rights reserved 8 7 2 Login to the application server machine as the Oracle Transportation Management user x Setup your environment by running otm install path2 install gc3env sh on UNIX or otm install path gt install gc3env cmd on Windows Run the following command java glog util appclass Base64Encoding new password This will return the encoded value for your new password NO os On the Oracle Transportation Management web server s edit the file otm install path gt tomcat bin tomcat conf search for the string DGC3EncodedPassword and change the value of this to the results of the previous step 8 Restart O
7. By default Oracle Transportation Management uses US Dollars when saving costs to the database Also by default Oracle Transportation Management triangulates all currency conversions through US Dollars This example illustrates how Oracle Transportation Management stores a shipment cost record with the currency storage default set to two different currencies Total actual cost of shipment is 1000 J PY If Oracle Transportation Management s currency storage default is USD current default in all Oracle Transportation Management installations Oracle Transportation Management stores this cost as follows Total_actual cost Total actual Total Actual cost base cost currency GI D JPY If instead Oracle Transportation Management s currency storage default is GBP Total_actual cost Total actual Total Actual cost base cost currency GI D In the first instance the rate of 7 76 represents the USD value of 1000 converted at the current rate in Oracle Transportation Management 128 77 while in the second instance the rate of 5 31 represents the GBP value of 1000 J PY converted at the current J PY GBP rate in the system 188 08 When to Change Currency Storage Default There are two scenarios where you would like to change your currency storage default either you only use one currency other than USD or you use multiple currencies but not USD Rates in One Single Currency In this case you only need to set your
8. Edit the file otm install path gt glog config glog properties and change the following properties This should be done on each Oracle Transportation Management Web and Application server dbserver db server fqdn glog database sid oracle sid glog database connectstring oracle connectstring OAS Edit the file otm install path gt oas j2ee home config data sources xml and change the following line lt connection factory factory class oracle jdbc pool OracleDataSource password glogdba url 2 jdbc oracle thin G DB FODN DB PORT DB SID user glogdba Copyright 2001 2009 Oracle rights reserved 4 WebLogic Edit the file lt otm_install_ path gt weblogic config gc3domain config xml template and change the following property under J DBCConnectionPool URL jdbc oracle thin lt db_server_fqdn gt 1521 lt oracle_sid gt WebSphere Edit the file otm install path gt websphere profiles default config cells _ APP_SERVER__Node01Cell nod es __APP_SERVER__Node01 resources xml where __APP_SERVER__ is your application server s host name and change the following line under resources jdbc J DBCProvider lt resourceProperties xmi id J2EEResourceProperty 1141837349928 name URL type java lang String value 2 jdbc oracle thin 8 DB FODN DB PORT DB SIDJ description This is a required property The URL indicating the database from which the Data Source will obtain connect
9. Spanish European es Spanish Latin American To have Notifications translated the following property will need to be set in the lt otm_install_path gt glog config glog properties file glog notify localizeStylesheet tru Modifying the Session Timeout The default session timeout for the Oracle Transportation Management Web Server is 30 minutes If you leave Oracle Transportation Management idle for 30 minutes your session will timeout and you will need to log in again For some Oracle Transportation Management installations you may want to increase this timeout Please note that increasing the session timeout will increase the load on your Web server and may decrease the number of simultaneous users that can access the system We don t recommend setting this above 60 minutes To change this setting edit the web xml files on your Oracle Transportation Management Web Server These files are located on your web server s otm install path gt tomcat conf web xml and otm install path2 glog gc3webapp WEB INF web xml Edit the following line in each file session timeout 30 session timeout Change the setting from 30 to your desired timeout period in minutes Restart the Oracle Transportation Management Instance as described in the chapter Starting Oracle Transportation Management after nstallation 15 Complete Monitoring Performance Windows On Windows you can monitor system performance using the Ta
10. This file is usually under otm install path gt glog config on Windows otm install path gt glog config on UNIX Uncomment and modify the following lines intelliroute host 192 168 101 101 intelliroute port 1998 intelliroute user otm intelliroute password changeme intelliroute location company If your IntelliRoute server running on port 1998 on a server named otmir oracle com with a user named otm with the password changeme and a location named company your lines would look like intelliroute host 192 168 101 101 intelliroute port 1998 intelliroute user otm intelliroute password changeme intelliroute location companyl Once this change has been made restart your Oracle Transportation Management instance Installing Rand McNally MileMaker The following software is required e McNally MileMaker Server v17 v18 Install the MileMaker Server as described in your user s manual You can setup Oracle Transportation Management to integrate with MileMaker during the initial Oracle Transportation Management installation as described earlier or you can modify an existing installation to use MileMaker To modify an existing Oracle Transportation Management installation you need to edit the glog properties file on the Oracle Transportation Management Application server This file is usually under otm install path gt glog config on Windows or otm install path gt gl
11. To use Python from the console you will need to make these changes to your otm install path gt install gc3env sh file as follows LD LIBRARY PATH S ORACLE HOME 1ib32 LD LIBRARY PATH export D LIBRARY PATH where LD LIBRARY PATH is the correct variable name for your OS WebLogic Change the Library Path to point to these libraries on AIX the environment variable is named LIBPATH on HP UX the environment variable is named SHLIB PATH on all other UNIX platforms it is named LD LIBRARY PATH a Add the line in otm install path gt tomcat bin tomcat conf as follows renumbering all other lines in this sequence wrapper java library path 2 ORACLE HOMES 1ib32 Edit the line in lt install path gt weblogic config gc3domain weblogic conf as follows renumbering all other lines in this sequence wrapper java library path 2 ORACLE HOMES 1ib32 To use Python from the console you will need to make these changes to your otm install path gt install gc3env sh file as follows LIBPATH SORACLE HOME 1i1b32 LIBPATH export LIBPATH where LIBPATH is the correct variable name for your OS WebSphere Change the Library Path to point to these libraries on AIX the environment variable is named LIBPATH on HP UX the environment variable is named SHLIB PATH on all other UNIX platforms it is named LD LIBRARY PATH a Edit the line in otm install path gt tomcat bin
12. submit begin purge dba install Answer You would not do any harm Your new job would replace the previously scheduled job If a previously scheduled job was running Oracle would let it finish Question After I m done entering all the criteria in Ul and get an email really want to physically purge data immediately How can do this Answer You can take advantage of the way Oracle schedules a job When Oracle schedules a job it executes the job right away After that the job is only executed at the time interval specified Question How do remove ship units batch grids and ship groups that are not referenced by any children Answer You submit begin pkg purge scavenge all end Manually Purging Transmissions from the Database Manually purging is an alternative to truncating the partitioned tables Learn more about the scheduled jobs that truncate partitioned tables later in the chapter Truncating data is much faster than purging but purging allows you to more exactly specify what data to purge Transmission purge deletes data associated with xml blobs used for integrating Oracle Transportation Management with external systems In general the xml blobs are temporary so there is no downside the getting rid of them Your DBA or System Administrator should set up a nightly or weekly background job to run purges as described below Manually Purge Transmissions To purge the transmission tables 1 Log into
13. Oracle Transportation Management is highly distributed and collaborative It is written in Java and uses Enterprise Java Beans XML HTML and XSL technologies The design is based on a thin HTML client fat application architecture so that applications are easily deployable and accessible by multiple enterprises It supports comprehensive integration via XML APIs to all of the application logic Server Overview The following illustration describes the overall architecture of the Oracle Transportation Management environment E Integration Data Highly Transactional Data Static Reference Data Each server is designed to perform specific functions that are briefly described in the following sections From a user s perspective all that you need to use to access Oracle Transportation Management is a standard Web browser such as Internet Explorer or Mozilla Firefox Web Server The Web server controls the Oracle Transportation Management user interface and communicates with the Application server to initiate the appropriate application logic The Oracle Transportation Copyright 2001 2009 Oracle All rights reserved 1 1 Management user interface is delivered to the user in HTML format and viewed using a browser such as Internet Explorer or Mozilla Firefox The Oracle Transportation Management Web server uses the Apache Web server and the Tomcat J ava servlet engine to manage the
14. e WebSphere WebSphere Advanced Server 6 0 with the following patches applied in the following order Application server only o 6 0 WS WAS LinuxX32 RP0000002 tar gz o 6 0 2 WS WAS LinuxX32 FP0000007 tar gz o 6 0 2 WS WAS avaSDK LinuxX32 FP00000033 pak e WebSphere WebSphere Application Client 6 0 Web only installs o Installer for this can be found in the AppClient directory of the main WAS install e Oracle 10gR2 10 2 0 3 0 DB Server or the latest version of 11g DB server only e Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services Report server only e Oracle Transportation Management Application software Before you begin the installation process ensure that the following is complete e Oracle Enterprise Linux 4 Update 4 has been installed on your server e size of the swap space on your server is equal to or greater than the amount of memory it contains e All Oracle Transportation Management servers are time synced using a process like NTP This is critical to the proper operation and troubleshooting of an Oracle Transportation Management instance e Oracle 10gR2 10 2 0 3 0 Client Administrator install has been installed and configured to connect to your database Pre Install Setup Ensure that Oracle Enterprise Linux 4 Update 4 and all of the latest patches are installed The latest Oracle recommended patch bundle can be downloaded from Oracle at http www oracle com technology tech
15. glogdba glogdba This user has access to functions and packages owned by glogowner amp reportowner but does not itself own any tables views functions or packages It must call the vpd set user stored procedure to set user context to view data May not be deleted glogowner glogowner This user owns Oracle Transportation Management tables views functions amp packages can create or alter data structures within the database and can manipulate data May not be deleted This user has complete access to the data There is no need to call the vpd package to set user context when logged in as glogdev does not own any tables views functions or packages May not be deleted glogload glogload Used for loading data into glogowner and reportowner schemas May not be deleted reportowner reportowner This user owns the tables views functions and packages required for reporting and can read the data May not be deleted 8 10 Copyright 2001 2009 Oracle All rights reserved Database User 10 Default Password Notes globalreportuser globalreportuser This user has read access to all the data in GC3 It is mainly used for XSQL reporting May not be deleted If you wish to change the passwords for these users follow these steps 1 Using SQL Plus log into the Oracle Transportation Management database as sys or system 2 Run the following for each user that you wish to change alter user lt user_name
16. 1 of the Oracle AS 10gR2 FR installation CD package Please read the requirements and installation instructions fully before installing the Oracle AS 10gR2 FR Software The instructions listed below should be used in conjunction with those supplied by Oracle as there are certain sections within the AS that are not utilized by Oracle Transportation Management at this time Please refer to the Oracle documentation as they are far more complete and contain in depth explanations of all installation options Create an oracle user and assign it to the DBA group The installer should be run as this user Insert Disk1 of the Oracle AS 10gR2 FR install package Run runi nstaller Ensure your system passes the Installation Requirements Check Review the Welcome screen and click Next S NS At the Destination Oracle Home and Oracle Home Name Screen please enter in the Oracle Home Name i e FR HOME AS_HOME etc and the path to the new Oracle Home i e u01 app oracle product reports109g Note Do NOT install the Oracle AS 10gR2 FR software to an existing Oracle Home This may cause any existing Oracle products including databases to become inoperable 7 Click Next after entering Oracle Home name and path 8 Enter the oracle user s group usually dba 9 Choose your language usually English 10 Specify an Instance Name unique identifier for the Reports instance usually a hostname admin password The ias adm
17. I LOG DETAIL Examples exec domainman transmission purge 90 8 24 Copyright 2001 2009 Oracle rights reserved deletes all transmission records for above tables that are older that 90 days regardless of whether they are associated with shipment events or tenders The process would run for 60 minutes since this is default and would process 5000 records at a time default exec domainman transmission purge 60 domainman no status purge 120 FALSE 2000 would delete all transmission records older than 60 days that do not have associated shipment events or tenders For those transmission records that are older than 60 days but have associated events or tenders the process will null out the CLOBs in order to save space The process will run for 2 hours and will process 2000 records at a time Note Transmission purge is an expensive operation It should be run during off peak hours Manually Purge Problem Records If you also want to purge the PROBLEM table 1 Log into SQL Plus as glogowner glogowner password tnsname 2 sql gt exec partit purge partit tables 90 to purge all database records in this table older than 90 days Partitioned Tables Because Oracle Transportation Management contains several integration and logging tables that can become quite large very quickly these tables have been partitioned to allow for quick purges of older data By partitioning the tables a particular partit
18. Install your WebLogic license by following the directions supplied by BEA Important Note You must remove a file from the WebLogic installation because of a code conflict between it and the latest J DBC drivers that Oracle Transportation Management ships with The simplest and safest way to do this is to rename the file The file in question is lt weblogic_install_path gt server lib ojdbcl4 jar rename it to be something like lt weblogic_install_path gt server lib ojdbcl4 jar bak where lt weblogic_install_path gt is whatever value was used in step 5 above Installing Oracle on the Database Server Please refer to the standard 10g Oracle DB Installation Guide Installing Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services on the Report Server The system requirements and installation steps along with explanations of each for the Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services hereafter referred to as Oracle AS 10gR2 FR installation are documented within either the web based or Adobe Acrobat PDF files on Disk Copyright 2001 2009 Oracle rights reserved 2 3 1 of the Oracle AS 10gR2 installation CD package Please read the requirements and installation instructions fully before installing the Oracle AS 10gR2 FR Software The instructions listed below should be used in conjunction with those supplied by Oracle as there are certain sections wi
19. OTM Startup activateThread INFO jvm 1 2007 11 28 05 56 05 07 11 28 05 56 05 OTM Startup loading startup classes INFO jvm 1 2007 11 28 05 56 08 07 11 28 05 56 08 Oracle Containers for J2EE 10g 10 1 3 3 0 initialized Note The first time OAS is started up it will automatically deploy the Oracle Transportation Management application This can take anywhere from 15 45 minutes depending on the speed of your system There is unfortunately no direct indication of when this process is finished You can infer that it has completed by checking the highest numbered directory in otm install path oas j2ee home application deployments GC3App e g gc3deploy66 If there is a single jar file in that directory called deployment cache jar and there are no class files there then the process has completed 5 WebLogic Start the Oracle Transportation Management App daemon e g etc init d otmapp start on the Oracle Transportation Management Application Server e tcan take several minutes for WebLogic to fully start up depending on your server check WebLogic you can monitor the otm install path gt logs weblogic console log file When WebLogic is fully initialized you will see the lines INFO jvm 1 2005 03 29 08 12 11 Mar 29 2005 8 12 11 AM EST Notice WebLogicServer BEA 000355 Thread ListenThread Default listening on port 7001 ip address 192 168 22 gt INFO jvm 1 2005 03 29 08 12
20. The job that gets executed For example to load data every day at 11 00 PM use the following exec aa refresh job p create job 02 07 2005 23 00 00 DY NULL load hd p load all Update Snapshot Refresh optional A new refresh process is loaded on the ROD database under glogowner to refresh certain analytics intelligence tables These are updated when a user inserts or updates data on the operational database By default this refresh is every five minutes Data Customizations optional Table AD TIME is used to define the Time Calendar for FTI It uses the normal Oracle Date If you would like to use a different calendar change the AD TI ME CSV delete the data from AD TIME table and re load the AD TIME CSV Migrate Historical Database HD To migrate the existing Historical database hdowner schema from version 5 5 05 to 5 5 06 follow the instructions below 1 Open up a shell UNI X or command prompt Windows on the APP server Important Ensure that your environment is setup correctly by running On UNIX otm install path install gc3env sh On Win32 otm install path VinstallNgc3env ocmd 2 Change directory to otm55 install path glog oracle script8 advanced analytics 3 In SQL Plus as user HDOWNER run hd_dbpatch55cu6 sql 4 Enter the passwords and connection strings when prompted 5 Check the log file nd dbpatch55cu6 10g to ensure it is error free before proceeding to t
21. and will leave a core dump in your current directory Resolution Install from the Server console recommended or log out of your X session reset your X server and log back in Starting Oracle Transportation Management After installing Oracle Transportation Management on Windows Server make sure that you reboot your server before you start Oracle Transportation Management There are environment settings that will not take effect until the server is rebooted Symptoms Apache won t startup correctly You get an error stating Cannot load apache modules mod ssl so into server 126 The specified module could not be found This error occurs when openssl exe is not in the path Resolution Restart your server before starting Oracle Transportation Management After installing Oracle Transportation Management on Solaris make sure that you log out of your session before you start Oracle Transportation Management There are environment settings that will not take affect until you log out and log back in Symptoms Apache Tomcat or OAS WebLogic WebSphere will not startup correctly Resolution Log out of your server and then log back in before starting Oracle Transportation Management When Oracle Transportation Management starts Tomcat opens a connection with OAS WebLogic WebSphere to cache certain information UOM fields dropdown boxes etc If OAS WebLogic WebSphere has not fully started before Tomcat is started this information is not
22. e What features did you like most about this manual If you find any errors or have any other suggestions for improvement please indicate the title and part number of the documentation and the chapter section and page number if available You can send comments to us in the following ways e Electronic mail otm doc_us oracle com e FAX 610 491 9897 Attn Documentation and Training Manager e Postal service Documentation and Training Manager Oracle Corporation 1016 W Ninth Ave Suite 300 King of Prussia PA 19406 USA If you would like a reply please give your name address telephone number and electronic mail address optional If you have problems with the software contact Support at https metalink oracle com or find the Support phone number for your region at http www oracle com support contact html Copyright 2001 2009 Oracle All rights reserved ix Preface This manual is for administrator s who are responsible for installing and managing the Oracle Transportation Management system at your site This manual provides step by step installation instructions for installing all Oracle Transportation Management software components This manual does not cover the installation of any operating system that is required to run Oracle Transportation Management such as Linux or Windows Server It is assumed that your IT staff will handle the installation and configuration of this software Change History Date
23. not already done so as part of ROD installation create_dblink_oltp_to_rod sql Then on the ROD run the following as GLOGOWNER if you have not already done so as part of ROD installation create_dblink_rod_to_oltp sql Run the following to set up the archive triggers and tables from the OLTP as GLOGOWNER If the tables already exist from prior versions this step will ensure they are in sync with the Oracle Transportation Management table structures create_archive_objects sql The upgrades patches will automatically keep the archive objects in sync as new tables and columns are added Moving Archiving from OLTP to ROD If archiving is already implemented and is stored on the OLTP you can later move it to the ROD You will need to e Export the archive schema e Login to OTLP database as system and run drop user archive cascade Run create_archive_user sql on the ROD as glogowner e Import archive schema onto the ROD database e Create database links as described below o Login to OTLP as glogowner and run create_dblink_oltp_to_rod o Login to ROD as glogonwer and run create_dblink_rod_to_oltp e Login to ROD as glogowner and run create_archive_objects sql which will recreate the triggers and set up grants Copyright 2001 2009 Oracle All rights reserved 3 29 4 Installing Fusion Transportation Intelligence Note It is recommended that a separate database instance be used for Transportation Intelligen
24. pak patches one by one a copy the pak file into the updateinstaller maintenance directory e g opt I BM WebSphere AppServer6 updateinstaller maintenance b Run the update script e g opt IBM WebSphere AppServer6 updateinstaller update c Follow the onscreen directions When it s finished run it again Repeat until it tells you that there is nothing further to install e Remove the contents of the updateinstaller maintenance directory f Repeat with next pak patch Installing WebSphere AppClient on the Web Server WebSphere This only needs to be done for web only servers Servers where the Oracle Transportation Management web amp application pieces reside together should skip this step You must run this installer from an X display Uncompress and untar the was 6000 base linux tar gz file Copy the AppClient directory to the target machine Run AppClient install Accept the license agreement Install WebSphere into opt IBM WebSphere AppClient6 6 Install your License file using the directions provided by IBM Installing Oracle on the Database Server m BR Please refer to the standard 10g Oracle DB Installation Guide Installing Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services on the Report Server The system requirements and installation steps along with explanations of each for the Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services hereafter referred to as Ora
25. 0 LA Apply 5 0 LA Patch 1 In SQL Plus as user GLOGOWNER run dbpatch_50a sql 2 Enter the passwords and connection strings when prompted 3 Check the log files dbpatch log and update_content log to ensure they are error free before proceeding to the next step Migrate to 5 0 GA Updating the Structure 1 On the Application server change to directory lt otm50_install_path gt glog oracle scripts8 2 In SQL Plus as GLOGOWNER run Qdbupdate 50b sgl to update the database with all the new 5 0 tables and columns 3 Enter the glogowner password reportowner password and database connection when prompted After the process has run verify the dbupdate_50b_ lt dbsid gt _ lt timestamp gt log file located in the same directory as source that there are no errors If the solution to the error is apparent then you can fix the problem and rerun the dbupdate 506 541 process again without harm you may also want to rerun to see if it automatically resolves your problem Contact Technical Support if the problem is not resolvable and send the entire log file along with any other logs you have from the day to our Technical Support team Do not continue until the dbupdate 50b log is clean Migrate to 5 0 GA Updating Data Content The GC3 5 0 database includes Procurement structures and data contents even you have not purchased the Procurement component license The database structure has been loaded in the previous step while the con
26. 05 56 05 07 11 28 05 56 05 56 08 07 11 28 05 56 08 Oracle 0 initialized utomatically deploy the Oracle Transportation Management application This can take anywhere from 15 45 minutes depending on the speed of your system There is unfortunate ly no direct indication of when this process is finished You can infer that it has completed by checking the highest numbered directory In otm install path NoasVj2eeMhomeNapplication deploymentsNGC3App e g gc3deploy66 If there is a single jar file in that directory called deployment cache jar and there are no class files there then the process has comp 13 WebLogic Start the WebLogic Service e It can take several minutes for WebLogi leted g otmapp c to fully start up depending on your server To check WebLogic you can monitor the otm install path Vlogs NweblogicNconsole log file When WebLogic is fully initialized you will see the lines 12 11 Mar 29 2005 8 12 11 AM listening on port 7001 EA 000355 Thread ip address 12 11 Mar 29 2005 8 12 11 AM EA 000329 Started WebLogic Admin for domain gc3domain running in Production gt 12 11 Mar 29 2005 8 12 11 AM INFO jvm 1 2005 03 29 08 EST Notice WebLogicServer B ListenThread Default 192 168 2 2 INFO jvm 1 2005 03 29 08 EST Notice WebLogicServer B Server otm boxl
27. 4 partition 1 partition 2 If the table is weekly then the data is divided as follows Week Partition Jan 1 7 partition 1 Jan 8 14 partition 2 Jan 15 21 partition 3 Jan 22 28 partition 4 Jan 29 Feb 4 partition 1 Feb 5 11 partition 2 Copyright 2001 2009 Oracle rights reserved 8 27 Every table reuses its partitions because the intention is that before the end of the cycle oldest partition is purged in preparation for the new cycle In other words for a monthly table on April 30th partition 1 should be purged to remove anuary s data which will then be used for May Truncate Jobs for Partitioned Tables In order to make truncating the partitioned tables as seamless as possible a script is provided that submits an Oracle job to automatically purge the oldest partition on the last day of the cycle These jobs should be submitted as a final step in any migration logged in as GLOGOWNER Enter SET SERVEROUTPUT ON to be able to see feedback Run Exec partit submit_job WW Run Exec partit submit_job MM go ort 4 Run Exec partit submit_job Q These jobs are set to run at 1 AM on the last day of the cycle by default Schedule Jobs at a Different Time You can specify a different time if you would like as an optional second parameter For example the following command will have the job run at 2 30am You can resubmit these jobs whe
28. ADMIN 2 In the left frame expand Configuration and Administration gt System Administration gt Data Source Manager 3 Select search 4 Select the desired database pool 5 You can now edit the initial capacity maximum capacity and capacity increment If resources permit you should set the initial and maximum capacity to the same value and save some overhead involved with expanding and shrinking the database pool Changing Memory Settings As your server load varies you may need to change the amount of memory that is allocated to the Oracle Transportation Management instance You can change the amount of memory allocated to both Tomcat and OAS WebLogic WebS phere Tomcat is the Java servlet server that Oracle Transportation Management uses Increasing the amount of memory that it can utilize allows more Oracle Transportation Management concurrent users and improves the speed of some integration tasks OAS WebLogic WebSphere is the application server that Oracle Transportation Management runs within Increasing the amount of memory that is has improves performance of business logic functions After making any memory changes you need to stop and restart Oracle Transportation Management as described starting on page in the chapter Starting Oracle Transportation Management after Installation 15 Complete The instructions below describe how to make these changes UNIX and Win32 To change the amount of memory that Tomcat uses edit
29. Application server only Copyright 2001 2009 Oracle rights reserved e WebSphere WebSphere Advanced Server 6 0 with the following patches applied in the following order Application server only o 6 0 WS WAS AixPPC32 RP0000002 tar o 6 0 2 WS WAS AixPPC32 FP0000007 tar o 6 0 2 WS WAS avaSDK AixPPC32 FP00000033 pak e WebSphere WebSphere Application Client 6 0 Web only installs o Installer for this can be found in the AppClient directory of the main WAS install e Oracle 10gR2 10 2 0 3 0 DB Server or the latest version of 11g DB server only e Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services Report server only e Oracle Transportation Management Application software Before you begin the installation process ensure that the following is complete e AIX 5 3 has been installed on your server e size of the swap space on your server is equal to or greater than the amount of memory it contains e All Oracle Transportation Management servers are time synced using a process like NTP This is critical to the proper operation and troubleshooting of an Oracle Transportation Management instance e Oracle 10gR2 10 2 0 3 0 Client Administrator install has been installed and configured to connect to your database Pre Install Setup Ensure that AI X 5 3 and all of the latest patches are installed The latest AI X recommended patch bundle could be downloaded from at https techs
30. Document Revision Summary of Changes 6 10 08 07 Added Change History table Updated Migrate GC3 5 0 Database to 5 5 section Updated hardware requirements for all platforms Updated patch requirements for WebSphere Updated supported translations matrix Updated suggested required database parameter settings Updated information on how NOT to uninstall Oracle Transportation Management Copyright 2001 2009 Oracle All rights reserved xi Date Document Revision Summary of Changes 8 10 09 08 Made the following edits Corrected exec aa_referesh_job p_create_job to be exec aa_refresh_job p_create_job Revised steps 13 14 in the Post Installation Setup section of the Installing Fusion Transportation Intelligence chapter Added the Post Installation OBI EE Instructions section to the Advanced Configuration chapter Moved Reset Sequence and Setup Security Roles sections after dbpatch 55 541 in the Installing Oracle Transportation Management on the Database Server section to resolve BUG 8767514 Changed Software Requirements sections to reflect new WebLogic version 8 1 SP6 Changed Software Requirements sections to reflect new WebSphere fixpack requirement FP33 Linux Software Requirements added 32 bit clarification Installing Oracle on the Database Server removed obsolete patch reference Migrate the New Database added warning Applying Consolida
31. For partition option at the command line type imp parfile imp otmv55 partition par userid system SYSTEM PWD Q CON STR For non partition option at the command line type imp parfile imp otmv55 nonpartition par userid system SYSTEM PWD Q CON STR 7 Check imp_otmv55 log file There should not any errors in the importing table portion It is safe to ignore the error message 00041 Warning object created with compilation warnings If there are other or ORA errors please contact Technical Support 8 I MPORTANT The database structure just imported is the 5 5 GA General Availability data structure and therefore must be migrated to the CU6 data structure Please see instructions in the Migrate the New Database section later in this chapter for steps on how to do this 3 20 Copyright 2001 2009 Oracle All rights reserved Running Oracle Transportation Management Scripts 1 Change to the otm install path gt glog oracle script8 directory on the Oracle Transportation Management Application server In SQL Plus as user GLOGOWNER run package sql glogowner_grants sql create_public_synonyms sql create_logon_triggers enter connection string when prompted 2 In SQL Plus as user ARCHIVE run archive_grants 3 In SQL Plus as user REPORTOWNER run reportowner_grants sql create_public_synonyms sql recompile_invalid_objects sql After running the
32. In this case you will not need the partition tablespaces and you should enter N for this option The default is Y Your ROD database is not partitioned So this question is irrelevant if you are creating ROD database tablespaces Hit ENTER in that case e Parameter Default Option Y N This process sets the following parameters with default values If you not want to use these values you should enter N The default is Y file size 1GB maximum file size if auto extend is on 2GB e Parameter Value Option If you choose N for Parameter Default Option you can enter values you want for the above parameters Otherwise just press Enter e Autoextend Option Enter N if you do not want your datafiles to be autoextended Default is Y Copyright 2001 2009 Oracle rights reserved 3 19 e Datafile directory Enter full path of datafiles directory The trailing slash for UNIX Linux or back slash should be included e Executing Now Option Enter Y if you want to let the process to create tablespaces for you Otherwise the process will generate create statements in the log file Default is N Creating Database Roles and Database Users Various SQL scripts that MUST be run before an attempt is made to start Oracle Transportation Management You can find them on the APPLICATION server under the lt otm_install_ path gt gc3 glog oracle script8 directory 1 In SQL Plus as the SYSTEM user run QGcreate glog roles
33. MANAGED TABLESPACES iisssssssssee nnne nena areae aa ean nnn 10 3 LOG Ss at s cash uere euer ehem petites Ads vedo ris ruat e Cer where tote 10 3 INITIAL SETTING OF NDQOS texas e eek ve Pe te vae ev ee e dp ec e n oe ve E Ca P a e e 10 3 INI TI AL SETUP OF ORACLE TRANSPORTATION MANAGEMENT DATABASE 10 3 ANALYZING TABLES GATHERING STATISTICS sssssnnuuuuuuaRARARARARRRRRRRRRRARRARRRRRRARARARARARRRARXAR 10 4 COPY DATABASE 10 5 COPY DATABASE FILES cernere Ert ERES SERRA ER ECC C LER Io a aad ones 10 5 ORACLE EXPORT UMPORT UTILITY cen deve e RR Y c e ees Ves cobs OCC CC C TP PT RT 10 5 DOMAIN COPY eis nnn ole t e Pea Raced ec PR RE TR Rete o RP PLE CAU RI RR CR ERAT reo Rene 10 6 PINNING LARGE OBJECT IN MEMORY cen nnnn enhn uuu a uana aua nuu uam auus u uana 10 6 DATABASE SPACE MONITORING 44444222222222223333333333 333333 33 33 33 8 3 SISEAISIEAARAASARARRRRRRARARARARRARARAR 10 7 SCHEDULED J 5 10 7 REAL APPLICATION CLUSTERS RAC cccccccnccccnnccccnneeeenceeeenneeeenneceenneeeennenenenenenenenens
34. Management software is distributed on CD or via download from standard Oracle channels Preparing to Install Oracle Transportation Management Oracle Transportation Management requires the following software Windows 2000 Server with Service Pack 4 or Windows 2003 Server with Service Pack 1 Internet Explorer 6 0 SP1 with Java Plugin 1 4 2 or later Note Popup Blockers may prevent your browser from working correctly with Oracle Transportation Management If you experience any problems try disabling them before contacting Technical Support Oracle 10gR2 10 2 0 3 0 client or the latest client version of 11g optional Web server required on Application server WebLogic WebLogic 8 1 with Service Pack 6 Application server only Oracle 10gR2 10 2 0 3 0 DB Server or the latest version of 119 DB server only Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services Report server only Oracle Transportation Management software Before you begin the installation process ensure that the following is already complete 2 2 Windows 2000 Server with Service Pack 4 or Windows 2003 Server with Service Pack 1 Copyright 2001 2009 Oracle rights reserved e The Server service under the Network Control Panel Start Menu gt Settings gt Control Panel is set to Maximize Throughput for Network Applications e Virtual memory is set to 1 5 to 2 times the amount of physical memory in
35. Oracle Transportation Management ships with The simplest and safest way to do this is to rename the file The file in question is weblogic install path server lib odbcl4 jar rename it to be something like weblogic install path server lib odbcl4 jar bak where weblogic install path is whatever value was used in step 5 above Installing Oracle on the Database Server Please refer to the standard 10g Oracle DB Installation Guide Installing Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services on the Report Server The system requirements and installation steps along with explanations of each for the Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services hereafter referred to as Oracle AS 10gR2 FR installation are documented within either the web based or Adobe Acrobat PDF files on Disk 1 of the Oracle AS 10gR2 FR installation CD package Please read the requirements and installation instructions fully before installing the Oracle AS 10gR2 FR Software The instructions listed below should be used in conjunction with those supplied by Oracle as there are certain sections within the AS that are not utilized by Oracle Transportation Management at this time Please refer to the Oracle documentation as they are far more complete and contain in depth explanations of all installation options Create an oracle user and assign it to the DBA group The installer should be run as this user Ins
36. SAME MACHINE cis sauces 8 16 INSTALLING MULTI PLE WEB SERVERS 8 16 NSTALLI NG TRANSLATIONS 2 4 ew rna a TRERRRRRRENNRRRRRESRRRARRRERNRRRRRNSRRRRRRENNRRRRREERREARRRENNNRNE NE 8 16 MODIFYING THE SESSION TIMEOUT 8 17 MONITORING PERFORMANCE siiseasansuauassEREMWEEYRRZRERSREEENRERSEEERNRERERNRSERRRREERNERERFNERRNANFEEARE 8 17 Copyright 2001 2009 Oracle rights reserved V UNIX dead eae ventiaad E EDA 8 18 PURGING EXCESS REPORTS FROM THE REPORT LOG 8 19 PURGE PROCESS vea a bk cR Cnr E teda OC ater E LU REA CURA adie ean wa oa 8 19 PURGE PROCESS FOR WINDOWS XO DIEN GG AY Due has oe wesw nant 8 19 DiAGNOSE PURGING PROBLEMS FOR SHIPMENTS AND ORDERS lt 8 20 SETUP UII 8 21 DIAGNOSE PROBLEMS IN EORR EATDL NER UI ER MCA ERREUR P
37. apache service If you are not using the default ports you will need to change the lt VirtualHost 80 gt and lt VirtualHost 443 gt to lt VirtualHost 8081 gt and lt VirtualHost 8443 gt c Modify the workers properties file with the location of your directory from the old location to the new OBI EE directory Also change the port and IP to be the same as what you entered for your server xml file for Tomcat Modify the mod_jk conf file with location of your directory from the old location to the new OBI EE directory Change the J kMount from JkMount GC3 ajp13 to J kMount analytics ajp13 Make a directory called OBI EE logs apache Copy lt otm_install_path gt fti advanced_analytics rpd to OBI EE Oracle BI server repository directory Open NQSConfig ini from OBI EE Oracle Bl server config directory a Comment the lines which say Star b Adda new line Star advanced analytics rpd DEFAULT Backup the existing OBI EE OracleBIData web catalog aa folder if any by renaming it to aa bk Time Stamp This backup will ensure that your custom Webcat changes will not be overwritten by the new FTI installation Copy otm install path fti aa webcat zip to OBI EE OracleBIData web catalog directory Unzip the webcat zip file in OBI EE OracleBIData web catalog directory Open instanceconfig xm
38. been made restart your Oracle Transportation Management instance Integration To BPEL As of the Oracle Transportation Management 5 5 CU2 release the recommended method for sending data from Oracle Transportation Management to a BPEL server is via Web Services that are configured in the External System Manager in the Oracle Transportation Management UI Refer to the online help for details Copyright 2001 2009 Oracle rights reserved 8 33 9 LDAP LDAP stands for the Lightweight Directory Access Protocol It is important to remember that LDAP is in essence a protocol a common language that various directory products can speak in order to communicate with users and applications and other directories The TCP IP based LDAP protocol contains messages allowing an LDAP client an application or user to connect to search add to delete from and modify an LDAP server the directory Overview LDAP clients connect to an LDAP server as a user in the directory sometimes called binding to the directory The LDAP server may choose from a number of authentication protocols see below to validate the identity of the connecting user Once connected the LDAP user can search or modify the directory if permission has been granted to perform these operations our case Oracle Transportation Management is the LDAP client A customer s LDAP directory is the server LDAP represents names in a standard format the Distinguished N
39. cached and certain fields will remain blank Symptoms Oracle Transportation Management has been started but some fields and drop down boxes are not populated as they should be Resolution Restart Oracle Transportation Management 503 Service Unavailable Errors While the application server is starting up the web server will respond to all requests with a 503 Service Unavailable error message This will go away once the application server has fully started up See section 6 Starting Oracle Transportation Management after Installation Is Complete for more information Uninstalling Oracle Transportation Management Oracle Transportation Management must be manually uninstalled there is no automated uninstall option prior to Oracle Transportation Management 5 5 CU5 there was an uninstall option available on Copyright 2001 2009 Oracle rights reserved 12 1 some platforms but it did not work Follow the directions below to completely remove Oracle Transportation Management from your system 1 If running on Windows remove the Oracle Transportation Management services The default names for these services are otmapache otmtomcat and otmweblogic The srvinstw exe utility from the Windows Resource Kit can help you remove these services 2 Remove the Oracle Transportation Management installation directory and all of its contents e g d gc3 on Windows and opt gc3 on UNIX 3 If running on UNIX remove the Oracle T
40. configure the user role for all their users to include either the FTI_Default SERVPROV VPD Profiles as applicable Performing this manual step is mandatory to ensure the proper operational behavior of the application Alternatively if you are using a customized VPD profile in Oracle Transportation Management you are mandated to manually include your additional external predicates over the FTI_Default or SERVPROV VPD profiles as applicable Copyright 2001 2009 Oracle All rights reserved 4 13 5 Installing Optional Components These components include Installing GFI FAXmaker for Networks SMTP 8 1 Installing PCMiler WorldWide Installing Rand McNally IntelliRoute Server Installing SMC RateWare Server Installing Python on a Client PC Installing FAXmaker for Fax Notifications FAXmaker is an email to fax gateway that allows Oracle Transportation Management to send out fax notifications Oracle Transportation Management sends an email via SMTP to a specific POP3 mailbox FAXmaker checks this mailbox at regular intervals and converts the emails within to fax transmissions if all security requirements are satisfied 1 2 Install FAXmaker for Networks SMTP 8 1 from on a Windows server and configure it to work with your modem s Refer to the FAXmaker documentation for details Test the modem to ensure that it gets a dial tone and can access an outside line Create a POP3 mailbox within your ma
41. currency storage default to the currency you use For example Oracle Transportation Management stores a 100 GBP shipment cost as 100 in both the total cost and the total cost base fields so no currency conversion is needed 1 Run the following insert statement example using GBP as new storage default as the DBA user INSERT INTO UOM TYPE UOM CODE UOM SHORT DESCRIPTION UOM LONG DESCRIPTION UOM RANK IS STORAGE DEFAULT IS DISPLAY DEFAULT DOMAIN NAME VALUES CURRENCY GBP UK POUND UK POUND 1 Y Y DBA 8 30 Copyright 2001 2009 Oracle All rights reserved Rates in Several Currencies In this case you need to 1 Decide what the currency storage default is for your Oracle Transportation Management installation 2 Set your currency storage default by running the following insert statement example using GBP as new storage default as the DBA user INSERT INTO TYPE UOM CODE SHORT DESCRIPTION UOM LONG DESCRIPTION UOM RANK IS STORAGE DEFAULT IS DISPLAY DEFAULT DOMAIN NAME VALUES CURRENCY GBP UK POUND UK POUND 1 Y Y DBA Oracle Transportation Management still needs currency rates to convert between the currencies you use You can download rates from the IMF website This populates the DEFAULT rate in the CURRENCY_EXCHANGE_RATE table The problem
42. for the Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services hereafter referred to as Oracle AS 10gR2 FR installation are documented within either the web based or Adobe Acrobat PDF files on Disk Copyright 2001 2009 Oracle All rights reserved 2 13 1 of the Oracle AS 10gR2 installation CD package Please read the requirements and installation instructions fully before installing the Oracle AS 10gR2 FR Software The instructions listed below should be used in conjunction with those supplied by Oracle as there are certain sections within the AS that are not utilized by Oracle Transportation Management at this time Please refer to the Oracle documentation as they are far more complete and contain in depth explanations of all installation options Create an oracle user and assign it to the DBA group The installer should be run as this user Insert Disk1 of the Oracle AS 10gR2 FR install package Run runtinstaller Ensure your system passes the Installation Requirements Check Review the Welcome screen and click Next At the Destination Oracle Home and Oracle Home Name Screen please enter in the Oracle Home Name i e FR HOME AS_HOME etc and the path to the new Oracle Home i e u01 app oracle product reports10g Note Do NOT install the Oracle AS 10gR2 FR software to an existing Oracle Home This may cause any existing Oracle products including databases to become inoperable OO 2 WN a 7 Cli
43. help This will display the help page e http servername 7777 repdemo runrepl AS html Run the test rdf report Enter the Connect String of your Oracle Transportation Management DB and click Run Report When prompted enter the User name glogdba password glogdba and the Connect String of your Oracle Transportation Management DB in the Database field Click Submit If the test report runs successfully your configuration is correct 32 If you encounter problems with Oracle Transportation Management communicating with Oracle Reports first double check your tnsnames ora file and ensure that the entries for your Oracle Reports instance and Oracle DB instance are correct You can utilize the sqlplus and tnsping utilities within Oracle AS 10gR2 FR to test these connections Startup Scripts UNIX Only The startup scripts are copied to etc rc local on AIX sbin init d on HP UX and etc init d on Linux and Solaris The default names are shown below but may differ depending on what names you specified in the installer e otmrptweb55 Oracle Transportation Management Reports Web Server Property Files on the Oracle Transportation Management Reports Server e glog properties otm install path gt glog config e httpd conf otm install path gt rptapache conf cgicmd dat u01 app oracle product reports conf e rep REPORTS 5 gt u01 app oracle product reports10g reports conf Log Files on th
44. host pcmiler company com pcmiler port 8145 If your PCMiler WorldWide running on port 8145 on a server named linus brown com your lines would look like pcmiler host linus brown com pcmiler port 8145 Once this change has been made restart your Oracle Transportation Management instance Installing Rand McNally IntelliRoute The following software is required e Rand McNally IntelliRoute with TrueTrack Win32 Java 12 01 2004 Install the Rand McNally IntelliRoute Server as described in your IntelliRoute user s manual You will also need to create a user e g otm password and location for the Oracle Transportation Management Application to use These activities are described in the IntelliRoute user s manual The IntelliRoute Server runs as a console application and cannot be run as a service Once the server is installed you need to install the IntelliRoute Java API onto the Oracle Transportation Management Application Server as described in your IntelliRoute user s manual You can setup Oracle Transportation Management to integrate with IntelliRoute during the initial Oracle Transportation Management installation as described earlier or you can modify an existing installation to use IntelliRoute To modify an existing Oracle Transportation Management installation you need to edit the glog properties file on the Oracle Transportation Management Application server 5 4 Copyright 2001 2009 Oracle rights reserved
45. hours rather than processing all records at once 1 As GLOGOWNER run G45mig audit trail sgl Reviewing Obsolete Tables and Columns When a table or column becomes obsolete during an upgrade the table column is renamed with XX lt version object became obsolete original name of table column gt To generate SQL for dropping obsolete objects run Ggen obsolete objects sql as GLOGOWNER Note This will not include objects that just became obsolete in the current version as a safety precaution This script will generate a SQL script called drop obsolete objects sgl which you can review and run at a convenient time Verifying Saved Queries After the upgrade some of your saved queries may no longer be valid due to changes in table structure 1 Run the following to verify the saved queries QGvalidate saved query sql If there are invalid saved queries you can decide what to do with them remove the records or modify them to correct the syntax ROD Maintenance for Upgrades After the 4 0 to 4 5 upgrade the ROD will not automatically be aware of new or changed Oracle Transportation Management tables If structural changes occurred the automatic refresh process will fail until the following steps have been completed Run the following command to create logs for new tables It will skip tables that already have a log 1 On the OLTP database in SQL Plus as user GLOGOWNER run Qcreate mview logs 2 On the ROD database in SQL Plu
46. identify broken views caused by obsolete columns It will then build or rebuild the materialized views for any new modified tables Note This will not automatically add columns that were added during an upgrade This is because the materialized view would need to be recreated from scratch again and you may not even need those new columns Therefore views should only need to be completely refreshed when a column has been removed or modified in a way that Oracle needs a new copy of the data Once the views are set it refreshes the views and builds any new indexes Upgrading from Version 5 0 to 5 5 Any new Oracle Transportation Management installation should be tested in a controlled environment before migrating your production database This ensures that any potential problems or incompatibilities don t affect your production Oracle Transportation Management instance s Note If you are migrating from a version earlier than 5 0 you must complete each previous version s migration instructions You cannot skip any migration steps Please go through all upgrade steps to 5 0 prior to starting the 5 0 to 5 5 migration The structure of the database to be migrated should be consistent with the GC3 5 0 database specification otherwise the migration will fail Custom Help If you have written custom documentation for Oracle Transportation Management you can link it to the Oracle Transportation Management help A file exists for you to custom
47. install path gt logs apache ssl log otm install path gt logs apache console log otm install path gt logs tomcat automatically rotates Python on 64 bit systems UNIX only If you are using the 64 bit Oracle client on the Web Server with Python you will need to make the following changes 1 2 Install the 32 bit Oracle DB client libraries OAS Change the Library Path to point to these libraries on AIX the environment variable is named LD_LIBRARY_PATH on HP UX the environment variable is named SHLIB_PATH on all other UNIX platforms it is named LD_LIBRARY_PATH Copyright 2001 2009 Oracle All rights reserved 3 11 3 4 3 12 Edit the line in lt otm_install_ path gt tomcat bin tomcat conf as follows renumbering all other lines in this sequence wrapper java library path 2 SORACLE_HOME 1ib32 Edit the line in otm install path gt tomcat bin tomcat sh as follows D LIBRARY PATH ORACLE HOME 11b32 ORACLE HOME lib o LIBRARY PATH export LD_LIBRARY_PATH where LD LIBRARY PATH is the correct variable name for your OS Add a line in otm install path gt oas bin oc4j after the definition of PYTHON HOME and PYTHON PATH as follows LIBRARY PATH DASH HOME l1ib SORACLE 11532 HOME lib LD_LIBRARY_PATH export LD_LIBRARY_PATH where LD LIBRARY PATH is the correct variable name for your OS I
48. is run at the host command line rather than from within SQL Plus Two command scripts are provided and the script you use is dependent on your operating system UNIX shell script update_content sh lt otm_install_ path gt glog config V55 or Windows command line script update content otm install path glog config V55 7 Review the log file called update content v55 timestamp log for errors located in the same directory as the SQL script Look for errors by searching key words like ORA Caught exception SP2 or lt Error gt within the log file Do not continue until the update content log is clean Data Migration 8 In SQL Plus as GLOGOWNER dbmigrate_55 sql 9 Enter the password and database connection string when prompted 10 After the process has run verify in the dbmigrate_55_ lt dbsid gt _ lt timestamp gt log file located in the same directory as the SQL script that there are no errors If an error occurs during a migration patch the database changes roll back It will however commit changes once a whole migration patch has been successfully applied and it will not try to migrate the data associated with that patch again If an error occurs partway through the process then you can fix the problem and rerun the process without harm If you cannot resolve the error yourself contact Technical Support Apply 5 5 Consolidated Update If the 5 5 Consolidated Update is available a
49. line in the security xml file that has alias glogdba e replace the old passwordz xor HBceERgaEhoz with the newly encrypted secret xor LDo8LTor 5 Restart Oracle Transportation Management glogload 1 Edit the otm install path glog config glog properties file on each Oracle Transportation Management Web and App server and replace the value of glog database load password with the new glogload password globalreportuser 1 Edit the otm install path glog config XSQLConfig xml file on each Oracle Transportation Management Web server and replace the value of lt password gt globalreportuser lt password gt with the new globalreportuser password Copyright 2001 2009 Oracle All rights reserved 8 11 Cleartext Passwords The following files have cleartext passwords in them Proper OS specific measures should be taken to ensure that only privileged users have read access to these files otm install path gt glog config glog properties otm install path2 glog config XSQLConfig xml OAS otm install path gt oas bin oc4j conf OAS otm install path gt oas j2ee home config data sources xml WebLogic otm install path gt weblogic config gc3domain weblogic conf WebLogic otm install path gt weblogic config gc3domain config xml template WebSphere otm install path gt websphere profiles default bin deployGC3 jacl WebSphere otm install path gt webspher
50. linux index html Once the Oracle Enterprise Linux 4 Update 4 operating system is installed you need to modify kernel parameters to ensure that the OS works properly with the application server 1 Update kernel parameters as needed for the Database Server This is covered in the Oracle DB installation documentation 2 Restart the server The following parameters may improve your server s performance Your system administrator should evaluate each of the settings below and implement them as necessary none 3 Improve file system performance by mounting them with the noatime parameter in etc fstab Creating the Oracle Transportation Management User You must add a group and user on the Application server called otm 1 Start the User Manager tool 2 Add a group called otm 3 Add a user called otm and set a password for the otm user Copyright 2001 2009 Oracle All rights reserved 2 21 4 Assign the otm user to the otm group Installing Oracle Application Server OAS on the Application Server OAS The necessary files will be installed as part of the Oracle Transportation Management installation no further work is needed Installing WebLogic on the Application Server WebLogic WebLogic Server is an application server a runtime environment that provides infrastructure services such as database access transaction coordinator and component framework for distributed applications WebLogic
51. logs for both GLOGOWNER and REPORTOWNER QGcreate mview logs Note You can let this run on the OLTP and continue to the next steps on the ROD Just make sure all the logs are created prior to running the create 541 script Create Tablespaces 1 To create the tablespaces for the ROD run the following It is the same script for creating tablespaces on the OLTP but enter Y when asked if this is the ROD database If archiving is going to be stored on the ROD also enter Y when prompted Qcreate gc3 tablespaces Note the ROD without archiving will be smaller than the OLTP since the ROD is a replica of the OLTP database without the LONG or CLOB columns key tablespaces for the ROD is DATA and INDX If archiving is stored on the ROD database then this will be stored in the ARCHIVE tablespace Copyright 2001 2009 Oracle rights reserved 3 25 Configure TNS Names on ROD Database Server 1 On the ROD database server configure your tnsnames ora file to have an entry for your OLTP database You will be prompted for the connection ID later when the database link is created Create Database Roles and Database Users 1 On the ROD database as user SYSTEM run the following Be very careful as to run this on the ROD database since this drops and recreates the users create_glog_roles sq create_glog_users sql The database users created have their passwords the same as their user ID respectively Creat
52. lt otm_install_path gt tomcat bin tomcat conf and modify the following lines wrapper java additional x Xms TOMCAT_MEMORY m wrapper java additional x Xmx TOMCAT_MEMORY m TOMCAT_MEMORY will be some integer value that represents the amount of memory in megabytes to use For instance if you changed this to 1 6GB the line would read Copyright 2001 2009 Oracle All rights reserved 8 3 wrapper java additional x Xms1600m wrapper java additional x Xmx1600m You can also change the amount of memory that OAS uses by editing otm install path gt oas bin oc4j conf wrapper java additional x Xms OAS MEMORY m wrapper java additional y Xmx OAS MEMORY m If you change this value to 1 6GB it would look like wrapper java additional x Xms1600m wrapper java additional y Xmx1600m You can also change the amount of memory that WebLogic uses by editing otm install path gt weblogic config gc3domain weblogic conf wrapper java additional x Xms WEBLOGIC MEMORY m wrapper java additional y Xmx WEBLOGIC MEMORY m If you change this value to 1 6GB it would look like wrapper java additional x Xms1600m wrapper java additional y Xmx1600m Under WebSphere this change would be made to the file otm install path gt websphere profiles default config cells _ APP SERVER NodeO1Cell nodes AP P SERVER NodeO1 perftuners xml where APP SERVER is your application serve
53. mainly Domestic Truckload Send orders to Oracle Transportation Management as order releases Work with domestic orders Plan your order releases into TL or LTL shipments buy shipments only Tender those shipments to service providers Overview A model is a set of CSV files that contains e User Roles e Menus e Manager Layouts and Screen Sets e Saved Queries e Workspace This data provides you with menus screens and fields specifically needed for the scenario you selected To apply a model e You import the CSV files into the existing domain BLUEPRINT e Change any data if needed in the BLUEPRINT domain e Create a domain for your company Copyright 2001 2009 Oracle All rights reserved 6 5 BLUEPRINT domain PreparedM Associate your domain with the BLUEPRINT domain Add users to your domain MYCORPdomain Import Blueprint Model 9 Go to the URL of your new Oracle Transportation Management server Enter a User Name of BLUEPRINT ADMIN Enter a Password of CHANGEME Click Login Click Configuration and Administration gt Blueprint gt Import Model Select an Import Type of Insert Select an Import Location of Import from Files Select a Model to Import If only one model exists Oracle Transportation Management automatically select that one DOMESTIC TRUCKLOAD Click Ok Oracle Transportation Management imports the CSV files associat
54. manually This script creates LOB tablespaces with 16 KB block size This is the recommended block size for optimal performance In order to create a tablespace with 16 KB block size you should have the following init ora parameter set if your database standard block size is not 16 KB Change the cache size as needed for your database db_16k_cache_size 104857600 100MB for 16k block buffers e Torun the script log in to the database as user SYS or any other user with CREATE TABLESPACE privilege and run script create_gc3_tablespaces sql Create Tablespace Options e ROD database Y N The primary Oracle Transportation Management database is OLTP type and also referred to OLTP A secondary database referred as ROD replicated operational database is also an option Oracle Transportation Management requires different tablespaces in this ROD database therefore if you are setting up an ROD database enter Y Otherwise enter N e Partition Option Y N In the Oracle Transportation Management OLTP database most integration tables are partitioned for the purpose of easy maintenance There are some other tables that are also partitioned To accommodate the partitioned tables there are dedicated tablespaces for these partitions But if your database is not partition enabled and you are not planning to add the partitioning option of Oracle you can have the partitioned Oracle Transportation Management tables created without partitioning
55. migrated should be consistent with the GC3 4 5 database specification otherwise the migration will fail Apply GC3 4 5 Service Releases Important Ensure that your environment is setup correctly by running On UNIX otm install path install gc3env sh Win32 otm install path2Vinstallgc3env cmd You must apply GC3 4 5 Service Release dated February 2005 SR 02 05 or later before you continue with the 5 0 migration You must also install the latest Oracle Transportation Management Service Release to your GC3 5 0 installation to ensure that any known migration issues have been patched and resolved 1 Log in as GLOGOWNER and run dbpatch 45 sgl which resides in the 4 5 directory otm45 install path2 glog oracle script8 Note Do not continue with the upgrade until the dbpatch log is completely clean Contact Technical Support if you have any questions or concerns Migrate GC3 4 5 Database to 5 0 GC3 5 0 had an interim release called 5 0 LA To migrate a 4 5 database to 5 0 GA you must first migrate 5 0 LA The following steps will guide you through the process Migrate to 5 0 LA Updating the Structure On the app server change to directory otm50 install path gt glog oracle script8LA SQL Plus log in as GLOGOWNER Run Qdbupdate 50a sql to update the database with all the new tables and columns to 5 0LA Beo Ni Enter the glogowner password reportowner password archive password and database connection when
56. order to have that attribute be successfully added Sometimes this schema checking can be turned off in the directory Another alternative is to use an attribute that already exists in the schema but is not populated You can change the NameSpace configuration to define the attribute where the GLUser information is contained so that Oracle Transportation Management knows where to get the Oracle Transportation Management User mapping LDAP and the Oracle Transportation Management Login If you have any doubt choose Default This most likely will be set up the Oracle Transportation Management Administrator to serve most needs The NameSpace allows logging in via the Oracle Transportation Management username and password see below The other choices represent LDAP directories that have been configured to work with Oracle Transportation Management The Oracle Transportation Management administrator has the ability to configure which directories are consulted when the Default option is chosen In fact when this option is chosen the administrator has the ability to configure an ordered list of directories to search Usually this results in a successful authentication The NameSpace is a special NameSpace that identifies the Oracle Transportation Management realm itself the usernames and passwords stored directly within Oracle Transportation Management When you search the NameSpace you are performing a search local t
57. originate from this email address to be converted and faxed out If an email is received from an email address that does not have an account FAXmaker will bounce it Select the new user and click on the Coverpages tab Click Add enter Oracle Transportation Management for the name and select G Log rtf as the cover page file Then click OK At the bottom of this window check the Cover page box Click on Setup and then Email2Fax Gateway configuration e Check Enable E mail2Fax Gateway Copyright 2001 2009 Oracle All rights reserved 5 1 11 12 e Enter your SMTP server and port usually 25 e Enter the Sender email address the email address for outgoing fax notifications that you entered when installing the Oracle Transportation Management application server e Enter your POP3 server usually the same as the SMTP server and port usually 110 e Enter the mailbox account password and login method This is the POP3 mailbox that you created a few steps ago Click OK to save this information Restart your FAXmaker services so the new configuration takes effect Refer to the FAXmaker documentation for any troubleshooting assistance or contact GFI directly If desired FAXmaker can also be configured to convert PDF attachments to text faxes by following these steps 13 14 15 16 17 18 19 Ensure that the latest version of Adobe Acrobat Reader is installed on the FAXmaker server After installation r
58. otm glog webserver urlprefix 2 Edit the index htm file under otm install path2 apache htdocs The following line needs to contain the URL prefix lt META http equiv refresh content 0 URL servlets glog webserver servlet umt Login e For example if your URL prefix is otm it would look like lt META http equiv refresh content 0 URL otm servlets glog webserver servlet umt Login 3 Ensure that the glog webserver URL setting in your glog properties files points to your reverse proxy server rather than the individual web server s 4 Restart Oracle Transportation Management to enable these changes Oracle Transportation Management can now be accessed through the reverse proxy but may not be accessible directly This is a limitation due to adjusting links to work with the reverse proxy Enabling Single Sign On SSO Support Oracle Transportation Management supports SSO where a central application the SSO provider authenticates users and then passes the login information to Oracle Transportation Management therefore bypassing the normal Oracle Transportation Management login process The burden of authentication then falls to the SSO provider Oracle Transportation Management will not provide any For SSO access to Oracle Transportation Management the invoking code needs to pass in the following parameter as part of the HTTP request appuid GUEST ADMIN where GUEST ADMIN is the
59. ready to proceed This step takes a few minutes typically one to five minutes UNI X Only The installer will prompt you to log in as root and run the root sh script This must be completed for a successful installation Win32 Only When finished you must restart your entire server before attempting to start Oracle Transportation Management Apply the latest Oracle Transportation Management consolidated update before starting up your server Contact Technical Support if you need assistance Copy all of the files from otm install path gt glog reports 10g to oracle reports home reports templates Overwrite all existing files Note You will need to do this step after applying each Oracle Transportation Management patch in order to ensure the files under oracle reports home reports templates are up to date It is now necessary to make configuration changes in support of the Oracle Transportation Management Oracle Reports installation Edit the TNSNAMES ORA file on the Reports Server Add a TNS entry that points to the same Oracle database instance as the Oracle Transportation Management installation Go to the Oracle Reports HOME directory Change to the reports conf directory and edit the rep REPORTS SERVERNAME conf file This is an XML file Make the following changes e Change the engine id property as follows engine id rwEng class oracle reports engine Enginel mpl initEngine 10 maxEngine 20 minEn
60. recompile_invalid_objects sql script you should see the following on the screen Invalid objects after Recompile 0 If the number of invalid objects is not zero run the recompile invalid objects sgl script again If you still have invalid objects after the second run copy the script output from the command prompt window paste into a text file and forward it on to Technical Support 4 In SQL Plus as user GLOGOWNER run setup sql QGrecompile invalid objects sql After running the recompile invalid objects sql script you should see the following the screen Invalid objects after Recompile 0 If the number of invalid objects is not zero run the recompile invalid objects sgl script again If you still have invalid objects after the second run copy the script output from the command prompt window paste into a text file and forward it on to Technical Support Verify Database Structure 5 In SQL Plus as user GLOGOWNER run Select count from all objects where status INVALID and owner in GLOGOWNER REPORTOWNER GLOGDEV GLOGLOAD The result should be COUNT 0 6 Run Select namespace from dba context where schema GLOGOWNER The result should be NAMESPACE GL USER 7 Copyright 2001 2009 Oracle rights reserved 3 21 select object_owner count from dba_policies where object owner in GLOGO
61. sql plus as glogowner glogowner password tnsname 2 sql gt exec domainman transmission purge age in days where clause total minutes keep status clob flag batch size The transmission purge process accepts the following arguments Age in days required the age of the transmissions that you want to purge If you have no idea of how many transmissions you have that are older than 30 days for example you can do the following query Copyright 2001 2009 Oracle rights reserved 8 23 Sql select count from i transmission where sysdate create date gt 30 Where clause optional Value should be domainman no status purge or be left null Use domainman no status purge if you want to keep transmissions that are associated with shipment events IE SHIPMENT STATUS or tender collaboration records TENDER COLLABORATION regardless of age Otherwise null ignores whether the transmission has shipment events tender collaboration records or not Total Minutes defaults to 60 The maximum number of minutes you would like the total purge process to take After processing a set of rows the procedure will check the total time If it exceeds the inputted time the process will wrap up the existing task and stop This is helpful if you have a tight time schedule in which you can perform this task Keep status clob flag defaults to TRUE If the where clause is set to domainman no status purge t
62. the appropriate executables from the Bea website We recommend that you run this installer from the server console Launch server814 hpux bin or platform814 hpux bin to install WebLogic Accept the license agreement Enter opt bea as the BEA Home Choose Typical Installation ROI Copyright 2001 2009 Oracle rights reserved 2 17 5 Install WebLogic into opt bea weblogic81 6 Install your License file using the directions provided by BEA Important Note You must remove a file from the WebLogic installation because of a code conflict between it and the latest J DBC drivers that Oracle Transportation Management ships with The simplest and safest way to do this is to rename the file The file in question is weblogic install path server lib odbcl4 jar rename it to be something like weblogic install path server lib odbcl4 jar bak where weblogic install path is whatever value was used in step 5 above Installing Oracle on the Database Server Please refer to the standard 10g Oracle DB Installation Guide Installing Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services on the Report Server The system requirements and installation steps along with explanations of each for the Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services hereafter referred to as Oracle AS 10gR2 FR installation are documented within either the web based or Adobe Acrobat PDF files on Disk
63. type as Complete and proceed to the next step When prompted enter the location of your JDK install opt oraclebi jdk Create an administrator password and proceed to the next step Post Installation Setup 1 2 3 4 4 The OBI EE installer does not include a Tomcat installer so you will need to download tomcat and manually configure some of the setup files Download Tomcat from http tomcat apache org download 55 cgi and download the core binaries for your operating system a Extract the download into a temporary directory b Move and rename the directory to OBI EE tomcat c Edit the OBI EE tomcat bin startup sh and add the Java home to the first line below all of the comments i JAVA HOME opt oraclebi jdk export JAVA HOME d Edit the OBI EE tomcat bin shutdown sh and add the Java home to the first line below all of the comments i JAVA HOME opt oraclebi jdk export JAVA HOME Edit the OBI EE tomcat conf server xml and replace the entry with the following lt xml 1 1 0 encoding UTF 8 gt Server port 8005 shutdown SHUTDOWN gt lt Comment thes ntries out to disable JMX MBeans support used for the administration web application gt lt Listener className org apache catalina core AprLifecycleListener gt lt Listener className org apache catalina mbeans ServerLifecycleListener gt lt Listener className org apache catalina mbeans GlobalReso
64. used packages procedures and functions Pinning objects in the shared pool can improve database performance if it is done correctly For large packages when pinned they do not need to be loaded and parsed from the database again and again Pinning large package also helps to avoid ORA 04031 error unable to allocate xxx bytes of shared memory It is recommended that in an Oracle Transportation Management production database following objects be pinned in the SGA Package 10 6 Copyright 2001 2009 Oracle rights reserved VPD PARTIT PKG_PURGE RRL USER_EXIT_HELPER RPT_GENERAL Database Space Monitoring A DBA should periodically monitor Oracle Transportation Management database s space usage There are several tables containing a column with data type of CLOB These columns can have great amount of data Some of the CLOB tables can be loaded quite often One example is _ TRANSMISSION and TRANSACTION table These tables contain transmission transaction s XMLs If there are inbound outbound transmissions in and out of system frequently the disk space usage of these two tables can grow very quickly Scheduled Jobs Oracle Transportation Management database uses Oracle scheduled job to perform certain activities inside the database Some of the jobs are set up automatically after the database is installed The others are optional and can be implemented by a DBA An Oracle Transportation M
65. user you should log out and log back in before you try to perform any User Management function You can also use the other User Management options to add users set security levels and so on Note Always change the default passwords after a new domain has been created For additional help and product instructions please use the online help in Oracle Transportation Management You can also access the help system from any browser With your Oracle Transportation Management server 15 up and running open up the following URL 6 4 Copyright 2001 2009 Oracle All rights reserved http webserver name html help webhelp en gc3help htm Note Replace webserver name with the name of your Oracle Transportation Management Web server Applying a Model This is an optional step If you can find a prepared model that matches what you need to do with Oracle Transportation Management it can help you implement Oracle Transportation Management a lot faster Available Models Go to the URL of your new Oracle Transportation Management server Enter a User Name of BLUEPRI NT ADMIN Enter a Password of CHANGEME Click Login Click Configuration and Administration gt Blueprint gt Import Model OP gr ds op dor Select an Import Type of Insert 7 Select an Import Location of Import from Files Oracle Transportation Management displays the available models under the Model to Import heading Model Fits your company if you
66. user interface and communications with the Application server Application Server The Application Server controls the application logic and communicates that logic between the Web server and the Database The Application server runs Oracle Application Server software from Oracle all supported platforms WebLogic Server software from BEA Systems all supported platforms or WebSphere Application Server from AIX and Linux only to manage system level details and operates at the center of the Oracle Transportation Management multi tier architecture In this architecture business logic is executed in the application server rather than in client applications The resulting thin client allows the client to manage the presentation layer the application server to manage the business logic and the back end data services to manage the data Database Server The Database server is the central repository for all the data entered in Oracle Transportation Management The Database server communicates with the Application server to deliver the appropriate data to the user based on the Oracle Transportation Management application logic The Database server also communicates with the Integration server to handle the import and export of Oracle Transportation Management data with other systems Oracle Transportation Management supports the following databases e Oracle 10g Release 2 any supported platform As of Oracle Transportation Management
67. within the log file Migrate to 5 0 GA Data Migration 1 In SQL Plus as GLOGOWNER run dbmigrate_50b sql 2 Enter the password and database connect string when prompted Note The script might run for several hours depending on the amount of data to process 3 After the process has run verify in the dbmigrate_50b_ lt dbsid gt _ lt timestamp gt log file located in the same directory as the SQL script that there are no errors If an error occurs during a migration patch the database changes roll back It will however commit changes once a whole migration patch has been successfully applied and it will not try to migrate the data associated with that patch again If an error occurs partway through the process then you can fix the problem and rerun the process without harm If you cannot resolve the error yourself contact Technical Support Run Security Role Script 1 Go to the otm install path gt glog oracle directory the Oracle Transportation Management Application server In SQL Plus as GLOGOWNER run Qinsert security roles sql Analyze the Database 1 Oracle Transportation Management databases should be fully analyzed after the 5 0 migration Oracle Transportation Management provides following analyze script But of course a DBA can use their own analyze process Ggather table stats sql The remaining steps are not critical to the upgrade but provide helpful information Reviewing Obsolete Tables and Colu
68. your database reportowner user password when prompted Note Make sure that DATA INDX and TEMP tablespaces are created The script does not create these tablespaces The user should manually create it This will create the hdowner user tables MViews packages etc It also creates a default job that will run every night at 12 00AM and refresh the history tables 3 Log into the database as hdwoner and execute the following command at the sqlplus prompt exec aa_load_hd p_load_all_once This script must be executed manually one time to do a complete refresh Note can also be setup on the Oracle Transportation Management ROD database ROD should be fully installed and configured within Oracle Transportation Management before attempting to create the FTI users and tables on ROD Copyright 2001 2009 Oracle All rights reserved 4 1 Update ETL Refresh Package optional A default job is created in the earlier step If you want to change the frequency delete this job and proceed as follows 1 Identify the frequency of data load from Oracle Transportation Management operational database ROD to HD 2 Log on as ndowner 3 Execute the AA REFRESH JOB P CREATE JOB package This package takes four parameters Start Date The date time when the load starts e Frequency DY for daily n HR for every n hours e name of weekday SUNDAY MONDAY etc for weekly e Start Time Start Time e What
69. 025MB Tomcat may not start Also please be sure to note whether this server will be used for Test Development or Production and what system resources it has available b WebLogic only Enter the path to your addjars directory e g tmp addjars This is the directory where you placed the extra jar files that Oracle Transportation Management requires During the installation they are copied from this directory to the appropriate installation directories C click Next WebSphere or AI X only Web Server Settings continued a Enter the number of logical CPUs in the server This is used to set a JVM performance parameter WebSphere only Web Server Settings continued a Enter the WebSphere Client Home directory which is the directory you specified when installing WebSphere Client e g opt I BM WebSphere AppClient UNI X Only UNIX Settings a Enter the user name that the Oracle Transportation Management programs will run under e g otm or otm55 b Enter the group name that the Oracle Transportation Management programs will run under e g otm or otm55 C click Next Choose whether or not to migrate custom settings from a previous Oracle Transportation Management installation 3 7 or later If you answer yes you ll need to choose the directory where your old glog properties file is located Click Next Choose the optional components with which Oracle Transportation Management will integrate Depending on what
70. 1 INFO jvm 1 2005 03 29 08 EST Notice WebLogicServer B RUNNING mode Copyright O 2001 2009 O EA 000360 Server started in racle All rights reserved 6 1 14 To check to see if everything has started up point to http lt web server name gt in your web browser and log in Note While the application server is starting up the web server will respond to all requests with a 503 Service Unavailable This will go away once the application server has fully started up Starting the UNIX Server 1 Start the Oracle database 2 Start the Oracle Reports if necessary e Reports Server start the Oracle Transportation Management Rpt Web daemon e g etc init d otmrptweb start 3 Start the Oracle Transportation Management Web daemon e g etc init d otmweb start on the Oracle Transportation Management Web Server e This will start both Apache and Tomcat 4 OAS Start the Oracle Transportation Management App daemon e g etc init d otmapp start on the Oracle Transportation Management Application Server e t can take several minutes for OAS to fully start up depending on your server To check WebLogic you can monitor the lt otm_install_ path gt logs oas console log file When OAS is fully initialized you will see the lines INFO jvm 1 2007 11 28 05 56 05 07 11 28 05 56 05 OTM Startup initServlet INFO jvm 1 2007 11 28 05 56 05 07 11 28 05 56 05
71. 10 7 11 APPENDIX A RECOMMENDED RESOURCES 11 1 ORACLE TRANSPORTATION 11 1 Pee eP Pee CEP CE CECCECEEPECTEPCECEETEPCECCEEEPCECEEERECECCEEEECECETERECEEECEEECECETERCEC EC Er RCC er ee 11 1 OPENSSL ceieecicceicenieccinesavendcendseudnendvendcensasaneuavesacens sauanenavesdcens rasvent css KERN RR Ee RN 11 1 PYTHON 2 523 n SRRRRRRRSRRRRRRRRRRERRRRESHARRRRERSRARRRRSSRRRRRRRSRRRRRRRSERRRRRSERARSRESSRRESRSEEEERERSEEEEAR 11 1 NETWORK PERFORMANCE 11 1 11 1 ORACLE APPLICATION SERVER OAS 11 2 perrr er erere rer CP ee CECPCECCCEEECECEEETETPCECEPECECECEEECPCETEPECECECEEPTPCrCEPE CECE RE errr er ere te 11 2
72. 10 with the latest Recommended Patches e Solaris patches for the JDK 1 4 2 e Internet Explorer 6 0 SP1 or Mozilla Firefox 1 5 x for client Note Popup Blockers may prevent your browser from working correctly with Oracle Transportation Management If you experience any problems try disabling them before contacting Technical Support For users wishing to view the results generated by the Load Configuration feature a VRML plug in for their Web Browser is needed Oracle Transportation Management has been tested with the Cortona plug in for Internet Explorer available at http www parallelgraphics com products cortona e Adobe Acrobat 6 0 for client e Oracle 10g Release 2 10 2 0 3 0 Enterprise Edition or the latest version of 11g e WebLogic WebLogic 8 1 with Service Pack 6 with an Advantage non clustered License Copyright 2001 2009 Oracle All rights reserved 2 5 e Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services optional e Integration Server EAI solution optional The following software is distributed with Oracle Transportation Management e OAS Oracle Application Server 10 1 3 0 patches e Apache Web Server 2 0 55 e Tomcat Java Serviet Server 5 5 16 e OpenSSL 0 9 8a e Sun JDK 1 4 2 e Python 2 4 2 e Java Service Wrapper 3 1 2 e zlib 1 2 3 The Oracle Transportation Management software is distributed on CD or via download from standard Oracle channels Preparing to Install Or
73. 11 lt Mar 29 2005 8 12 11 AM EST gt lt Notice gt lt WebLogicServer gt lt 000329 gt lt Started WebLogic Admin Server otm boxl1 for domain gc3domain running in Production Mode 6 2 Copyright 2001 2009 Oracle All rights reserved INFO jvm 1 2005 03 29 08 12 11 Mar 29 2005 8 12 11 AM EST lt Notice gt lt WebLogicServer gt lt BEA 000360 gt Server started in RUNNING mode gt WebSphere Start the Oracle Transportation Management App daemon e g etc init d otmapp start on the Oracle Transportation Management Application Server e tcan take several minutes for WebSphere to fully start up depending on your server check WebSphere you can monitor the otm install path gt logs websphere console_out log file When WebSphere is fully initialized you will see the lines 8 4 06 10 00 16 809 EDT 0000000a WsServerImpl WSVROOOI1I Server serverl open for e business 8 4 06 10 02 45 720 EDT 00000041 SystemOut End startup is ready To check to see if everything has started up point to http web server name in your web browser and log in Note While the application server is starting up the web server will respond to all requests with a 503 Service Unavailable error message This will go away once the application server has fully started up Stopping the Windows Server 1 2 Stop the Apache service e g otmapache on the Oracle Transportation M
74. 400 max threads proc maxusers 3 maxfiles 8192 maxfiles lim 8192 ncallout 2 nproc 7 4 16 2 nkthread 2 lt max_thread_proc gt nfile 2 lt nproc gt 1000 nproc lt maxusers gt 5 64 2 Update additional kernel parameters as needed for the Database Server This is covered in the Oracle installation documentation 3 Restart the server Creating the Oracle Transportation Management User You must add a group and user on the Application server called otm Start SAM Add a group called otm Add a user called otm and set a password for the otm user Q9 qw re 4 Assign the otm user to the otm group Installing Oracle Application Server OAS on the Application Server OAS The necessary files will be installed as part of the Oracle Transportation Management installation no further work is needed Installing WebLogic on the Application Server WebLogic WebLogic Server is an application server a runtime environment that provides infrastructure services such as database access transaction coordinator and component framework for distributed applications WebLogic Server also provides administrative features such as configurable security management and application deployment tools and clustering to promote high availability and scalability You must purchase WebLogic Server version 8 1 with Service Pack 6 from Bea Systems Inc Once you have the appropriate license you can download
75. 5 5 CU4 Oracle Transportation Management now supports Oracle 11g on any supported platform Integration Server The Integration server is responsible for e Accepting Oracle Transportation Management XML from an Enterprise Application Integration EAI solution e Persisting XML transmission to a staging table e Accepting requests from the Oracle Transportation Management Application server to build Oracle Transportation Management XML from staged data Sending Oracle Transportation Management XML to an solution The EAI solution is used as a secure data pipeline and data transformation engine and is responsible for e Sending and receiving EDI flat files to and from an EDI Van e Transforming EDI flat files to Oracle Transportation Management XML e Login Security communication is permitted only from registered IP addresses e Encryption Security using https Guaranteed delivery only if a partner server is the remote side The Integration server s job is to safely store XML transmissions and transform the XML transmission into internal tables The Oracle Transportation Management Application server is responsible for 1 2 Copyright 2001 2009 Oracle All rights reserved initiating jobs that move data to and from staging tables and notifies the Application server when new data has arrived in the staging table The Application server must notify the Integration server when it has moved new data to the
76. 8 32 SORTING ciet dar en att bcr ea debi odas Te pe dct haa e oaa eas fun 8 32 SCALABILITY CONFI GURATI 8 32 BPEL NTEGRATION season us nzunnusamuuuEaruns aa EEuEYva sra ERE Nr ar ERE EEENRRRRRERRESRRER RE 8 32 BPELFLOWS EP CP et oue eto ca m ev E ende DOG AL aed Va op S RR 8 32 ORACLE TRANSPORTATION MANAGEMENT PROPERTIES FILES FOR EBS INTEGRATION THROUGH BPEL 8 33 ORACLE TRANSPORTATION MANAGEMENT PROPERTIES FILES FOR BPEL INTEGRATION 8 33 INTEGRATION TO BPEL oce a a SE sean P ota cea Po Ra Ra e 8 33 OVER VI E aiaee seri RasasesrRiwrre saa risapa ssusRRaN ERR RERRRRRRRERERERRRRRISEERRNNESRRRERETARRR 9 1 EDABP SCHEMA A teret utet etii rv tad eR Puts ei estin UU De e Eae ames 9 1 LDAP IN ORACLE TRANSPORTATION MANAGEMENT ieseeen mee nasse sena aaa nnn 9 1 LIMITATIONS ea LOC EE ERR TRE TRANI 9 2 LDAP SERVER src ERO C a CPC ERE C CL CR DD V ER RC TOC CEDE PR LEE RA CR 9 2 SINGLE SIGN ON SUPPORT atri aa a ER e a de da ia et e RA dU t E c PL EFE Ea 9 2 DEFINITIONS iie cag RR RSRRRRERRRNRRRRRRRNRRARRRBRRRRRERRRNRRRVRBRNRRENRRRSRRNERRRNRRRVRRRRREERERSRRESESEERR 9 2 NA
77. ANGEME Used to start amp stop the application as well as manage the WebSphere console May not be deleted In order to change the system user s password do the following 1 Login to Oracle Transportation Management as DBA ADMIN and use the Oracle Transportation Management User Manager to change the password for the system user refer to the online help for details 2 On the application server edit the following files replacing the old password with the new password a otm install path2 websphere profiles default bin deploy GC3 jacl b otm install path2 websphere profiles default bin deployGC3SS jacl otm install path2 websphere profiles default bin undeployGC3 jacl d otm install path2 websphere profiles default bin undeployGC3SS e otm install path websphere profiles default config cells APP SERVER Node01 Cell nodes APP SERVER NodeO0 1 servers server1 server xml where APP SERVER is your application server s host name f look on the jvmEntries line near the bottom of the file g otm install path websphere profiles default config cells APP SERVER gt Node01 Cell security xml where APP SERVER is your application server s host name i login to your APP server machine as the Oracle Transportation Management user Copyright 2001 2009 Oracle rights reserved 8 9 ii cd WAS INSTALL DIR lib where WAS INSTALL DIR is the directory where you installed the WebSphere Ap
78. C3 par where it lists all schemas Oracle Transportation Management application needs 7 Perform import on the source database You can do a FULL import if the export was a FULL export Alternatively you can do a schema import Oracle supplies a schema import parameter file imp GC3 par where it lists all schemas Oracle Transportation Management application needs Copyright 2001 2009 Oracle All rights reserved 10 5 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 Features Limitations e Can be used between different platforms and different operating systems e Oracle version in the destination environment must be equal or higher than that of source environment e Need to pre create an Oracle database in the destination environment Whole Oracle Transportation Management database copy If there are data in the source database that the client does not want to be copied to the destination database then data cleaning process should be carried out in the destination database after the import e take a long time to finish depending on the size of the database Domain Copy Oracle Transportation Ma
79. MESPACE ski RR ERR RA RO CC Pana n 9 2 DISTINGUISHED NAME ss jes iss Enn Ma a Reena Md E ea Exe Der AE E TRAE 9 3 LDAP AUTHENTICATION PROTOCOL tv pee eve e v et c d UC vU da Y CA a P PER 9 3 LDAP ENGRYPTIONZPROTOCOL SS LY 3 roues eee en eroi oerte trs rt d D a m E D of c e cat cai se n 9 3 EDAP AUTHENTICATION METHOD 2 x uer or dA Ep LA D DEA ERR SERA TUR aks 9 3 LDAP PROTOCOL VERSION 55 rre eed e m e ae e E Rv b dada tak vac rad RE Ehe UE E RA ca RC 9 4 EDAP DIRECTORIES 12 2 2 RR TERRE RR RR ERRRRQRRERRARTR S RRRRRRNRRRRRRRFRRRRRRRNRRASKRRSRRNRRNRFRRREURE MEE 9 4 ORGANIZING LDAP DIRECTORIES FOR ORACLE TRANSPORTATION MANAGEMENT 9 4 vi Copyright 2001 2009 Oracle All rights reserved LDAP AND THE ORACLE TRANSPORTATION MANAGEMENT LOGIN ern 9 4 CONFIGURING LDAP NAMESPACES ssnnnnnn mH RRRRRRRRRRRRRRRRRRRRRARARSARSARSASSSSSSSSSSRRRRRS 9 4 NAMESPACE ATTRIBUTES xerit e ate fite CO e e t CY Pl FR en te a f t n a af e 9 5 COMMON QUESTIONS a nha RRRRRRRERRRRRRRRRRRRRRRSRRRRRRARRRRRRERSRRARRRRARRRERRRERRERREERESARRRERRRRARREA 9 7 10 DATABASE ADMI NI 10 1 INI TI AL SETUP OF ORACLE DATABASE 10 1 INFTTAE PARAMETEBS redens i Rer E tu eaa Rat Rudi IET Rasa abr eo A nun ovo a e ci aani 10 1 USING LOCALLY
80. Management Follow the instructions in the Installing Oracle Transportation Management chapter to finish your Oracle Transportation Management installation You must run the installer as a non root user though root access will be required to run a script during the installation The user that runs the installer must have full rights to the installation directory AIX Installation Requirements It is HIGHLY recommended that you make available personnel who are familiar with the installation and configuration of UNIX based applications Also it is recommended that you have an administrator familiar with the creation and support of Oracle Database instances A Network Administrator may be necessary at times especially during the configuration of systems that will be accessed through firewalls VPN etc You must run the installer as a non root user though root access will be required to run a script during the installation The user that runs the installer must have full rights to the installation directory Note Sections that are specific to the type of Application Server being used are marked with OAS WebLogic or WebSphere Minimum Hardware Requirements Note this section only details the minimum hardware required to run the base Oracle Transportation Management application It does not take into account additional Oracle Transportation Management components or third party components and it is not a configuration for high volume or co
81. N HASH JOIN T OPTIMIZ 50 iR INDEX CACHING Setting this parameter to encourage optimizer to favor NESTED HASH JOIN STATISTICS LEVEL ALL ESTED LOOP over LOOP over Collect row source execution statistics and timed operating system statistics PGA AGGREGATE TARGET 209715200 200 MB This is the target of memory usage of work area and other data structure control information for server process When this parameter is set automatic memory management is turned on Oracle suggests for initial setting this parameter can be set to 0 16 total memory that this database can use If you set this parameter you should keep watching PGA usage and adjust it accordingly Don t set it too small It will affect query performance if too small If you don t set it default is unset with a value shown as 0 WORKAREA SIZE POLICY AUTO If PGA AGGREGATE TARGET is set MANUAL PGA AGGREGATE TARGET is not set You should really just leave this parameter to take default default value depends on PGA AGGREGAT E TARGET setting It is idea to set this parameter to MANUAL when PGA AGGREGATE TARGE or vise versa query rewrite enabled true For using function based index query rewrite integrity trusted For using function based index PROCESSES The not good is set For in
82. O enabled true gt lt ParamList gt lt Param name IMPERSONATE Source serverVariable nameInSource REMOTE USER ParamList LogoffUrl http O M W M W EBSERV ER LogoffUrl LogonUrl http lt O lt SSO gt lt Auth gt EBSERV Change the credentialstore xml ER LogonUrl a Open a command prompt window or command shell on the machine where Oracle Presentation Services has been installed b Navigate to the directory OBI EE Oracle BI web bin on Linux or UNIX This is the location for the CryptoTools utility EE Oracle BI web bin on Windows or OBI c ForLinux systems Setup the environment by running the following scripts OracleBI HOMI OracleBI HOMI E setup user sh E setup sa init sh d Execute the CryptoTools utility to add the impersonator user credentials to the Oracle BI Presentation Services Credential Store cryptotools credstor add infil OracleBIData web config credentialstore xml Credential Alias impersonation Username Impersonator Password secret you want to encrypt the password y n y Passphrase for encryption another secret you want to write the passphrase to the xml y n n File OBI EE Oracle BIData web config credentialstore xml exists Do you want to overwrite it y n y Navigat
83. ORACLE Oracle Transportation Management Administration Guide Release 5 5 Part No B28768 09 September 2009 Oracle Transportation Management Administration Guide Release 5 5 Part No B28768 09 Copyright 2001 2009 Oracle All rights reserved The Programs which include both the software and documentation contain proprietary information they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright patent and other intellectual and industrial property laws Reverse engineering disassembly or decompilation of the Programs except to the extent required to obtain interoperability with other independently created software or as specified by law is prohibited The information contained in this document is subject to change without notice If you find any problems in the documentation please report them to us in writing This document is not warranted to be error free Except as may be expressly permitted in your license agreement for these Programs no part of these Programs may be reproduced or transmitted in any form or by any means electronic or mechanical for any purpose If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government the following notice is applicable U S GOVERNMENT RIGHTS Programs software databases and related documentation and technical data delivere
84. OV Purged partition 2 for table IE MARKS Purged partition 2 for table IE SHIPMENTSTATUS Purged partition 2 for table IE SHIPMENT REFNUM Purged partition 2 for table IE SHIP GROUP REFNUM 8 28 Copyright 2001 2009 Oracle rights reserved Purged partition 2 for table IE SS EQUIPMENT Purged partition 2 for table IE SS REMARK Purged partition 2 for table IE SS STOP Purged partition 2 for table IE SS S EQUIPMENT Purged partition 2 for table IE S SHIP UNIT Purged partition 2 for table IE S SHIP UNIT LINE Purged partition 2 for table I LOG DETAIL Purged partition 2 for table I LOG Purged partition 2 for table I LOG DETAIL Purged partition 2 for table I TRANSACTION DETAIL Purged partition 2 for table PROBLEM Purged inbound i transaction records Purged inbound i transmission records PL SQL procedure successfully completed Default Units of Measure By default Oracle Transportation Management uses U S units of measure when saving data to the database To change what units of measure Oracle Transportation Management uses follow these steps 1 Run the following SQL statement to find out what the current storage default is for each UOM select TYPE UOM CODE UOM RANK IS STORAGE DEFAULT from UOM where IS STORAGE DEFAULT Y The current typical layout of the UOM table for an Orac
85. Oracle rights reserved monitor the performance statistics of OAS using general UNIX tools You can also get detailed performance statistics from the OAS console on the Performance tab WebLogic The Tomcat service starts up one and shows up as lt path gt java server Xms512m Unfortunately this can be hard to find if you have multiple J VMs running on the same machine Usually you can identify Tomcat by the amount of memory it is using as normal Tomcat instances use large amounts of memory typically 768MB to 2GB You can monitor the performance statistics of Tomcat using general UNIX tools The WebLogic service starts up one Java and shows up as lt path gt java server XX MaxPer differs slightly from the Tomcat instance Unfortunately this can be hard to find if you have multiple J VMs running on the same machine Usually you can identify WebLogic by the amount of memory it is using as normal WebLogic instances use large amounts of memory typically 512MB to 2GB You can monitor the performance statistics of WebLogic using general UNIX tools You can also get detailed performance statistics from the WebLogic console Follow the steps under the Monitoring Performance Windows section WebSphere The Tomcat service starts up one Java and shows up as lt path gt java Xlp Xms512m Unfortunately this can be hard to find if you have multiple JVMs running on the same machine Usu
86. Oracle All rights reserved 2 15 WebLogic WebLogic 8 1 with Service Pack 6 with an Advantage non clustered License Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services optional Integration Server EAI solution optional The following software is distributed with Oracle Transportation Management OAS Oracle Application Server 10 1 3 0 patches Apache Web Server 2 0 55 Tomcat J ava Servlet Server 5 5 16 OpenSSL 0 9 8a HP JDK 1 4 2 Python 2 4 2 Java Service Wrapper 3 1 2 zlib 1 2 3 The Oracle Transportation Management software is distributed on CD or via download from standard Oracle channels Preparing to Install Oracle Transportation Management Oracle Transportation Management requires the following software HP UX 11iv2 with latest HP Recommended Patch Bundle Oracle 10gR2 10 2 0 3 0 Client or the latest version of 11g optional for Web server required for Application server WebLogic WebLogic 8 1 with Service Pack 6 Application server only Oracle 10gR2 10 2 0 3 0 DB Server or the latest version of 11g DB server only Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services Report server only Oracle Transportation Management Application software Before you begin the installation process ensure that the following is complete HP UX 11iv2 has been installed on your server The size of the swap space on your server is equal to or greater than the amount of mem
87. RA REN enna MD REN C STER Dac DEN 8 21 TROUBLESHOOT WITH SQESERVIET tte emer va eet vd rae ene ev teria a het Ra eoe v EE ER Tat 8 22 MANUALLY PURGING TRANSMISSIONS FROM THE DATABASE 8 23 MANUALLY PURGE TRANSMISSIONS essen eee eese A naar arn ra rana 8 23 MANUALLY PURGE PROBLEM sense eee teen anna ran rana 8 25 PARTITIONED TABLES 2 243 28v a RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR RUPEE 8 25 RANGE PARTI TIONING zd dvd if iue eter sot Ec eri eS us n Ret et E md dasa dac i GP e t Pa Rie 8 25 ORACLE TRANSPORTATION MANAGEMENT PARTITIONED TABLES eene nnn 8 26 TRUNCATE J OBS FOR PARTITIONED TABLES e e t ey re n nx ere a ras n PRX XX RR dee des 8 28 DEFAULT UNITS OF 8 29 CHANGING CURRENCY SETTINGS 8 30 WHEN TO CHANGE CURRENCY STORAGE seme nasse een ann nn 8 30 ACCOUNTING FOR MISSING TI ME ZONES oo eee ehe nn nnn huh u uuu a aaa a3 au AG GU UR uu uu uu uu nu n 8 31 I NTERNATI ONAL CHARACTERS IN SQL PLUS WINDOWS nnnm
88. RENARRRRREEEUSERR RASSEERENMESNRREEERNER 8 5 ORACLE TRANSPORTATION MANAGEMENT USERS sseceeeeeeeee IIIa ases en n eene ann 8 5 APPLICATION SERVER USERS deuil wi aee dde acoso e eoa bw Pee Boc S ra d a c bec d de 8 7 ORACLE DATABASE USERS lente EAE ER MR TER D TEE DATE REIR MU ERA UE DEAS TEL UL DA RR 8 10 CLEEARTEXT PASSWORDS 5 5 eec RERO OD OCDE XC COELO CE RO CO eevee RC C T C C RD OCDE 8 12 CONFIGURING ORACLE TRANSPORTATION MANAGEMENT TO USE A DIFFERENT DATABASE 8 12 CREATING AND NSTALLI NG SSL CERTIFICATES eee ee hann uau hann nuu u aant 8 13 PAPA GAB 5349525 so basado actis comte tad dot taste etae ipei eus 8 13 ENABLE MOD 8 14 ENABLING AUTOMATIC WEB UI 8 14 ENABLING REVERSE PROXY SUPPORT 8 14 ENABLING SINGLE SIGN ON SSO 8 15 INSTALLING MULTI PLE ORACLE TRANSPORTATION MANAGEMENT NSTANCES ON THE
89. Server also provides administrative features such as configurable security management and application deployment tools and clustering to promote high availability and scalability You must purchase WebLogic Server version 8 1 with Service Pack 6 from Bea Systems Inc Once you have the appropriate license you can download the appropriate executables from the Bea website We recommend that you run this installer from the server console Launch server814 linux bin or platform814 linux bin to install WebLogic Accept the license agreement Enter opt bea as the BEA Home Choose Typical Installation Install WebLogic into opt bea weblogic81 Install your License file using the directions provided by BEA Important Note You must remove a file from the WebLogic installation because of a code conflict between it and the latest DBC drivers that Oracle Transportation Management ships with The simplest and safest way to do this is to rename the file The file in question is weblogic install path server lib odbcl4 jar rename it to be something like weblogic install path server lib odbcl4 jar bak where weblogic install path is whatever value was used in step 5 above Installing WebSphere on the Application Server WebSphere WebSphere is an application server a runtime environment that provides infrastructure services such as database access transaction coordinator and component framew
90. TED OPERATIONAL DATABASE FOR REPORTING AND ARCHIVING 3 25 REPLICATED OPERATIONAL DATABASE MAINTENANCE enema aaa nana 3 28 ARGHIVESS ETUD stays EEA ethane raa 3 28 4 INSTALLING FUSION TRANSPORTATION INTELLIGENCE 4 1 PREPARING ORACLE TRANSPORTATION MANAGEMENT DATABASE FOR TRANSPORTATION I NTEEEIGENGE 5 iiie cee cease uence saws Cec wescucuereceeuceccusbecades 4 1 OPERATIONAL aee aane aaa nnn 4 1 CREATE DATABASE USERS AND PACKAGES n nee nnn 4 1 MIGRATE HISTORICAL DATABASE HD 4 2 INSTALLING OBI EE ORACLE BUSINESS NTELLI GENCE ENTERPRISE EDITI ON 4 3 PRESINSTAEEATION SETUP sts te toa een d ert vos i oto e te ct n e a ea i wh ette 4 3 INSTALISOBI EE eee Saas Tana i dre rp Sc neta Dens M etas Der DOA Ane o DA eS 4 4 POST NSTALLATION SETUP irc RR E CX T CADO LOL ER ERR CLA CER CO EAR A T d 4 4 ORACLE TRANSPORTATION MANAGEMENT FTI PROPERTIES enun nunt 4 11 ENABLING FTI AGENTS IN ORACLE TRANSPORTATION MANAGEMENT ssss22ssss2222222222225 4 12 EINUX TASKS E T a E a A 4 12 MANDATORY ORACLE TRANSPORTATION MANAGEMENT USER ROLE VPD PROFILE CONFIGURATION 4 13 5 INSTALLING OPTIONAL
91. TO 4 0 7 1 UPGRADING FROM VERSION 4 0 4 5 7 3 UPGRADING FROM VERSION 4 5 5 0 7 7 APPLY GG3 4 5 SERVICE RELEASES ir sn cata eer er er aw e d et a Fe e aba wera a 7 7 MIGRATE GC3 4 5 DATABASE TO 5 0 eese rose e er ee tee re te xr e pedet emere sp tede ge cfl ipi ey dings 7 7 UPGRADING FROM VERSION 5 0 TO 5 5 7 11 G STOM HELP carre e eater tte EE e ate at ea 7 11 APPLY GC3 5 0 SERVICE RELEASES oen e c xxi de mri eb for e D or e n oa C PE RE cc P cd 7 12 MIGRATE 5 0 DATABASE 5 5 siis cede RA S Ub d ER ER a E MEN ARA 7 12 8 ADVANCED CONFI 8 1 APPLYING CONSOLIDATED UPDATES 8 1 BRANDING 555 tht Suae ER SIR see cn scene va Dnus pudo d uU von od ror Mer Deae
92. WNER REPORTOWNER group by object owner The result should be OBJECT OWNER COUNT GLOGOWNER 18552 REPORTOWNER 224 8 Run object_count sql For partitioned database the results should be OWNER ARCHIVE LOB SEQUENCE TABLE GLOGDEV TRIGGER GLOGLOAD TRIGGER GLOGOWNER FUNCTION INDEX INDEX PARTITION JAVA CLASS JAVA SOURCE LOB LOB SUBPARTITION PACKAGE PACKAGE BODY PROCEDURE QUEUE SEQUENCE TABLE 3 22 Copyright 2001 2009 Oracle All rights reserved TRIGGER REPORTOWNER INDEX PACKAGE PACKAGE BODY SEQUENCE TABLE TRIGGER For non partitioned database the results should be OWNER OBJ ECT_TYPE ARCHIVE LOB SEQUENCE TABLE GLOGDEV TRIGGER GLOGLOAD TRIGGER GLOGOWNER FUNCTION INDEX JAVA CLASS JAVA SOURCE LOB PACKAGE PACKAGE BODY PROCEDURE 1 Copyright 2001 2009 Oracle All rights reserved QUEUE SEQUENCE TABLE TRIGGER REPORTOWNER PACKAGE PACKAGE BODY SEQUENCE TABLE TRIGGER VIEW If your results differ from those shown above gather the log files generated from the import process and SQL scripts and f
93. aan hen ar eae sud ele ert cedet e A peg e Y nd 2 15 PREPARING TO INSTALL ORACLE TRANSPORTATION MANAGEMENT ccecceee cece cece ee ee ee ee nn nn nen nennen nens 2 16 ORACLE ENTERPRISE LINUX NSTALLATI ON REQUIREMENTS eene nonna nnn 2 19 FRED VAST DIN UX zorro cete Cr Pte eaa Fen v sr Ee bi eo QS twr auti E I s ns 2 19 MINIMUM HARDWARE REQUIREMENTS 2 19 SOFTWARE REQUIREMENTS 3 n E E E D E e E LP a aa E 2 20 PREPARING TO INSTALL ORACLE TRANSPORTATION MANAGEMENT iienh mH eme enema 2 20 3 INSTALLING ORACLE TRANSPORTATION MANAGEMENT 3 1 IMPORTANT NOTE REGARDING THIRD PARTY SOFTWARE s sssssnnuuuuuuusuuuRRRRRRRRRRRRRRRRRRR RR 3 1 RECOMMENDED INSTALLATION STEPS wsccccccnnceccceeeeenneseeeeeeenneneeeeeeenneneeeeeeeennaneeeeeeennnnnes 3 1 INSTALLING ORACLE TRANSPORTATION MANAGEMENT ON A SINGLE SERVER eee 3 2 INSTALLING ORACLE TRANSPORTATION MANAGEMENT ON THE APPLICATION SERVER 3 2 INSTALLING ORACLE TRANSPORTATION MANAGEMENT ON THE WEB 3 8 INSTALLING ORACLE TRANSPORTATION MANAGEMENT ON THE REPORTS 3 13 Copyright 2001 2009 Oracle rights reserved iii INSTALLING ORACLE TRANSPORTATION MANAGEMENT ON THE DATABASE SERVER 3 16 INSTALLING THE REPLICA
94. ach instance should be bound to a different IP address Please contact your Network or UNI X Administrators for more information on creating virtual addresses within a server iii WebSphere Oracle Transportation Management does not currently support running more than one WebSphere instance of Oracle Transportation Management on a single box b WebLogic only Enter the App Server SNMP Port usually 7161 WebLogic amp WebSphere only Enter the Application Server Home directory which is the directory you specified when installing WebLogic WebSphere e g opt bea BM WebSphere AppServer6 9 WebLogic only Enter the WebLogic Server Path which is the directory that you installed WebLogic into and is underneath the BEA home directory e g opt bea weblogic81 e Enter the Application Server memory in megabytes which is the amount of system memory that WebLogic WebSphere uses This default is 1025MB but may be higher depending on your configuration Note If this value is lower than 1025MB the Application server may not start Also please take into consideration whether the server will be used for Test Development or Production and what system resources are available f click Next 12 WebSphere or AI X only App Server Settings continued a Enter the number of logical CPUs in the server This is used to set a JVM performance parameter 13 App Server Settings continued a Enter the Oracle Transpor
95. acle Transportation Management Oracle Transportation Management requires the following software e Solaris 9 or 10 with latest Sun Recommended Patch Bundle e SUNWIZIib or GNU zlib package e Oracle 10gR2 10 2 0 3 0 Client or the latest version of 11g optional for Web server required for Application server e WebLogic WebLogic 8 1 with Service Pack 6 Application server only e Oracle 10gR2 10 2 0 3 0 DB Server or the latest version of 11g DB server only e Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services Report server only e Oracle Transportation Management Application software Before you begin the installation process ensure that the following is complete e Solaris 9 or 10 has been installed on your server e size of the swap space on your server is equal to or greater than the amount of memory it contains e All Oracle Transportation Management servers are time synced using a process like NTP This is critical to the proper operation and troubleshooting of an Oracle Transportation Management instance e Oracle 10gR2 10 2 0 3 0 Client Administrator install has been installed and configured to connect to your database Pre Install Setup Ensure that Solaris 9 or 10 and all of the latest patches are installed The latest Solaris recommended patch bundle could be downloaded from Sun at http sunsolve sun com After the latest Sun Recommended patches are installed you need to ins
96. acle Transportation Management User Manager refer to the online help for details Resetting Passwords Passwords in the Oracle Transportation Management database are encrypted and are not presented as clear text If you lose a password for a user and need to reset it you can log in as an Admin user for that domain and reset their password using the User Manager If the Admin user password is lost or if you want to reset more than one password you can do the following 1 Login to the application server machine as the Oracle Transportation Management user 2 Setup your environment by running otm install path2 install gc3env sh on UNIX or otm install path gt install gc3env cmd on Windows 3 cd to otm install path gt oracle script8 4 Run update password sh on UNIX or update password cmd on Windows with the following parameters update password sh glog properties path user password lt ifPasswords gt o properties path directory where glog properties is e g otm install path gt glog config o user one or more users separated by commas or all e g GUEST ADMI N SERVPROV ADMIN o password the new password o ifPasswords or more passwords to match against separated by commas or all For example update password sh opt otm 554 glog config GUEST ADMIN foobar all will change GUEST ADMIN s password to foobar regardless as to what it is currently set to u
97. aintenance directory f Repeat with next tar patch 7 Once the patches are installed install the pak patches one by one a copy the pak file into the updateinstaller maintenance directory e g opt I BM WebSphere AppServer6 updateinstaller maintenance b Run the update script e g opt IBM WebSphere AppServer6 updateinstaller update c Follow the onscreen directions When it s finished run it again Repeat until it tells you that there is nothing further to install e Remove the contents of the updateinstaller maintenance directory f Repeat with next pak patch Installing WebSphere AppClient on the Web Server WebSphere This only needs to be done for web only servers Servers where the Oracle Transportation Management web amp application pieces reside together should skip this step You must run this installer from an X display Uncompress and untar the was 6000 base aix tar gz file Copy the AppClient directory to the target machine Run AppClient install Accept the license agreement Install WebSphere into opt I BM WebSphere AppClient6 6 Install your License file using the directions provided by IBM Installing Oracle on the Database Server Please refer to standard 10g Oracle Installation Guide Installing Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services on the Report Server The system requirements and installation steps along with explanations of each
98. all Interface Data Source Name User Name Password Timeout Minutes Maximum Connections Bulk Fetch Buffer Siz Database Table for Jobs Database Table for Instances Database Table for Parameters Database Table for Messages DEFAULT VALUES Quit Enter 5 and press enter Enter hdowner as your password and hdowner again to confirm the ssword bytes Oracle 9i OCI 81 91 RPTAPP hdowner 60 J 33792 S NO JOB S NO INSTANCE S NO JOB PARAM S NO ERR MSG Scheduler Database Configuration S PRPRPR Database Call Interface Data Source Name User Name Password Timeout Minutes Maximum Connections Bulk Fetch Buffer Siz Database Table for Jobs Database Table for Instances Database Table for Messages DEFAULT VALUES bytes Database Table for Parameters Oracle 9i OCI 81 91 RPTAPP hdowner KKKKK 60 5 33792 S NO JOB S NO INSTANCE S NO JOB PARAM S NO ERR MSG 0 Quit Enter 0 and press enter answer yes when prompted to save Scheduler Configuration Database General Advanced Quit OWNER Select 0 and press enter Delivers Configuration Menu Configure Scheduler Configure Mail Configure iBots Configure Workflow Configure Java Extension OUFE
99. all_path gt websphere profiles default bin ulimit n 8096 su lt otm_user gt wsadmin sh serverl username system password lt ws_pwd gt conntype NONE f undeployGC3SS jacl wsadmin sh serverl username system password ws pwd conntype NONE f undeployGC3 jacl After each JACL script is run there should be a message indicating that the application was successfully uninstalled It is safe to ignore the following error websphere profiles default bin setupCmdLine sh line 35 ulimit open files cannot modify limit Operation not permitted 4 Deploy the application After each step ensure that there are no errors f cd otm install path websphere profiles default bin ulimit n 8096 su otm user wsadmin sh serverl username system password ws pwd conntype NONE javaoption Xms512m javaoption Xmx512m f deployGC3SS jacl wsadmin sh serverl username system password ws pwd conntype NONE javaoption Xms512m javaoption Xmx512m f deployGC3 jacl After each JACL script is run there should be a message indicating that the application was successfully installed It is safe to ignore the following error websphere profiles default bin setupCmdLine sh line 35 ulimit open files cannot modify limit Operation not permitted There are two shell scripts available to use to help automate this task They are located in otm install path2 websphere and are named un
100. ally you can identify Tomcat by the amount of memory it is using as normal Tomcat instances use large amounts of memory typically 768MB to 2GB You can monitor the performance statistics of Tomcat using general UNIX tools The WebSphere service starts up one and shows up as lt path gt java Xbootclasspath p Unfortunately this can be hard to find if you have multiple JVMs running on the same machine Usually you can identify WebSphere by the amount of memory it is using as normal WebSphere instances use large amounts of memory typically 512MB to 2GB You can monitor the performance statistics of WebSphere using general UNIX tools You can also get detailed performance statistics from the WebSphere console Purging Excess Reports from the REPORT LOG Table Purge Process for UNIX 1 Logon to the UNIX machine on which the Report server is installed 2 Run the shell script purgeRepLog sh The script prompts for the nine parameters that are listed later in this section Based on the parameters passed the script deletes the records from the database and deletes the PDF files Note The USERID used to logon to the UNIX machine should have delete permissions on the PDF files created by the report server Purge Process for Windows 1 Logon to the Windows machine on which the Report server is installed 2 Run the batch file purgeRepLog bat with the parameters that are list later in this section in the order specifie
101. already done so Alternatively UNIX users can install in console mode as described below 5 10 11 12 Run the installer to start the installation a UNIX otmv553_ lt platform gt bin b Win32 otmv553_win32 exe Note Oracle Transportation Management also supports CONSOLE MODE installation on Linux UNIX platforms only This allows you to install Oracle Transportation Management when a GUI console is not available or practical Run the following commands to launch the installer in this mode 5 stty erase H otmv553_ lt platform gt bin i console Note On UNIX Linux systems the Installer extracts to tmp and you will receive an error if there is not sufficient room there for the Installer to extract itself If you need to change this directory you must set the IATEMPDIR environment variable 5 export IATEMPDIR some other temp directory otmv553 platform bin Read the installation notice and click Next Read the Third Party Software notice and click Next Choose the installation directory e g opt otm or opt otm55 to denote version If you are installing more than one Oracle Transportation Management instance on a server each instance should be installed into a different directory Choose which Application Server you will be using Oracle Application Server OAS WebLogic or WebSphere a For Linux a choice is presented between OAS WebLogic amp WebSphere b For AIX a choice is presented between We
102. ame or DN see below for more detail on DNs This format contains name attributes like organization country organization unit etc Moreover these attributes are arranged hierarchically So there can be multiple organizational units within an organization and multiple organizations within a country The directory is searched and organized hierarchically Each name is associated with one or more directory objects These directory objects contain attributes that can be used for authentication for populating databases for applications or any other number of uses Because of the focus on clients the LDAP community also defined standards for the string representation of DNs RFC 1779 search filters RFC 1960 and attribute syntaxes RFC 1778 fora C language based API RFC 1823 and for the format of URLs for accessing LDAP services RFC 1959 LDAP Schema A directory schema specifies among other things the types of objects that a directory may have and the mandatory and optional attributes that each type of object may have LDAP version 3 defines a schema RFC 2252 and RFC 2256 based on the X 500 standard The schema includes common objects found in networks such as countries localities organizations users persons groups and devices It also defines a way for a client application to access the server s schema so that it can find out the types of objects and attributes that a particular server supports The LDAP schema has
103. an from within SQL Plus Two command scripts have been provided the script you use is dependent on your operating system UNI X shell script update procure content sh otm install path glog config V50A or DOS command script update procure content otm install path NglogNconfig V50A Review the log file called update procure content v50A timestamp log for errors located in the same directory as the SQL script Look for errors by searching key words like ORA Caught exception SP2 within the log file Migrate to 5 0 LA Data Migration 1 2 3 In SQL Plus as GLOGOWNER run Qdbmigrate 50a sql Enter the password and database connect string when prompted Note The script might run for several hours depending on the amount of data to process After the process has run verify in the dbmigrate 50a lt gt timestamp log file located in the same directory as the SQL script that there are no errors If an error occurs during a migration patch the database changes roll back It will however commit changes once a whole migration patch has been successfully applied and it will not try to migrate the data associated with that patch again If an error occurs partway through the process then you can fix the problem and rerun the process without harm If you cannot resolve the error yourself contact Technical Support 7 8 Copyright 2001 2009 Oracle rights reserved Migrate to 5
104. anagement database DBA should monitor these jobs regularly Real Application Clusters RAC Oracle Transportation Management may be used in conjunction with RAC by making the following changes to the lt otm_install_path gt glog config glog properties file Comment out the lines starting with the following by putting a at the front of the line dbserver glog database sid glog database connectstring glog database port Add the following lines right after the above section Any text in bold needs to be supplied with a valid value each block of code is actually one single line there should be no line breaks glog database dbaOnly t2client connectionURL jdbc oracle thin DESCRIP TION ADDRESS_LIST LOAD_BALANCE ON ADDRESS PROTOCOL TCP HOST DB_FQD HOST 1 NAME PORT DB PORT ADDRESS PROTOCOL TCP HOST DB_FQDN_HOST_ 2 NAME PORT DB PORT CONNECT DATA service name SERVICE NAME glog database dbathin t2client connectionURL glog database dbaOnly t2c lient connectionURL glog database DBA t2client connectionURL glog database dbaOnly t2clien t connectionURL glog database DBADirect t2client connectionURL glog database dbaOnly t 2client connectionURL glog database migration t2client connectionURL glog database dbaOnly t 2client connectionURL glog database dbathin t2client connectionURL glog database dbaOnly t2c lient connectionURL Copy
105. anagement Web Server Stop the Tomcat service e g otmtomcat on the Oracle Transportation Management Web Server Stop the Oracle Transportation Management App service e g otmapp on the Oracle Transportation Management Application server On the Reports Server stop the Oracle Transportation Management Rpt Web service e g named otmrptweb if necessary On the Reports server stop Oracle Reports if necessary Stop the Oracle database if necessary If you are going to restart Oracle Transportation Management wait one minute between stopping and restarting the servers This gives WebLogic the time it needs to fully shut down Stopping the UNIX Server 1 2 e Stop the Oracle Transportation Management Web daemon e g etc init d otmweb stop on the Oracle Transportation Management Web Server Stop the Oracle Transportation Management App daemon e g etc init d otmapp stop on the Oracle Transportation Management Application server On the Reports Server stop the Oracle Transportation Management Rpt Web daemon e g etc init d otmrptweb stop if necessary On the Reports server stop Oracle Reports if necessary Stop the Oracle database if necessary If you are going to restart Oracle Transportation Management wait one minute between stopping and restarting the servers This gives WebLogic the time it needs to fully shut down Creating Domains An Oracle Transportation Management domain is a unique nam
106. ansportation Management to encrypt the communication between Oracle Transportation Management and the LDAP server LDAP Authentication Method Oracle Transportation Management uses two major methods of authentication Local authentication involves searching for a name object in the directory and extracting some attributes These attributes are in turn used to authenticate the name Most commonly the password attribute is used to validate entries It s called local authentication because the validation is performed locally by the client The client logs into the LDAP directory as a sort of super user called the Principal The principal user is used to look up all other users in the directory Oracle Transportation Management can also authenticate users by attempting to directly connect to the directory as the user in question instead of connecting as a Principal user and then performing a lookup This allows the LDAP directory to perform the authentication at the LDAP server It s called External authentication because the authentication is performed externally to the LDAP client This method insures that sensitive authentication information such as certificates or passwords never leaves the LDAP server In the LDAP world this method of authentication is often called binding to the server Copyright 2001 2009 Oracle All rights reserved 9 3 LDAP Protocol Version LDAP is a TCP IP based protocol and this protocol has
107. apache bin envvars apr config prefix opt otm55 apache apr config exec prefix opt otm55 apache apr config datadir opt otm55 apache apr config includedir opt otm55 apache include apu config prefix opt otm55 apache apu config exec prefix opt otm55 apache apu config includedir opt otm55 apache include apxs my Sinstallbuilddir opt otm55 apache build envvars LD_LIBRARY_PATH opt otm55 apache lib LD_LIBRARY_PATH envvars std LD LIBRARY PATH opt otm55 apache lib LD LIBRARY PATH rotatelogs sh cd opt otm55 apache bin 6 The first entry that needs to be modified is in the apachectl file Before it is modified it looked like this HTTPD opt otm55 apache bin httpd d opt otm55 apache 7 Once it has been modified it should look like this HTTPD opt oraclebi apache bin httpd d opt oraclebi apache Note It is recommended to document all of the changes you are making for future troubleshooting of potential configuration issues 8 Change directory to OBI EE apache conf a Modify the httpd conf file with the location of your OracleBI directory from the old location to the new OBI EE directory ServerRoot opt oraclebi apache PidFile opt oraclebi logs apache httpd pid ErrorLog opt oraclebi logs apache error log CustomLog opt oraclebi apache bin rotatelogs sh opt oraclebi logs apache access log 86400 combined CustomLog opt oraclebi logs apache deflate log defla
108. arate partitions to keep them from filling up your primary partition In order to do this just create the Oracle Transportation Management installation directory and mounted partitions before installation Some recommended directories are e lt install path2 logs Web and App Servers This is the directory that all logs are created under including user created logs and it can grow very quickly e otm install path2 temp upload Web Server This is the directory that uploaded files get placed in prior to processing The growth will vary based on your product usage e lt install path2 rptapache htdocs Report Server This is the directory that scheduled reports will get placed into The growth will vary based on your product usage Note If you are upgrading an existing Oracle Transportation Management installation to Oracle Transportation Management 5 5 please take a moment to read about the following changes first implemented in GC3 5 0 e startup scripts and procedure has changed Please read the Starting and Stopping the Oracle Transportation Management Servers section of the chapter Starting Oracle Transportation Management after nstallation I s Complete for more details e The console output for java processes no longer goes to the nohup out files Instead it goes to the console log files under otm install path logs tomcat and otm install path logs weblogic directories These log files automaticall
109. bLogic amp WebSphere For all other platforms a choice is presented between OAS amp WebLogic Choose Rpt Server to install the Reports Server only and click Next Read the instructions for filling out the required data and click Next General Settings a Enter the Web Server External Fully Qualified Domain Name e g otmweb oracle com This would work if otmweb is the server name and oracle com is the domain name If your site were accessed through a load balancer or NAT device this would be the external URL outside your network If not then this would be the URL to your web server from within your network b Enter the Web Server External Port usually 80 If your site was accessed through a load balancer or NAT device this is the external port If not then this is the port on your web server Copyright 2001 2009 Oracle rights reserved 3 13 13 14 15 16 17 3 14 f Enter the Fully Qualified Domain Name of your Web Server This may or may not be the same as the Web Server External URL Please contact your Network Administrator if you have any concerns about this Enter the Web Server Port usually 80 Enter the Fully Qualified Domain Name of your Application Server which is the name of your server and the domain name e g otmapp oracle com click Next General Settings continued a b f Enter the App Server Port OAS 23791 WebLogic 7001 WebSphere 2809 E
110. bLogic console May not be deleted In order to change the system user s password do the following 1 Login to Oracle Transportation Management as DBA ADMIN and use the Oracle Transportation Management User Manager to change the password for the system user refer to the online help for details 8 8 Copyright 2001 2009 Oracle All rights reserved 2 On the application server edit the file lt otm_install_ path gt weblogic config gc3domain weblogic conf at the top of the file is a line that looks like this set WL_PW CHANGEME Change it to the value of the new password Login to the application server machine as the Oracle Transportation Management user pg gu dm 9 Setup your environment by running otm install path2 install gc3env sh on UNIX or otm install path gt install gc3env cmd on Windows 7 Run the following command java glog util appclass Base64Encoding new password 8 This will return the encoded value for your new password 9 On the Oracle Transportation Management web server s edit the file otm install path tomcat bin tomcat conf search for the string DGC3EncodedPassword and change the value of this to the results of the previous step 10 Restart Oracle Transportation Management WebSphere WebSphere creates no new users on its own relying on the users Oracle Transportation Management creates User ID Default Password Notes system CH
111. be executed as the user who submits it sqlplus gt execute pkg purge dba install a number This job will be executed as DBA The number represents a number of 30 minute periods For example 1 represents 30 minutes between job executions and 3 represents 90 minutes between job executions The pkg purge package could become invalid after having patched Oracle Transportation Management In that case you can just re schedule the job 6 Monitor the progress sqlplus gt select count 1 from job queue Copyright 2001 2009 Oracle rights reserved 8 21 The count should decrease quickly by hundreds of records typical speed is 4000 5000 business records per hour 7 Look in the i_log table for any error messages as well as start and end times of the purge Troubleshoot with SQLServlet After you have submitted your shipment order purge job in the process manager within Oracle Transportation Management you should receive an email The script moves all GIDs to the job queue table After 30 minutes or whatever job interval you have chosen you should notice that the total number of rows in the job_ queue table has decreased If not the following question and answer section helps you to diagnose the problem These answers assume that you can use the SQLServlet Question How do know when my purging will start Answer Submit the following select last date next date from dba jobs where job 1 The time u
112. become one of the basic ways that different LDAP directories can interoperate Corporations use the schema to store user profile organization contact and location information Oracle Transportation Management relies on the username and for local authentication password attributes Currently Oracle Transportation Management requires that the username be part of the distinguished name and requires that the gluser attribute be added to each user object LDAP in Oracle Transportation Management LDAP is used by Oracle Transportation Management to allow users to log into Oracle Transportation Management using standardized LDAP names instead of or in addition to Oracle Transportation Management usernames Oracle Transportation Management allows authentication to be performed by a remote LDAP server a more secure more centralized approach Corporate users can securely log onto Oracle Transportation Management with the LDAP login names that they are used to and use everyday Copyright 2001 2009 Oracle rights reserved 9 1 Oracle Transportation Management allows the LDAP users to be mapped to Oracle Transportation Management users in the LDAP directory itself This way Oracle Transportation Management permits a single Oracle Transportation Management user to be mapped to multiple LDAP users This allows a generic Oracle Transportation Management user such as GUEST GUEST may have primarily read only access to limited informat
113. bjects are under schema GLOGOWNER Oracle Transportation Management database object types include but not limited to TABLE TABLE PARTITION INDEX INDEX PARTITION LOB SUBPARTITION PACKAGI PACKAGE BODY PROCEDURE FUNCTION JAVA CLASS JAVA SOURCI Lu FI Lu Copyright 2001 2009 Oracle rights reserved 10 3 QUE TYP AG Each Oracle Transportation Management application table has a primary key There are many foreign keys in Oracle Transportation Management database to guarantee data integrity Certain database maintenance work such as import may cause foreign keys NOT VALIDATED The DBA should make sure the status of the foreign keys are ENABLED and VALIDATED Each application table also has a footprint trigger that populates footprint columns of the table All of the triggers should be ENABLED Analyzing Tables Gathering Statistics The Oracle Transportation Management database performs best when Optimizer statistics are gathered using scripts provided by Oracle Transportation Management Oracle Transportation Management scripts gathers statistics by performing full compute for all the objects including indexes columns with histograms partitions etc Oracle also has automatic statistics gathering job GATHER STATS JOB which is enabled by default when a database is created or when a database is upgraded from a
114. bles and Columns When a table or column becomes obsolete during an upgrade the table column is renamed with XX lt version object became obsolete original name of table column gt To generate SQL for dropping obsolete objects run gen_obsolete_objects sql as GLOGOWNER Note it will not include objects that just became obsolete in the current version as a safety precaution This script will generate an SQL script called drop obsolete objects sgl which you can review and run at a convenient time Verifying Saved Queries After the upgrade some of your site s saved queries may no longer be valid due to changes in table structure Run the following to verify the saved queries Qvalidate saved If there are invalid saved queries you can decide what to do with them remove the records or modify them to correct the syntax Contact Technical Support if you need assistance Upgrading from Version 4 0 to 4 5 Any new Oracle Transportation Management installation should be tested in a controlled environment before migrating your production database This ensures that any potential problems or incompatibilities don t affect your production Oracle Transportation Management instance s Note If you are migrating from a version earlier than 4 0 you must complete each previous version s migration instructions You cannot skip any migration steps Please go through all upgrade steps to 4 0 prior to starting the 4 0 to 4 5 migrat
115. ce The replicated online database ROD instance of Oracle Transportation Management is the ideal database You may decide to use the Oracle Transportation Management operational instance however this may have performance implications If you choose to use ROD on Oracle Transportation Management operational instance replace ROD below with operational database Preparing Oracle Transportation Management Database for Transportation Intelligence Operational Database Log on to the Oracle Transportation Management OLTP database as glogowner Run the following script from the directory lt otm_install_path gt glog oracle script8 advanced_analytics directory load_status_script sql This script loads the new READY_TO_LOAD status to all shipments order bases and order releases in Oracle Transportation Management This may take time depending on how many business objects are in the database This also loads the status of NOT READY TO LOAD for these objects Create Database Users and Packages ROD Database 1 Log in to the database as sys 2 Run the following script from a SQL prompt otm install path NVglogNoracleNscript8Nadvanced analyticsNcreate aa _ all sql e Enter your Connection 10 to the database when prompted This will be the SID of either your ROD database or the Optional Operational Database e Enter your database system user password when prompted e Enter your database glogowner user password when prompted e Enter
116. ck Next after entering Oracle Home name and path 8 Enter the oracle user s group usually dba 9 Choose your language usually English 10 Specify an Instance Name unique identifier for the Reports instance usually a hostname admin password The ias admin password will be used to manage the Oracle Reports server 11 Enter the FQDN of an SMTP mail relay server 12 Click Install on the Summary screen 13 Monitor the installation process 14 Write down the Oracle HTTP Server URL usually nttp servername 7777 and Oracle Enterprise Manager Application Server Control URL usually http lt servername gt 1810 The OEM AS url is used to stop and start the Oracle Reports Server 15 Click Exit after the installation process completes Installing Oracle Transportation Management Follow the instructions in the Installing Oracle Transportation Management chapter to finish your Oracle Transportation Management installation You must run the installer as a non root user though root access will be required to run a script during the installation The user that runs the installer must have full rights to the installation directory HP UX Installation Requirements It is HIGHLY recommended that you make available personnel who are familiar with the installation and configuration of UNI X based applications Also it is recommended that you have an administrator familiar with the creation and support of Oracle Database in
117. cle AS 10gR2 FR installation are documented within either the web based or Adobe Acrobat PDF files on Disk 1 of the Oracle AS 10gR2 FR installation CD package Please read the requirements and installation instructions fully before installing the Oracle AS 10gR2 FR Software Copyright 2001 2009 Oracle rights reserved 2 23 The instructions listed below should be used in conjunction with those supplied by Oracle as there are certain sections within the AS that are not utilized by Oracle Transportation Management at this time Please refer to the Oracle documentation as they are far more complete and contain in depth explanations of all installation options det a 11 12 13 14 15 Create an oracle user and assign it to the DBA group The installer should be run as this user Insert Disk1 of the Oracle AS 10gR2 FR install package Run runi nstaller Ensure your system passes the Installation Requirements Check Review the Welcome screen and click Next At the Destination Oracle Home and Oracle Home Name Screen please enter in the Oracle Home Name i e FR HOME 5 HOME etc and the path to the new Oracle Home i e u01 app oracle product reports109g Note Do NOT install the Oracle AS 10gR2 FR software to an existing Oracle Home This may cause any existing Oracle products including databases to become inoperable Click Next after entering Oracle Home name and path Enter the oracle user s group usua
118. d Based on the parameters passed the script deletes the records from the database and deletes the PDF files Copyright 2001 2009 Oracle rights reserved 8 19 Parameters These parameters should be passed to the procedure in the order listed below e Start Date this is the starting date from which the records are to be purged can be used to imply all dates Default value is NULL The format for the field is DD MON YYYY e Date this date is to date till which the records are to be purged can be used to imply all dates Default value is NULL The format for the field is DD MON YYYY e Domain Name Domain name for which the records and files are to be purged indicates all domains Default value is NULL GL User GL User ID for which the records and files are to be purged can be used to indicate all users Default value is NULL e Report GID the Report GID for which the records and files are to be purged indicates all the Report GIDs Default value is NULL e Job Number Job Number for which the records and files are to be purged indicates all the job numbers Default value is NULL e DB User Name the database user name e DB Password the database password e Connect string the database SID or the connect string Default value is the value of the environment variable ORACLE_SID Diagnose Purging Problems for Shipments and Orders Most likely the reason for your problem is o
119. d otm and set a password for otm user xx ge iE Assign the otm user to the otm group Installing Oracle Application Server OAS on the Application Server OAS The necessary files will be installed as part of the Oracle Transportation Management installation no further work is needed Installing WebLogic on the Application Server WebLogic WebLogic Server is an application server a runtime environment that provides infrastructure services such as database access transaction coordinator and component framework for distributed applications WebLogic Server also provides administrative features such as configurable security management and application deployment tools You must purchase WebLogic Server version 8 1 with Service Pack 6 from Bea Systems Inc Once you have the appropriate license you can download the appropriate executables from the Bea website We recommend that you run this installer from the server console 1 Launch server814 solaris bin or platform814 solaris bin to install WebLogic Copyright 2001 2009 Oracle rights reserved 2 7 Accept the license agreement Enter opt bea as the BEA Home Choose Typical Installation Install WebLogic into opt bea weblogic81 Install your License file using the directions provided by BEA IS Important Note You must remove a file from the WebLogic installation because of a code conflict between it and the latest DBC drivers that
120. d be placed based upon the INSERT DATE This adds to flexibility in how the tables are segmented For integration related partitioned tables each table has been defined as a quarterly a monthly or a weekly table The frequency to which the table has been associated drives how the partitions are populated and also the frequency of the purge Each of these tables has four partitions except for transaction and transmission which have eight to differentiate between inbound and outbound transmissions Quarterly Monthly Weekly EXPLANATI ON TRANSACTION outbound GL LOGIN HISTORY TRANSMISSION outbound IE INROUTE SERVPROV IE MARKS IE SHIPMENTSTATUS IE SHIPMENT REFNUM IE SHIP GROUP REFNUM IE SS EQUIPMENT IE SS REMARK IE SS STOP IE SS S EQUIPMENT IE S SHIP UNIT IE S SHIP UNIT LINE LOG I LOG DETAIL TRANSACTION DETAIL PROBLEM TRANSACTION inbound TRANSMISSION inbound 8 26 Copyright 2001 2009 Oracle rights reserved Here is how it works If the table is defined as quarterly then one quarter will go into each partition In other words Quarter Partition Jan Mar partition 1 Apr Jun partition 2 Jul Sep partition 3 Oct Dec partition 4 If the table is monthly then the data is segmented as follows Month Partition partition 1 partition 2 partition 3 partition
121. d to U S Government customers are commercial computer software or commercial technical data pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the Programs including documentation and technical data shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement and to the extent applicable the additional rights set forth in FAR 52 227 19 Commercial Computer Software Restricted Rights J une 1987 Oracle USA Inc 500 Oracle Parkway Redwood City CA 94065 The Programs are not intended for use in any nuclear aviation mass transit medical or other inherently dangerous applications It shall be the licensee s responsibility to take all appropriate failsafe backup redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes and we disclaim liability for any damages caused by such use of the Programs The Programs may provide links to Web sites and access to content products and services from third parties Oracle is not responsible for the availability of or any content provided on third party Web sites You bear all risks associated with the use of such content If you choose to purchase any products or services from a third party the relationship is directly between you and the third party Oracle is not responsible f
122. dardManager pathname gt Context Host lt Engine gt lt Service gt lt Server gt Change the IP address to the IP address of the server that OBI has been installed on and the location of the docBase to the location of your OBI EE web app You may also need to change the listen port 8009 or the shutdown port 8005 if you are running OBI EE on the same physical server that you have Oracle Transportation Management web server installed These ports will have already been used by the Oracle Transportation Management Tomcat processes Oracle Transportation Management installer does not include an Apache please copy the apache folder from your Oracle Transportation Management 5 5 installation over to the OBI EE directory Change directory to OBI EE apache bin You will need to modify all files that have the old location of your Apache directory to the new Apache directory You can determine the files that need to be changed using the grep command For instance if the directory you copied Apache from was home otm55 apache you could use grep to look for all files in the OBI EE apache bin directory using the following command grep otm55 The following files and corresponding entries should be returned Copyright 2001 2009 Oracle All rights reserved 4 5 apachect1 HTTPD opt otm55 apache bin httpd d opt otm55 apache apachectl if test f opt otm55 apache bin envvars then apachectl opt otm55
123. denote version If you are installing more than one Oracle Transportation Management instance on a server each instance should be installed into a different directory Choose which Application Server you will be using Oracle Application Server OAS WebLogic or WebSphere a For Linux a choice is presented between OAS WebLogic amp WebSphere b For AIX a choice is presented between WebLogic amp WebSphere For all other platforms a choice is presented between OAS amp WebLogic Choose App Server to install the Application Server only and click Next Read the instructions for filling out the required data and click Next General Settings a Enter the Web Server External Fully Qualified Domain Name e g otmweb oracle com This would work if otmweb is the server name and oracle com is the domain name If your site were accessed through a load balancer or NAT device this would be the external URL outside your network If not then this would be the FQDN of your web server from within your network b Enter the Web Server External Port usually 80 If your site were accessed through a load balancer or NAT device this is the external port If not then this is the port on your web server c Enter the Web Server Fully Qualified Domain Name This may or may not be the same as the Web Server External FQDN Please contact your Network Administrator if you have any questions about this Enter the Web Server Port usually 80 Enter
124. deployOTM sh and deployOTM sh Startup Scripts UNIX Only The startup scripts are copied to etc rc local on AIX sbin init d on HP UX and etc init d on Linux and Solaris The default names are shown below but may differ depending on what names you specified in the installer otmapp55 Oracle Transportation Management Application Server Property Files on the Oracle Transportation Management Application Server e glog properties otm install path gt glog config WebLogic only e config xml template otm install path gt weblogic config gc3domain e weblogic sh weblogic bat otm install path gt weblogic config gc3domain e weblogic conf otm install path gt weblogic config gc3domain Log Files on the Oracle Transportation Management Application Server e glog app log otm install path2 logs automatically rotates Oracle Application Server OAS only Copyright 2001 2009 Oracle rights reserved 3 7 e console log otm install path2 logs oas does not rotate WebLogic only e weblogic log otm install path gt logs weblogic automatically rotates e wl domain log otm install path gt logs weblogic automatically rotates e console log otm install path gt logs weblogic automatically rotates WebSphere only e console out log otm install path gt logs websphere automatically rotates e console err log otm install path gt logs websphere automatically rotates Install
125. e profiles default bin deployGC3SS jacl WebSphere otm install path gt websphere profiles default bin undeployGC3 jacl WebSphere otm install path gt websphere profiles default bin undeployGC3SS In addition the following two files have passwords that can be easily decrypted WebSphere otm install path2 websphere profiles default config cells APP SERVER NodeO1Cell nod es APP SERVER NodeO l servers serverl server xml where APP SERVER is your application server s host name WebSphere otm install path2 websphere profiles default config cells APP SERVER NodeO1Cell security xml where APP SERVER is your application server s host name Configuring Oracle Transportation Management to use a Different Database At some point you may need to point your Oracle Transportation Management instance to another database for testing development or fail over purposes Follow the directions below to configure Oracle Transportation Management to use this new database It is assumed that the new Oracle Transportation Management database has already been created and populated with data using the database installation directions earlier in this manual The database should also be at the same patch level as your Oracle Transportation Management instance to prevent any incompatibility problems 1 2 8 12 Shutdown your Oracle Transportation Management Web and Application servers as described earlier in this guide
126. e Database Links 1 The two databases now need to see each other so that the ROD can be refreshed from the OLTP and logging information from the ROD can be written back to the OLTP Visibility will be accessed through database links Run the following scripts you will be immediately reconnected as GLOGOWNER on the appropriate database OLTP or ROD once you have entered the proper parameters so who you are initially connected as is not a concern Qcreate dblink rod to oltp sql 2 You should see SUCCESS in the feedback after the creation of each link as it is tested If you see an error then do not continue until this step is successful as the next steps rely on the links Note If you change the passwords for your databases rerun the database link creation scripts so that the links use the correct passwords Otherwise use of the links will produce an Invalid username password error Initialize the ROD database 1 To populate the ROD run the following step create_rod sql It will connect as GLOGOWNER and create and populate the materialized views This step will take several hours or days depending upon the size of your OLTP database and the parallelism number you choose Once the ROD is initially set up it will be updated incrementally through the use of the logs This will prompt you for e the ROD connection string e parallelism you want to set for the refresh group This defaults to null meaning proces
127. e Oracle Transportation Management Reports Server e access log otm install path gt logs rptapache may grow quickly e error log otm install path gt logs rptapache e rwserver log u01 app oracle product reports10g reports logs rep REPORTS 5 gt Installing Oracle Transportation Management on the Database Server You should have your Database Administrator install the Oracle database and fine tune it for performance Once Oracle is installed follow these steps to complete the process These steps outline the procedures to set up an Oracle database for Oracle Transportation Management It requires that Oracle database server 10gR2 be installed including Oracle Database 10g Product from 10g companion CD It also requires the database server be patched to 10 2 0 3 0 and an Oracle database be created Please note that the Oracle Transportation Management database scripts are located under otm install path gt glog oracle script8 on the Oracle Transportation Management Application server Requirements Oracle Version 10 2 0 3 0 Enterprise Edition Oracle Options Jserver Accelerator Partitioning optional strongly recommended Oracle Instance Character Set UTF8 3 16 Copyright 2001 2009 Oracle rights reserved Initial Parameters The following initial parameters should be set O7_DICTIONARY_ACCESSIBILITY true Open_cursors 200 or greater Please refer to the init ora file in otm install pa
128. e Transportation Management software Win32 change into otm install gt instead 2 Create a RSA private key for your Apache server it will be Triple DES encrypted and PEM formatted openssl genrsa des3 out server key 1024 3 Enter your PEM pass phrase This will be a password that you create Make a backup copy of the server key and remember your pass phrase you will need it You can see the details of the RSA private key with this command openssl rsa noout text in server key 4 You can also create a decrypted PEM version of the RSA private key with this command openssl rsa in server key out server key unsecur 5 Create a Certificate Signing Request CSR with the server RSA private key output will be in PEM formatted openssl req new key server key out server csr config openssl cnf 6 Please answer all of the questions to the best of your ability especially the common name your company s domain name Copyright 2001 2009 Oracle rights reserved 8 13 7 You can view the details of your CSR this command openssl req noout text in server csr 8 You now have to send this Certificate Signing Request CSR to a Certifying Authority CA for signing The result is then a real Certificate which can be used for Apache You now need to transfer the CSR to a commercial CA like Verisign or Thawte Usually you will need to post the CSR into a web form pay for the signing a
129. e WebSphere console Open a web browser and go to https appserver name 9043 ibm console where appserver name is the FQDN of 8 2 Copyright 2001 2009 Oracle rights reserved your Oracle Transportation Management Application server You need to login as system with the password you setup when installing WebSphere Refer to your WebSphere documentation or http publib boulder ibm com infocenter wasinfo v6r0 index jsp Changing Database Pool Size As your server load varies you may need to change the number of connections in the database pool This may increase the performance of your Oracle Transportation Management instance To determine if you have a database connection bottleneck follow the instructions provided under the section Monitoring Performance After making any database pool changes you may need to stop and restart Oracle Transportation Management as described in the chapter Starting Oracle Transportation Management after Installation 15 Complete Also before you change your pool size consult a qualified Oracle DBA and ensure that your database can handle the new number of connections If you set your pool connections higher than your database can support Oracle Transportation Management will not be able to startup and function correctly The instructions below describe how to make these changes 1 Log into your Oracle Transportation Management system http lt otm_webserver_name gt as the user DBA
130. e completed for a successful installation 29 There are additional libraries that are required in order for Oracle Transportation Management to work properly Please view the README TXT file for information on where to obtain and install these additional libraries 30 Win32 Only When finished you must restart your entire server before attempting to start Oracle Transportation Management 31 Apply the latest Oracle Transportation Management consolidated update before starting up your server Contact Technical Support for information and assistance IMPORTANT NOTE FOR WebSphere ONLY After installing Oracle Transportation Management you must deploy the application properly within WebSphere To do that please do the following 1 Login to the Application server as root 2 Execute the following commands initially as root then as the user that Oracle Transportation Management runs as In all cases a otm install path is the name of the directory where Oracle Transportation Management was installed to b otm user is the account that Oracle Transportation Management runs as lt ws_pwd gt password for system WebSphere user default CHANGEME 3 6 Copyright 2001 2009 Oracle rights reserved 3 Undeploy the application Note you must do this even if it s the first install of Oracle Transportation Management on this server After each step ensure that there are no errors cd lt otm_inst
131. e that typically identifies a company The purpose of a domain is to provide the ability to keep company data separate and secure from other company data in a shared web based environment For example if you are using Oracle Transportation Management in an environment where many companies may be using the same Oracle Copyright 2001 2009 Oracle rights reserved 6 3 Transportation Management installation the domain allows you to isolate data in Oracle Transportation Management for each company Therefore many users from different companies can work in the same Oracle Transportation Management installation or website and use data that is private and specific to their company Data that is considered sharable is stored in a domain called PUBLIC allowing access to users regardless of their company The data that is used for the Ask Oracle Transportation Management wizards is considered public since it is not proprietary to any one company GUEST and SERVPROV Domains The GUEST and SERVPROV are automatically created when you install Oracle Transportation Management These domains are used as follows e GUEST This is a sample domain that you can use to get started using Oracle Transportation Management and experiment with all of the software functionality and data e SERVPROV This is a special domain for use with service providers Special logic is built into Oracle Transportation Management to provide security for service provider
132. e to the directory OBI EE Oracle Bl server bin and execute the schconfig script in 10 1 3 3 the directory is OBI EE server Bin Copyright c 1997 2006 Oracle Corporation All rights reserved Delivers Configuration Menu Configure Mail Configure iBots Configure Workf Configure Java Quit Configure Scheduler low Enter 1 and press enter Extension Copyright 2001 2009 Oracle All rights reserved Scheduler Configuration OWNER KKKKK Database General Advanced Quit Enter 1 and press enter Scheduler Database Configuration 1 Database Type 2 Call Interface 3 Data Source Name 4 User Name 5 Password 6 Timeout Minutes 7 Maximum Connections 8 Bulk Fetch Buffer Size bytes 9 Database Table for Jobs 10 Database Table for Instances 11 Database Table for Parameters 12 Database Table for Messages 13 DEFAULT VALUES 0 Quit Enter 1 and press enter CEST Database AFERE 01 Oracle 8i 02 Oracle 91 03 Oracle 10g R1 04 Oracle 10g R2 05 DB2 05 390 V7 06 DB2 05 390 V8 07 DB2 UDB V7 08 DB2 UDB V8 Enter 02 and press enter in 10 1 3 3 Scheduler Database Configuration 1 Database Type 2 Call Interface 3 Data Source Name 4 User Name 5 Password 6 Timeout Minutes 7 Maxim
133. e v v e Va A AE 6 1 STARTING THE UNI X SERVER isssssssssssseees esee eme esee ease aa kae are aea a aane nn 6 2 STOPPING THE WINDOWS SERVER 5 ge LESER SERRA waved deve diate de Ra OO UL GU VUE ETE Fd ob D Ea 6 3 STOPPING THE UNI X SERVER nnda aaa aaa aae aae aenea 6 3 CREATING DOMAINS 6 3 GUEST AND SERVPROV DOMAINS 2 5 DN TALK RA date in Hes Ve E EL AR ege poe EA 6 4 APPLYING A MODEL 2 63 53 33 RR RRERRRRRSRRRRRRRRRRERRRRRRRRERERRRNRRARERRNRRENKRRNRRRERRENRREENERURENESEEEE 6 5 AVAILABLE MODELS LOVE NAAR VO Mia ba DAE AE EVA ED E E EET P RR TCU 6 5 OVERVIEW aces Cousens iia taek vied ota dian wl aad aara 6 5 IMPORT BLUEPRINT MODEL sex exact ra vc eC vC v e aa es re ee eV E e cC cane cara eas 6 6 CREATE YOUR COMPANY DOMAIN iess mesh memes nn 6 6 iv Copyright 2001 2009 Oracle All rights reserved LET YOUR COMPANY DOMAIN USE THE IMPORTED SETTINGS 6 7 CREATE NEW SER pce TAI ERE TERR BERE PR EDS ERR ERE LONE REEL ETRAS EE TNAR 6 7 7 DATABASE nnne nn nnns 7 1 UPGRADING FROM VERSION 3 7
134. ecommend upgrading to Oracle 91 first and then upgrading to Oracle Transportation Management version 4 0 during back to back weekends Follow the installation instructions and install the new 4 0 Oracle Transportation Management components into new directories Once this is complete you should compare your old glog properties file with the new glog properties file and migrate any customized settings Finally copy any customer specific glog properties files to the new Oracle Transportation Management instance and ensure that the new glog properties file references these files Customer specific properties files usually follow the format glog company name properties The following topics outline the procedures for migrating a GC3 3 7 database to 4 0 The structure of the database to be migrated should be consistent with the GC3 3 7 database specification otherwise the migration will fail To complete these procedures you need the following DB passwords System password e glogowner password reportowner password In addition you will be creating tablespaces for LOB columns For this step you will need to know the directory in which the datafiles will exist and a default initial size for the LOB tablespaces Before you begin the migration shutdown all processes running against the database and shutdown the Oracle Transportation Management application Always create a full backup of the database before beginning any Oracle Transpor
135. ed with the model you chose 10 11 12 Note for advanced users If you have access to two simultaneous Oracle Transportation Management servers you can create your own blueprint domain on one server and import that domain into a second Oracle Transportation Management server If that is the case select an Import Location of Import from Remote Host You can also re apply your own blueprint domain with an Import Type of Update Make sure your blueprint domain only refers to data accessible on both servers Log out Log back in as BLUEPRINT ADMIN Verify that you are happy with the configuration You can modify the menus finder sets etc to suit your needs Create Your Company Domain 1 2 6 6 Log in as DBA ADMIN Click Configuration and Administration gt Domain Management gt Add Domain Enter a Domain Name For example MYCORP Copyright 2001 2009 Oracle All rights reserved 4 Click Add Domain Wait until Oracle Transportation Management displays a confirmation page 5 Log out Let Your Company Domain Use the Imported Settings 6 Log in as BLUEPRINT ADMIN Click Configuration and Administration gt Blueprint gt Associate Domain Select a Domain Name of MYCORP Click Ok Log out Log back in as MYCORP ADMIN Oracle Transportation Management displays both the menu OTM_PLANNER and OTM_ADMIN At this point Oracle Transportation Management has Set the role of all use
136. ement instance using a web browser 2 Click 9 to display the software version and consolidated update version If your consolidated update version shows GA then you are running the initial Oracle Transportation Management release with no release Each consolidated update contains specific installation instructions The consolidated update installations on UNIX only can be run in console mode no XServer required To run the consolidated update installer in this mode run the installer as follows otmv55 P consolidated update number platform bin i console Note Unless specifically stated otherwise you must apply the latest available Roll up patch RU of the current version of Oracle Transportation Management before applying the consolidated update Branding Oracle Transportation Management consolidated updates typically include updated web files XSL html jpg gif JS etc to fix specific reported problems and to provide minor enhancements requested by customers Since each Oracle Transportation Management consolidated update includes a list of updated files you should apply the consolidated update to your test site re brand the updated files and then test everything Once it has passed your testing you should apply the consolidated update and your new branded files to your production site This procedure ensures that you have all of the fixes included in the latest consolidated update and that your branding is not broken
137. er 13 Click Exit when the installation process completes Note The Oracle Reports service may stop whenever a user logs out of the Windows server Due to this limitation the Windows console must stay continuously logged in You may LOCK the console for security reasons Installing Oracle Transportation Management Follow the instructions in the Installing Oracle Transportation Management chapter to finish your Oracle Transportation Management installation You must be logged in as Administrator or someone with Administrative privileges to install Oracle Transportation Management successfully Solaris Installation Requirements It is HIGHLY recommended that you make available personnel who are familiar with the installation and configuration of UNIX based applications Also it is recommended that you have an administrator familiar with the creation and support of Oracle Database instances A Network Administrator may be necessary at times especially during the configuration of systems that will be accessed through firewalls VPN etc 2 4 Copyright 2001 2009 Oracle All rights reserved You must run the installer as non root user though root access will be required to run a script during the installation The user that runs the installer must have full rights to the installation directory Note Sections that are specific to the type of Application Server being used are marked with OAS or WebLogic Minimum Hardware Re
138. er and the web server Test and Development Server e Combined Web amp App 2 x 1 4 GHz dual core Itanium CPU 4 GB RAM 40 GB disk Note For the Report and Database servers please see the documentation associated with those products Production Servers e Web Server 2 x 1 6 GHz dual core Itanium CPU 4 GB RAM 40 GB disk e Application Server 2 x 1 6 GHz dual core Itanium CPU 4 GB RAM 40 GB disk Note For the Report and Database servers please see the documentation associated with those products Software Requirements e HP UX 11iv2 with the latest Recommended Patches e HP UX patches for the JDK 1 4 2 e HP UX JDK 1 4 2 08 e Internet Explorer 6 0 SP1 or Mozilla Firefox 1 5 x for client Note Popup Blockers may prevent your browser from working correctly with Oracle Transportation Management If you experience any problems try disabling them before contacting Technical Support Note For users wishing to view the results generated by the Load Configuration feature a VRML plug in for their Web Browser is needed Oracle Transportation Management has been tested with the Cortona plug in for Internet Explorer available at http www parallelgraphics com products cortona Note Oracle Transportation Management 5 5 is certified with the 32 bit version only for HP UX 11i v2 e Adobe Acrobat 6 0 for client e Oracle 10g Release 2 10 2 0 3 0 Enterprise Edition or the latest version of 11g Copyright 2001 2009
139. erational database ROD is a replicated version of your OLTP database except for CLOB and LONG columns on a completely separate database It is created using Oracle s materialized view technology The ROD is intended for users who need to run reports or long running queries Separating the reporting from the online transaction processing ensures that reports do not adversely affect performance of the OLTP database Once you create the new database for storing the ROD ensure that the database initialization parameters are similar to the OLTP database such as the character set and that the dictionary accessibility is set to true The ROD does not use partitioning since LONG and CLOB columns are not copied over Creating Materialized View Logs on the OLTP Log files are needed to capture updates inserts and deletes on the OLTP database so that the ROD database can be refreshed incrementally Run the following to install the logs onto the OLTP database 1 If you had our previous ODS system run the following first as GLOGOWNER on the OLTP database This will remove previous logs Repeat this step as REPORTOWNER Also it is recommended to make a backup of the original ROD database if there is one since the next steps will completely wipe out the environment Follow the rest of the steps as described to recreate your replicated environment user mview logs 2 On the OLTP database as GLOGOWNER run the following It created the
140. ert Disk1 of the Oracle AS 10gR2 FR install package Run runi nstaller Ensure your system passes the Installation Requirements Check Review the Welcome screen and click Next OY oro At the Destination Oracle Home and Oracle Home Name Screen please enter in the Oracle Home i e FR HOME AS etc and the path to the new Oracle Home i e u01 app oracle product reports10gR2 Note Do NOT install the Oracle AS 10gR2 FR software to an existing Oracle Home This may cause any existing Oracle products including databases to become inoperable 7 Click Next after entering Oracle Home name and path 8 Enter the oracle user s group usually dba 9 Choose your language usually English 10 Specify an Instance Name unique identifier for the Reports instance usually a hostname and ias_admin password The ias_admin password will be used to manage the Oracle Reports server 2 8 Copyright 2001 2009 Oracle All rights reserved 11 Enter the FQDN of SMTP mail relay server 12 Click Install on the Summary screen 13 Monitor the installation process 14 Write down the Oracle HTTP Server URL usually http lt servername gt 7777 and Oracle Enterprise Manager Application Server Control URL usually http lt servername gt 1810 The OEM AS url is used to stop and start the Oracle Reports Server 15 Click Exit after the installation process completes Installing Oracle Transportation
141. essfully applied and it will not try to migrate the data associated with that patch again If an error occurs partway through the process then you can fix the problem and rerun the process without harm If you cannot resolve the error yourself contact Technical Support 7 Go to the otm install path gt glog oracle script8 directory on the Oracle Transportation Management Application server In SQL Plus as user SYS run QGgather table stats sql Running this script will enable you to take advantage of the latest indexes The script might run for several hours 8 Go to the otm install path gt glog oracle directory the Oracle Transportation Management Application server In SQL Plus as user GLOGOWNER run QGinsert security roles sql The remaining topics are not critical to the upgrade but provide helpful information Copyright 2001 2009 Oracle rights reserved 7 5 Migrating Audit Trail Information optional Audit trail information has been redesigned in 4 5 Oracle Transportation Management provides an optional migration script that can be run if your site would like to keep its historical audit trail information This can be run while 4 5 is up and running You will be prompted for the date range for the auditing information you would like to keep The smaller the date range the quicker the process will finish You can run this process multiple times if you would like to process sets of small ranges during off peak
142. eware URL linus brown com glog RatingEngine Rateware Port 23700 Once this change has been made you will need to restart your Oracle Transportation Management instance Installing Python on a Client PC This is a prerequisite to using the ClientUtil py for exporting importing from a remote Oracle Transportation Management instance or for using sql2xml py or xml2sql py for exporting importing from a database for which you have sql net access Installing Python 1 Copy the contents of the otm install path gt utils integration python directory to a path on your local PC for example d product otmpython 2 Within this directory you will find and extract the python for gc3v55 zip file into a path on your local PC It will automatically create a python directory that contains all of the python executables and libraries Ex d products python 3 Set your PYTHONPATH environment variables You can set pythonpath permanently in your environment using Settings gt Control Panel 2System Environment 4 Set PYHOME d products python 5 Set PYTHON d products otmpython 6 Set PYTHON PATH PYTHON HOMEVMib python2 4 PYTHON_HOME lib python2 4 site packages PYTHON_HOME lib python2 4 site packages _xmlplus GLOG_HOME utils integration python 7 You are now ready to use the Oracle Transportation Management client side python scripts Python International Character Set Configuration The site py file under py
143. g RPTAPP DESCRIPTION ADDRESS LIST ADDRESS PROTOCOL TCP HOST DB FQDN PORT DB CONNECT DATA SID DB SID Note If you get the following error your tnsnames ora file is not properly configured o nQSError 43059 Init block GET WEBSERVER Dynamic refresh of repository scope variables has failed o nQSError 17001 Oracle Error code 12154 message ORA 12154 TNS could not resolve service name at OCI Logon o nQSError 17014 Could not connect to Oracle database To set up scheduler cd opt OracleBI server Bin opt OracleBI setup user sh opt OracleBI setup sa init sh schconfig Follow prompts tp setup DB connection user password To start the server run opt OracleBI setup run sa sh Verify there are no errors by running tail f opt OBIEE OracleBI server Log NQServer log 4 12 Copyright 2001 2009 Oracle All rights reserved opt OracleBI setup run saw sh Verify there are no errors by running tail f opt OBIEE OracleBIData web log sawlog0 log opt OracleBI setup run sch sh Verify there are no errors by running tail opt OBIEE OracleBI server Log NQScheduler log The following error message may be displayed in the NQserver log file on startup of OBIEE when using the 64 bit Oracle 9i client Could not open 1ibclntsh so 9 1 no such file or directory If you receive this
144. gine 10 engLife 50 maxldlez 30 callbackTimeOut 90000 gt e Modify the SourceDir property lt property name sourceDir value lt otm_install_ path gt glog reports gt Edit or create the cgicmd dat file on the Reports Server under reports10g reports conf The file should look like the following Keep in mind that the format of this file is important and spaces and blank lines should be just as they are below Replace lt db_connect_string gt with the connect string for your Oracle Transportation Management database as configured in your TNSNAMES ORA file all hide_pass_key userid glogdba glogdba lt db_connect_string gt Note Everything from hide_pass_key to should be on one line When the configuration is complete log into the Oracle Enterprise Manager usually http lt servername gt 1810 The username is ias_admin and the password was defined during installation Click on Reports Server rep servername Then click on Restart to restart your Oracle Reports server Copyright 2001 2009 Oracle rights reserved 3 15 30 If the Oracle Enterprise Manager is not running you can start it by logging into your server as the oracle user changing into the lt ORACLE_FR_HOME gt bin directory and running emctl start iasconsole 31 In order to test your Oracle Reports installation use a web browser to hit the following URLs http servername 7777 reports rwservlet
145. gt identified by lt new password gt Some users have additional steps that need to be taken glogdba 1 Edit the otm install path gt glog config glog properties file on each Oracle Transportation Management Web and App server and replace the value of glog database password with the new glogdba password 2 OAS Edit the file otm install path gt oas j2ee home config data sources xml and replace the password on all lines containing user glogdba 3 WebLogic Edit the file otm install path2 weblogic config gc3domain config xml template and replace the password on the line containing user glogdba 4 WebSphere Edit the file otm install path gt websphere profiles default config cells _ APP SERVER gt NodeO1Cell security xml where APP SERVER is your application server s host name a login to your APP server machine as the Oracle Transportation Management user b cd WAS INSTALL DIR lib where WAS INSTALL DIR is the directory where you installed the WebSphere Application Server e g opt IBM WebSphere AppServer6 Type the following all on one line where secret is your new password make note of the output specifically the stuff between the quotes e g encoded password xor LDo8LTor java bin java cp securityimpl jar iwsorb jar ras jar wsexception jar bootstrap jar emf jar ffdc jar com ibm ws security util PasswordEncoder secret d look forthe lt authDataEntries
146. he next step 4 2 Copyright 2001 2009 Oracle rights reserved Installing OBI Oracle Business Intelligence Enterprise Edition Pre Installation Setup 1 Logon to the server which OBI will be installed on as the oracle user 2 As a prerequisite to OBI you will need to install the Oracle SQLPlus Client for version 9i as outlined earlier in this document Note If you are installing OBI EE on a server running 64 bit Linux be sure the LD_LIBRARY_PATH for the oracle user also includes the lt Oracle 9i Client Home gt lib32 directory If the path isn t correct the following error would be generated later in the OBI EE installation ibcIntsh so 9 0 cannot open shared object file No such file or directory The same error would be generated if the oracle user didn t have permissions to access the Oracle Home gt lib or lib32 directory due to OS permission restrictions 3 Add the tnsnames ora entry to point to either your ROD database or your OLTP database Ensure you don t have a sqlnet ora file in the same director as your tnsnames ora The connetor s name must be RPTAPP RPTAPP DESCRIPTION ADDRESS LIST ADDRESS PROTOCOL TCP HOST host name PORT port number gt CONNECT_DATA SID lt SID Name gt 4 Create the directory where you will be installing Oracle Business Intelligence eg opt oraclebi and change ownerships so that oracle dba owns the directo
147. he client does not want to copy to the destination database then data cleaning process should be carried out in the destination database after the copy e Source and destination servers must be the same platform same operating system and same Oracle version between e Requires DBA skills e Requires down time in the source database if there is no hot backup Oracle Export Import Utility Using the Oracle export import method the entire Oracle Transportation Management database structures can be copied from one database to another To successfully copy an Oracle Transportation Management database following guidelines are recommended 3 Create all Oracle Transportation Management used tablespaces first in the target database 4 Check if all of Oracle Transportation Management required init ora parameters are properly set in the target database 5 Oracle Transportation Management database roles and schema users should be created in the target database before the import This should be done by running Oracle Transportation Management supplied SQL scripts as described below Log in to the target database as user SYSTEM create_glog_roles sql Make sure no errors create_glog_users sql Make sure no errors 6 Perform export on the source database The easiest way is to do a FULL export But if for any reason you do not want a FULL export you can do a schema export Oracle supplies a schema export parameter file exp_G
148. he process will examine this flag otherwise this flag is ignored When the flag is set to TRUE no clobs are nulled out When the flag is set to FALSE the CLOB column TRANSACTION table are nulled out only for following rows e Whose insert date are older than specified age e They have associated shipment events which means these transactions have related records in IE SHIPMENTSTATUS table Note that transactions with no related records SHIPMENTSTATUS table but with related records in TENDER COLLABORATION table will not have the CLOB column nulled out Batch size default 5000 Limits the number of transmission records that should be processed at a time The smaller your rollback segment the lower this number should be set If you get a rollback segment error rerun the process with a lower batch size specified The transmission purge process delete records from the following tables I TRANSMISSION I TRANSACTION I LOG IE INROUTE SERVPROV IE MARKS IE SHIPMENTSTATUS IE SHIPMENT REFNUM IE SS EQUIPMEN IE SS REMARK IE SS STOP IE 55 S EQUIPMENT IE S SHIP UNIT IE S SHIP UNIT LINE IE SHIP GROUP REFNUM IT SHIPMENT REFNUM IT TENDER RESPONSE ENDER COLLABORATION SERVPROV TENDER COMMEN SERVPROV TENDER REFNUM LENDER COLLABORATION STATUS
149. hing jobs at their scheduled times Rebuilding an Existing Materialized View If you want the new columns of a particular table to be regenerated execute the following EXEC pkg_rod build_mview table_name It will drop and recreate the materialized view empty You can wait until the next refresh for it to populate or you can do the following EXEC pkg_rod refresh_one table_name If you are recreating several materialized views you may want to kick off the refresh for all views manually by executing the following EXEC pkg_rod refresh_all Archive Setup Oracle Transportation Management can store archived orders and shipments on your transactional OLTP database or on the replicated online database ROD used for reporting If you do not have an ROD set up but plan to and want archiving stored there you can create the separate database and follow the initial ROD steps of e Create Tablespaces e Configure TNSNames 3 28 Copyright 2001 2009 Oracle All rights reserved e Create Database Roles and Users Run the following to create the ARCHIVE user and ARCHIVE tablespace on the database that will store archiving should be your OLTP or the ROD This step can be skipped if you already have the archive user As the user SYSTEM run the following create_archive_user sql If archiving will be stored on the ROD run the following as GLOGOWNER on your OLTP if you have
150. his would be the external URL outside your network If not then this would be the URL to your web server from within your network Enter the Web Server External Port usually 80 If your site was accessed through a load balancer or NAT device this is the external port If not then this is the port on your web server Enter the Fully Qualified Domain Name of your Web Server This may or may not be the same as the Web Server External URL Please contact your Network Administrator if you have any concerns about this Enter the Web Server Port usually 80 Enter the Fully Qualified Domain Name of your Application Server which is the name of your server and the domain name e g otmapp oracle com click Next General Settings continued a b e f Enter the App Server Port OAS 23791 WebLogic 7001 WebSphere 2809 Enter the Database Server Fully Qualified Domain Name that is the name of your Database Server and the domain name e g otmdb oracle com Enter the Database Server Port This is usually 1521 Enter the Database Connect String This is the DB connect string as setup in your tnsnames ora file under the Oracle client installation Contact your Oracle Administrator for this information Enter the Database SID name click Next General Settings continued a C Enter Oracle Home Path where you installed the Oracle client u01 app oracle product 1020 for instance and click Next Enter
151. home lib must be modified to change encoding ascii to encoding utf 8 Failure to make the above change will cause international characters to be garbled 5 6 Copyright 2001 2009 Oracle All rights reserved 6 Starting Oracle Transportation Management after Installation Is Complete Starting and Stopping the Oracle Transportation Management Servers Starting the Windows Server 8 9 Start the Oracle database Start Oracle Reports if necessary On the Reports Server start the Oracle e g otmrptweb 10 Web Server 11 Start the Apache service on the Oracle Tran otmapache OAS Start the OAS Service e g otmapp It can take several minutes for OAS to f 12 OAS you can monitor the lt otm_install_ initialized you will see the lines INFO 2007 11 28 05 Startup INFO Startup INFO jvm 1 initServl jvm 1 activateT jvm 1 Startup loading s INFO jvm 1 Containers for J2EE et 2007 11 hread 2007 11 tartup cl 2007 11 28 05 LOG 10s Note The first time OAS is started it will a 28 05 28 05 asses Transportation Management Report Web service Start the Tomcat service e g named otmtomcat on the Oracle Transportation Management sportation Management Web server e g ully start up depending on your server To check path gt logs oas console log file When OAS is fully 56 05 07 11 28 05 56 05 56 05 07 11 28 05 56
152. il server that can be accessed by the FAXmaker server The mailbox name should be identical to the email address for outgoing fax notifications that you entered during the Oracle Transportation Management application server install Test this POP3 account using any email client that supports POP3 Please contact your System Administrators for more information as they will have greater insight into the makeup of your SMTP mail services Copy the Oracle Transportation Management fax template file lt otm_install_path gt install FAXmaker G Log rtf or lt otm_install_path gt install FAXmaker G Log rtf to FAX maker s coverpage directory e g C Program Files FAXmaker Coverpage Start FAXmaker Configuration MMC Console 10 Start the Fax Server Configuration application Select Lines tab ensure that your modem is configured to send faxes ONLY Do not configure the modem to allow faxes to be received Under the Coverpages tab set G Log rtf as the default coverpage and set your paper size to letter Under the Dialing tab setup any special dialing requirements such as dialing 7 to get an outside line Click OK to save this information Click on User Configuration tab Add a new user The username and email address should be identical to the email address from which email notifications will come that you entered when you installed the Oracle Transportation Management application server This allows emails that
153. in password will be used to manage the Oracle Reports server 11 Enter the FQDN of an SMTP mail relay server 12 Click Install on the Summary screen 13 Monitor the installation process 2 18 Copyright 2001 2009 Oracle rights reserved 14 Write down the Oracle HTTP Server URL usually http lt servername gt 7777 and Oracle Enterprise Manager Application Server Control URL usually http lt servername gt 1810 The OEM AS url is used to stop and start the Oracle Reports Server 15 Click Exit after the installation process completes Installing Oracle Transportation Management Follow the instructions in the Installing Oracle Transportation Management chapter to finish your Oracle Transportation Management installation You must run the installer as a non root user though root access will be required to run a script during the installation The user that runs the installer must have full rights to the installation directory Oracle Enterprise Linux Installation Requirements It is HIGHLY recommended that you make available personnel who are familiar with the installation and configuration of UNIX based applications Also it is recommended that you have an administrator familiar with the creation and support of Oracle Database instances A Network Administrator may be necessary at times especially during the configuration of systems that will be accessed through firewalls VPN etc You must run the installer as a non r
154. in the dbaPool UNIX On UNIX you can monitor system performance using the ps top or sar You should monitor general trends such as CPU usage memory usage and memory swapping out to virtual memory All processes for Oracle Transportation Management should run under the user setup during the installation process This can be helpful for identifying the processes The Apache service starts up multiple instances of Apache to handle incoming requests Each of these will show up as httpd and can be monitored for performance statistics using general UNIX tools Oracle Application Server OAS The Tomcat service starts up one and shows up as lt path gt java Xms512m Unfortunately this can be hard to find if you have multiple J VMs running on the same machine Usually you can identify Tomcat by the amount of memory it is using as normal Tomcat instances use large amounts of memory typically 768MB to 2GB You can monitor the performance statistics of Tomcat using general UNIX tools The OAS service starts up one Java JVM and shows up as lt path gt java server XX MaxPerm differs slightly from the Tomcat instance Unfortunately this can be hard to find if you have multiple J VMs running on the same machine Usually you can identify OAS by the amount of memory it is using as normal OAS instances use large amounts of memory typically 512MB to 2GB You can 8 18 Copyright 2001 2009
155. ing Oracle Transportation Management on the Web Server The Oracle Transportation Management Install Program requires a graphical interface on Win32 On UNI X we recommend that you run this installer from the server console or from an X Windows session Please contact your UNI X Administrator for more information about launching GUI based UNI X applications Also you must set the DISPLAY environment variable if you haven t already done so Alternatively UNIX users can install in console mode as described below 1 WebLogic only Create a directory to store the additional jar files needed by Oracle Transportation Management a We recommend tmp addjars and will use that for the purpose of these instructions b Copy the following files from the WebLogic server lib directory on the Oracle Transportation Management Application server e g opt bea weblogic81 server lib to tmp addjars on your Web server i weblogic jar ii webservices jar iii xmlx jar 2 Run the installer to start the installation a UNIX otmv553 platform bin b Win32 otmv553 win32 exe Note Oracle Transportation Management also supports CONSOLE MODE installation on Linux UNI X platforms only This allows you to install Oracle Transportation Management when a GUI console is not available or practical Run the following commands to launch the installer in this mode stty erase H otmv553 platform bin i console Note On UNIX Linux systems the I
156. ing lines in the mod deflate section SetOutputFilter DEFLATE SetInputFilter DEFLATE Enabling Automatic Web UI Login Oracle Transportation Management can remember a user s login ID and password and auto fill these fields This feature stores the hashed login ID and password in a cookie within the end user s web browser This feature may present a security concern if enabled To enable do the following 1 Edit the otm install path gt glog config glog properties file on your Web servers and add the following property glog webserver login remember true 2 Restart Oracle Transportation Management for this to take effect The Remember Me checkbox will now appear on the login screen and browser based users can selectively enable this feature for their login Enabling Reverse Proxy Support Oracle Transportation Management supports some reverse proxy solutions The reverse proxy is expected to identify sites based on a URL prefix such as otm and then strip that prefix off before 8 14 Copyright 2001 2009 Oracle rights reserved forwarding the URL to Oracle Transportation Management Every link that Oracle Transportation Management sends to the browsers will contain the defined URL prefix To enable reverse proxy support do the following 1 Edit the otm install path gt glog config glog properties file on your Web and Application servers and modify the line to include the desired URL prefix ex
157. ings continued a b d Enter the Oracle Transportation Management Report Server Web Server Service lnit Script name e g otmrptweb55 If installing more than one Oracle Transportation Management instance on a server this should be unique for each one Enter the Oracle Reports Connect String Enter the ORACLE HOME path of Oracle Reports e g u01 app oracle product reports109g click Next UNI X only UNIX Settings a b Enter the user name that the Oracle Transportation Management programs will run under e g otm or otm55 Enter the group name that the Oracle Transportation Management programs will run under e g otm or otm55 Copyright 2001 2009 Oracle rights reserved 18 19 20 21 22 23 24 25 26 27 28 29 Select whether or not to integrate your Reports Server with Replicated Operational Database ROD then click Next ROD only Replicated Operational Database a Fully Qualified Domain Name of the ROD Server b Port that Oracle is using on the ROD server usually 1521 c Connect String for the ROD database d SID of the ROD database e click Next Review the summary before continuing and click Next when ready to proceed The file copy process may take a while and may appear to hang please be patient Once the files are copied the Install Program prompts you to begin configuring Oracle Transportation Management Click next when you are
158. integrating with PCMiler WorldWide enter the following a Fully Qualified Domain Name of the PCMiler WorldWide b PCMiler WorldWide port usually 8145 c click Next 24 If you are integrating with Rand McNally IntelliRoute Server enter the following a IP address of the Rand McNally IntelliRoute Server b Rand McNally IntelliRoute Server port usually 1998 IntelliRoute user name setup during the IntelliRoute server installation e g otm d IntelliRoute password setup during the IntelliRoute server installation e IntelliRoute location setup during the IntelliRoute server installation f click Next 25 If you are integrating with Rand McNally MileMaker Server enter the following a Enter the Fully Qualified Domain Name of the MileMaker server b Enter the MileMaker server port usually 1031 C click Next 26 If you are integrating with PTV s Map amp Guide server enter the following a Fully Qualified Domain Name of the Map amp Guide server b Map amp Guide server port usually 2000 C click Next 27 Please review the summary before continuing and click Next when ready to proceed The file copy process may take some time please be patient Once the files are copied the installation program prompts you to begin configuring Oracle Transportation Management This step takes a few minutes typically one to five minutes 28 UNI X Only The installer will prompt you to log in as root and run the root sh script This must b
159. ion Follow the installation instructions and install the new GC3 4 5 components into new directories Once this is complete you should compare your old glog properties file with the new glog properties file and migrate any customized settings Finally copy any customer specific glog properties files to the new Oracle Transportation Management instance and ensure that the new glog properties file references these files Customer specific properties files usually follow the format glog lt company_name gt properties Copyright 2001 2009 Oracle All rights reserved 7 3 The following topics outline the procedures for migrating 4 0 database to 4 5 The structure of the database to be migrated should be consistent with the GC3 4 0 database specification otherwise the migration will fail Apply GC3 4 0 Service Releases You must apply the latest GC3 4 0 Service Release before you continue with the 4 5 migration You must also install the latest Oracle Transportation Management Consolidated update to your GC3 4 5 installation to ensure that any known migration issues have been patched and resolved 1 Log in as GLOGOWNER and run dbpatch_40 sql which resides the 4 0 directory lt otm40_install_ path gt glog oracle script8 Note Do not continue with the upgrade until the dbpatch log is completely clean Contact Technical Support if you have any questions or concerns Important Ensure that your environment is setup cor
160. ion segment can be truncated instead of records being individually deleted which is inefficient for large amounts of data Range Partitioning Here is an example of partitioning or segmenting a table where a certain year and month drive the partition the data should be placed in This is an example of partitioning by range Range Partition Jan Mar 2001 sales q1 Apr Jun 2001 sales q2 Jul Sep 2001 sales q3 Oct Dec 2001 sales 94 CREATE TABLE sales invoice no NUMBER sale year INT NOT NULL sale month INT NOT NULL PARTITION BY RANGE sale year sale month PARTITION sales 41 VALUES LESS THAN 2001 04 TABLESPACE data PARTITION sales q2 VALUES LESS THAN 2001 07 TABLESPACE data PARTITION sales q3 VALUES LESS THAN 2001 10 ABLESPACE data PARTITION sales q4 VALUES LESS THAN 2002 01 Copyright 2001 2009 Oracle rights reserved 8 25 TABLESPACE data Oracle Transportation Management Partitioned Tables Oracle Transportation Management database has groups of partitioned tables Most of them are range partitioned However the ranges are not hard coded Instead a partition key column has been added to each partitioned table which is populated with a trigger The value of the calculated key determines into which partition the data shoul
161. ion to a large group of users without giving the password to all of these users LDAP allows Oracle Transportation Management user security and policy information to be centralized in one place the LDAP directory In addition Oracle Transportation Management contains multiple directory support see NameSpaces below This allows multiple LDAP directories to be consulted to find names For instance a Logistics company may wish to authenticate Shippers with a local LDAP directory and Service Providers with an external LDAP directory In addition NameSpaces allow the same directory to be looked up using for instance different authentication protocols or different branches of the same directory tree Oracle Transportation Management allows you to choose which directory is consulted upon login Alternatively a default search order can be configured so that multiple directories can be looked up in turn to authenticate a login Limitations Oracle Transportation Management does not support group authentication group membership testing or distribution lists It simply supports username authentication upon login Oracle Transportation Management does not support the use of user profile attributes from LDAP such as language time zone e mail addresses or any other user preferences All user parameters are controlled within Oracle Transportation Management the gluser attribute provides the linkage between an LDAP user and an Oracle Transportat
162. ion Management does not pass through the URL on an internal DNS name you will need to open a firewall IP and port so that Oracle Transportation Copyright 2001 2009 Oracle rights reserved 4 11 Management can call the external FQDN After changes are made you will need to restart the Oracle Transportation Management web server Enabling agents in Oracle Transportation Management 1 Log on to Oracle Transportation Management as DBA ADMIN Activate the following agents Business Process Automation gt Agents and Milestones gt Automation Agent Change the event if necessary o LOAD ORDER BASE TO HD Default Event Order base created o LOAD ORDER RELEASE TO HD Default Event Order on shipment tendered o LOAD SHIPMENT TO HD Default Event Shipment tendered Identify the Transportation Intelligence users Assign appropriate Transportation Intelligence Role to each user Note Make sure that the aa load hd p load all once is manually run once after the FTI install This will do a complete load of the data Linux Tasks 1 Add the following to OracleBI HOME setup user sh ORACLE HOME u01 app oracle product 920 export ORACLE HOME LD LIBRARY PATH u01 app oracle product 920 1ib LD LIBRARY PATH export LD LIBRARY PATH TNS_ADMIN SORACLE_HOME network admin export TNS ADMIN PATH SORACLE HOME bin S PATH export PATH In the tnsnames ora file add the followin
163. ion Management user The LDAP directory itself must be modified to contain the mapping this in itself could be considered a limitation Oracle Transportation Management does not use the LDAP directory to store contact information e mail addresses location information or other centrally maintained pieces of information vital to large corporations using our product LDAP Server Oracle Transportation Management does not contain an LDAP server Many customers already have a corporate LDAP Server and one of the major goals of this feature is to allow corporations to centralize user and security information not having it scattered in many different places Oracle Transportation Management can be configured to talk to an LDAP Server by defining a NameSpace Single Sign on Support With LDAP Oracle Transportation Management supports the ability to have users login to Oracle Transportation Management using LDAP usernames that they are familiar with Sometimes third party packages allow user to log into the package once Thereafter that person will not have to log in to each individual application that may be accessed subsequently LDAP as a technology is often used in the implementation of Single Sign on solutions Definitions NameSpace A NameSpace is where information about an LDAP directory is stored in Oracle Transportation Management It is an Oracle Transportation Management term and not an LDAP term It contains informatio
164. ions such as jdbc oracle thin G8localhost 1521 sample for thin driver and jdbc oracle oci8 80sample for thick driver required true NOTE only change the values DB FOQDN DB PORT DB SID Restart your Oracle Transportation Management Web and Application servers as described earlier in this guide On an Oracle Transportation Management Reports server edit cgicmd dat under your Oracle AS 10gR2 FR installation and update the connect string You may also need to edit your tnsnames ora files on each Oracle Transportation Management Web App and Reports server Oracle Reports may need to be re configure to point at the new database Creating and Installing SSL Certificates Oracle Transportation Management is delivered with demonstration SSL certificates for Apache using mod ssl and OpenSSL and the application server To run these servers in a production environment you should replace these with your own real certificates verified by a known Certificate Authority such as Verisign Thawte etc In a high traffic SSL environment you should use hardware SSL accelerators as they simplify certificate management increase SSL performance and greatly reduce the load on your servers Hardware solutions are available from F5 Intel and others Apache 1 Open a command prompt and change into otm install path gt apache openssl bin where otm install path is where you installed the Oracl
165. is that all rates from the IMF are against USD You have two alternatives to using USD centric IMF rates e Write an API that uses another source than the to bring in exchange rates stated against your currency storage default or Update the rates you need manually or use a CSV process while again entering your needed rates against your preferred currency You can do this nightly monthly or in any other frequency e Inthe property file glog properties set glog currency base to your currency storage default e g EUR This makes Oracle Transportation Management triangulate through the currency of your choice This means that Oracle Transportation Management will have all DEFAULT rates stated against your base currency and triangulates using your base currency Accounting for Missing Time Zones The UTC pl sql package depends java running in Oracle to do time zone conversions Some time zones are not accounted for in the java util TimeZone class The solution to this problem involves a new and optional missing_time_zone table which has the following structure Column Value TIME_ZONE_GID NOT NULL VARCHAR2 128 ALT_TIME_ZONE_GID NOT NULL VARCHAR2 128 ADJ FACTOR NOT NULL NUMBER So for example if you had a location that specified a time zone of FOO and you wanted FOO to be treated the same as America New York you would specify a missing time zone record of time zone gid FOO alt time
166. it is rapid lookups However many commercial directories allow entries to be indexed and placed in a single branch In addition the NameSpaces feature can be configured to allow multiple branches to be searched am using local authentication and my principal user uses an encrypted password but my users use simple authentication How do get authentication to work You cannot have the Principal using a different encryption algorithm than the individual users If you really need this you can use external authentication and bypass the special authentication for the Principal altogether If you have two user groups that use different authentication mechanisms you can set up two NameSpaces that point to the same directory but use different authentication methods Then set the default search order parameter see above to search the two namespaces Copyright 2001 2009 Oracle rights reserved 9 7 10 Database Administration The contents of this chapter represent our recommendations rather than requirements When making any changes to an Oracle Transportation Management database the DBA should always consider the size and the activity pattern of the database the hardware configurations and business requirements Initial Setup of Oracle Database Initial Parameters Oracle Transportation Management provides a sample init ora file with recommended values of some key parameters These values may need to be adjusted according t
167. itial connections of 100 in Weblogic WebSphere configuration O7 DICTIONARY ACCESSIBILITY TRUE This is required optimizer features enabl 11 1 0 6 1 This parameter is needed for optimizer distinct elimination fa l se This parameter is needed for le 119 onl le llg only and is mandatory ly and is mandatory 10 2 Copyright 2001 2009 Oracle rights reserved Using Locally Managed Tablespaces Oracle recommends using locally managed tablespaces for all of Oracle Transportation Management tablespaces including SYSTEM tablespace Locally managed tablespaces can improve performance by eliminating some recursive operations during space allocation Initial Redo Log Files It is recommended to have three four or five redo log groups Each group should have at least two members We recommend that the initial size of the redo log files be 10 20 MB Once the database is in normal operation especially for a production database the DBA should monitor the log switch frequency If log switch occurs too often for example less than 10 minutes the size of redo log files should be increased Initial Setting of Undo Historically Oracle has used rollback segments to manage undo Space management for these rollback segments has proved to be quite complex In 9i and later Oracle provides UNDO tablespace another way to manage undoes UNDO MANAGEMENT AUTO Using this method DBAs do not ha
168. ize You must know some elementary HTML in order to edit the file By editing the HTML of the file general custom help htm you can add links to any documents that you have written to supplement Oracle Transportation Management s documentation Alternatively you can replace that topic with one of the same name that you have created Copyright 2001 2009 Oracle rights reserved 7 11 Note If you choose to edit that topic add your own documentation or links to your own documentation be careful not to overwrite the file when you upgrade your software If you install a consolidated update that help file will be overwritten when the new help is installed To avoid overwriting your edited help topic make a backup of the file before upgrading Then replace the newly installed file with the one from your backup Apply GC3 5 0 Service Releases Important Ensure that your environment is setup correctly by running e On UNIX otm install path install gc3env sh e On Win32 otm install path Vinstallgc3env cmd You must also install the latest GC3 5 0 Service Release to your GC3 5 0 installation and apply the Service Release script to your 5 0 database to ensure that any known migration issues have been patched and resolved 1 Log in as GLOGOWNER and run dbpatch_50b sql which resides in the 5 0 directory otm50 install path gt glog oracle script8 Note Do not continue with the upgrade until the dbpatch log is co
169. l under OBI EE OracleBIData web config directory Change the line with CatalogPath to point to the aa directory From lt CatalogPath gt opt oraclebi oraclebidata web catalog paint lt CatalogPath gt To lt CatalogPath gt opt oraclebi oraclebidata web catalog aa lt CatalogPath gt Also add the following lines to the section of the file above the lt ServerInstance gt lt WebConfig gt lt CredentialStore gt lt CredentialStorage type file path lt OracleBIData gt web config credentialstore xml passphrase another secret lt CredentialStore gt lt Auth gt lt SSO enabled true gt lt ParamList gt lt Param name IMPERSONATE source serverVariable name InSource REMOTE_USER gt lt ParamList gt LogoffUrl http OTM WEBSERVER LogoffUrl LogonUrl http OTM WEBSERVER LogonUrl lt 550 gt lt Auth gt Copyright 2001 2009 Oracle All rights reserved 4 7 18 19 20 21 4 8 For the logo add the file lt o tm_install_path gt fti portallogo gif The location of the file is OBI EE Oracle Bl web app res s_oraclel0 portal Add the following to OBI CredentialStore EE OracleBIData web config instanceconfig xml CredentialStorage type file path OracleBIData web config credentialstore xml passphrase another secret CredentialStore Auth SS
170. ld record references them Answer No the purging program is implemented with cascade delete functionalities It would delete the referenced children before deleting their parent However this may be a security problem For example the parent and child data might exist in different domains and the user trying to purge does not have read and write privileges to the domain containing the child data Question want to purge but some parent and child data exist in different domains What should do Answer You have two options The first is to grant read and write privileges from the child domain to parent domain You may not like this option because you have to do a lot of granting The other option 8 22 Copyright 2001 2009 Oracle All rights reserved is to schedule the purge job with DBA privileges by submitting begin pkg_purge dba_install end Question How do change the job interval Answer The default job interval is 30 minutes during Oracle Transportation Management database installation or patching However you are only allowed to change the interval in increments of 30 minutes by calling the stored procedure with a number in the parameter For example if you would prefer the job to run every 12 hours then you submit begin pkg purge dba install 24 end The parameter 24 is calculated from 30 minutes x 24 12 hours Question The database already has a scheduled purging job What would happen to that job if
171. le Transportation Management instance is as follows This layout shows that for this particular Oracle Transportation Management installation the default E FREE TOAD GLOGDEV HERA35 select 5 STORAGE DEFAULT from UOM wh i3 Eie Edit Grid SQL Window Database Create View Debug Tuning Window Help 18 x EAE ENA E 44 DER a ETES T ARG ok GE 8 DISTANCE KI 2Y VOLUME CUFT VEIGHT LB 1Y TEMPERATURE 1Y _ DURATION 5 17 _ SPEED 2Y storage UOM for length is FT for distance Miles etc Note If you use a default currency other then USD you will need to remove that currency record from UOM table after each consolidated update is installed 2 Run the following SQL statement to change the default storage in your system for any UOM This example changes the default UOM for LENGTH from current FT to M meters Copyright 2001 2009 Oracle rights reserved 8 29 UPDATE SET IS STORAGE DEFAULT Y WHERE CODE M 3 You will also need to remove the Y flag on the current length default of FT UPDATE UOM SET IS STORAGE DEFAULT N WHERE UOM CODE FT The above is an example for length but the same SQL can be used to change the defaults for DISTANCE SPEED TEMPERATURE VOLUME and WEIGHT Changing Currency Settings
172. ler to support most fax generation software This handler embeds routing information into one of the following 3 mail components e message body e subject line e to alias i e the last name of the to party The embedding is accomplished with a picture string describing the modified format of the above component You can specify original information from the text email to use in the modified component including e firstName e lastName e company e phone e punctuation or space e message e subject Replacements are represented by one of these identifiers surrounded by parenthesis for example firstName Newline characters are preserved To transform an email message body to one supporting FAXMaker the picture string would be firstName company lastName rawPhone n message The following properties control the default fax handler glog fax defaultHandler routingMode message body to default message glog fax defaultHandler routingPicture lt picture string gt default firstName company lastName rawPhone n message For RightFax the properties default to log fax defaultHandler routingMode to log fax defaultHandler routingPicture name lastName firstName 9 9 glog fax email fax company com For FAXMaker they default to Copyright 2001 2009 Oracle All rights reserved 5 3 log fa
173. lly dba Choose your language usually English Specify an Instance Name unique identifier for the Reports instance usually a hostname admin password The ias admin password will be used to manage the Oracle Reports server Enter the FQDN of an SMTP mail relay server Click Install on the Summary screen Monitor the installation process Write down the Oracle HTTP Server URL usually http servername 7777 and Oracle Enterprise Manager Application Server Control URL usually http servername 1810 The OEM AS url is used to stop and start the Oracle Reports Server Click Exit after the installation process completes Installing Oracle Transportation Management Follow the instructions in the Installing Oracle Transportation Management chapter to finish your Oracle Transportation Management installation You must run the installer as a non root user though root access will be required to run a script during the installation The user that runs the installer must have full rights to the installation directory 2 24 Copyright 2001 2009 Oracle rights reserved 3 Installing Oracle Transportation Management It is HIGHLY recommended that you make available personnel who are familiar with the installation and configuration of Windows or UNIX based applications depending on operating system you are installing on Also we recommend that in the case of the Oracle Database that you have on hand a
174. lowing e Request Throughput The rate at which requests are processed The higher the better e Requests Waiting The number of requests waiting to process The lower the better e Memory Usage The amount of memory utilized by WebLogic Keep in mind that this shows you how much memory WebLogic is using within the memory allocated to the J VM The amount of memory reported by your operating system will be higher since the VM reserves all of the memory that it has been configured to allocate regardless of whether WebLogic is using it all or not This was set during the Oracle Transportation Management installation To get a true memory reading you should force a garbage collection e Force Garbage Collection This will force the JVM to free up all unused memory This should be run in order to get a true memory reading from the main performance screen Keep in mind that forcing a garbage collection will slow the server down and shouldn t be forced continually The JVM usually manages garbage collections automatically as the server runs 7 To monitor database connections expand Services gt gt Connection Pools 8 Select dbaPool 9 Select the Monitoring tab and Monitor all instances of dbaPool 10 This page shows you the initial maximum and high number of db connections You should monitor whether the high number is at or near the maximum number of connections If so you should consider increasing the database connections
175. lready done so Alternatively UNIX users can install in console mode as described below Note Paths shown in this section will be in UNIX format Ex opt gc3 but should be in Windows format for Win32 installs D gc3 or D gc3 All directions are generic across all operating systems and any differences will be noted 3 2 Copyright 2001 2009 Oracle rights reserved e 9 Note All instructions apply regardless of which Application Server you are using unless otherwise noted Run the installer to start the installation a UNIX otmv553 platform bin b Win32 otmv553 win32 exe Note Oracle Transportation Management also supports CONSOLE MODE installation on Linux UNI X platforms only This allows you to install Oracle Transportation Management when a GUI console is not available or practical Run the following commands to launch the installer in this mode stty erase H otmv553 platform bin i console Note On UNIX Linux systems the Installer extracts to tmp and you will receive an error if there is not sufficient room there for the Installer to extract itself If you need to change this directory you must set the IATEMPDIR environment variable export IATEMPDIR some other temp directory otmv553 platform bin Read the installation notice and click Next Read the Third Party Software notice and click Next Choose the installation directory e g opt otm or opt otm55 to
176. m before contacting Technical Support Note For users wishing to view the results generated by the Load Configuration feature a VRML plug in for their Web Browser is needed Oracle Transportation Management has been tested with the Cortona plug in for Internet Explorer available at http www parallelgraphics com products cortona Adobe Acrobat 6 0 for client Oracle 10g Release 2 10 2 0 3 0 Enterprise Edition or the latest version of 11g WebLogic WebLogic 8 1 with Service Pack 6 with an Advantage non clustered License WebSphere WebSphere Application Server 6 0 Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services optional Integration Server EAI solution optional The following software is distributed with Oracle Transportation Management OAS Oracle Application Server 10 1 3 0 patches Apache Web Server 2 0 55 Tomcat Java Servlet Server 5 5 16 OpenSSL 0 9 8a IBM JDK 1 4 2 Python 2 4 2 Java Service Wrapper 3 1 2 zlib 1 2 3 The Oracle Transportation Management software is distributed on CD or via download from standard Oracle channels Preparing to Install Oracle Transportation Management Oracle Transportation Management requires the following software 2 10 AI X 5 3 with latest Recommended Patch Bundle Oracle 10gR2 10 2 0 3 0 Client or the latest version of 11g optional for Web server required for Application server WebLogic WebLogic 8 1 with Service Pack 6
177. mend the following book Network Troubleshooting Tools O Reilly by Joseph D Sloan ISBN 059600186X Tomcat The online documentation for Tomcat can be found under the following URL http jakarta apache org tomcat tomcat 5 5 doc Copyright 2001 2009 Oracle rights reserved 11 1 Oracle Application Server OAS The online documentation for OAS can be found under the following URL http download west oracle com docs cd B25221 04 index htm WebLogic The online documentation for WebLogic can be found under the following URL http e docs bea com wls docs81 WebSphere The online documentation for WebSphere can be found under the following URL http publib boulder ibm com infocenter wasinfo v6r0 index jsp Java Service Wrapper The online documentation for JSW can be found under the following URL http wrapper tanukisoftware org doc english introduction html 11 2 Copyright 2001 2009 Oracle All rights reserved 12 Appendix B Troubleshooting Known Issues Installation There are known problems with Windows X server Terminal Emulators InstallAnywhere on Solaris InstallAnywhere is the installation program used by both WebLogic and Oracle Transportation Management Symptoms Installer started from Windows via remote X session appears to fail immediately or in debug mode displays an error containing the sting An unexpected exception has been detected in native code outside the VM
178. message please verify that the file does not exist in the SORACLE_HOME 1ib32 If the file does not exist create this file linked to the 1ibcintsh so file that is in the SORACLE_HOME 1ib32 directory 6 Install apache and Tomcat with the following context in the server xml Context path analytics docBase opt OracleBI web app privileged true Manager className org apache catalina session StandardManager pathname gt lt Context gt Mandatory Oracle Transportation Management User Role VPD Profile Configuration FTI offers additional external predicates in version 5 5 06 These are now available under the following standard VPD Profiles shipped with the OTM application e FTI_Default This VPD Profile is applicable for all users who are not service providers in Oracle Transportation Management This includes all the external predicates available in the existing Default Oracle Transportation Management VPD profile and the new external predicates specific to the FTI solution s historical database tables SERVPROV This VPD Profile is applicable for all users who are also service providers Oracle Transportation Management This includes all the external predicates available in the existing SERVPROV OTM VPD profile and the new external predicates specific to the FTI solution s historical database tables As a result customers are now requested to mandatorily re
179. mns When a table or column becomes obsolete during an upgrade the table column is renamed with XX lt version object became obsolete original name of table column gt 1 To generate SQL for dropping obsolete objects run Ggen obsolete objects sgl as GLOGOWNER Note This will not include objects that just became obsolete in the current version as a safety precaution This script will generate a SQL script called drop obsolete objects sgl which you can review and run at a convenient time 7 10 Copyright 2001 2009 Oracle rights reserved Verifying Saved Queries After the upgrade some of your saved queries may no longer be valid due to changes in table structure 1 Run the following to verify the saved queries validate_saved_query sql If there are invalid saved queries you can decide what to do with them remove the records or modify them to correct the syntax ROD Maintenance for Upgrades After the 4 5 to 5 0 migration the ROD will not automatically be aware of new or changed Oracle Transportation Management tables If structural changes occurred the automatic refresh process will fail until the following steps have been completed Run the following command to create logs for new tables It will skip tables that already have a log 1 On the OLTP database in SQL Plus as GLOGOWNER run mview logs 2 On the ROD database in SQL Plus as GLOGOWNER run dbupdate_rod sql This will first
180. mpletely clean Contact Technical Support if you have any questions or concerns Migrate GC3 5 0 Database to 5 5 Updating the Structure If 5 5 CUs are available you should install the latest CU before running below database migration steps This is important as bugs if any in the database migration scripts would get fixed in the Service Releases Therefore you will not run into any known issues On the app server change to directory otm55 install path2 glog oracle script8 SQL Plus log in as GLOGOWNER Run dbupdate_55 sql to update the database with all the new tables and columns to 5 5 Enter the glogowner password reportowner password archive password and database connection when prompted qx coUo ze 5 After the process has run verify in the dbupdate 55 dbsid timestamp log file located in the same directory as source that there are no errors If the solution to the error is apparent then you can fix the problem and then rerun the dbupdate_55 sql process again without harm you may also want to rerun to see if it automatically resolves your problem Contact Technical Support if the problem is not resolvable and send the entire log file along with any other logs you have from the day to our Technical Support team Do not continue until the dbupdate 55 log is clean 7 12 Copyright 2001 2009 Oracle All rights reserved Updating Data Content 6 Update the PUBLIC data by running update_content This process
181. mplex implementations To determine the correct configuration for your production test and development environments you should work with your hardware and or implementation consultants Web User You must have any computer capable of running one of the supported browsers see the Oracle Transportation Management Technical Architecture document for a list of supported browsers Many factors will affect the performance experience of the end user including CPU type amp speed operating system version available memory hard drive speed network card speed and network bandwidth between the browser and the web server Test and Development Server e Combined Web amp App 2 x 1 9 GHz Power5 CPU 4 GB RAM 40 GB disk Note For the Report and Database servers please see the documentation associated with those products Copyright 2001 2009 Oracle All rights reserved 2 9 Production Servers Web Server 2 x 2 1 GHz Power5 CPU 4 GB RAM 40 GB disk Application Server 2 x 2 1 GHz Power5 CPU 4 GB RAM 40 GB disk Note For the Report and Database servers please see the documentation associated with those products Software Requirements AIX 5 3 with the latest Recommended Patches AIX patches for the JDK 1 4 2 Internet Explorer 6 0 SP1 or Mozilla Firefox 1 5 x for client Note Popup Blockers may prevent your browser from working correctly with Oracle Transportation Management If you experience any problems try disabling the
182. n administrator familiar with the creation and support of Oracle Database instances A Network Administrator may be necessary at times especially during the configuration of systems that will be accessed through firewalls VPN etc Note Sections that are specific to the type of Application Server being used are marked with OAS WebLogic or WebSphere Similarly operating system specifc sections are marked with AIX Linux etc Important Note Regarding Third Party Software Oracle Transportation Management uses several third party components to run the basic system Many of these are shipped with the product but several are not including some that are required to even start Oracle Transportation Management s servers Please read the ReadMe txt file included with the product documentation in the same location that you found this Administration Guide This file is also shown at the end of the install process Recommended Installation Steps Oracle Transportation Management can be installed in various configurations to provide scalability for production instances or to provide for consolidation of system resources for test development instances Production instances of Oracle Transportation Management would normally run each application layer Web Application Database Reports on separate physical servers For instance we would see the following configuration e Server One Oracle Database instance e Server Two Oracle Transp
183. n a way that Oracle needs a new copy of the data Once the views are set it refreshes the views and builds any new indexes 7 14 Copyright 2001 2009 Oracle All rights reserved 8 Advanced Configuration Note Default paths are used below and may differ from your configuration Note Whenever you edit the Oracle Transportation Management property files only edit the glog properties file Any changes that you make override the settings in other glog properties files Applying Consolidated Updates Oracle provides Oracle Transportation Management consolidated updated on a regular basis These consolidated updates include installation instructions and may require updates on any or all of the Oracle Transportation Management servers Oracle Transportation Management consolidated updates are cumulative so you get all previous fixes by installing the latest release The typical consolidated update installation takes between 45 90 minutes depending on backup time and time to run SQL scripts against database and involves a restart of the Oracle Transportation Management servers We recommend that under Production circumstances that you allocate 2 2 5 hours for the entire procedure Note Please check the release notes for the consolidated update which need to be followed in conjunction with this guide To determine which consolidated update level your server is at do the following 1 Log into your Oracle Transportation Manag
184. n earlier database release This job gathers statistics on all objects in the database that have missing statistics or stale statistics stale the underlying object has been modified significantly i e more than 10 of the rows The Scheduler runs this job during a maintenance window by default 10pm to 6am This automatic job gathers statistics by estimate and not in as much detail as the Oracle Transportation Management job Over time it tends to override detailed statistics gathered by the Oracle Transportation Management job for fast growing tables hence automatic job should be replaced by Oracle Transportation Management statistics job Below are the steps to verify that statistics are gathered by the Oracle Transportation Management statistics job 1 In SQL Plus as user GLOGOWNER run select min last_analyzed from user_tables If it returns a date older than two weeks then Oracle Transportation Management statistics job is not running since that day or it is not scheduled In that case schedule a weekly job using any job scheduler and have it run otm install dir gt oracle script8 gather_table_stats sql during a low activity period or off peak hours Note gather table stats sql also runs gather column histograms sql so both should be in same directory 2 Disable Oracle s automatic job In SQL Plus as user SYS or any DBA account run SELECT enabled FROM DBA SCHEDULER JOBS WHERE JOB GATHER STATS JOB
185. n such as the branch of the naming hierarchy to search for users the URL of the LDAP server the authentication methods to be employed and the protocol version to use A user logging in can choose which NameSpace to use for authentication or use the default In the default case Oracle 9 2 Copyright 2001 2009 Oracle All rights reserved Transportation Management allows multiple directories to be looked up one by one until successful authentication has taken place Distinguished Name A Distinguished Name or DN is the standard format for naming within LDAP directories Quite simply a distinguished name is an ordered list of naming attributes These attributes are often syntactically organized into a single string such as Doe ou Marketing o Oracle c US see RFC 1779 This name consists of Common Name Organizational Unit Organization and Country attributes The directory uses these attributes to arrange objects in the directory hierarchically So there can be multiple organizational units within an organization and multiple organizations within a country This way different branches of the LDAP tree can be searched independently For instance one might want to search only names within the organization Oracle Oracle Transportation Management requires that the user 10 field be part of the Distinguished Name at least externally to an LDAP client It also requires that each LDAP user object to be au
186. n the Application Server WebLogic WebLogic Server is an application server a runtime environment that provides infrastructure services such as database access transaction coordinator and component framework for distributed applications WebLogic Server also provides administrative features such as configurable security management and application deployment tools and clustering to promote high availability and scalability You must purchase WebLogic Server version 8 1 with Service Pack 6 from Bea Systems Inc Once you have the appropriate license you can download the appropriate executables from the Bea website We recommend that you run this installer from the server console Launch server814_aix bin or platform814 aix bin to install WebLogic Accept the license agreement Enter opt bea as the BEA Home Choose Typical Installation Install WebLogic into opt bea weblogic81 Install your License file using the directions provided by BEA Important Note You must remove a file from the WebLogic installation because of a code conflict between it and the latest J DBC drivers that Oracle Transportation Management ships with The simplest and safest way to do this is to rename the file The file in question is ox gro o m oc weblogic install path server lib odbcl4 jar rename it to be something like weblogic install path server lib odbcl4 jar bak where weblogic install path is whatever value was used in ste
187. nagement provides utilities to copy domains between Oracle Transportation Management databases There are two approaches to copy domains The first one uses a PL SQL procedure to generate INSERT statements with domain data to be copied from the source database The insert statements can be run in the target database The second approach uses Oracle TABLE mode export import with WHERE clause to move domain data between source and destination databases Please refer to the Oracle Transportation Management document titled Data Management Guide for details of this method Features Limitations e Can be used between different platforms and different operating systems e Oracle version in the target environment must be equal or higher than that in the source environment if using export import approach e Requires pre creating an Oracle database and installing an Oracle Transportation Management database in the target environment e Oracle Transportation Management table structures must be identical between the source and target database e Can just move one or more domain data between the databases Pinning Large Object in Memory This section is for a production database and an experienced DBA Oracle requires space in the System Global Area SGA for stored packages and functions If SGA space is fragmented there may not be enough space to load a package or function Oracle recommends pre allocating space in the SGA shared pool for frequently
188. namespace used in user interface display Required String example CompanyDir Only alpha numeric and underscores are allowed URL of the LDAP server Required LdapUrl String example Idap somehost 389 Principal User to log in as on LDAP server Required if authentication local Distinguished Name example Uid foo Credential LDAP principal password Required if authentication local String Copyright 2001 2009 Oracle All rights reserved 9 5 Attribute Description Valid Values UserDN Distinguished name of all users to be searched the branch of the tree to search Always specify the most specific attributes first for example supply Organizational Unit ou before Organization 0 which should be supplied before Country c etc Required Distinguished Name example ou people o acme com c US userNameAttribute Name of the User 10 attribute in the LDAP directory Required String default uid glUserAttribute Name of the GLUSER attribute in the LDAP directory Required String example gluser userAuthentication credentialAttribute Type of authentication employed for this namespace Name of the password attribute in the LDAP directory Required if authentication local Local authentication based on downloaded attributes external an LDAP bind as the user in question default String e
189. nd await the signed Certificate that you then store into a server crt file 9 When you receive the file back from the Certifying Authority you will copy this file into otm install path gt apache conf ssl crt Also copy server key from otm install path gt apache openssl bin to otm install path gt apache conf ssl key The server key file was created earlier 10 Now you have two files server key and server crt These files can be used now Edit your apache configuration file otm install path gt apache conf httpd conf Scroll to almost to the end of the file and you will see two lines SSLCertificateFile conf ssl crt demo cert SSLCertificateKeyFile conf ssl key demo key 11 Replace demo cert with the file name server crt and replace demo key with the file name server key Make sure that you put the file names at the end of the path Notice server crt is for SSLCertificateFile and server key is for SSLCertificateKeyFile The Server csr file is no longer needed 12 Restart Apache for these new settings to take effect Enable mod deflate Oracle Transportation Management can use mod deflate under Apache to compress outbound html content This reduces bandwidth consumption and increases performance over slow network links If you wish to enable this feature do the following 1 Edit the otm install path apache conf httpd conf file on each Oracle Transportation Management Web server and uncomment the follow
190. nder the heading of next date tells you when the next purge should be started Question submit select last date next date from dba jobs where job 1 but no record is returned for the query Answer This means that the purge job is not scheduled To schedule the purging job you can submit begin pkg purge install end Question It is passed the time specified in the next date column in the previous query However the total number of rows in the job queue table is still unchanged Why Answer One possibility is that the pkg purge package has become invalid after you have patched Oracle Transportation Management You can reschedule the job by submitting begin pkg_purge install end Question rescheduled the job However the total number of rows in the job_ queue table is still unchanged Why Answer Most likely the two Oracle init parameters are not set You should ask your DBA to check the two parameters Question All of my GIDs are removed from the job queue table However my shipments or orders are still not deleted or only partially deleted How can find out what is wrong Answer All of the error messages are logged in the log table You can submit select from i_log where written_by PKG_PURGE to help you diagnose the problem Question view the error log There are some fk violation related error messages Does this mean that the purging program cannot delete parent records when a chi
191. ne of the following e Oracle init parameters are not set up Pkg purge package has become invalid after an Oracle Transportation Management patch e Purging job is not scheduled The shipment order purge was developed for database archive purposes The data is purged from the glogowner schema and archived in the archive schema During purging there is a dependency between shipments and orders Shipments should be purged before orders After purging the shipments the application also purges the corresponding ship units batch grids and ship groups Corresponding means that only a shipment or order release about to be purged can reference them no other shipments or order releases may reference them You can purge either in SQL Plus or in Oracle Transportation Management The purge is a two step process 1 The GIDs from shipment order or ship unit that meet the selection criteria are moved into the table job queue 2 The Oracle background process wakes up at certain time intervals and deletes the objects The default interval is 30 minutes As mentioned earlier only ship units batch grids and ship groups referenced by a shipment or order release about to be purged are purged Ship units batch grids and ship groups not referenced by a shipment or order release about to be purged stay in the database This is to avoid Oracle Transportation Management application errors For example we do not want the following to happen e You ha
192. nect string when prompted Note The script might run for several hours depending on the amount of data to be processed 5 After the process has run verify in the dbmigrate_40_ lt dbsid gt _ lt timestamp gt log file located in the same directory as the SQL script that there are no errors 7 2 Copyright 2001 2009 Oracle All rights reserved 6 If an error occurs during a migration patch the database changes roll back It will however commit changes once a whole migration patch has been successfully applied and it will not try to migrate the data associated with that patch again If an error occurs partway through the process then you can fix the problem and rerun the process without harm If you cannot resolve the error yourself contact Technical Support Reset DB Sequences 1 In SQL Plus as user SYS run exec domainman reset_sequences sql 2 Go to the lt otm_install_path gt glog oracle script8 directory on the Oracle Transportation Management Application server In SQL Plus as user SYS run analyze_tables sql Running this script will enable you to take advantage of the latest indexes The script might run for several hours 3 Go to the otm install path gt glog oracle directory the Oracle Transportation Management Application server In SQL Plus as user GLOGOWNER run insert_security_roles sql The remaining topics are not critical to the upgrade but provide helpful information Reviewing Obsolete Ta
193. never you need to change the runtime since it will auto delete the previous job and create it again with the new time SOL exec partit submit job WW 02 30 Job 1164 has been submitted It will run next on 13 MAY 2002 02 30 Remove Jobs If you need to remove the job you can execute the partit remove job procedure SQL EXEC PARTIT REMOVE JOB WW PL SQL procedure successfully completed Since the job is submitted as a standard Oracle job you may want to read Oracle documentation about Oracle jobs and the DBMS JOB package that we utilize in our procedures If you need to manually run the purge you can do so by running purge partitioned tables sql logged in as GLOGOWNER You will be prompted for the frequency You may want to run this script if you are not automating the purge or if it fails and you would like to run it manually For example it can look like this SOL Gpurge partitioned tables This routine will truncate the oldest partition for each table that has been identified to be purged at the inputted frequency The valid values are Q for quarterly MM for monthly or WW for weekly or D for daily By purging the old data it can prepare room for the next week month or quarter Please enter a frequency Q MM WW D MM Purging partition 2 Purged partition 2 for table GL LOGIN HISTORY Purged partition 2 for table IE INROUTE SERVPR
194. nstall Only Enter all components that you wish to integrate with using a comma separated list no spaces If you are integrating with Oracle Reports server enter the following Fully Qualified Domain Name of the Oracle Reports server Port that Apache using on the Oracle Report server usually 81 c Directory that Oracle Transportation Management was or will be installed into on the Report Server e g opt otm d TNSNAMES entry of the Oracle Reports Server e click Next Select whether or not to integrate your Reports Server with a Replicated Operational Database ROD then click Next ROD only Replicated Operational Database a Fully Qualified Domain Name of the ROD Server b Port that Oracle is using on the ROD server usually 1521 c Connect String for the ROD database d SID of the ROD database e click Next If you are integrating with Fusion Transportation Intelligence FTI enter the following a Fully Qualified Domain Name of the FTI server b Port number of the FTI server C Click Next If you are integrating with FAXMaker or RightFax enter the following a Phone number that faxes will seem to originate from b Email address that the fax server polls C click Next If you are integrating with SMC RateWare server enter the following a SMC RateWare Fully Qualified Domain Name Copyright 2001 2009 Oracle rights reserved 3 5 b SMC RateWare Server Port usually 23700 c click Next 23 If you are
195. nstaller extracts to tmp and you will receive an error if there is not sufficient room there for the Installer to extract itself If you need to change this directory you must set the IATEMPDIR environment variable export IATEMPDIR some other temp directory otmv553 platform bin 3 Read the installation notice and click Next 4 Read the Third Party Software notice and click Next 5 Choose the installation directory e g opt otm or opt otm553 to denote version If you are installing more than one Oracle Transportation Management instance on a server each instance should be installed into a different directory 6 Choose which Application Server you will be using Oracle Application Server OAS WebLogic or WebSphere 3 8 Copyright 2001 2009 Oracle rights reserved 10 11 12 a b For Linux a choice is presented between OAS WebLogic amp WebSphere For AIX a choice is presented between WebLogic amp WebSphere For all other platforms a choice is presented between OAS amp WebLogic Choose Web Server to install the Web Server only and click Next Read the instructions for filling out the required data and click Next General Settings a f Enter the Web Server External Fully Qualified Domain Name e g otmweb oracle com This would work if otmweb is the server name and oracle com is the domain name If your site were accessed through a load balancer or NAT device t
196. nter the Database Server Fully Qualified Domain Name that is the name of your Database Server and the domain name e g otmdb oracle com Enter the Database Server Port This is usually 1521 Enter the Database Connect String This is the DB connect string as setup in your tnsnames ora file under the Oracle client installation Contact your Oracle Administrator for this information Enter the Database SID name click Next General Settings continued a C Enter Oracle Home Path where you installed the Oracle client u01 app oracle product 1020 for instance Enter the URL Prefix if your web server is running behind a reverse proxy or SSO solution Otherwise you can accept the default click Next Report Server Settings a b f Enter the Oracle Transportation Management Web Server IP Address Enter the Oracle Transportation Management Application Server IP Address Enter the Oracle Transportation Management Report Server FQDN ex otmrpt oracle com Enter the Report Server IP Address Apache and Tomcat on the Report Server will be bound to this IP address If you are installing more than one Oracle Transportation Management instance on a server each one should be bound to a different IP address Please contact your Network or UNIX Administrators for more information on creating virtual IP addresses within a server Enter the Report Server Apache Port usually 81 click Next Report Server Sett
197. o available physical memory on the database server As rule of thumb the System Global Area SGA or the shared memory of a database should always be allocated in the physical memory for fast data access If SGA is too large and swapped to disk paging will occur Paging usually overweighs the advantage of having a large SGA We recommend the following values for some of initial parameters DB BLOCK SIZE 8192 or at least 4096 DB CACHE SIZE 209715200 200 MB DB 16K CACHE SIZE 104857600 100 MB SHARED POOL SIZE 125829120 120 MB I SHARED SERVERS 0 LOG BUFFER 163840 160 KB SORT AREA SIZE 1048576 1 MB SORT AREA RETAINED SIZE 1048576 1 MB This parameter is ignored if PGA AGGREGATE TARGET is set OPEN CURSORS 200 JOB QUEUE PROCESS 4 This is mandatory since Oracle Transportation Management database uses scheduled jobs LOG CHECKPOINT INTERVAL Do not set this parameter if FAST START MTTR TARGET is set Otherwise set it to 0 or infinity OPTIMIZER MODE CHOOSE Oracle Transportation Management database uses cost based optimizer Setting to CHOOSE will let Oracle use CBO when there are statistics Copyright 2001 2009 Oracle rights reserved 10 1 OPTIMIZ 50 T R_INDEX_COST_ADJ Setting this parameter to encourage optimizer to favor
198. o casis aoan 8 1 PosT I NSTALLATION OBI EE INSTRUCTIONS aaa nan 8 2 CHANGING LOGGING 5 8 2 ORACLE TRANSPORTATION 8 2 NU nod A E E A 8 2 Sas esta 8 2 ORACLE APPLICATION SERVER OAS e e Dr v c P E T ua a E 8 2 WEBLOGIC rcr te C n ee e ee rie Cen d Verc a Ern e E BD C TR CA Ea e MA oe 8 2 MEBSPHERE rere ree vb ne PUR ES DX Bob ee er were Ld PEE ERR Ponda MeO dda br eau 8 2 CHANGING DATABASE POOL SIZE 8 3 CHANGING MEMORY SETTINGS 8 3 UNIX AND WINS 2 s Pet c tete rne eae age eT eee rti e e edit n et a eU d nea E POL V ERR 8 3 CHANGING NOTIFICATION SETTINGS 8 4 CHANGING PASSWORDS iueisszaswruiskhir iss EE SNR EN IS EERRRRERRP
199. o the Oracle Transportation Management product Configuring LDAP NameSpaces The glog ldap properties file is read the webserver when the first user logs in It is never read again You can bounce the Tomcat Instance if you know how to do this if you need to reload the properties The Application Server will automatically adjust The following is a sample property file containing one NameSpace 9 4 Copyright 2001 2009 Oracle rights reserved ldap searchOrder GC3 CorpDir ldap namespace name CorpDir ldqp namespace CorpDir authProtocol simple ldap namespace CorpDir ldapUrl ldap localhost 389 ldap namespace CorpDir principal otmdev ldap namespace CorpDir credential CHANGEME ldap namespace CorpDir userDN o Oracle c US ldap namespace CorpDir userNameAttribute uid ldap namespace CorpDir glUserAttribute gluser ldap namespace CorpDir userAuthentication local ldap namespace CorpDir credentialAttribute password The search order parameter is global to all NameSpaces The namespace name parameter must precede the other NameSpace parameters Other NameSpaces can be added below NameSpace Attributes Here is a list of the attributes that comprise a NameSpace Attribute Description Valid Values The Authentication Protocol to employ authProtocol None simple default CRAM MD5 v3 external authentication only DIGEST MD5 v3 external authentication only Name Of the LDAP
200. obsolete_objects sql script right after the database migration to prevent accidental dropping newly obsolete objects Verifying Saved Queries After the upgrade some of your saved queries may no longer be valid due to changes in table structure 19 Run the following to verify the saved queries validate_saved_query sql If there are invalid saved queries you can decide what to do with them remove the records or modify them to correct the syntax ROD Maintenance for Upgrades After the 5 0 to 5 5 migration the ROD will not automatically be aware of new or changed Oracle Transportation Management tables If structural changes occurred the automatic refresh process will fail until the following steps have been completed Run the following command to create logs for new tables It will skip tables that already have a log 20 On the OLTP database in SQL Plus as GLOGOWNER run QGcreate mview logs 21 On the ROD database in SQL Plus as GLOGOWNER run dbupdate_rod sql This will first identify broken views caused by obsolete columns It will then build or rebuild the materialized views for any new modified tables Note This will not automatically add columns that were added during an upgrade This is because the materialized view would need to be recreated from scratch again and you may not even need those new columns Therefore views should only need to be completely refreshed when a column has been removed or modified i
201. og config on UNIX Uncomment and modify the following lines milemaker host milemaker company com milemaker port 1031 If your MileMaker server running on port 1031 on a server named linus brown com your lines would look like milemaker host linus brown com milemaker port 1031 Once this change has been made restart your Oracle Transportation Management instance Installing SMC RateWare The following software is required e SMC RateWare Server 1 2 330 e Appropriate CZAR tariffs Install the SMC RateWare server and load the CZAR tariffs as described in your RateWare user s manual Copyright 2001 2009 Oracle All rights reserved 5 5 You can setup Oracle Transportation Management to integrate with RateWare during the initial Oracle Transportation Management installation as described earlier or you can modify an existing installation to use RateWare To modify an existing Oracle Transportation Management installation you need to edit the glog properties file on the Oracle Transportation Management Application server This file is usually under otm install path gt glog config on Windows or otm install path gt glog config on UNIX Uncomment and modify the following lines fglog RatingEngine Rateware URL rateware company com fglog RatingEngine Rateware Port 23700 If your RateWare server is running on port 23700 on a server named linus brown com your lines would look like glog RatingEngine Rat
202. oing fax notifications that you entered during the Oracle Transportation Management application server install Test this POP3 account using any email client that supports POP3 Please contact your System Administrators for more information as they will have greater insight into the makeup of your SMTP mail services Install RightFax according to the vendor s installation guide and configure it to poll the POP3 mailbox created above The configuration of Oracle Transportation Management is handled by the following properties in the App server glog properties file 4 RightFax Settings optional log fax defaultHandler routingMode to log fax defaultHandler routingPicture name lastName firstName ax rawPhone log fax email fax company com Q maa Copyright 2001 2009 Oracle All rights reserved Fax Generation in Oracle Transportation Management Fax generation is controlled via a plug and play interface FaxHandler Classes that implement this interface support the following two methods public MailAddress getAddress returns the mail address for fax generation public void handle MailEvent event FaxTopic faxTopioc modifies our standard text e mail to conform to outgoing fax specifications The fax handler is specified the property glog fax handler fax handler class name gt Oracle Transportation Management supplies a standard fax handler glog server workflow notify DefaultFaxHand
203. on feature a VRML plug in for their Web Browser is needed Oracle Transportation Management has been tested with the Cortona plug in for Internet Explorer available at http www parallelgraphics com products cortona Adobe Acrobat 6 0 for client Oracle 10g Release 2 10 2 0 3 0 Enterprise Edition or the latest version of 11g WebLogic WebLogic 8 1 with Service Pack 6 with an Advantage non clustered License WebSphere WebSphere Advanced Server 6 0 Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services optional Integration Server EAI solution optional The following software is distributed with Oracle Transportation Management OAS Oracle Application Server 10 1 3 0 patches Apache Web Server 2 0 55 Tomcat Servlet Server 5 5 16 OpenSSL 0 9 8a JRockit JDK 1 4 2 Python 2 4 2 Java Service Wrapper 3 1 2 zlib 1 2 3 The Oracle Transportation Management software is distributed on CD or via download from standard Oracle channels Preparing to Install Oracle Transportation Management Oracle Transportation Management requires the following software 2 20 Oracle Enterprise Linux 4 Update 4 with latest Oracle recommended patch bundle Copyright 2001 2009 Oracle rights reserved e Oracle 10gR2 10 2 0 3 0 Client or latest version of 11g optional for Web server required for Application server e WebLogic WebLogic 8 1 with Service Pack 6 Application server only
204. on your production site Oracle Transportation Management now supports branding by domain You should brand into the following path which eliminates the problem of overwriting branding when Oracle Transportation Management consolidated updates are installed otm install path apache htdocs xsl1 branded subdirectory Copyright 2001 2009 Oracle rights reserved 8 1 Contact Technical Support group to receive patch notifications or to download the latest Oracle Transportation Management patch See the Oracle Transportation Management Branding Guide for detailed information on branding Post Installation OBI EE Instructions 1 Your custom Webcat contents available under the OBI OracleBIData web catalog aa bk Time Stamp folder manually backed up by you will have to be manually incorporated into the new Webcat contents available under the OBI EE OracleBIData web catalog aa folder Completing this manual task will allow you to host the new Webcat contents as well as your old Custom contents Changing Logging Options After any of these settings are changed you should restart the Oracle Transportation Management instance as described in the chapter Starting Oracle Transportation Management after Installation Is Complete for the changes to take effect Oracle Transportation Management To modify the Oracle Transportation Management logging options you need to log into your Oracle Trans
205. oot user though root access will be required to run a script during the installation The user that runs the installer must have full rights to the installation directory Note Sections that are specific to the type of Application Server being used are marked with OAS WebLogic or WebSphere Red Hat Linux Red Hat AS ES 4 is also a supported platform but Oracle Transportation Management has not been certified on it In this manual wherever Oracle Enterprise Linux 4 Update 4 is referenced simply replace it with Red Hat AS ES 4 Update 5 Any Red Hat only instructions will be clearly marked as such Minimum Hardware Requirements Note this section only details the minimum hardware required to run the base Oracle Transportation Management application It does not take into account additional Oracle Transportation Management components or third party components and it is not a configuration for high volume or complex implementations To determine the correct configuration for your production test and development environments you should work with your hardware and or implementation consultants Web User You must have any computer capable of running one of the supported browsers see the Oracle Transportation Management Technical Architecture document for a list of supported browsers Many factors will affect the performance experience of the end user including CPU type amp speed operating system version available memory hard dri
206. or a the quality of third party products or services or b fulfilling any of the terms of the agreement with the third party including delivery of products or services and warranty obligations related to purchased products or services Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party Oracle is a registered trademark of Oracle Corporation and or its affiliates Other names may be trademarks of their respective owners ii Copyright 2001 2009 Oracle All rights reserved Contents SEND US YOUR COMMENTS CHANGE HISTORY a aa XI 1 ARCHITECTURE OVERVIEW 17 1 SERVER OVERVIEW m annu RRRERRARRRRRERRRRRRRRRRRRRRRRRRRRRRESRERRRRRRRRRRRARRRRRRRRERERRRRRRRRRRARARERE 1 1 WEB SERVERS ebat st rete ed dahin tate Na aj toe stehe vont tole ioc ice aat vus da pi ave 1 1 APPLICATIONSSERVERz e eut zt eeu dvi wed Sue cn s det eta utem deut rede AR a dU T Ss Ce Dd 1 2 DATABASE SERVER iiis ix YR ARA UC CO RT D VC DR EUR LER C E LATE CER e A E na 1 2 INTEGRATION SERVER X RA EU cimeanacede BIA Ris 1 2 2 INSTALLATION REQUI
207. ork for distributed applications WebSphere also provides administrative features such as configurable security management and application deployment tools and clustering to promote high availability and scalability You must purchase WebSphere version 6 0 from IBM Once you have the appropriate license you can download the appropriate executables from the Bea website You must run this installer from an X display 1 Uncompress and untar the was 6000 base linux tar gz file 2 Launch WAS install 3 Accept the license agreement 2 22 Copyright 2001 2009 Oracle rights reserved 4 may complain about the OS not being supported If you are running Red Hat AS 4 x you may ignore this warning 5 Install WebSphere into opt IBM WebSphere AppServer6 Install your License file using the directions provided by 7 Once base installation is complete install the tar gz patches one by one D a Uncompress the patch in the directory where WebSphere was installed to e g opt I BM WebSphere AppServer6 it will create a directory called updateinstaller b Run the update script e g opt IBM WebSphere AppServer6 updateinstaller update Follow the onscreen directions When it s finished run it again Repeat until it tells you that there is nothing further to install e Remove the contents of the updateinstaller maintenance directory f Repeat with next tar patch 8 Once the tar gz patches are installed install the
208. ortation Management Application server OAS WebLogic WebSphere e Server Three Oracle Transportation Management Web server Apache Tomcat e Server Four Oracle Application server Reports Optional The instructions that follow assume that you are installing a production instance of Oracle Transportation Management where the various applications reside on separate physical servers If you want to install a test or development instance of Oracle Transportation Management please see the Installing Oracle Transportation Management on a Single Server section Test instances can be consolidated on to one two three or more servers depending on the hardware availability within your organization Commonly we will see the following configuration for Test instances e Server One Oracle database instance AND Oracle Application Server Reports e Server Two Oracle Transportation Management Application Server OAS WebLogic WebSphere AND Oracle Transportation Management Web Server Apache Tomcat If the Test server has enough resources Memory CPU it is possible to run everything on a single system This should ONLY be done for test instances and is NOT recommended for any Production level use Please contact Technical Support if you have any questions Copyright 2001 2009 Oracle rights reserved 3 1 Before installing your Oracle Transportation Management instance you may decide to mount certain high growth directories on sep
209. orward them on to Technical Support Migrate the New Database You must now migrate the new database to the CU3 structure 1 Open up a shell UNIX or command prompt Windows on the APP server Important Ensure that your environment is setup correctly by running On UNIX lt otm_install_path gt install gc3env sh On Win32 lt otm_install_path gt install gc3env cmd Note Failure to do this will return many java lang NoClassDefFoundError errors and will result in the failure of the database migration to succeed which in turn will prevent you from starting up the Oracle Transportation Management instance 2 Change directory to lt otm55_install_path gt glog oracle script8 3 In SQL Plus as user GLOGOWNER run dbpatch_55 sql 4 Enter the passwords and connection strings when prompted Check the log files dbpatch log and update_content log to ensure they are error free before proceeding to the next step 3 24 Copyright 2001 2009 Oracle All rights reserved Reset Sequences 1 In SQL Plus as the GLOGOWNER user run Set serverout on size 1000000 Execute domainman reset_sequence Setup Security Roles 1 Change to the otm install path gt gc3 glog oracle directory on the Oracle Transportation Management Application server 2 In SQL Plus as the GLOGOWNER user run Qinsert security roles sql Installing the Replicated Operational Database for Reporting and Archiving A replicated op
210. ory it contains All Oracle Transportation Management servers are time synced using a process like NTP This is critical to the proper operation and troubleshooting of an Oracle Transportation Management instance Oracle 10gR2 10 2 0 3 0 Client Administrator install has been installed and configured to connect to your database The HP UX J DK 1 4 2_08 has been installed This is required so that specific libraries get installed on your system This package is available from HP s web site http www hp com products1 unix java Pre Install Setup Ensure that HP UX 11iv2 and all of the latest patches are installed The latest HP UX recommended patch bundle could be downloaded from HP at http www software hp com SUPPORT_PLUS 2 16 Copyright 2001 2009 Oracle All rights reserved After the latest Recommended patches are installed you need to install the latest patches to support the HP JDK 1 4 2 The latest patch bundles are available at http www hp com products1 unix java patches index html Note It is CRITICAL that the latest patch bundle is installed on your server Without these patches the Java JVM may not run or may be very unstable Once the HP UX operating system is installed you need to modify kernel parameters to ensure that HP UX works properly with Oracle Transportation Management 1 Use SAM to update the following kernel parameters These are minimum settings and may be higher maxusers
211. p 5 above Installing WebSphere on the Application Server WebSphere WebSphere is an application server a runtime environment that provides infrastructure services such as database access transaction coordinator and component framework for distributed applications WebSphere also provides administrative features such as configurable security management and application deployment tools and clustering to promote high availability and scalability You must purchase WebSphere version 6 0 from IBM Once you have the appropriate license you can download the appropriate executables from the IBM website 2 12 Copyright 2001 2009 Oracle All rights reserved You must run this installer from an X display Uncompress and untar the was 6000 base aix tar gz file Launch WAS install Accept the license agreement Install WebSphere into opt IBM WebSphere AppServer6 Install your License file using the directions provided by IBM Ox gu deo I Once base installation is complete install the tar patches one by one a Uncompress the patch in the directory where WebSphere was installed to e g opt I BM WebSphere AppServer6 it will create a directory called updateinstaller b Run the update script e g opt IBM WebSphere AppServer6 updateinstaller update c Follow the onscreen directions When it s finished run it again Repeat until it tells you that there is nothing further to install e Remove the contents of the updateinstaller m
212. pdate password sh opt otm 554 glog config all foobar DEFAULT will change ALL passwords to foobar but only if they are currently set to CHANGEME or DEFAULT 8 6 Copyright 2001 2009 Oracle All rights reserved Note When running this procedure for all users the application server s system user password is changed as well If you had previously changed this you will need to change it back or change it as noted under the section Application Server Users below OAS This also applies to the guest user Note The changes will not take effect until the instance is restarted Application Server Users Default Users Each type of application server has one or more users that are utilized in running Oracle Transportation Management and each user has a separate set of instructions to be used if you want to change the password None of these users may be deleted unless otherwise noted Oracle Application Server OAS The following OAS users are created oc4jadmin CHANGEME Used to stop the application server and to access the console May not be deleted Use the following steps when changing the oc4jadmin password 1 Ensure that Oracle Transportation Management is up and running 2 Log in to the OAS console http lt app_server_fqdn gt 8888 em 3 Click Setup in the upper right corner 4 Enter the current password and the new password twice then select Apply
213. plication Server e g opt IBM WebSphere AppServer6 iii Type the following all on one line where secret is your new password make note of the output specifically the stuff between the quotes e g encoded password xor LDo8LTor java bin java cp securityimpl jar iwsorb jar wsexception jar bootstrap jar emf jar ar com ibm ws security util PasswordEncoder secret iv look forthe lt authDataEntries line in the security xml file that has alias system v replace the old password xor HBceERgaEho with the newly encrypted secret passwordz xor LDo8LTor 3 Login to the application server machine as the Oracle Transportation Management user 4 Setup your environment by running otm install path2 install gc3env sh on UNIX or otm install path gt install gc3env cmd on Windows 5 Run the following command java glog util appclass Base64Encoding new password 6 This will return the encoded value for your new password 7 On the Oracle Transportation Management web server s edit the file otm install path gt tomcat bin tomcat conf search for the string DGC3EncodedPassword and change the value of this to the results of the previous step 8 Restart Oracle Transportation Management Oracle Database Users Database User ID Default Password Notes archive archive This user owns the DMP tables used for archiving the data May not be deleted
214. portation Management instance as the DBA ADMIN user Then Navigate through the following menus Data Management gt Power Data gt General gt Log Files Click Search to show all available log files For complete details please see the online help Apache To modify your Apache log settings you need to edit the configuration file httpd conf This file is usually under otm install path NVapacheNconf on Windows otm install path apache conf on UNI X Refer to your Apache documentation or http httpd apache org for more information Tomcat To modify your Tomcat log settings you need to edit the configuration file server xml This file is usually under otm install path Ntomcat conf on Windows otm install path tomcat conf on UNI X Refer to your Apache documentation or http jakarta apache org tomcat for more information Oracle Application Server OAS There are no user configurable settings for these log files WebLogic To modify your WebLogic log settings you need to use the WebLogic console Open a web browser and go to http appserver name 7001 console where appserver name is the FQDN of your Oracle Transportation Management Application server You need to login as system with the password you setup when installing WebLogic Refer to your WebLogic documentation or http e docs bea com wls docs81 index html WebSphere To modify your WebSphere log settings you need to use th
215. pply the latest CU to the database 11 In SQL Plus as user GLOGOWNER run dbpatch_55 sql 12 Enter the passwords and connection strings when prompted 13 Check the log files dbpatch log and update_content log to ensure they are error free before proceeding to the next step Run Security Role Script 14 Go to the otm install directory on the Oracle Transportation Management Application server In 5 Plus as GLOGOWNER run insert_security_roles sql 15 Shutdown your database and then restart it Analyze the Database 16 Oracle Transportation Management database should be fully analyzed after the 5 5 migration Oracle Transportation Management provides following analyze script 17 gather_table_stats sq The remaining steps are not critical to the upgrade but provide helpful information Copyright 2001 2009 Oracle All rights reserved 7 13 Reviewing Obsolete Tables and Columns When a table or column becomes obsolete during an upgrade the table column is renamed with XX lt version object became obsolete original name of table column gt 18 To generate SQL for dropping obsolete objects run gen_obsolete_objects sql as GLOGOWNER Note This will not include objects that just became obsolete in the current version as a safety precaution This script will generate a SQL script called drop_obsolete_objects sql which you can review and run at a convenient time Do not run drop_
216. problem is not resolvable and send the entire log file along with any other logs you have from the day to our Technical Support team Do not continue until the dbupdate 45 log is clean Updating Data Content 1 Update the PUBLIC data by running update content This process is run at the host command line rather than from within SQL Plus Two command scripts have been provided the script you use is dependent on your operating system UNI X shell script update content sh otm install gt glog config V45 DOS command script update content otm install gt glog config V45 2 Review the log file called update content v45 timestampz log for errors located in the same directory as the SQL script Search for errors beginning with ORA or lt Error gt within the log file This procedure migrates the data content into the table structures for the latest enhancements 3 In SQL Plus as user GLOGOWNER run 9dbmigrate 45 sgl 4 Enter the password and database connect string when prompted Note The script might run for several hours depending on the amount of data to be processed 5 After the process has run verify in the dbmigrate 45 dbsid timestamp log file located in the same directory as the SQL script that there are no errors 6 If an error occurs during a migration patch the database changes roll back It will however commit changes once a whole migration patch has been succ
217. prompted Copyright 2001 2009 Oracle rights reserved 7 7 After the process has run verify in the dbupdate 50a dbsid timestamp log file located in the same directory as source that there are no errors If the solution to the error is apparent then you can fix the problem and then rerun the dbupdate 50a sql process again without harm you may also want to rerun to see if it automatically resolves your problem Contact Technical Support if the problem is not resolvable and send the entire log file along with any other logs you have from the day to our Technical Support team Do not continue until the dbupdate 50a log is clean Migrate to 5 0 LA Updating Data Content 1 Update the PUBLIC data by running update content This process is run at the host command line rather than from within SQL Plus Two command scripts are provided and the script you use is dependent on your operating system UNI X shell script update content sh otm install path glog config V50A or DOS command script update content otm install path NglogNconfig V50A Review the log file called update content v50A timestamp log for errors located in the same directory as the SQL script Look for errors by searching key words like ORA Caught exception SP2 or lt Error gt within the log file Load the Procurement PUBLIC data by running update procure content This process is run at the host command line rather th
218. quirements Note this section only details the minimum hardware required to run the base Oracle Transportation Management application It does not take into account additional Oracle Transportation Management components or third party components and it is not a configuration for high volume or complex implementations To determine the correct configuration for your production test and development environments you should work with your hardware and or implementation consultants Web User You must have any computer capable of running one of the supported browsers see the Oracle Transportation Management Technical Architecture document for a list of supported browsers Many factors will affect the performance experience of the end user including CPU type amp speed operating system version available memory hard drive speed network card speed and network bandwidth between the browser and the web server Test and Development Server e Combined Web amp App 2 x 1 5 GHz UltraSparcllli CPU 4 GB RAM 40 GB disk space Note For the Report and Database servers please see the documentation associated with those products Production Servers e Web Server 2 x 1 6 GHz UltraSparcllli CPU 4 GB RAM 40 GB disk space e Application Server 2 x 1 6 GHz UltraSparcllli CPU 4 GB RAM 40 GB disk space Note For the Report and Database servers please see the documentation associated with those products Software Requirements Solaris 9 or
219. r s host name lt param name MaxMX APP JVM lt gt If you change this value to 1 60GB it would look like lt param name MaxMX gt 1600 lt param gt In all cases restart your Oracle Transportation Management instance to make these changes take effect Changing Notification Settings The Oracle Transportation Management server sends out a variety of notifications to users Changing these settings involves modifying the glog properties file on your Oracle Transportation Management Application server as described below glog mail smtp host smtp company com This setting defines the SMTP server that Oracle Transportation Management uses when sending email and fax notifications glog workflow notify advisor email OTMAdvisor company com This setting defines the email address that email and fax notifications will appear to come from This email address should be valid and this email box should be monitored so that bounced emails and delivery failures are caught FAXmaker will also send fax success failure responses to this email address glog workflow notify advisor fax 800 555 1212 This setting defines the fax number that fax notifications appear to come from 8 4 Copyright 2001 2009 Oracle All rights reserved glog workflow notify FAXmaker email fax company com This setting defines the e mail address of the fax server The fax server should monitor the corresponding mailbox and convert
220. racle Transportation Management In order to change the guest user s password do the following 1 Login to the application server machine as the Oracle Transportation Management user 2 Setup your environment by running lt otm_install_path gt install gc3env sh on UNIX or otm install path gt install gc3env cmd on Windows 3 Change directories to the otm install path gt glog oracle script8 directory 4 Run the following command Unix Linux update password sh config guest new password Windows Nupdate password sh config guest new password 5 Run the command java glog util appclass Base64Encoding new password gt This will return the encoded value for your new password 7 On the Oracle Transportation Management web server s edit the file lt otm_install_ path gt tomcat bin tomcat conf search for the block of code starting with wrapper java additional 1 and add an additional line with the following wrapper java additional DGuestEncodedPassword lt encoded password where is the next sequential number in the block and lt encoded password gt is the value from the previous step 8 Restart Oracle Transportation Management WebLogic WebLogic creates no new users on its own relying on the users Oracle Transportation Management creates User ID Default Password Notes system CHANGEME Used to start amp stop the application as well as manage the We
221. ransportation Management init scripts These scripts are installed under etc init d and their default names are otmweb and otmapp 4 Modify your PATH and CLASSPATH environmental variables and change them back to their original state Browsers Symptoms Your browser displays stale or incorrect data while using Oracle Transportation Management Resolution Configure your browser to Check for newer versions of stored pages Every visit to the page This will ensure that your browser displays the correct data and not cached pages Depending on your browser this option is usually under the Cache or Temporary Internet files section of the Options or Preferences window 12 2 Copyright 2001 2009 Oracle All rights reserved
222. rectly by running On UNIX lt otm_install_path gt install gc3env sh Win32 otm install path2Vinstallgc3env cmd Implementing 4 5 components within 4 0 optional To reduce migration time we have provided scripts that add new 4 5 tables and columns and in some cases populate to a 4 0 environment We recommend testing the overall timeframe of the migration without the preupdate premigrate steps If you determine downtime is too long then you can use these scripts to reduce downtime Since these steps can be performed while 4 0 is running the overall downtime of the 4 5 migration is reduced However this script should be run during off peak hours when heavy data loads are not running You can also choose to run this script while the system is down in the 4 0 environment If you plan to run these scripts it is recommended to run these steps in the weekend prior to the 4 5 upgrade 1 As GLOGOWNER run preupdate_45 sql If the pre update script cannot obtain access to a table for a new column you may see a resource busy message within the preupdate_45 log file You can either rerun pre update at another time once the table is available which will only apply the failed procedure s or wait until migration down time The step for running dbupdate_45 sql will automatically attempt to add the column at that time The ss_status_history and order_release tables have new columns that need to be populated as part of the migra
223. right 2001 2009 Oracle rights reserved 10 7 glog database dbaglogowner t2client connectionURL glog database dbaOnl y t2client connectionURLS glog database dbareportowner t2client connectionURL glog database dbaO nly t2client connectionURL 10 8 Copyright 2001 2009 Oracle All rights reserved 11 Appendix Recommended Resources For most of these products many resources are available which may better than those listed below These resources are provided for your reference and are not endorsed by Oracle Inc Oracle Transportation Management The online help for Oracle Transportation Management can be accessed once you have installed and started your Oracle Transportation Management instance The URL is http lt webserver_name gt html help webhelp en gc3_help htm Where lt webserver_name gt is the FQDN of your Oracle Transportation Management Web Server Apache The online documentation for Apache can be found at the following URL http httpd apache org docs We also recommend the following books Professional Apache by Peter Wainwright ISBN 1861003021 e Apache Server Bible by Mohammed J Kabir ISBN 0764532189 OpenSSL The online documentation for OpenSSL can be found at the following URL http www openssl org org docs Python The online documentation for Python can be found under the following URL http www python org doc Network Performance We recom
224. rs with a role of ADMIN to the BLUEPRINT OTM_ADMIN role Set the role of all users with a role of DEFAULT to the BLUEPRINT OTM_PLANNER role Create a new user 6 a ONS As MYCORP ADMIN click Configuration and Administration gt User Management gt Add User Enter a User Name of for example PLANNER Enter a Password and retype it in Retype Password Click Finished Log out Log back in as MYCORP PLANNER Oracle Transportation Management displays only the OTM_PLANNER menu Copyright 2001 2009 Oracle All rights reserved 6 7 7 Database Migration Upgrading from Version 3 7 to 4 0 Note If you are migrating from a version prior to 3 7 refer to the 4 5 Administration Manual Any new Oracle Transportation Management installation should be tested in a controlled environment before migrating your production database This ensures that any potential problems or incompatibilities don t affect your production Oracle Transportation Management instance s Note If you are migrating from a version earlier than 3 7 you must complete each previous version s migration instructions You cannot skip any migration steps Please go through all upgrade steps to 3 7 prior to starting the 3 7 to 4 0 migration IMPORTANT GC3 4 0 relies on Oracle 9i so this upgrade must occur prior to the upgrade of Oracle Transportation Management If the Oracle upgrade needs to be run at a separate time due to time constraints then we r
225. rter interval if you have Advance Analysis runs in this ROD database like every 15 minutes e Note that the initial time to run is a date but the interval is a string Examples EXEC REFRESH MAKE REFRESH GROUP P GROUP NAME lt gt 5 for SHIPMENT group uses all defaults which means set initial refresh time to be 12am the next day refresh every day with no parallelism OR EXEC PKG REFRESH MAKE REFRESH GROUP P GROUP NAME lt gt P INITIAL TIME gt trunc sysdate 2 for AA group initially starts refresh 2 days from now at 12am and refresh once a day default OR EXEC REFRESH MAKE REFRESH GROUP P GROUP lt gt INITIAL TIME gt trunc sysdate 5 p interval gt SYSDATE 15 24 60 for AA group starting 5 days from now at 12am refreshes every 15 minutes with a parallelism setting of 3 You can verify the settings by querying the view DBA REFRESH Note The DBA should check the alert log for any potential errors on a daily basis It is recommended to run the refresh during off peak hours since reports should not be run while the refresh process is occurring It does not cause errors but would cause potential report integrity problems since some tables might have been refreshed while others may not have completed Copyright 2001 2009 Oracle rights reserved 3 27 Replicated Operational Database Maintenance After an upgrade or patch the ROD will not automa
226. ry mkdir opt oraclebi 5 Install the J rockit JDK 1 5 or above currently 1 6 into the opt oraclebi jdk directory The JDK can be downloaded using the following link http commerce bea com index jsp Note Previous BEA product releases including J Rockit and service packs are available to customers with contract support accounts 6 Copy the file to the opt oraclebi directory 7 Change the permissions on the file to 755 chmod 755 jrockit R27 4 0 jdk1 5 0 12 linux ia32 bin 8 Change the owner and group on the file to oracle and dba chown oracle dba jrockit R27 4 0 jdk1 5 0 12 linux ia32 bin Note Be sure the JAVA HOME for the oracle user points to this newly installed jdk 9 Copy the OBI EE installer to a temporary directory on the server and extract the installer using the cpio command cpio idmv filename cpio idmv biee linux x86 redhat 101330 diskl cpio Copyright 2001 2009 Oracle rights reserved 4 3 10 Once the files have been extracted change the owner and group on the newly created directory and all of the sub directories to the oracle user and dba group chown R oracle dba Install OBI EE 3 4 Run the OBI EE installer When prompted enter the opt oraclebi for the Installation Location and opt oraclebi oraclebidata for the Data Location in lowercase Select the installation type as basic and proceed to the next step When prompted select the Setup
227. s as GLOGOWNER run Qcreate logon triggers sql 3 On the ROD database in SQL Plus as GLOGOWNER run dbupdate_rod sql This will first identify broken views caused by columns becoming obsolete It will then build or rebuild the materialized views for any new modified tables 7 6 Copyright 2001 2009 Oracle All rights reserved Note this will not automatically add columns that were added during an upgrade This is because the materialized view would need to be recreated from scratch again and you may not even need those new columns Therefore views should only need to be completely refreshed when a column has been removed or modified in a way that Oracle needs a new copy of the data Once the views are set it refreshes the views and builds any new indexes Upgrading from Version 4 5 to 5 0 Any new Oracle Transportation Management installation should be tested in a controlled environment before migrating your production database This ensures that any potential problems or incompatibilities don t affect your production Oracle Transportation Management instance s Note If you are migrating from a version earlier than 4 5 you must complete each previous version s migration instructions You cannot skip any migration steps Please go through all upgrade steps to 4 5 prior to starting the 4 5 to 5 0 migration The following topics outline the procedures for migrating a GC3 4 5 database to 5 0 The structure of the database to be
228. s that access Oracle Transportation Management for web tendering This is the domain that must be used for all service providers e PUBLIC This domains stores public data that can be accessed by all other domains If you are using Oracle Transportation Management in an Oracle On Demand hosted environment where many customers are using the same Oracle Transportation Management instance you need to provide On Demand staff with the appropriate domain name to maintain data confidentiality and security for your company Oracle can create the domain for you on the hosted site Note Do NOT delete any of the default domains that are shipped with Oracle Transportation Management If you have installed Oracle Transportation Management at your own site use the following procedures to create a domain Start Oracle Transportation Management and login with an ADMIN ID and password Choose Security Services gt Domain Manager Click Add Domain Type a domain name and click Submit Inquiry to create the new domain Domain names must abide by the rules for an Oracle database Pe NOS A default user called lt domain name gt ADMIN is automatically created with Admin Level security As the administrator of the new domain you should log into the new domain and change the password for the default user Choose the Manage User option in the User Manager once you log into the domain to change the password Note When you change the password of the ADMIN
229. sing will occur in serial but you can set it to 1 or higher This can improve the overall time it takes to refresh the ROD database read Planning for Parallel Propagation The higher this setting is the more data that is processing in parallel The number you set this to will be limited by the resources of your hardware Modify Refresh Time In the previous step the materialized views created were grouped into following refresh groups AA SHIPMENT OB_ORDER_BASE ORDER_RELEASE INVOICE 3 26 Copyright 2001 2009 Oracle All rights reserved S_SHIP_UNIT INTEGRATION COMMON Xxx xx in COMMON xx stands for 1 2 3 The refresh schedule for the groups has been set as below GROUP INITIAL REFRESH INTERVAL BETWEEN REFRESHES AA SYSDATE 1 Every 15 minutes other groups SYSDATE 1 Every one day If you want to change the refresh interval you can call pkg refresh make refresh group procedure This procedure accepts four parameters e Group name e Initial time the refresh job should begin e defaults to TRUNC SYSDATE 1 e when ROD is initially created it is set to 5 5 5 so that the refresh does not occur during initial setup i e 5 days from 12am of current day e Interval of time between refresh jobs e defaults to SYSDATE 1 which means to run the refresh job once a day Note even the default is once a day for AA group you should set it to much sho
230. sk Manager or Performance Monitor You should monitor general trends such as CPU usage memory usage and memory swapping out to virtual memory The Apache service starts up multiple instances of Apache to handle incoming requests Each of these will show up as Apache exe and can be monitored for performance statistics using general Windows Server tools The Tomcat service starts up one Java JVM and shows up as java exe Unfortunately this can be hard to find if you have multiple JVMs running on the same machine Usually you can identify Tomcat by the amount of memory it is using as normal Tomcat instances use large amounts of memory typically 512MB to 2GB You can monitor the performance statistics of Tomcat using general Windows Server tools Copyright 2001 2009 Oracle rights reserved 8 17 The Weblogic service starts up one but shows up as beasvc exe because of WebLogic s special service runner You can monitor the performance statistics of WebLogic using general Windows Server tools You can also get detailed performance statistics from the WebLogic console Follow these steps Log into the WebLogic console http lt appserver_name gt 7001 console as the user system In the left frame expand gc3domain gt Servers Select the Oracle Transportation Management server In the main frame select the Monitoring tab Then select the Performance tab de OO Ne This screen shows you the fol
231. sql Qcreate glog users sql The database users created have a password that matches their userid Import Oracle Transportation Management Database Structure and Public Data 1 Change to the otm install path gt gc3 glog oracle export directory the Oracle Transportation Management Application server 2 Unzip otmv55 partition zip or otmv55 nonpartition zip file 3 Modify dump file path in imp otmv55 partition par imp otmv55 nonpartition par to make sure it is the location of the dump file otmv55 partition dmp or otmv55 nonpartition dmp 4 Set environment variable ORACLE SID to your database SID If the ORACLE SID is not set within the system environment you set this within your current command prompt by typing export ORACLE 5 your ORACLE 510 gt You can check that this variable is active by typing echo ORACLE SID You should see your ORACLE SID displayed 5 Set environment variable 5 LANG to LANGUAGE TERRITORY UTF8 Here LANGUAGE is used for Oracle messages day names and month names TERRITORY specifies conventions for default calendar monetary numerical format For example if in USA you can set the parameter to AMERICAN CA UTF8 For more information on NLS LANG see the Oracle National Language Support Guide 6 At command line type replace SYSTEM PWD with the password of user SYSTEM and replace CON STR with the database connection string setup in your tnsnames ora file
232. ssociated with those products Software Requirements for Oracle Transportation Management Server Configurations e Windows 2000 Server with Service Pack 4 or e Windows 2003 Server with Service Pack 1 e Internet Explorer 6 0 SP1 or Mozilla Firefox 1 5 x for client Copyright 2001 2009 Oracle All rights reserved 2 1 Note Popup Blockers may prevent your browser from working correctly with Oracle Transportation Management If you experience any problems try disabling them before contacting Technical Support Note For users wishing to view the results generated by the Load Configuration feature a VRML plug in for their Web Browser is needed Oracle Transportation Management has been tested with the Cortona plug in for Internet Explorer available at http www parallelgraphics com products cortona Adobe Acrobat 6 0 for client Oracle 10g Release 2 10 2 0 3 0 Enterprise Edition or the latest version of 11g WebLogic WebLogic 8 1 with Service Pack 6 with an Advantage non clustered License Oracle Application Server 10gR2 10 1 2 0 2 Forms and Reports Services optional Integration Server EAI solution optional The following software is distributed with Oracle Transportation Management OAS Oracle Application Server 10 1 3 0 patches Apache Web Server 2 0 55 Tomcat J ava Servlet Server 5 5 16 OpenSSL 0 9 8a JRockit JDK 1 4 2 Python 2 4 2 Java Service Wrapper 3 1 2 zlib 1 2 3 The Oracle Transportation
233. ssword reportowner password and database connection when prompted 3 After the process has run verify in the dbupdate 40 dbsid timestamp log file located in the same directory as source that there are no errors If the solution to the error is apparent then you can fix the problem and then rerun the dbupdate 40 process again without harm Contact Technical Support if the problem is not resolvable and send the entire log file along with any other logs you have from the day to our Technical Support team Do not continue until the dbupdate 40 log is clean Updating Data Content 1 Update the PUBLIC data by running update content This process is run at the host command line rather than from within SQL Plus Two command scripts have been provided the script you use is dependent on your operating system UNI X shell script update content sh otm install path glog config dbaglogowner dbareportow ner V40 OR DOS command script update content otm install path glog config dbaglogowner dbareportowner v4o 2 Review the log file called update_content_v40_ lt timestamp gt log for errors located the same directory as the SQL script Search for errors beginning with ORA or lt Error gt within the log file This procedure migrates the data content into the table structures for the latest enhancements 3 In SQL Plus as user GLOGOWNER run dbmigrate_40 sql 4 Enter the password and database con
234. staging table The Integration server does not perform data validation Data validation occurs when data is transferred from the staging table to the Application server tables The staging table does not enforce referential integrity or constraints The Integration server and the Application server communicate to the Application server using Session Bean calls When an integration event occurs the Integration server notifies the Application server using a session bean call When the application service needs to communicate with the outside world it does so directly using an integration solution that provides a method to build transmissions and forward them to the EAI solution Copyright 2001 2009 Oracle All rights reserved 1 3 2 Installation Requirements Windows 2000 2003 Server Installation Requirements It is HIGHLY recommended that you make available personnel who are familiar with the installation and configuration of Windows based applications It is also recommended that you have an administrator familiar with the creation and support of Oracle Database instances A Network Administrator may be necessary at times especially during the configuration of systems that will be accessed through firewalls VPN etc You must be logged in as Administrator or someone with Administrative privileges to install Oracle Transportation Management successfully Note Sections that are specific to the type of Application Server being
235. stances A Network Administrator may be necessary at times especially during the configuration of systems that will be accessed through firewalls VPN etc You must run the installer as a non root user though root access will be required to run a script during the installation The user that runs the installer must have full rights to the installation directory 2 14 Copyright 2001 2009 Oracle rights reserved Note Sections that are specific to the type of Application Server being used are marked with OAS or WebLogic Minimum Hardware Requirements Note this section only details the minimum hardware required to run the base Oracle Transportation Management application It does not take into account additional Oracle Transportation Management components or third party components and it is not a configuration for high volume or complex implementations To determine the correct configuration for your production test and development environments you should work with your hardware and or implementation consultants Web User You must have any computer capable of running one of the supported browsers see the Oracle Transportation Management Technical Architecture document for a list of supported browsers Many factors will affect the performance experience of the end user including CPU type amp speed operating system version available memory hard drive speed network card speed and network bandwidth between the brows
236. tablespaces or use the provided procedure which is described below We recommend all Oracle Transportation Management tablespaces are locally managed with automatic segment space management The sizes specified above are minimal for the successful installation of Oracle Transportation Management database LOB tablespaces are used to hold LOB objects which are usually very space consuming If the database is being used immediately with integrations we recommend double the 3 18 Copyright 2001 2009 Oracle All rights reserved size of these tablespaces at the creation time We also recommend giving 20 50 more space to the other tablespaces Using Provided Procedure to Create Tablespaces We provide a SQL script create_gc3_tablespaces sql to create all tablespaces of Oracle Transportation Management database When you run this script you are prompted for options which are explained below All of the tablespaces are locally managed with uniform size set as 5MB for LOB tablespaces and 1MB for the others Only one datafile is created for each tablespace The datafiles of all tablespaces are created in the same directory that you specify If you want to create dictionary managed tablespaces and or create tablespaces in different file systems directories you should run the script with Execute Now option set to N This way the process will generate create tablespaces statements in a log file You can modify the statements and run them later
237. tall the latest patches to support the Sun JDK 1 4 2 The latest patch bundles are available at 2 6 Copyright 2001 2009 Oracle All rights reserved http sunsolve sun com pub cgi show pl target patches J 25 Note It is CRITICAL that the latest patch bundle is installed on your server Without these patches the Java JVM may not run or may be very unstable Once the Solaris 9 or 10 operating system is installed you need to modify kernel parameters to ensure that Solaris works properly with the application server 1 Edit the etc system file and add the following lines at the end of the file set rlim fd max 8192 set rlim fd cur 8192 set tcp tcp conn hash 512 32768 set shmsys shminfo shmmax 4294967295 set autoup 900 set tune t fsflushr 1 2 The following kernel parameters may improve your server s performance Your system administrator should evaluate each of the settings below and add the appropriate settings to your etc system file set maxpgio 25468 set slowscan 500 set ncsize 5000 set ufs ninode 10000 3 Update additional kernel parameters as needed for the Database Server This is covered in the Oracle DB installation documentation 4 Restart the server 5 Install the latest SUNWzlib or GNU zlib packages Creating the Oracle Transportation Management User You must add a group and user on the Application server called otm Start the Admin tool Add a group called otm Add a user calle
238. tation Management App Server Init Script Service name e g otmapp553 If installing more than one Oracle Transportation Management instance on a server this should be unique for each one 3 4 Copyright 2001 2009 Oracle rights reserved 14 15 16 17 18 19 20 21 22 b Enter SMTP Server Fully Qualified Domain Name This server name is necessary to send email notifications from within Oracle Transportation Management Please contact your Network Administrator for this information c Enter the Default Reply To Email Address that all email notifications will appear to come from This should map to a real mailbox and will allow you to check for bounced messages or delivery failures d click Next UNI X Only UNIX Settings a Enter the user name that the Oracle Transportation Management programs will run under e g otm or otm55 b Enter the group name that the Oracle Transportation Management programs will run under e g otm or otm55 click Next Choose whether or not to migrate custom settings from a previous Oracle Transportation Management installation 3 7 or later If you answer yes you ll need to choose the directory where your old glog properties file is located Click Next Choose the optional components with which Oracle Transportation Management will integrate Depending on what you choose the installer may prompt for additional configuration information a Console I
239. tation Management migration Apply GC3 3 7 Service Releases You must apply the latest GC3 3 7 Service Release before you continue with the 4 0 migration You must also install the latest Oracle Transportation Management Service Release to your GC3 4 0 installation to ensure that any known migration issues have been patched and resolved 1 Log in as GLOGOWNER and run dbpatch 37 sql which resides in the 3 7 directory otm37 install path2 glog oracle script8 Note Do not continue with the upgrade until the dbpatch log is completely clean Contact Technical Support if you have any questions or concerns Copyright 2001 2009 Oracle rights reserved 7 1 Important Ensure that your environment is setup correctly by running On UNIX otm install path install gc3env sh Win32 otm install gt NinstallNgc3env cmd Updating GLOGOWNER Grants 1 Go to the script8 directory for 4 0 otm40 install path gt glog oracle script8 2 Log on as SYSTEM 3 Run 40 mig grants sql which directly grants GLOGOWNER the ability to create and drop public synonyms versus through a role Adding Tablespaces for LOB columns 1 As the SYSTEM user run create lob tablespace sgl You are prompted for the directory in which to store the datafiles and the initial size for the tablespaces Updating the Structure 1 Run Qdbupdate 40 sql to update the database with all the new tables and columns 2 Enter the glogowner pa
240. te DocumentRoot opt oraclebi apache htdocs Directory opt oraclebi apache htdocs SSLSessionCache dbm opt oraclebi logs apache ssl scache SSLMutex file opt oraclebi logs apache ssl mutex SSLCertificateFile opt oraclebi apache conf ssl crt demo crt SSLCertificateKeyFile opt oraclebi apache conf ssl key demo key Include opt oraclebi apache conf mod jk conf ServerRoot opt otm55 apache PidFile opt otm55 logs apache httpd pid ErrorLog opt otm55 logs apache error log CustomLog opt otm55 apache bin rotatelogs sh opt otm55 logs apache access log 86400 combined CustomLog opt otm55 logs apache deflate log deflate ServerRoot opt oraclebi apache If you are copying the apache directory to another server you will also need to update the following entries in the httpd conf to point to the server where the files are being copied to 4 6 Copyright 2001 2009 Oracle All rights reserved 10 11 12 13 14 15 16 17 b Change the Listen IP addresses from the old IP to the IP of the server Also note you will need to change the ports since it will need to match what you use for your glog properties on the Oracle Transportation Management web server If you are installing the OBI app a seperate server than your Oracle Transportation Management Webserver you will not need to change the ports being used Change the user and group that will be running the
241. ted Updates added note about applying latest RU first Changing Passwords for OAS systems fixed guest password instructions Added Installing Multiple Oracle Transportation Management Instances on the Same Machine Scalability Configuration removed referred to Oracle Transportation Management Application Scalability Guide Added sections e Migrate Historical Database HD under the Preparing Oracle Transportation Management Database for Transportation Intelligence section Mandatory Oracle Transportation Management User Role VPD Profile Configuration under the Installing Fusion Transportation Intelligence chapter 9 23 09 After CU6 the following changes were made For the aa_webserver property you must now use http or https in the path xii Copyright 2001 2009 Oracle All rights reserved Copyright 2001 2009 Oracle rights reserved xiii 1 Architecture Overview Oracle Transportation Management is built for interactive environments that leverage the Internet as an information backbone to capture reference data such as updates to carriers carrier rates shipping schedules locations ports and other logistics sources The underlying architecture is a unique multi enterprise data model with n tier web and application servers partitioned database server native XML language extensible style sheets advanced data security and optimal caching
242. tent is loaded below after normal Oracle Transportation Management content loading 1 Update the Oracle Transportation Management PUBLIC data by running update content This process is run at the host command line rather than from within SQL Plus Two command scripts have been provided the script you use is dependent on your operating system UNI X shell script update content sh otm install path glog config V50B or DOS command script update content otm install path NglogNconfig V50B 2 Review the log file called update content v50B timestamp log for errors located in the same directory as the SQL script Look for errors by searching key words like ORA Caught exception SP2 or lt Error gt within the log file Copyright 2001 2009 Oracle rights reserved 7 9 3 Load the Procurement PUBLIC data by running update_procure_content This process is run at the host command line rather than from within SQL Plus Two command scripts have been provided the script you use is dependent on your operating system UNIX shell script update procure content sh lt otm_install_path gt glog config V50B or DOS command script update procure content otm install path NglogNconfig V50B 4 Review log file called update procure content v50B timestamp log for errors located in the same directory as the SQL script Look for errors by searching key words like ORA Caught exception SP2
243. th gt glog oracle script8 for recommendations other parameters Create Tablespaces The following tablespaces are required to be created first As the database grows more datafiles should be added to accommodate the application For performance purposes all tablespaces should be on different physical disks if available or on RAID 0 1 storage Required Tablespaces for Oracle Transportation Management database For a partitioned database required tablespaces and initial file sizes are listed below Tablespace Initial File Size ARCHIVE 500 MB DATA 1500 MB INDX 3000 MB REPORT 300 MB REPORTINDX 300 MB BPL_DAY1 BPL_DAY2 BPL_DAY3 BPL_DAY4 BPL_DAY5 BPL_DAY6 BPL_DAY7 PART_1 PART_2 PART 3 PART 4 LOB1 Copyright 2001 2009 Oracle rights reserved 3 17 Tablespace Initial File Size LOB2 300 MB LOB3 300 MB LOB4 300 MB LOB5 100 MB For a non partitioned database required tablespaces and initial file sizes are listed below Tablespace Initial File Size ARCHIVE 500 MB DATA 1500 MB INDX 3000 MB REPORT 300 MB REPORTINDX 300 MB LOB1 300 MB LOB2 300 MB LOB3 300 MB 1084 300 LOB5 100 MB LOB6 100 MB LOB7 100 MB TEMP 1 GB These tablespaces should be created first A database administrator can write a script to create the
244. the Fully Qualified Domain Name of your Application Server which is the name of your server and the domain name e g otmapp oracle com f click Next General Settings continued a Enter the App Server Port OAS 23791 WebLogic 7001 WebSphere 2809 Copyright 2001 2009 Oracle rights reserved 3 3 b Enter the Database Server Fully Qualified Domain Name that is the name of your Database Server and the domain name e g otmdb oracle com c Enter the Database Server Port This is usually 1521 Enter the Database Connect String This is the DB connect string as setup in your tnsnames ora file under the Oracle client installation Contact your Oracle Administrator for this information e Enter the Database SID name f click Next 10 General Settings continued a Enter Oracle Home Path where you installed the Oracle client u01 app oracle product 1020 for instance b Enter the URL Prefix if your web server is running behind a reverse proxy or SSO solution Otherwise you can accept the default C click Next 11 App Server Settings a Enter the App Server IP Address i OAS Oracle Transportation Management does not currently support running more than one Oracle Application Server instance of Oracle Transportation Management on a single box ii WebLogic WebLogic will be bound to this IP address specifically If you are installing more than one Oracle Transportation Management instance on a server e
245. the URL Prefix if your web server is running behind a reverse proxy or SSO solution Otherwise you can accept the default click Next Web Server Settings a Enter the Web Server IP Address Apache will be bound to this IP address If you are installing more than one Oracle Transportation Management instance on a server each instance should be bound to a different IP address Please contact your Network or UNIX Administrators for more information on creating virtual IP addresses within a server Enter the Web Server SSL Port usually 443 Enter the Oracle Transportation Management Web Server Service lnit Script name e g otmweb55 If installing more than one Oracle Transportation Management instance on a server this should be unique for each one This script will be created under etc init d UNIX only Enter the Tomcat Data Port usually 8009 Copyright 2001 2009 Oracle rights reserved 3 9 13 14 15 16 17 18 19 20 21 3 10 e Enter the Tomcat Shutdown Port usually 8007 Note This port must be unique for every Oracle Transportation Management instance on a physical server since it binds to 127 0 0 1 f click Next Web Server Settings continued a Enter the Tomcat Memory in Megabytes This is the amount of system memory that Tomcat will use This is 1025Mb by default but may be higher or lower depending on your configuration Note If this value is lower than 1
246. the incoming emails to faxes Changing Passwords The following lists out all of the default users created as part of a standard Oracle Transportation Management installation their default passwords and how they can to be changed Oracle Transportation Management Users Default Users A new Oracle Transportation Management installation has the following users created User ID Default Password Notes DBA ADMIN CHANGEME May not be deleted DBA DEFAULT CHANGEME SERVPROV ADMIN CHANGEME May not be deleted SERVPROV DEFAULT CHANGEME GUEST ADMIN CHANGEME May not be deleted GUEST DEFAULT CHANGEME GLOG ADMIN CHANGEME GLOG DEFAULT CHANGEME STAGE ADMIN CHANGEME STAGE DEFAULT EBS ADMIN CHANGEME CHANGEME EBS DEFAULT CHANGEME E1 ADMIN CHANGEME E1 DEFAULT CHANGEME BLUEPRINT ADMIN CHANGEME BLUEPRI NT DEFAULT CHANGEME system CHANGEME Copyright 2001 2009 Oracle rights reserved Change via the Application Server Users process below May not be deleted 8 5 Default Password Notes CHANGEME OAS Change via the Application Server Users process below May not be deleted ebs el el blueprint blueprint glog glog glogdev CHANGEME Unless otherwise noted above passwords for Oracle Transportation Management users can be changed using the Or
247. the system Also within the Server control panel Performance set the Performance boost for the foreground application to NONE e All Oracle Transportation Management servers are time synced using a process like NTP This is critical to the proper operation and troubleshooting of an Oracle Transportation Management instance e Oracle 10gR2 10 2 0 3 0 client Administrator install has been installed and configured to connect to your database Installing Oracle Application Server OAS on the Application Server OAS The necessary files will be installed as part of the Oracle Transportation Management installation no further work is needed Installing WebLogic on the Application Server WebLogic WebLogic Server is an application server a runtime environment that provides infrastructure services such as database access transaction coordinator and component framework for distributed applications WebLogic Server also provides administrative features such as configurable security management and application deployment tools You must purchase WebLogic Server version 8 1 with Service Pack 6 from Bea Systems Inc Once you have the appropriate license you can download the executables from the Bea website Run server814 win32 exe or platform814 win32 exe to install WebLogic Accept the license agreement Enter d product bea as the BEA Home Choose Typical Installation Install WebLogic into d product bea weblogic81
248. thenticated with Oracle Transportation Management be populated with the GLUSER attribute The GLUSER attribute should not be part of the Distinguished Name A fully qualified DN identifies the name of an object within an LDAP directory A relative DN identifies a branch of the naming tree but does not necessarily address a schema object LDAP Authentication Protocol An LDAP Authentication Protocol is used between an LDAP client and LDAP server to authenticate a user within the directory Oracle Transportation Management supports simple authentication clear text username amp password and some other authentication protocols such as CRAM MD5 Oracle Transportation Management also supports using no authentication at all although this is somewhat pointless These protocols can be used in both local and external authentication see below LDAP Encryption Protocol SSL Oracle Transportation Management allows encryption between the Oracle Transportation Management application server and the LDAP server This insures that password information flowing between the LDAP server and Oracle Transportation Management is not intercepted Oracle Transportation Management uses SSL Secure Socket Layer to provide this encryption SSL is a generic transport layer encryption authentication solution The LDAP directory server must support SSL in order to use this feature Although SSL can in theory be used for authentication as well SSL is used by Oracle Tr
249. thin the AS that are not utilized by Oracle Transportation Management at this time Please refer to the Oracle documentation as they are far more complete and contain in depth explanations of all installation options Follow these steps to install Oracle AS 10gR2 FR software Insert Disk1 of the Oracle AS 10gR2 FR install package Click iSetup exe Ensure your system passes the Installation Requirements Check Review the Welcome screen and click Next SON a At the Destination Oracle Home and Oracle Home Name Screen enter the Oracle Home Name i e FR HOME AS etc and the path to the new Oracle Home i e d product oracle reports10g Note Do NOT install the Oracle AS 10gR2 FR software to an existing Oracle Home This would cause any existing Oracle products including databases to become inoperable 6 Click Next 7 Choose your language usually English 8 Specify an Instance Name unique identifier for the Reports instance usually a hostname and ias_admin password The ias_admin password will be used to manage the Oracle Reports Server 9 Enter the FQDN of an SMTP mail relay server 10 Click Install on the Summary screen 11 Monitor the installation process 12 Write down the Oracle HTTP Server URL usually http lt servername gt 7777 and Oracle Enterprise Manager Application Server Control URL usually http lt servername gt 1810 The OEM AS URL is used to stop and start the Oracle Reports Serv
250. thing like AMERICAN AMERICA WE8MSWIN1252 An incorrect NLS LANG setting in this case would be AMERICAN AMERICA WE81SO8859P15 2 If characters still do not display properly then you should switch to a font that contains support for the characters you need You can find more information on how to do this from Oracle For example http otn oracle com docs tech sqgl plus content html Note To find out which font supports the characters script you need to use the Character Map utility on Windows Server Sorting Proper sorting in languages other than English can currently not be done via the Oracle Transportation Management web interface However language sensitive sorting of Oracle Transportation Management data is possible when you have direct access to the Oracle Transportation Management database with applications such as Toad and SQL Plus by setting the desired sort order as an ALTER SESSION parameter For example by issuing the command ALTER SESSION SET NLS SORT SWEDISH the sort order for the current session will be changed to Swedish Scalability Configuration See the separate Oracle Transportation Management Application Scalability Guide for instructions on how to configure Oracle Transportation Management s scalability feature BPEL Integration BPEL Flows Oracle Transportation Management provides BPEL integrations with EBS These flows can be found in otm install path utils integration bpel flows Each flow should ha
251. tically be aware of new Oracle Transportation Management tables You only need to run this when you complete all the upgrades on the OLTP in other words if you are upgrading through 2 versions on the OLTP in one weekend complete those upgrades first and then upgrade the ROD Run the following command to create logs for new tables It will skip tables that already have a log 1 On the OLTP database in SQL Plus as user GLOGOWNER run create_mview_logs 2 On the ROD database in SQL Plus as GLOGOWNER run pre_dbupdate_rod sql This script checks if any job is running and marks it as broken If there are running jobs you should see a statement like Refresh job 504 is running Please ask DBA to bounce the database Once the database is restarted no jobs will be running which allows the next step to run much faster If no refresh job is running this script will say No refresh job is running now Please go ahead to migrate the rod database now Please note that all broken jobs will be enabled in step 3 during the execution of dbupdate rod sgl 3 On the ROD database in SQL Plus as GLOGOWNER run dbupdate_rod sql This script will build or rebuild the materialized views for any new modified tables so that materialized views in ROD database are in sync with tables in OTLP database Please note that script dbupdate_rod will not refresh materialized views after they are build rebuild Materialized views will be refreshed later by refres
252. tion By running the following three database triggers will be created to maintain the data within the 4 0 environment Immediately following the creation of the triggers the fields will be populated These triggers will remain in place until your database has been fully upgraded to 4 5 2 As GLOGOWNER run premigrate_45 sql If your site chooses not to run these scripts in the 4 0 environment the dbupdate 45 and dbmigrate scripts will automatically add these changes that were not implemented during the preupdate premigrate phase The rest of the steps are all mandatory and will be performed as part of the downtime 4 5 migration 7 4 Copyright 2001 2009 Oracle rights reserved Updating GLOGOWNER Grants 1 Go to the script8 directory for 4 5 otm45 install path gt glog oracle script8 2 Log on as SYSTEM 3 Run 45 mig grants sgl Updating the Structure 1 Run dbupdate_45 sql to update the database with all the new tables and columns 2 Enter the glogowner password reportowner password and database connection when prompted 3 After the process has run verify in the dbupdate 45 dbsid timestamp log file located in the same directory as source that there are no errors If the solution to the error is apparent then you can fix the problem and then rerun the dbupdate 45 process again without harm you may also want to rerun to see if it automatically resolves your problem Contact Technical Support if the
253. tion Management Generally with more web servers you can maintain more simultaneous user connections into the Oracle Transportation Management server s web interface You may also see increased performance in integration since incoming integration files are posted to a servlet on the Web server and are passed back to the Application server We recommend using a hardware load balancer to spread the incoming requests among multiple Web servers Hardware solutions are available from many vendors including Alteon Cisco F5 and others Installing Translations Under UNI X systems 1 Log in as the Oracle Transportation Management user 2 Change the directory to otm install path gt glog oracle script8 3 Run the following command install lang sh lang id gt country id gt Under Windows Log in as the Oracle Transportation Management user Start gt Run gt cmd Change the directory to otm install path gt glog oracle script8 Bom Run the following command install lang sh lang 19 gt country id gt where valid lang id gt and country id gt values are Language Language ID Country ID Chinese Simplified zh CN Chinese Traditional zh TW French Canadian fr CA French European fr German Italian Japanese 8 16 Copyright 2001 2009 Oracle rights reserved Language Language 10 Country ID Korean ko Portuguese Brazillian pt Russian ru
254. tomcat conf as follows renumbering all other lines in this sequence wrapper java library path 2 ORACLE HOMES 1ib32 Edit the line in otm install path gt tomcat bin tomcat sh as follows LIBPATH SORACLE HOME 1i1b32 ORACLE HOME lib LIBPATH export LIBPATH where LIBPATH is the correct variable name for your OS Add a line in otm install path gt websphere profiles default bin setupCmdLine sh after the definition of PYTHON HOME and PYTHON PATH as follows LIBPATH DASH HOME lib S ORACLE 11032 50 HOME lib LIBPATH export LIBPATH where LIBPATH is the correct variable name for your OS Copyright 2001 2009 Oracle rights reserved d use Python from the console you will need to make these changes to your otm install path gt install gc3env sh file as follows LIBPATH SORACLE HOME 1i1b32 LIBPATH export LIBPATH where LIBPATH is the correct variable name for your OS Installing Oracle Transportation Management on the Reports Server The Oracle Transportation Management Install Program requires a graphical interface on Windows On UNIX we recommend that you run this installer from the server console or from an X Windows session Please contact your UNIX Administrator for more information about launching GUI based UNIX applications Also you must set the DISPLAY environment variable if again if you haven t
255. two major revisions still in use Version 2 contains most of the basic LDAP functionality RFC 1777 defines what is now called version 2 of the LDAP or LDAP v2 The LDAP v3 RFC 2251 protocol is designed to address some of the limitations of LDAP v2 in the areas of internationalization authentication referral and deployment It also allows new features to be added to the protocol without also requiring changes to the protocol itself LDAP Directories Organizing LDAP Directories For Oracle Transportation Management Oracle Transportation Management requires that the user 10 field be part of the Distinguished Name at least externally to an LDAP client It also requires that each LDAP user object to be authenticated with Oracle Transportation Management be populated with the GLUSER attribute The GLUSER attribute should not be part of the Distinguished Name Each NameSpace contains a User DN field This contains a relative DN that identifies the branch of the LDAP tree to search for users Oracle Transportation Management searches this branch and this branch only meaning no sub branches are searched If you wish to search for sub branches you must define each sub branch as a NameSpace and use the default search order to search for them one by one see NameSpaces above Many directories enforce trueness to the schema defined for a particular object This means that the object s schema must be modified to contain the attribute GLUser in
256. um Connections 8 Bulk Fetch Buffer Size bytes 9 Database Table for Jobs 10 Database Table for Instances 11 Database Table for Parameters 12 Database Table for Messages 13 DEFAULT VALUES 0 Quit Select 3 and press enter kk Oracle 10g R2 OCI 10g 60 5 33792 S NO JOB S NO INSTANCE S NO JOB PARAM S NO ERR MSG you should select 3 KKKKK Oracle 9i OCI 81 91 KKKKK 60 5 33792 S NO JOB S NO INSTANCE S NO JOB PARAM S NO ERR MSG Copyright 2001 2009 Oracle rights reserved 4 9 Copyright 2001 2009 Oracle rights reserved Enter RPTAPP for your datascource and press enter Scheduler Database Configuration 10 11 12 13 0 Database Call Interface Data Source Name User Name Password Timeout Minutes Maximum Connections Bulk Fetch Buffer Siz Database Table for Jobs Database Table for Instances Database Table for Parameters Database Table for Messages DEFAULT VALUES Quit Enter 4 and press enter Enter hdowner for the username and press enter bytes Oracle 9i 81 91 KKKKK 60 5 33792 S NO JOB S NO INSTANCE S NO JOB PARAM S NO ERR MSG Scheduler Database Configuration 10 11 12 13 0 Database C
257. un Acrobat Reader to get rid of any messages displayed the first time the program is run Open the FAXmaker Configuration program and select Fax server configuration then open Document Conversion Enter PDF in the Extension field and click Add Click OK and close out of the FAXmaker Configuration program Restart your FAXmaker services so the new configuration takes effect The configuration of Oracle Transportation Management is handled by the following properties in the App server glog properties file lt otm_install_path gt glog config glog properties FaxMaker Settings optional glog workflow notify faxmaker email fax company com Installing RightFax for Fax Notifications RightFax is an email to fax gateway that allows Oracle Transportation Management to send out fax notifications The Oracle Transportation Management application sends an email via SMTP to a specific POP3 mailbox RightFax checks this mailbox at regular intervals and converts the emails within to fax transmissions if all security requirements are satisfied 1 2 5 2 Install RightFax 8 5 from Captaris on a Windows 2000 server and configure it to work with your modem s Refer to the RightFax documentation for details Test the modem to ensure that it gets a dial tone and can access an outside line Create a POP3 mailbox within your mail server that can be accessed by the FAXmaker server The mailbox name should be identical to the email address for outg
258. un the root sh script This must be completed for a successful installation There are additional libraries that are required in order for Oracle Transportation Management to work properly Please view the README TXT file for information on where to obtain and install these additional libraries Win32 Only When finished you must restart your entire server before attempting to start Oracle Transportation Management Apply the latest Oracle Transportation Management consolidated update before starting your server Contact Technical Support if you need assistance Startup Scripts UNIX Only The startup scripts are copied to etc rc local on AIX sbin init d on HP UX and etc init d on Linux and Solaris The default names are shown below but may differ depending on what names you specified in the installer otmweb55 Oracle Transportation Management Web Server Property Files on the Oracle Transportation Management Web Server glog properties otm install path gt glog config httpd conf otm install path gt apache conf mod jk conf otm install path gt apache conf tomcat sh tomcat bat gc3 tomcat bin tomcat conf gc3 tomcat bin server xml gc3 tomcat conf Log Files on the Oracle Transportation Management Web Server glog web log otm install gt 1095 automatically rotates access log otm install path gt logs apache may grow quickly error log otm install path2 logs apache mod jk log otm
259. upport services ibm com server fixes After the latest Recommended patches are installed you need to install the latest patches to support the IBM JDK 1 4 2 The latest patch bundles are available at https techsupport services ibm com server fixes Note It is CRITICAL that the latest patch bundle is installed on your server Without these patches the may not run may be very unstable Once the AIX operating system is installed you need to modify kernel parameters to ensure that AI X works properly with the application server 1 Edit the etc security limits file and change the following parameters fsize 1 core 1 cpu 1 data 1 rss 1 stack 1 nofiles 1 2 Update additional kernel parameters as needed for the Database Server This is covered in the Oracle DB installation documentation 3 Restart the server Copyright 2001 2009 Oracle rights reserved 2 11 Creating the Oracle Transportation Management user You must add a group and user on the Application server called otm Start SMIT Add a group called otm Add a user called otm and set a password for the otm user 4 Assign the otm user to the otm group Installing Oracle Application Server OAS on the Application Server OAS ONS The necessary files will be installed as part of the Oracle Transportation Management installation no further work is needed Installing WebLogic o
260. urcesLifecycleListener i gt Listener className org apache catalina storeconfig StoreConfigLifecycleListener Global JNDI resources gt lt GlobalNamingResources gt Editable user database that can also be used by UserDatabaseRealm to authenticate users gt Resource name UserDatabase auth Container type org apache catalina UserDatabase Copyright 2001 2009 Oracle rights reserved description User database that can be updated and saved factory org apache catalina users MemoryUserDatabaseFactory pathname conf tomcat users xml lt GlobalNamingResources gt lt Define the Tomcat Stand Alone Servic gt lt Service name Catalina gt lt Define an AJP 1 3 Connector on port 8009 gt lt Connector address lt URL gt port 8009 enableLookups false protocol AJP 1 3 gt lt Define the top level container in our container hierarchy gt Engine name Catalina defaultHost lt host name gt jvmRoute jvm1 gt lt Realm className org apache catalina realm UserDatabaseRealm resourceName UserDatabase gt Host name localhost appBase webapps unpackWARs true autoDeploy false xmlValidation false xmlNamespaceAware false Context path analytics docBase opt oraclebi web app privileged true Manager className org apache catalina session Stan
261. used are marked with OAS or WebLogic Minimum Hardware Requirements Note this section only details the minimum hardware required to run the base Oracle Transportation Management application It does not take into account additional Oracle Transportation Management components or third party components and it is not a configuration for high volume or complex implementations To determine the correct configuration for your production test and development environments you should work with your hardware and or implementation consultants Web User You must have any computer capable of running one of the supported browsers see the Oracle Transportation Management Technical Architecture document for a list of supported browsers Many factors will affect the performance experience of the end user including CPU type amp speed operating system version available memory hard drive speed network card speed and network bandwidth between the browser and the web server Test and Development Server e Combined Web amp App 2 x 3 0 GHz dual core Xeon CPU 4 GB RAM 40 GB disk Note For the Report and Database servers please see the documentation associated with those products Production Servers e Web Server 2 x 2 4 GHz quad core Xeon CPU w 4 MB cache 4 GB RAM 40 GB disk e Application Server 2 x 2 4 GHz quad core Xeon CPU w 4 MB cache 4 GB RAM 40 GB disk Note For the Report and Database servers please see the documentation a
262. user s GID This can also be passed in as part of the HTTP header see below to control this behavior By default the logic checks the header first and then the request There are several properties that control SSO They must be set in the glog properties file on the Web Server glog security sso true is SSO allowed or not It is false by default glog security sso appUidName appuid to change the name of the UID field glog webserver initial_page url used if a redirect is not provided as part of the request url can either be an Oracle Transportation Management servlet or a fully qualified URL o glog webserver urlprefix glog webserver context glog webserver util Fra meGC3Servlet o http some domain com some_page html glog security sso appUidLocation x where X is of the following o 1 default check HTTP header amp then request parameter for the user name o 2 check request parameter only o 3 check HTTP header only Copyright 2001 2009 Oracle rights reserved 8 15 Installing Multiple Oracle Transportation Management Instances the Same Machine Installing multiple Oracle Transportation Management instances on the same physical or logical machine is supported However it is only supported when using virtual IP addresses Any other solution is not supported Installing Multiple Web Servers Multiple Web servers can be utilized to increase the performance of Oracle Transporta
263. ve a README TXT file in the zip file with further instructions There are several other flows that ship with the other Oracle products Refer to the respective product documentation for the details for those flows 8 32 Copyright 2001 2009 Oracle rights reserved Oracle Transportation Management Properties Files for EBS Integration through BPEL If integrating with EBS through BPEL Process Manager you need to include uncomment the ebs properties file in the glog properties file on the Oracle Transportation Management Web and Application servers These files are usually under lt otm_install_path gt glog config on Windows otm install path gt glog config on UNIX In the glog properties file you would uncomment the following include ebs properties Your line would look like this include ebs properties Once this change has been made restart your Oracle Transportation Management instance Oracle Transportation Management Properties Files for BPEL Integration If integrating with the BPEL Process Manager but not necessarily integration with EBS you will need to enable a property in the glog properties file on the Oracle Transportation Management Web and Application servers These files are usually under lt otm_install_path gt glog config on Windows otm install path gt glog config on UNIX In the glog properties file add the following glog integration enableParserInServlets tru Once this change has
264. ve just created a ship unit and you are going to use it to build a shipment e At that moment the purge job starts and removes the ship unit 8 20 Copyright 2001 2009 Oracle rights reserved Setup The shipment order or ship unit purge should have been set up during the Oracle Transportation Management database installation If not the following steps helps you set up the purge 1 Add two parameters in init ora job_queue_interval integer 60 job_queue_processes integer 4 2 Shutdown your database and then restart it 3 pkg_shipment_purge sql to compile pkg purge package in SQL Plus 4 pkg purge install to schedule a job Diagnose Problems Before you conclude that your purge did not work you should diagnose your problem 1 Log in as DBA in SQL plus 2 Find out if your Oracle database is ready to run background job sql gt show parameters job NAME TYPE VALUE job queue interval integer 60 job queue processes integer 4 3 If either value is 0 you should add these two parameters to the init ora file or directly set the values sql gt alter system set job_queue_interval 60 sql gt alter system set job_queue_processes 4 4 Find out if the purge job is scheduled sqlplus gt select job from user_jobs JOB 1 5 If the value is not 1 you should schedule the job by executing either one of the following commands salplus execute pkg purge install a number This job will
265. ve speed network card speed and network bandwidth between the browser and the web server Test and Development Server Combined Web amp App 2 x 3 0 GHz dual core Xeon CPU 4 GB RAM 40 GB disk Note For the Report and Database servers please see the documentation associated with those products Copyright 2001 2009 Oracle All rights reserved 2 19 Production Servers Web Server 2 x 2 4 GHz quad core Xeon CPU w 4 MB cache 4 GB RAM 40 GB disk Application Server 2 x 2 4 GHz quad core Xeon CPU w 4 MB cache 4 GB RAM 40 GB disk Note For the Report and Database servers please see the documentation associated with those products Software Requirements Oracle Enterprise Linux OEL 4 Update 4 with the latest Recommended Patches Note Although a 64 bit OS can be used OTM is a 32 bit application Therefor the 32 bit versions of some supporting libraries may be necessary to install on a 64 bit OEL machine The following list of such libraries that some clients have had an issue with in the past is meant to be an example list and is not exhaustive openssl compat libstdc gdbm db4 Internet Explorer 6 0 SP1 or Mozilla Firefox 1 5 x for client Note Popup Blockers may prevent your browser from working correctly with Oracle Transportation Management If you experience any problems try disabling them before contacting Technical Support Note For users wishing to view the results generated by the Load Configurati
266. ve to deal with the complexities of managing rollback segment space and can exert control over how long undo is retained before being overwritten This is the recommended method for Oracle Transportation Management If you decide using manual UNDO management you should set up your rollback segments following the guideline below Rollback segments should be designed adequately to reduce contention and prevent snapshot too old errors Most of the transactions of an Oracle Transportation Management database are small and of OLTP type The number of rollback segments is determined by the number of concurrent transactions in the database For initial settings the number of rollback segment should be set to at least four Each rollback segments also should have equal size of INITIAL and NEXT extents with MINEXTENTS equals to ten The INITIAL and NEXT extent size can be set to 2 MB The DBA should periodically monitor the rollback segment usage and adjust setting or add new segments if needed Initial Setup of Oracle Transportation Management Database There are several schema owners users and database roles that need to be created in the database Running create glog roles sgl and create 9109 users sql will get these roles and users created These two scripts should be run by user SYS because there are EXECUTION privileges on SYS s objects to be granted to Oracle Transportation Management database users Most of Oracle Transportation Management database o
267. x defaultHandler routingMode message log fax defaultHandler routingPicture firstName company lastNam rawPhone n message glog fax email fax company com Installing PCMiler g g e The following software is required e WorldWide v14 v15 v16 1 v17 v18 v19 or v20 1 with the following modules e Optional PCMiler Canada Postal Codes Install the PCMiler WorldWide as described in your PCMiler user s manual Install the PCMiler Canada Postal Codes if desired PCMiler WorldWide runs as a console application which may not be viable for production environments You may be able to use a tool such as svrany exe from the Windows Resource Kit http www microsoft com or FireDaemon http www firedaemon com to run it as a service However if PCMiler WorldWide runs as a service you should ensure that this is set to automatically start You can setup Oracle Transportation Management to integrate with PCMiler during the initial Oracle Transportation Management installation as described earlier or you can modify an existing installation to use PCMiler To modify an existing Oracle Transportation Management installation you need to edit the glog properties file on the Oracle Transportation Management Application server This file is usually under otm install path gt glog config on Windows or otm install path gt glog config on UNI X Uncomment and modify the following lines pcmiler
268. xample userpassword Connect to directory using SSL true or false true false default version The version of the LDAP protocol 2 or 3 2 default 3 ctxFactory JNDI Service Provider to use String default com sun jndi Idap LdapCtxFact ory The Distinguished Name is an ordered list of attributes and the attributes must be listed by the most specific attribute first For instance OrganizationalUnit is more specific than Organization but less specific than an individual user within that OrganizationalUnit Similarly a domain component attribute of Oracle is more specific than dc com When you specify a DN you are really specifying a path from the node you are interested in up to the root of the directory tree 9 6 Copyright 2001 2009 Oracle rights reserved Common Questions Why can t connect using local authentication even though the password attribute is present There are a number of reasons why this could happen The password attribute may not be visible to Oracle Transportation Management even though it may be visible to other clients The password could be encrypted you might want to try changing the authenticationProtocol attribute It is possible that the directory entry is not readable by the Principal being used Why does authentication fail for entries not directly below the UserDN in the directory tree This is a limitation of the LDAP client the benef
269. y rotate and are no longer overwritten at startup e The default password for the system user has changed to CHANGEME This is required for logging into the WebLogic console If your password is different you can either update it or update the Tomcat and Weblogic configuration files as described in the Changing Passwords section of Advanced Configuration chapter Installing Oracle Transportation Management on a Single Server You can install Oracle Transportation Management on a single server for testing and development purposes e Run the install program and select Web and Application servers to install both on the same server e Install all required software for the Application and Web Servers as described previously or e the install program and select Web Application and Report Servers to install all three Oracle Reports must be installed on this same physical server on the same server and follow all the prompts e Install the Oracle Database as described in this chapter Installing Oracle Transportation Management on the Application Server The Oracle Transportation Management Install Program requires a graphical interface on Win32 On UNI X we recommend that you run this installer from the server console or from an X Windows session Please contact your UNIX Administrator for more information about launching GUI based UNI X applications Also you must set the DISPLAY environment variable if again if you haven t a
270. you choose the installer will prompt for the appropriate configuration information a Console Install Only Enter all components that you wish to integrate with using a comma separated list no spaces If you are integrating with Oracle Reports server enter the following Fully Qualified Domain Name of the Oracle Reports server Port that Apache using on the Oracle Report server usually 81 Directory that Oracle Transportation Management was or will be installed into on the Report Server e g opt gc3 d TNSNAMES entry of the Oracle Reports Server e click Next Select whether or not to integrate your Reports Server with a Replicated Operational Database ROD then click Next ROD only Replicated Operational Database a Fully Qualified Domain Name of the ROD Server Copyright 2001 2009 Oracle rights reserved 22 23 24 25 26 Port that Oracle is using on the ROD server usually 1521 Connect String for the ROD database SID of the ROD database e click Next Review the summary click next when ready to proceed The file copy process may take a while and may appear to hang please be patient Once the files are copied the Install Program prompts you to begin configuring Oracle Transportation Management Click next when you are ready to proceed This step takes a few minutes typically one to five minutes UNI X Only The installer will prompt you to log in as root and r
271. zone gid America New York adj factor 0 The adj factor is added to the time zone offset So if the time zone offset for America New York was 5 and you wanted FOO to have an offset of 4 you could set the adj factor to 1 Copyright 2001 2009 Oracle rights reserved 8 31 Some of the missing Australian time zones are accounted for in the java code itself The defaults established in the code for the Australian time zones can be overridden via the missing_time_zone table International Characters in SQL Plus Windows This application supports multiple languages However you can only display characters for one language at a time The following needs to be done to properly configure this application to work in another language 1 Specify NLS_LANG as a system or environment variable on your client The NLS_LANG parameter has three components language territory and charset Examples of NLS_ LANG settings are NLS LANG AMERICAN AMERI CA WE8I SO8859P1 NLS LANG JAPANESE JAPAN J A16EUC For more information on NLS LANG see the Oracle National Language Support Guide Important the character set part of your NLS LANG setting needs to correspond to your client application character set For example in an English Windows environment the usual character set of GUI applications is the operating system code page 1252 which corresponds to the Oracle character set WE8MSWIN1252 Therefore you would set your 5 LANG to some

Download Pdf Manuals

Related Search

Related Contents

Dome pressurizzato - Bosch Security Systems  最大7台 のモニタを同時に検査、検証できます  User Manual  User instructions  ダウンロード  User's Guide to the PGF Package, Version 0.65    LED Dim Pro    

Copyright © All rights reserved. Failed to retrieve file