cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01017: invalid username/password; after Oracle Upgrade 9.2.06 to 10.2

Former Member
0 Kudos

Hi

I did an oracle Upgrade from Oracle Upgrade 9.2.06 to 10.2 as per SAP Documentation.

and after the upgrade was successful i changed the password of SAPABT (sapowner)

and now it is giving an error in work folder <b>dev_wo</b>

while connecting can any one help please ?

Tue Feb 06 18:55:20 2007

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPABT's password

C Connecting as /@ABT on connection 0 (nls_hdl 0) ... (dbsl 640 110706)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 044FAB58 045000D4 044FF95C

C Attaching to DB Server ABT (con_hdl=0,svchp=044FF8A8,svrhp=04503F14)

C Starting user session (con_hdl=0,svchp=044FF8A8,srvhp=04503F14,usrhp=08C48D68)

C Now '/@ABT' is connected (con_hdl 0, nls_hdl 0).

C Got SAPABT's password from OPS$-user

C Disconnecting from connection 0 ...

C Close user session (con_hdl=0,svchp=044FF8A8,usrhp=08C48D68)

C Now I'm disconnected from ORACLE

C Connecting as SAPABT/<pwd>@ABT on connection 0 (nls_hdl 0) ... (dbsl 640 110706)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 044FAB58 045000D4 044FF95C

C Starting user session (con_hdl=0,svchp=044FF8A8,srvhp=04503F14,usrhp=08C48D68)

C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017

[dboci.c 4473]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11297]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#3 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#3 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#2 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#2 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1284]

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Have you done the password change using oralce methods or using BRCONNECT.

If u change using oracle , it will not update the password in the SAPUSER table.

The work process always connects as its corresponding OPS$ user with operating system authentication. The work process select the SAP<SCHMAID>(in your case it is SAPABT) password in Table SAPUSER.

When you change using Oracle methods, it will not update the password in the SAPUSER table. If you use BRCONNECT method to change the password of the SAPABT user, It will update in the SAPUSER table also.

If you have not done using BRCONNECT , please do the same.

Call BRTOOLS, Select Additional Functions --> Change password for sap user.

Might be this will help you.

Regards

Upender Reddy

Former Member
0 Kudos

SQL> connect / as sysdba

Connected.

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

OWNER

-


OPS$CTSINTCOSNW5\ABTADM

SQL> SELECT OWNER, TABLE_OWNER, TABLE_NAME FROM DBA_SYNONYMS WHERE SYNONYM_NAME

= 'SAPUSER';

OWNER TABLE_OWNER

-


-


TABLE_NAME

-


OPS$CTSINTCOSNW5\SAPSERVICEABT OPS$CTSINTCOSNW5\ABTADM

SAPUSER

SQL>

Followed the note 400241 Problems with ops$ or sapr3 connect to Oracle

Problem got solved via the

Updating BR * Tools

brconnect -u / -c -f stats -t all -f collect -p 4 in Oracle Database Guide 4.3.6 BRCONNECT

Call BRTOOLS, Select Additional Functions --> Change password for database user.

in my case it is sapabt user

Thanks for the quick reply

Former Member
0 Kudos

Followed Upgrade Guide in other documentation

Oracle Upgrade Guide

5.9 Performing Post Upgrade Tasks

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Prateek,

GO through sap notes 400241 and follow the step which mention in notes

it may solve your problem

cheer

Paresh

Former Member
0 Kudos

Problem solved

Former Member
0 Kudos

Could you tell me how can you solve this problem?

Former Member
0 Kudos

Hello,

The error indicate that the password on the SAPUSER table does not matches the password for the user.

The following command is an alternative to change the password:

brconnect -u system/<syst_pwd> -f chpass -o SAPABT -p <new_sap_pwd>