DbSl Trace: ORA-1403 when accessing table SAPUSER

[Former Member]

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

[mateus_pedroso · Accepted solution]

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.

[Paul_Babier]

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