Install and configure Apex 5.0.X embedded PL/SQL

This article presents how to install and configure Apex for version 5.0.X

Prepare software to installation

Download installation package from Oracle site and unzip.

Download apex_5.0.X.zip to directory /tmp and unzip it from
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html

cd /tmp
unzip <downloaded software>

After unzip is completed a new directory will be created /tmp/apex so go to this directory and log into database as SYSDBA. Always use SYSDBA account for running all scripts.

cd /tmp/apex
sqlplus / as sysdba

Pre-installation steps

It’s recommended to do backup of the database and disable the Oracle XMLDB HTTP server by setting the HTTP port to 0.

EXEC DBMS_XDB.SETHTTPPORT(0);

Continue reading

Patch terminology in Oracle databases

This article in short explain patch terminology used by Oracle.

New Name Old Name Description
Interim Patch PSE, MLR, Exception release, One-Off, x-fix, Hotfix, Security One-Off A patch containing one or more fixes made available to customers who cannot wait until the next patch set or new product release to get a fix.
Diagnostic Patch Diagnostic Patch, test Patch, Fix Verification Binary (FVB), e-fix An interim patch created specifically to diagnose a problem and not to fix a bug.
Bundle Patch Maintenance Pack, Service Pack, MLRs, Cumulative Patch, Update Release, Bundle Patch An iterative, cumulative patch that is issued between patch sets. Bundle patches usually include only fixes, but some may include minor enhancements. Examples are the Database Windows Bundles and SOA Bundle Patches.
Patch Set Update (PSU)
Patch Set Update (PSU) A quarterly patch that contains the most critical fixes for the applicable product, allowing customers to apply one patch to avoid many problems.
Security Patch Update (SPU)
Critical Patch Update (CPU) An iterative, cumulative patch consisting of security fixes. Formerly known as Critical Patch Update.Note that the program name which delivers SPUs will still be called Critical Patch Update, as defined below:

Oracle’s program for quarterly release of security fixes. Patches released as part of this program may be Patch Set Updates, Security Patch Updates, and Bundle Patches. Regardless of the patch type, the patches are cumulative.

 

Have a fun :)
Tomasz

Finding source code in Oracle

Finding source code written by a developer is typical task executed by a DBA or a developer.

Generally there are two basic methods to get source code:

  • select code from dictionary views – quick, simple, can return part of code, complicated to generate properly DDL
  • generate code using DBMS_METADATA package – very powerful, returns full code, easy to generate DDL code

Continue reading

NOLOGGING and recovery in Oracle

In Oracle Database NOLOGGING option used together with DIRECT mode speeds up transactions executed in a database because it limits information that Oracle writes about such transactions into redo logs and finally impacts size of generated archivelogs.

unrecoverable_transactions_1

That’s because Oracle just writes basic information about executed transaction without modified data to redo logs. Such transactions are called UNRECOVERABLE because in case of database recovery archivelogs don’t have real data only informations about executed transactions.

It can impact later restores and this article shows it.

Continue reading

Install Oracle in silent mode 12C Release 1 (12.1)

This article presents how to install Oracle 12C Release 1 in silent mode.

Silent mode installation allows to configure necessary Oracle components without using graphical interface nor any interaction with end user. It’s very useful method especially when you want to prepare standard installation using shell scripts.

Read following article to install OEL6 Linux: Install Oracle Linux 6 64 bit(for comfort set 4G memory for your virtual machine). During OEL6 installation I drop user oracle and both group dba and oinstall.

Software

Software for 12CR1 is available on OTN or edelivery

Database software

linuxamd64_12102_database_1of2.zip 
linuxamd64_12102_database_2of2.zip

Requirements

Be sure you fulfil following:

  • Oracle Linux 6 with the Unbreakable Enterprise kernel: 2.6.39-200.24.1.el6uek.x86_64 or later
  • Oracle Linux 6 with the Red Hat Compatible kernel: 2.6.32-71.el6.x86_64 or later

Continue reading

Install Oracle in silent mode 11G Release 2 (11.2)

This article presents how to install Oracle 11G Release 2 in silent mode.

Silent mode installation allows to configure necessary Oracle components without using graphical interface nor any interaction with end user. It’s very useful method especially when you want to prepare standard installation using shell scripts.

Read following article how to install Oracle Enterprise Linux 6: Install Oracle Enterprise Linux 6 (for comfort set 4G memory for your virtual machine before proceeding with Oracle software installation).

Installation software is available on OTN version 11.2.0.1 or metalink 11.2.0.4. In this installation I’m presenting installation for 11.2.0.4 but for previous version 11.2.0.X it shouldn’t be different.

Following components will be installed in silent mode:

  • oracle binaries: Oracle Enterprise Edition 11G Release 2
  • network components: listener LISTENER
  • database components: database ORA11G.dbaora.com and database console

Oracle software that was verified

release 11.2.0.4

p13390677_112040_Linux-x86-64_1of7.zip 
p13390677_112040_Linux-x86-64_2of7.zip

Continue reading

Define SecureFile LOBs during import Oracle Database 12C release 1 (12.1)

In Oracle 12C it’s possible to define LOB storage method during import time independent from export settings.

It gives more flexibility during importing data.

impdp .. TRANSFORM=LOB_STORAGE:SECUREFILE|BASICFILE|DEFAULT|NO_CHANGE
  • DEFAULT – no lob storage clause is set for CREATE TABLE
  • NO_CHANGE – use settings from dump file
  • BASICFILE – creates LOBs as basicfile
  • SECUREFILE – creates LOBs as securefile
  • Can be set in PL/SQL using DBMS_DATAPUMP.METADATA_TRANSFORM

Example

Imports data and sets LOBs as SECUREFILE

impdp hr/hr DIRECTORY=dpdump_dir DUMPFILE=hr.dmp
TRANSFORM=LOB_STORAGE:SECUREFILE

Have a fun :)

Tomasz