Autoconfig Error after clone in 12.1.3 Instance

While running autoconfig on a cloned instance , the below mentioned error occurred:


PL/SQL procedure successfully completed.

declare
*
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 32


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
adadmprf.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.

AutoConfig could not successfully execute the following scripts:
    Directory: /u01/apps/mine/inst/apps/test_mine/admin/install
      adadmprf.sh             INSTE8_PRF         1 

Solution:

1. select applications_system_name from applsys.fnd_product_groups; 

This will return the source instance sid.

2. Update the entry with target instance name:

 update applsys.fnd_product_groups set applications_system_name = '<target instance>'; 

3. Run autoconfig again. 

FRM-92101 There was a failure in forms server during startup: Error after cloning in 12.1.3 Instance

After Performing Clone from PRODUCTION to TEST : Database 11.2.0.3 and Apps 12.1.3 , while opening forms the above error occurred.


Solution:

1. $ cd $ORACLE_HOME/lib32   >>>>>>This is 10.1.2 OH

$ rm ldflags
$ ln -s $ORACLE_HOME/lib/ldflags ldflags

Then, stop the web tier services and relink the forms executable(s):

$ cd $ORACLE_HOME/forms/lib32/
$ make -f ins_forms.mk install

2. Start all Services and retest.

HCC in Exadata Database 11g

Oracle’s Hybrid Columnar Compression technology is a new method for organizing data within a database block. Storing  data in a ‘columnar’ format, where data is organized and stored by column. Otherwise row format is followed to store where all column data for a particular row is stored sequentially within a single database block.

Hybrid Columnar Compression: HCC  is a compression option available only for tables residing on Exadata Storage. 

Apart from Exadata storage, Axiom, the SPARC Super Cluster and the Sun ZFS Storage Appliance have the same technology. 

This won’t work on any other system as seen below:

SQL> alter table mine move compress for query high;

alter table mine move compress for query high

            *

ERROR at line 1:

ORA-64307: hybrid columnar compression is not supported for table spaces on this storage type

HIGH and LOW are the Options available in the above querry.

The above query was run on a non-exadata storage system.

HCC re-organizes data into Compression Units (CU). It comes in two forms; 

Warehouse Compression (add COMPRESS FOR QUERY to your table definition script)

 and Archive Compression (add COMPRESS FOR ARCHIVE to your table script).

Physical IO’s are reduced hence enhancing performance.