Skip to Content
avatar image
Former Member

ORA 43851 during System Copy with SAPINST

Hi,

Please can anybody help me out on the issue below ?

During a System Copy with SAPINST on oracle 11.2.0.2 in the ABAP IMPORT phase I got an ORA-43851 error :

DbSl Trace: ORA-43851 occurred when executing SQL stmt (parse error offset=451)

(DB) ERROR: DDL statement failed

I can see it is related to a LOB feature as below:

ORA-43851:

LOB feature unsupported below compatible 11.0.0

Cause:

An 11g LOB feature was specified when the RDBMS is operating at a compatible setting lower than "11.0.0".

Action:

Upgrade the RDBMS compatible setting to "11.0.0" or higher to enable the desired new features.

Please how can I fix it to allow SAPINST to finish successfully ?

Thanks veru for much for some help.

Best regards,

Mauricio

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 22, 2011 at 01:40 PM

    How about setting compatible = 11.2.0?

    Cheers Michael

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Folks,

      I started the instance in nomount state and found out the following:

      SQL> show parameter compatible

      NAME TYPE VALUE

      -


      -


      -


      compatible string 10.2.0

      But how can I change it ?

      I mean, there is no init.ora/spfile at this point.

      when I tried ALTER SYSTEM SET COMPATIBLE = ''11.2.0' I got:

      SQL> alter system set compatible = '11.2.0' scope=spfile;

      alter system set compatible = '11.2.0' scope=spfile

      *

      ERROR at line 1:

      ORA-32001: write to SPFILE requested but no SPFILE is in use

      SQL> alter system set compatible = '11.2.0';

      alter system set compatible = '11.2.0'

      *

      ERROR at line 1:

      ORA-02095: specified initialization parameter cannot be modified

      SQL>

      I think when I installed oracle 11.2.0 it came with this setting.

      Anh idea ?

      Thanks in advance,

      Mauricio

  • avatar image
    Former Member
    Jul 22, 2011 at 03:59 PM

    Try this:

    sqlplus

    /as sysdba

    show parameter spfile

    If you do NOT see anything in the VALUE for the parameter spfile, then the SPFILE was NOT created and you are using the PFILE. The pfile (and spfile) are located in $ORACLE_HOME/dbs directory. You have 2 options:

    1) Create an spfile

    sqlplus "/as sysdba"

    create spfile from pfile;

    shutdown immediate

    startup

    Then run your alter system command for the compatible

    shutdown immediate

    startup

    That should ensure that the parameter is loaded on the restart of the DB.

    2) cd $ORACLE_HOME/dbs

    edit the init<SID..ora

    Change the compatible parameter in the init<SID>.ora

    sqlplus "/as sysdba"

    shutdown immediate

    startup

    Now the parameter should be enabled.

    Then enable the SPFILE as shown aboe in #1.

    Good Luck,

    Mike Kennedy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi experts

      i completed sap installation with abap. i trying login through GUI in client 001 i given user sap* password 06071992 and pass.

      i also try 800 client and ddic user with 19920706. but its not working. its shows name or password is incorrect. kindly help to solve this issue.