ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "PSAPSR3731"

[Former Member]

Hello all,

I am upgrading sap BW from 7.0 to 7.3 on Windows OS oracle 11. On preprocesing fase I have this error:

    
      Severe error(s) occured in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE!

      Last error code set: Single errors (code <= 😎 found in logfile  'DBCLONE.ELG'

8 ETGCLN START CLONING TABLES
3 ETGCLN Reading C:\usr\sum\SUM\abap\mem\TAIATRANS.DAT
3 ETGCLN START D342L -> D342L~
3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN  CREATE TABLE "D342L~" ("PROGNAME" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "STATUS" VARCHAR2 (000060) DEFAULT ' ' NOT NULL,
"TYPE" VARCHAR2 (000003) DEFAULT ' ' NOT NULL, "BLOCKNR" NUMBER (000010) DEFAULT 0 NOT NULL, "BLOBLG" NUMBER (000010) DEFAULT 0 NOT NULL,
"UDAT" VARCHAR2 (000024) DEFAULT ' ' NOT NULL, "UTIME" VARCHAR2 (000018) DEFAULT ' ' NOT NULL, "BLOCKLG" NUMBER (000010) DEFAULT 0 NOT NULL,
"BLOCK" BLOB) PCTFREE 10 PCTUSED 00 INITRANS 001 TABLESPACE PSAPSR3731 NOCOMPRESS STORAGE (INITIAL 0000010128 K NEXT 0000002560 K MINEXTENTS
0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01) LOB("BLOCK") STORE AS SECUREFILE ( NOCOMPRESS )
1EETGCLN ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "PSAPSR3731"
1EETGCLN D342L
1EETGCLN Error when cloning table structure
3 ETGCLN START D346T -> D346T~
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN  CREATE TABLE "D346T~" ("PROGNAME" VARCHAR2 (000120) DEFAULT ' ' NOT NULL, "TYPE" VARCHAR2 (000003) DEFAULT ' ' NOT NULL,
"BLOCKNR" NUMBER (000010) DEFAULT 0 NOT NULL, "BLOBLG" NUMBER (000010) DEFAULT 0 NOT NULL, "UDAT" VARCHAR2 (000024) DEFAULT ' ' NOT NULL,
"UTIME" VARCHAR2 (000018) DEFAULT ' ' NOT NULL, "BLOCKLG" NUMBER (000010) DEFAULT 0 NOT NULL, "BLOCK" CLOB) PCTFREE 10 PCTUSED 00
INITRANS 001 TABLESPACE PSAPSR3731 NOCOMPRESS STORAGE (INITIAL 0000001464 K NEXT 0000002560 K MINEXTENTS 0000000001 MAXEXTENTS
UNLIMITED PCTINCREASE 0000 FREELISTS 001 FREELIST GROUPS 01) LOB("BLOCK") STORE AS SECUREFILE ( NOCOMPRESS )
1EETGCLN ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "PSAPSR3731"
1EETGCLN D346T
1EETGCLN Error when cloning table structure

I know that SecureFiles in Oracle 11g Database Release 1 is a new part of oracle, I did tried to, as a workaround, set the following Oracle initialization parameter to: db_securefile = 'ignore'. And rester server and tried upgrade again but I have stil the same problem.

Any Idea how can I continue with this upgrade?

Should I use another value for  : db_securefile parameter ?

Or how can I Specify an ASSM tablespace for SECUREFILE lobs?

Thanks

Reza

[Former Member · Accepted solution]

Hello Tunga and Orkun,

Thanks for help, I did actually added this parameter on  Oracle initialization parameter,

But did not help but after used this command on sql:

SQL> ALTER SYSTEM SET db_securefile = 'IGNORE;.  I can continue with my upgrade.

Thanks again

[Former Member]

Hi Ejersbo Reza

check the below web link Hope it s useful for u

http://www.datasoftech.com/library/DSI_11g_Sec1.pdf

Regards

BHASKER.T

[Former Member]

Hi Reza,

Add db_securefile = 'ignore' into Oracle profile parameters. You can find the further information in the note, below;

Note 1487754 - Add. info.: Upgrade to SAP NW 7.3 ORACLE

Best regards,

Orkun Gedik