ERROR => ORA-1403 after 10.2.0.4 32 bit upgrade

[Former Member]

Hi Gurus,

We have a problem after oracle upgrade 9i to 10g

The SAP instance disp+work no working, but R3trans -d is ok.

The wp table no work. ORA-1031 when accessing table SAPUSER

Please let me know how to fix this.

Regards,

[Former Member]

Hi,

The problem has been solved after applying the following steps.

select * from V$NLS_PARAMETERS where PARAMETER = 'NLS_NCHAR_CHARACTERSET';

Note 669902 - Setting the national character set to UTF8

select USERNAME,ACCOUNT_STATUS from dba_users;

ALTER USER <USER> ACCOUNT UNLOCK;

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

SAP's note was the key to correct the problem.

sqlplus /NOLOG @oradbusr.sql <schemaowner> NT <userdomain>

Apply the SAP Note: 50088

Thanks

Edited by: Gabino Sequera Flores on Aug 31, 2010 4:54 PM