Oracle 12C – Error Installing EM13 Templates

oracleoracle-12c

Linux OS version working with:

Oracle Linux Server release 7.3

Oracle Database and Grid Infrastrucutre version:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Oracle Grid Infrastucture 12c Release 2

* All prerequisites met

I am getting the following error message when trying to create the database template in Oracle using dbca:

I am unsure if the error is related to a version issue or something I can't identify. If anyone has come across this issue, please will you provide a solution.

Best Answer

The column ACDRROWTSINTCOL# was added to a few dictionary tables, including TAB$, in version 12.2.

The EM templates are for version 12.1.0.2. The download page clearly states that the template should be used with 12.1.0.2.

http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/db-templates-3233309.html

Note: You can use following DB templates only with EM 13.2.0.0 release. Refer to the EM 13.2.0.0 Install guide to learn how to use these DB templates to setup database that will house the EM repository 13.2.0.0 DB templates are only for 12.1.0.2 version of DB with config types [ Single Instance and PDB ]

Related Solutions

Linux – Oracle returns an error ORA-01031: insufficient privileges

Something must have gone wrong at the O/S level - check this page for some steps to track down the problem

Oracle: Creating Case Insensitive Database with NLS_COMP and NLS_SORT

Even if you manage to create a database with nls_comp=LINGUISTIC, nls_sort=BINARY_CI (from scratch (Custom Database or manually), not seed or template) , the indexes will be still created without these settings and you have to take specify them manually.

SQL> select * from NLS_DATABASE_PARAMETERS where parameter in ('NLS_COMP', 'NLS_SORT');

PARAMETER       VALUE
--------------- ---------------
NLS_COMP        LINGUISTIC
NLS_SORT        BINARY_CI

SQL> select * from NLS_INSTANCE_PARAMETERS where parameter in ('NLS_COMP', 'NLS_SORT');

PARAMETER       VALUE
--------------- ---------------
NLS_SORT        BINARY_CI
NLS_COMP        LINGUISTIC

SQL> create table t1(id varchar2(1), something char(2000));

Table created.

SQL> insert into t1 select 'a', 'a' from dual connect by level <= 10000;

10000 rows created.

SQL> insert into t1 values ('b', 'b');

1 row created.

SQL> commit;

Commit complete.

SQL> create index t1_i1 on t1(id);

Index created.

SQL> exec dbms_stats.gather_table_stats(user, 'T1', cascade=>true, estimate_percent=>100, method_opt=>'for all columns size auto for columns id size 2');

PL/SQL procedure successfully completed.

SQL> select /*+ index(t1 t1_i1) */ count(*) from t1 where id = 'B';

  COUNT(*)
----------
         1

SQL> select * from table(dbms_xplan.display_cursor);

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  34cypvvhnwczh, child number 0
-------------------------------------
select /*+ index(t1 t1_i1) */ count(*) from t1 where id = 'B'

Plan hash value: 3724264953

---------------------------------------------------------------------------
| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |       |       |   907 (100)|          |
|   1 |  SORT AGGREGATE    |      |     1 |     2 |            |          |
|*  2 |   TABLE ACCESS FULL| T1   |  5001 | 10002 |   907   (1)| 00:00:01 |
---------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter(NLSSORT("ID",'nls_sort=''BINARY_CI''')=HEXTORAW('6200'))

Index can not be used, hint does not help, and the estimated cardinality is just simply CEIL (NUM_ROWS / NUM_DISTINCT). This time with the proper index:

SQL> create index t1_i2 on t1(NLSSORT("ID",'nls_sort=''BINARY_CI'''));

Index created.

SQL> exec dbms_stats.gather_table_stats(user, 'T1', cascade=>true, estimate_percent=>100, method_opt=>'for all columns size auto for columns id size 2, SYS_NC00003$ size 2');

PL/SQL procedure successfully completed.

SQL> select count(*) from t1 where id = 'B';

  COUNT(*)
----------
         1

SQL> select * from table(dbms_xplan.display_cursor);

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID  9pvkbfkycz6q4, child number 0
-------------------------------------
select count(*) from t1 where id = 'B'

Plan hash value: 3225262789

---------------------------------------------------------------------------
| Id  | Operation         | Name  | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |       |       |       |     1 (100)|          |
|   1 |  SORT AGGREGATE   |       |     1 |     3 |            |          |
|*  2 |   INDEX RANGE SCAN| T1_I2 |     1 |     3 |     1   (0)| 00:00:01 |
---------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - access("T1"."SYS_NC00003$"=HEXTORAW('6200'))

Best Answer

Related Solutions

Linux – Oracle returns an error ORA-01031: insufficient privileges

Oracle: Creating Case Insensitive Database with NLS_COMP and NLS_SORT

Related Question