Skip to Content
avatar image
Former Member

DbSl Trace: ORA-1403 when accessing table SAPUSER

Dear All,

I am installing SAP Solution manager 7.0 EHP1 on HP-UX.

DB is oracle 10.2.0.2.

At time of installation I am getting error at phase ABAP IMPORT.

I am getting below error in installtion log:

Loading of 'SAPNTAB' import package: ERROR

Import Monitor jobs: running 0, waiting 29, completed 0, failed 1, total 30.

WARNING[E] 2010-08-06 11:53:54.590

CJSlibModule::writeError_impl()

CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.

I checked import_monitor.java.log and import_monitor.log. Both file indicating to check SAPNTAB.log file for detail information. Below is log of SAPNTAB.log file.

SAPNTAB.log-->

__________________________________________________________

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(RFF) ERROR: /oracle/SLM/soldump/export/51036442_2/DATA_UNITS/EXP4/DATA/SAPNTAB.TOC is not from the same export as /oracle/SLM/soldump/export/51036442_2/DATA_

UNITS/EXP4/DATA/SAPNTAB.001

____________________________________________________________

Thanks and regards,

Pramod

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 07, 2010 at 02:45 PM

    ORA-01403: no data found

    Log entries: Logon as OPS$ user to get <sapowner>'s password Connecting as /@<sid> on connection 0 ...

    Now I'm connected to ORACLE

        • ERROR => ORA-1403 when accessing table SAPUSER

        The main cause of ORA-01403 is that the table SAPUSER does not contain any entries. Therefore, proceed as follows:

        o Use the following BRCONNECT call (BRCONNECT 6.10 or higher) to set the password consistently in SAPUSER and in the Oracle DDIC:

        brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

        o Alternatively, you can insert it in SAPUSER manually.

        INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

        Another possible cause is that SAPUSER contains incorrect entries. The system always uses the user name to select from SAPUSER. Therefore, you must ensure that the user name is always uppercase (SAPR3 or SAP<sid>) and that it corresponds exactly to the value of the environment variable dbs_ora_schema if SAP<sid> is used.

        o If the system continues to issue ORA-01403, see the "General checks"section once again.

        Add comment
        10|10000 characters needed characters exceeded

      • Aug 09, 2010 at 09:35 PM

        Hello,

        You may also want to review the following notes"

        4001241 - Problems with OPS$ or SAPR3 connect to Oracle

        103133 - SAPDBA: ORA-01403 for adding data file

        142579 - Invalid DBMS_AQ_IMPORT_INTERNAL / export problems

        534765 - DB Connect fails because of wrong DB schema in environment

        There you should find some guidance on actions to correct.

        Hope this is helpful.

        Regards,

        Paul

        Add comment
        10|10000 characters needed characters exceeded