cancel
Showing results for 
Search instead for 
Did you mean: 

Java upgrade - SUM - OPS$ - ORADBUSR.SQL

0 Kudos

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

-----------------------------------------------------------

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Andrew

How did you start the Upgrade ?

Java Upgrades must be started with:       http://hostname:1128/lmsl/sumjava/SID/index.html

Cheers, Fausto

former_member962333
Discoverer
0 Kudos

Hi Andrew

Please try to change the password for SAPSR3DB user and check.

brconnect -u system/<password> -f chpass -o SAPSR3DB -p
    <new password>

0 Kudos

Hello,

I check password maybe 10 times, but no progress

arun_kumar165
Participant
0 Kudos

Hi Andrew,

Can you please check whether user has been locked.

arun_kumar165
Participant
0 Kudos

Hi Andrew,

please try to change password for SAPSR3DB in BRTOOLS and Provide Same password in Config Tool for SAPSR3DB Schema user

0 Kudos

I attache fles R710VPE.DPT

Former Member
0 Kudos

Hi

Check below sapnote if you haven't yet?

2067086 - ORA-01017 during SAP Upgrade

1576837 - ORA-01017: invalid username/password;

Regards,

Prithviraj.

0 Kudos

Thank you, I have learned these notes, but it are not suitable to my case

0 Kudos

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: