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

[Former Member]

Hello colleagues,

in TCode SM21 we've got a lot of following errors, that were repeated very often:

10:25:09 BTC 010 BY 2 Database error 1017 at CON

10:25:09 BTC 010 BY 0 > ORA-01017: invalid username/password; logon denied

10:25:09 BTC 010 BY 2 Database error 1017 at CON

10:25:09 BTC 010 BY 0 > ORA-01017: invalid username/password; logon denied

10:25:09 BTC 010 R1 9 Initialization DB-Connect Failed, Return Code 000256

10:25:09 BTC 010 Q0 2 Stop Workproc10, PID 3549

Background processes only affected and seems to be restarted after every attempt for connection into database.

After restart fo system (DB + ABAP) problem still persists, but does not occur that often. In productive system approximately once in every 2 hours, but is still there.

System environment:

DB: Oracle Release 10.2.0.2.0

OS: HP-UX

SAP: SAP ECC 6.0

Listener is up and running:

oraqxs 499 1 0 10:15:31 ? 0:01 /oracle/QXS/102_64/bin/tnslsnr LISTENER_QXS -inherit

R3trans working as well:

mucsx032:qxsadm 29> R3trans -d -v

This is R3trans version 6.14 (release 700 - 10.09.07 - 09:57:00).

R3trans finished (0000).

Below is extract from WP tracefile.

*

trc file: "dev_w10", trc level: 1, release: "700"

*

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

M sysno 02

M sid QXS

M systemid 274 (HP (IA-64) with HP-UX)

M relno 7000

M patchlevel 0

M patchno 133

M intno 20050900

M make: single threaded, ASCII, 64 bit, optimized

M pid 3549

M

M

M Wed May 6 10:25:09 2009

M kernel runs with dp version 232(ext=109) (@(#) DPLIB-INT-VERSION-232)

M length of sys_adm_ext is 364 bytes

M ThInit: running on host ciqxs02

M calling db_connect ...

C Oracle Client Version: '10.2.0.1.0'

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

C Logon as OPS$-user to get SAPDAT's password

C Connecting as /@QXS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 600000000299f0a0 60000000029a6a20 60000000029aa408

C Attaching to DB Server QXS (con_hdl=0,svchp=60000000029aa338,srvhp=60000000029ac688)

C Starting user session (con_hdl=0,svchp=60000000029aa338,srvhp=60000000029ac688,usrhp=60000000029a7238)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

[dboci.c 4532]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11044]

C Try to connect with default password

C Connecting as SAPDAT/<pwd>@QXS on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 WE8DEC 1 600000000299f0a0 60000000029a6a20 60000000029aa408

C Starting user session (con_hdl=0,svchp=60000000029aa338,srvhp=60000000029ac688,usrhp=60000000029a7238)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

[dboci.c 4532]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11044]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#5 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#5 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1435]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10377]

M

M Info for wp 10

M

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_BTCWP

M act_reqtype = DP_RQ_BTCWP

M rq_info = 8576

M tid = -1

M mode = 255

M len = 24

M rq_id = 1055

M rq_source = FROM_WP_CA

M last_tid = 10

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M mode_cleaned_counter = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M req.vm = no VM

M attachedVm = no VM

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 724]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 259]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc10 3549) [dpuxtool.c 259]

Do you have an idea how to get rid of this error? Did you experienced the same problem before? We will be thankful for any ideas.

Thank you all in advance.

[Former Member · Accepted solution]

go through this Note

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

[Former Member · Accepted solution]

Already tried that note, everything seems to be set up correctly. OPS$ mechanism is working. It looks that works OK, but from time to time somehow cannot connect to DB. There is 4SID's running on one hardware. Might be problem with load, memory?

[Former Member · Accepted solution]

May be but not sure. we never faced this issue for our 7 SIDs on one hardware..

[Former Member]

So finally it was performance problem. We found in the OS hanging processes that all together took quite a lot from processor capacity. After killing them everything runs smoothly. Thank you all for your knowledge sharing.

[Former Member]

Hi,

You did not mention abt the kerneleveland DB/SAP version details.

Chk the note 623242.

Regards.......