on 06-23-2010 4:44 PM
Dear All,
IMPORT ABAP is failed with the following below error R3load is failed with the test connection
system specifications:
ECC6.0, Oracle, Windows x64
D:\>R3load -testconnect
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
R3load: START OF LOG: 20100623171746
R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
R3load: version R7.00/V1.4 [UNICODE]
Compiled Jan 24 2008 01:41:44
R3load -testconnect
DbSl Trace: ORA-1403 when accessing table SAPUSER
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1017
DbSl Trace: CONNECT failed with sql error '1017'
(DB) ERROR: db_connect rc = 256
DbSl Trace: ORA-1403 when accessing table SAPUSER
DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1017
Table SAPUSER is actually presented in the ops$sidadm, i have changed the password to default sap also
but still there is no use.
Could you please guide me , how to rectify this error
Thanks and Regards
Purna
With the help of Note 400241-Problems with ops$ or sapr3 connect to Oracle i have solved my problem.
I had run the command "alter user sapsr3 identified by sap;" and just retry abap import had started.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
After reading your error again, there is an oracle message ORA-01017, which means:
ORA-01017: invalid username/password; logon denied
Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password.
Change both your DB & SAP password using brtools:
8. Additional Functions
3. Change password
<removed_by_moderator>
Edited by: Juan Reyes on Jul 6, 2010 12:08 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try run R3trans -dw using <SID>adm.
If return code not 0000 which means OK, read trans.log to see what is the real problem.
Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am also getting the same error. I have checked listener is running and database is also up.
yes , this is fresh installation. But I am trying on lunix x86_64 and database oracle 10.2.0.4.0
Edited by: Jayant Kr. Sharma on Jul 5, 2010 1:50 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Is this a fresh installation or system copy , also which password you have changed .
Just make sure that database and listener is up and running.
Additionaly you can check tnsping SID.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Read SAP Note 400241.
Check the synonym for SAPServiceSID
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.