on 02-12-2007 4:53 AM
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]
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Prateek,
GO through sap notes 400241 and follow the step which mention in notes
it may solve your problem
cheer
Paresh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.