ORA-30014: operation only supported in Automatic Undo Management mode

[Former Member]

Experts,

I am migrating systems from 46C SR2 /HP -UX PARISC64 / oracle 8.1.7 (Source) to 46CSR2 /HP-UXIA64/oracle 10g (Target).I am using homogeneous DB copy based on R3load Procedure.After this I will upgrade the 46CSR2 to ECC6.0.

I have exported DB from Source and installing target system .I am getting error during the installation phase "BCREATEDB_IND_ORA InternalInstallationDo" as mentioned in the subject line.

What is the cause of this error .Please help.

I am attaching the log entries also for your information.

info: DBCREATEDB_IND_ORA SvrmgrDoDummy 2 656

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Dec 2 14:26:38 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> SET TERMOUT ON;

SQL> SHUTDOWN ABORT;

ORACLE instance shut down.

SQL> STARTUP NOMOUNT PFILE=init.ora;

ORACLE instance started.

Total System Global Area 163577856 bytes

Fixed Size 2048664 bytes

Variable Size 150998376 bytes

Database Buffers 8388608 bytes

Redo Buffers 2142208 bytes

SQL> CREATE DATABASE C11

2 CONTROLFILE REUSE

3 MAXDATAFILES 254

4 MAXLOGFILES 255

5 MAXLOGHISTORY 1000

6 MAXLOGMEMBERS 3

7 MAXINSTANCES 50

8 NOARCHIVELOG

9 CHARACTER SET "WE8DEC"

10 DATAFILE

11 '/oracle/C11/sapdata1/system_1/system.data1' SIZE 350M REUSE

12 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL

13 DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE

14 '/oracle/C11/sapdata1/temp_1/temp.data1' SIZE 300M REUSE

Info: DBCREATEDB_IND_ORA SvrmgrDoDummy 2 656

Return from DB: 30014.

Info: DBCREATEDB_IND_ORA SvrmgrDoDummy 2 656

15 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

16 UNDO TABLESPACE PSAPUNDO DATAFILE

17 '/oracle/C11/sapdata1/roll_1/roll.data1' SIZE 700M REUSE

18 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

19 SYSAUX DATAFILE

20 '/oracle/C11/sapdata1/sysaux_1/sysaux.data1' SIZE 100M REUSE

21 AUTOEXTEND ON NEXT 20M MAXSIZE 10000M

22 LOGFILE

23 GROUP 11 (

24 '/oracle/C11/origlogA/log_g11m1.dbf',

25 '/oracle/C11/mirrlogA/log_g11m2.dbf'

26 ) SIZE 20M REUSE

27 ,GROUP 13 (

28 '/oracle/C11/origlogA/log_g13m1.dbf',

29 '/oracle/C11/mirrlogA/log_g13m2.dbf'

30 ) SIZE 20M REUSE

31 ,GROUP 12 (

32 '/oracle/C11/origlogB/log_g12m1.dbf',

33 '/oracle/C11/mirrlogB/log_g12m2.dbf'

34 ) SIZE 20M REUSE

35 ,GROUP 14 (

36 '/oracle/C11/origlogB/log_g14m1.dbf',

37 '/oracle/C11/mirrlogB/log_g14m2.dbf'

38 ) SIZE 20M REUSE

39 ;

CREATE DATABASE C11

*

ERROR at line 1:

ORA-30014: operation only supported in Automatic Undo Management mode

Info: DBCREATEDB_IND_ORA SvrmgrDoDummy 2 656

SQL> EXIT

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

Error: DBCREATEDB_IND_ORA InternalInstallationDo 2 656

Create Database failed errorcode = 30014.

Error: DBCREATEDB_IND_ORA InstallationDo 2 656

Phase failed.

Error: Main {} 2 656

Installation aborted.

[fidel_vales · Accepted solution]

Check your initialization file (initC11.ora)

is UNDO_MANAGEMENT = AUTO ?

is UNDO_TABLESPACE = PSAPUNDO ?

[Former Member]

answered.