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.
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.
Start the installation by running ./runInstaller from the installation directory
choose “skip software updates”
for any Professional DBA, applying patches is an essential and crucial process. So, to get to the point.
Oracle Database (220.127.116.11) 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) .
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 😉
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 18.104.22.168.0 – 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