Error in R3load in Database Import

[Former Member]

Hello,

I am installing 3.1I system on Aix 5.3 and Oracle 9.2.0.7. I am getting below error in my database import.

***********************************************************************************************DbSl Trace: Connect with default <uid>/<pwd> failed

DbSl Trace: Try to connect as OPS$-user to get the <uid>/<pwd>

DbSl Trace: CONNECT failed with sql error '1017'

#(IMP) ERROR: couldn't connect to DB

rc = 256

error message returned by DbSl:

#STOP: 20070524184058

#(IMP) ERROR: DbSlRollback failed

DbSlRollback: rc = 1

(SQL error 1017)

#START OF LOG: 20070525091803

1. R3load version @(#)R3load.c 20.29.121.1 SAP 00/07/07

2. R3load -i EX000.cmd -p EX000.log -r

***********************************************************************************************

Regards,

Bhushan

[Former Member]

It looks like the OPS$ user is not configured.

Try to follow note 50088(NT) or 361641(UNIX)

[andreas_herzog]

isn't this any of the tasks AFTER the database load is finished eg. post installation stuff?

@Bhushan ...are you doing a system copy or a clean install?

-> by the way...31i is no longer supported by sap...do you get more info if you try

> R3trans -d

GreetZ, AH

[Former Member]

Yes,

But also, it seems that SAPR3 user does not have the default password.

in any case, it is good to take a look at the trace file created by "R3trans -d"

[Former Member]

Hello,

do the OPS$ User exist? Do they have the right permissions? To which user does the table SAPUSER belong? Can you connect with sap<xyz) or SAPR3 to database?

e.g. like

sqlplus /nolog

connect sap<xyz>/pw?

you should change the password for the sap database user with brtools, like

brconnect -f chpass -o [sapr3 | sap<sid> | sap<xyz> | sapsr3] -p <new_password>

Best regards

K.Baran

[Former Member]

yes, the SAP note Note 400241 - Problems with ops$ or sapr3 connect to Oracle can help you.

Best regards

K.Baran