ERROR => CONNECT failed with sql error '1017'

[Former Member]

Hi,

we are getting the following error when we run r3trans -dx.It is an windows system.

Here i have attached the trans.log.

4 ETW000 r3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 30.11.2010 - 08:58:12

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Tue Nov 30 08:58:14 2010 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 3857 0.003857

4 ETW000 [dev trc ,00000] using "E:\usr\sap\TQ1\DVEBMGS10\exe\dboraslib.dll"

4 ETW000 22 0.003879

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 9 0.003888

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 18 0.003906

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.167)

4 ETW000 143 0.004049

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 16 0.004065

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 25 0.004090

4 ETW000 [dev trc ,00000] New connection 0 created 18 0.004108

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 29 0.004137

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 16 0.004153

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 15 0.004168

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 18 0.004186

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 223 0.004409

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 6714 0.011123

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 23 0.011146

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 2397 0.013543

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPRP1's password 16 0.013559

4 ETW000 [dev trc ,00000] Connecting as /@TQ1 on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 22 0.013581

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 18 0.013599

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0000000006E6C090 000000000032AFF0 0000000006E7E378

4 ETW000 109 0.013708

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 6894 0.020602

4 ETW000 [dev trc ,00000] Allocating server context handle 14 0.020616

4 ETW000 [dev trc ,00000] Attaching to DB Server TQ1 (con_hdl=0,svchp=0000000006E7E238,srvhp=0000000006E80608)

4 ETW000 37 0.020653

4 ETW000 [dev trc ,00000] Assigning server context 0000000006E80608 to service context 0000000006E7E238

4 ETW000 21591 0.042244

4 ETW000 [dev trc ,00000] Allocating user session handle 32 0.042276

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000006E7E238,srvhp=0000000006E80608,usrhp=000000000032B808)

4 ETW000 32 0.042308

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

4 ETW000 34551 0.076859

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 23657 0.100516

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 13 0.100529

4 ETW000 [dev trc ,00000] Try to connect with default password 12 0.100541

4 ETW000 [dev trc ,00000] Connecting as SAPRP1/<pwd>@TQ1 on connection 0 (nls_hdl 0) ... (dbsl 700 030508)

4 ETW000 17 0.100558

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 16 0.100574

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0000000006E6C090 000000000032AFF0 0000000006E7E378

4 ETW000 18 0.100592

4 ETW000 [dev trc ,00000] Assigning username to user session 000000000032B808

4 ETW000 15 0.100607

4 ETW000 [dev trc ,00000] Assigning password to user session 000000000032B808

4 ETW000 23 0.100630

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0000000006E7E238,srvhp=0000000006E80608,usrhp=000000000032B808)

4 ETW000 18 0.100648

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

4 ETW000 3281 0.103929

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 19 0.103948

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 10 0.103958

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#5 @ 431]

4 ETW000 10634 0.114592

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#5 @ 431]

4 ETW000 17 0.114609

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TQ1'"

[Former Member]

Hi,

LOG BY0=>ORA-01017: invalid username/password; logon denied 

You need to change your schema users password using "brconnect"

Try as follow:

1. Login as ora<sid>

2. Use below command to reset SAPRP1 users password

# brconnect  -u system -f chpass -o SAPRP1 -p <new password>

If it still doesn't work... just set the password as "sap" (it is default password for schema user)

# brconnect  -u system -f chpass -o SAPRP1 -p sap

Hope, it helps you...

Suggestions:

Above thing will help even if OPS$ mechanism is not set correctly...

But it is recommended to create and set permissions for OPS$ user. Else some BRTools function will produce errors...

Relevant notes are already suggested by others...

Please go through it word by word...

Regards.

Rajesh Narkhede

[markus_doehr2]

No offense - but did you try to use the search function here in the SDN?

Markus

[Former Member]

yes tried few solutions..But did not work.

[markus_doehr2]

Start reading

Note 562863 - FAQ: Logon mechanisms

to understand how the system tries to connect to the database.

Then use

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

to recreate your OPS$ user.

Since you did not post any information what you did to the system, whether it was running before or what was changed we can't give you any more specific hints.

Markus

[former_member524429]

Hi,

Along with the above suggestions, try to execute the below commands to see the status of DBA users account. Check weather they are locked or not.

connect / as sysdba

select username,account_status from dba_users;

If any OPS$, SAPSR3*, SYS, SYSTEM users are locked then open it using the below command.

ALTER USER <username> ACCOUNT UNLOCK;

Regards,

Bhavik G. Shroff

[Former Member]

Users are not locked.I tried that.

In SQlnet.ora file,SQLNET.AUTHENTICATION_SERVICES = (NTS) .Should this be changed to None?

[JPReyes]

Check weather they are locked or not

Well seens like they are not locked just yet as he'll be getting a ORA-28000 error, but if he doesn't fix the OPS$ users he'll be unlocking them soon.

Regards

Juan

[JPReyes]

In SQlnet.ora file,SQLNET.AUTHENTICATION_SERVICES = (NTS) .Should this be changed to None?

No, Did you read note 400241? that info is there.... also if you are working on windows read Note 50088

Regards

Juan