Installing Oracle Database 12c in IBM AIX environment

The following is a “general purpose” procedure for 12cR1 binary instillation on AIX environment. you still need to refer to Oracle official documentation for further details and clarification.

******** Pre-requisites:

1. Operating System:

Oracle recommends that you install on AIX 6.1 Technology Level 9 or later.

AIX 7.1 Technology Level 1 Service Pack 3 (“7100-01-03-1207”) or later, 64-bit kernel

Note: You can install on AIX 7.1 Technology Level 1, but Oracle recommends that you install on AIX 7.1 Technology Level 3 or later.

2. User Profile , make sure that your profile is referencing to the right new Oracle Home.

3. check your Oracle Inventory file and the correct path.

Instillation Process:

Start the installation by running ./runInstaller from the installation directory



Choose “YES”


choose “skip software updates”




8 - original

15 14 - original 13 12 - original 10 9 8 - original 6 5 4 2 1 3


Oracle Database 11g future patches

for any Professional DBA, applying patches is an essential and crucial process. So, to get to the point.

Oracle Database ( Last patch set will be released on July 2015 !

Oracle Database (11.2.04) Last patch set will be released on January 2018 !

This shows that Oracle are pushing people to go to 12c (my humble opinion) .

Oracle Database 12c: Extended Datatypes

The datatypes of varchar2, NVARCHAR2 has increased from 4000 bytes to 32767 bytes in 12c.

After the upgrade if you try to create a table with the new size you can’t do that directly:

create table mousaem.tab1 (id number,text varchar2(32767 byte));

You will receive the below error:


To enable this feature:

1.You first need to make sure that the parameter “COMPATIBLE=12.1.0” is added to your init.ora file. usually the initialization parameter file is located under Oracle Home then dbs file system in (unix/linux) environments.


2. Then, add the following parameter in your init.ora file


3.Then you need to shut down the database

4.Then startup in “upgrade” mode


5.Then execute the script:


6.Then shutdown the database normally

SQL> shutdown immediate

7.Then “startup” normally and check the parameter


Now Try re-creating the table again ………. created successfully!!!!!


you can double check it from TOAD or Sql developer:


Interesting New Feature 😉

ORA-39000: bad dump file specification & ORA-39142: incompatible version number 4.1 in dump file for (Oracle 11g impdp, oracle 12c expdp)

after i have exported the data from my source database which is 12cR1 and imported the dump to the destination database which is 11gR2 , i faced the below error:

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39000: bad dump file specification

ORA-39142: incompatible version number 4.1 in dump file “/export/dir/test.dmp”

In order to fix this error,  you need to lower the exported dump version using the “version” parameter from the source 12cR1 database, using the command:

nohup $ORACLE_HOME/bin/expdp “‘/as sysdba ‘”  DIRECTORY=DIR DUMPFILE=test.dmp  TABLES=sch1.test_table version=11.2 logfile=test_exp.log &

remark: nohup will let the expdp command execute on the background.

so the trick is to add the “version” parameter