Reasons of RMAN Database Backup Failure

Reasons of RMAN Database Backup Failure

-Network issue
-Space issues in mount
-Tablespace full
-Directory permission issue

What is your backup strategies for Database

What is your backup strategies for Database?

-Rman backup's are scheduled through crontab.
-We have full backup policy on Saturday, everyday we have incremental backups.
-Archives are backed up every two hours from archive destination to tapes.

What is Oracle Transportation Management (OTM)

What is Oracle Transportation Management (OTM)?

OTM stands for Oracle Transportation Management, it is a software/product/solution designed to automate logistics business processes like optimizing shipping costs, sending tender requests to service providers (carriers) and similar other functionalities related to logisitcs business.

Oracle Transportation Management History:

-Oracle Transport Management (OTM) is a product acquired from a company called Global Logistics, Inc (G-LOG)
-OTM was initially called GC3 (Global Command and Control Center)
-G-LOG was founded in May 1999 by Tim Sensing.
-Fedex was the first customer for GC3.
-G-Log was acquired by Oracle Corporation in November 2005.

Modules of Oracle Transportation Management:

-Forwarding and Brokerage Operations.
-Operational Planning.
-Sourcing.
-Freight Payment, Billing and Claims.
-Logistics Inventory Visibility
-Cooperative Routing
-Fleet Management.
-In-Memory Logistics Command Center.
-Fusion Transport Intelligence.

Versions of Oracle Transportation Management:

6.3.4 - June 2014
6.2
6.1 - May 2011
6.0 - April 2009
5.5 - August 2009
5.0 - January 2007

OTM Important Log files

OTM Important Log files

=>OTM web server log file Location

cd $OTM_HOME/logs/tomcat
-rw-r--r--. 1 oracle dba    0 Nov  9 10:55 startup.out
-rw-r--r--. 1 oracle dba  51K Nov  9 10:54 shutdown.log.0
-rw-r--r--. 1 oracle dba 2.3M Nov  9 11:49 console.log.0

=>OTM App server log file location

cd $OTM_HOME/logs/weblogic
-rw-r--r--. 1 oracle dba 865K Nov  9 10:56 weblogic.log
-rw-r--r--. 1 oracle dba 2.2M Nov  9 11:30 console.log.0

How many ways we can do OTM Installation

How many ways we can do OTM Installation?

We can do OTM installation in three ways:

1) GUI
./otmv635_<platform>.bin

2) CONSOLE
./otmv635_<platform>.bin –i console

3) SILENT
./otmv635_<platform>.bin –i silent –f installer.properties

Oracle Transport Management OTM Database Users

Oracle Transport Management OTM Database Users

-Archive
This user owns the DMP tables used for archiving the data. May not be deleted.

-GLOGDBA
This user has access to functions and packages owned by glogowner and 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
This user owns OTM tables, views, functions and packages, can create or alter data structures within the database and can manipulate data. May not be deleted.

-GLOGLOAD
Used for loading data into glogowner and reportowner schemas. May not be deleted.

-DIR_XML_USER
This user should be use for Direct XML integration. This user has the minimum privileges to successfully insert XML transmissions into database objects when using the Direct XML integration feature.

-REPORTOWNER
This user owns the tables, views, functions and packages required for reporting, and can read the data. May not be deleted.

-GLOBALREPORTUSER
This user has read access to all the data in OTM. It is mainly used for reporting. May not be deleted.

-HDOWNER
This user owns FTI tables, views, functions and packages, can create or alter data structures within the database and can manipulate data. May not be deleted.