on 04-02-2016 4:38 PM
Hello!
We need your help!
We are making upgrade SAP Enterprise Portal (Java Stack) from 7.02 to 7.4 NW
When we run SUM (SP16 PL6) we immediately receive the following error message
---------------------------------------------------------------------------------------------
Severe error(s) occurred in phase PREP_EXTRACT/PREIMP!
Last error code set: Single errors (code <= 😎 found in logfile 'PREIMP.ELG'
ERROR:
Detected the following errors:
# /oracle/SUM/abap/log/R710VPE.DPT:
4 ETW000 TRACE-INFO: 58: [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 TRACE-INFO: 59: 26 0.944185
4 ETW000 TRACE-INFO: 60: [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 9 0.944194
4 ETW000 TRACE-INFO: 61: [ dblink ,00000] ***LOG BY2=>sql error 1017 performing CON 3741 0.947935
4 ETW000 TRACE-INFO: 62: [ dblink ,00000] ***LOG BY0=>ORA-01017: invalid username/password; logon denied 8 0.947943
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DPT'"
Trouble Ticket Generation
A trouble ticket and an archive with all relevant log files have been generated.
Trouble ticket: "/oracle/SUM/abap/log/SAPup_troubleticket.log"
Log archive: "/oracle/SUM/abap/log/SAPup_troubleticket_logs.sar"
------------------------------------------------------------------------------
This log and attached R710VPE.DPT file might mean that OPS$ mechanism is not adjusted and the SUM check demands working OPS$.
I found notes and studied them
157499 - OPS$ connect and security aspects
400241 - Problems with ops$ or sapr3 connect to Oracle
Also the notes
361641 - Creating OPS$ users on UNIX
50088 - Creating OPS$ users on Windows NT/Oracle
According to the notes, I tried running script ORADBUSR.SQL to create OPS$ user but unsuccessfully.
Script ORADBUSR.SQL generates the error below. The script might be trying to create a user with a password and cannot do it because of the password policy. I couldn’t find where the password appears in the script.
Incidentally, did I write the command string for the script in my case correctly?
sqlplus /NOLOG @ORADBUSR.SQL SAPSR3DB UNIX DPT X
using following Parameters:
.
. Oracle Version: 11.2.0.4.0
. Parametervalue os_authent_prefix: OPS$
. Schema Id: SR3
. Database User (Schema): SAPSR3DB
. SAP R/3 Administrator: OPS$DPTADM
. SAP R/3 Serviceuser: OPS$SAPSERVICEDPT
.
User OPS$ORADPTdoes already exist.
unable to create user: OPS$DPTADM
begin
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password length less than 8
ORA-06512: at line 79
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
-----------------------------------------------------------
Hi Andrew
How did you start the Upgrade ?
Java Upgrades must be started with: http://hostname:1128/lmsl/sumjava/SID/index.html
Cheers, Fausto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrew
Please try to change the password for SAPSR3DB user and check.
brconnect -u system/<password> -f chpass -o SAPSR3DB -p
<new password>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrew,
please try to change password for SAPSR3DB in BRTOOLS and Provide Same password in Config Tool for SAPSR3DB Schema user
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Check below sapnote if you haven't yet?
2067086 - ORA-01017 during SAP Upgrade
1576837 - ORA-01017: invalid username/password;
Regards,
Prithviraj.
I do next
create user OPS$DPTADM default tablespace PSAPSR3DB temporary tablespace psaptemp identified externally;
grant connect, sapdba, resource to OPS$DPTADM;
create table OPS$DPTADM.SAPUSER ( USERID VARCHAR2(256), PASSWD VARCHAR2 (256));
insert into OPS$DPTADM.SAPUSER values ('SAPSR3DB', 'qwer1234');
SAPSR3DB in SAPUSER has same password as in DB, but not successfully
hcmportal:oradpt 57> sqlplus /@DPT
SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 5 15:52:11 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.