Installation ODI 12.1.3: step by step


This document describes the installation of Oracle Data Integrator Version 12.1.3 on the Linux (OEL) Server.

Prepare the Installation

Minimal Server Requirements

 

Check the Oracle Documentation for the Prerequisites. Your Server must have following (min.) Settings;

RAM:    8 GB

Disk:    20 GB

Temp:    2 GB

Swap:    8 GB

Enable Unicode Support

Oracle Documentation:

Your operating system configuration can influence the behavior of characters supported by Oracle Fusion Middleware products.

On UNIX operating systems, Oracle highly recommends that you enable Unicode support by setting the LANG and LC_ALL environment variables to a locale with the UTF-8 character set. This enables the operating system to process any character in Unicode

Continue reading

Advertisements

PL SQL Code to Reset Sequence Every Day


I found two methods to reset a sequence daily.

First approach is using a function and a profile option.

Below function is used to reset the sequence every day. It is not advisable to use a sequence in this manner, but for a requirement I had to reset a sequence every day.

This method uses a profile option named ‘XX_SEQ_DATE’ to store current date. It has to be initialized, and the parameter p_user_id needs to be set from fnd_user value.

A sequence is created using:

CREATE SEQUENCE XX_SEQ
START WITH 1
MAXVALUE 99
MINVALUE 1
CYCLE
NOCACHE
NOORDER
/
Continue reading

Perbedaan Web Server & Application Server


Web server memberikan layanan untuk tampilan pada web browser, sedangkan Application server menyediakan operasi yang bisa dipanggil oleh aplikasi client. Singkatnya kita bisa katanan bahwa Web Server secara eksklusif menghandel HTTP request, sedangkan Application Server memberikan layanan bussiness logic untuk suatu aplikasi yang dimungkinkan melalui beberapa protokol, termasuk bisa juga lewat HTTP.

Web Server

Web server memberikan layanan permintaan melalui protokol HTTP. Ketika Web server menerima sebuah request via HTTP atau HTTP request, dia akan merespon dan memberikan HTTP response, seperti mengirimkan halaman HTML. Dalam memproses request, web server bisa jadi akan merespon dengan halaman statik HTML atau gambar, mengirimkan redirect atau akan memberikan permintaan atau request tersebut ke script program dinamis yang lain seperti CGI, JSP dsb. Jadi pada umumnya, web server akan memberikan respon dalam bentuk halaman HTML umntuk pada akhirnya di tampilkan di web browser.

Continue reading

Auditing in Oracle Database


The auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary.

Every time a user attempts anything in the database where audit is enabled the Oracle kernel checks to see if an audit record should be created or updated (in the case or a session record) and generates the record in a table owned by the SYS user called AUD$. This table is, by default, located in the SYSTEM tablespace. This itself can cause problems with potential denial of service attacks. If the SYSTEM tablespace fills up, the database will hang.

init parameters

Until Oracle 10g, auditing is disabled by default, but can be enabled by setting the AUDIT_TRAIL static parameter in the init.ora file.

From Oracle 11g, auditing is enabled for some system level privileges.

SQL> show parameter audit

NAME

TYPE

VALUE

———————-

————

————-

audit_file_dest

string

?/rdbms/audit

audit_sys_operations

boolean

FALSE

audit_syslog_level

string

NONE

audit_trail

string

DB

transaction_auditing

boolean

TRUE

AUDIT_TRAIL can have the following values.

Continue reading