Oracle 1017 error Logon denied

[Former Member]

Hi,

After setting the envionment variable as per the note 556232 my issue is solved a bit but I am struck at stage ORA:1017 logon denied. I followed as per notes 50088 ans 400241 but still I am having the same problem. Below are the logs...

DEV_W0

-

---

-

---

trc file: "dev_w0", trc level: 1, release: "640"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Sat Aug 12 15:41:59 2000

B create_con (con_name=R/3)

B Loading DB library 'J:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' ...

B

B Sat Aug 12 15:42:00 2000

B Library 'J:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' loaded

B Version of 'J:\usr\sap\DEV\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.55)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 10

M intno 20020600

M make: multithreaded, ASCII

M pid 2608

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 2608) [dpxxdisp.c 1153]

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M DpShMCreate: sizeof(wp_adm) 9936 (828)

M DpShMCreate: sizeof(tm_adm) 2083168 (10364)

M DpShMCreate: sizeof(wp_ca_adm) 18000 (60)

M DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M DpShMCreate: sizeof(comm_adm) 192000 (384)

M DpShMCreate: sizeof(vmc_adm) 0 (320)

M DpShMCreate: sizeof(wall_adm) (22440/34344/56/100)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 04F40040, size: 2372048)

M DpShMCreate: allocated sys_adm at 04F40040

M DpShMCreate: allocated wp_adm at 04F417A8

M DpShMCreate: allocated tm_adm_list at 04F43E78

M DpShMCreate: allocated tm_adm at 04F43EA0

M DpShMCreate: allocated wp_ca_adm at 05140800

M DpShMCreate: allocated appc_ca_adm at 05144E50

M DpShMCreate: allocated comm_adm_list at 051465C0

M DpShMCreate: allocated comm_adm at 051465D8

M DpShMCreate: allocated vmc_adm_list at 051753D8

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 05175400

M DpShMCreate: allocated wall_adm at 05175408

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Sat Aug 12 15:42:01 2000

M calling db_connect ...

C Got ORACLE_HOME=H:\oracle9i\bin from environment

C

C Sat Aug 12 15:42:03 2000

C Client NLS settings: AMERICAN_AMERICA.WE8MSWIN1252

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

C Connecting as /@DEV on connection 0 (nls_hdl 0) ...

C Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch

C 0 1 0357EF98 077DB2A8 077DAD10

C Attaching to DB Server DEV (con_hdl=0,svchp=077DAC64,svrhp=035835B4)

C

C Sat Aug 12 15:42:08 2000

C Starting user session (con_hdl=0,svchp=077DAC64,srvhp=035835B4,usrhp=0358BDC8)

C Now '/@DEV' is connected (con_hdl 0, nls_hdl 0).

C Got SAPR3's password from OPS$-user

C Disconnecting from connection 0 ...

C Closing user session (con_hdl=0,svchp=077DAC64,usrhp=0358BDC8)

C Now I'm disconnected from ORACLE

C Connecting as SAPR3/<pwd>@DEV on connection 0 (nls_hdl 0) ...

C Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch

C 0 1 0357EF98 077DB2A8 077DAD10

C Starting user session (con_hdl=0,svchp=077DAC64,srvhp=035835B4,usrhp=0358BDC8)

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

[dboci.c 4176]

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

[dbsloci.c 9891]

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

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

B ***LOG BY2=> sql error 1017 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#1 @ 419] [dblink 0419 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 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

M *****************************************************************************

M *

M * LOCATION SAP-Server MYS-705894_DEV_01 on host MYS-705894 (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sat Aug 12 15:42:08 2000

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9553

M * COUNTER 1

M *

M *****************************************************************************

M

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 728]

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2608) [dpnttool.c 357]

-

---

OPS$USER

SQL*Plus: Release 9.2.0.6.0 - Production on Sat Aug 12 15:50:42 2000

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> CONNECT / AS SYSDBA

Connected.

SQL> SELECT *FROM "OPS$MYS-705894\DEVADM".SAPUSER;

USERID

-

---

PASSWD

-

---

SAPDEV-CRYPT

V01/0010ZctvSB67Wv3u6Yw=

SAPR3-CRYPT

V01/0010ZctvSB67Wv3u6Yw=

SAPDEV

sap

USERID

-

---

PASSWD

-

---

SAPSR3

sap

-

---

GRANTED ROLES

SQL> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS

2 WHERE GRANTEE = 'OPS$MYS-705894\DEVADM';

GRANTED_ROLE

-

---

SAPDBA

CONNECT

RESOURCE

-

---

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'T000';

OWNER

-

---

SAPDEV

-

---

SQL> SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'SAPUSER';

OWNER

-

---

OPS$MYS-705894\DEVADM

-

---

SQL> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS

2 WHERE GRANTEE = 'OPS$MYS-705894\DEVADM';

GRANTED_ROLE

-

---

SAPDBA

CONNECT

RESOURCE

-

---

Please help me......actually it is trying to take the sapowner as SAPR3 but when I try to change the password from brconnect it is giving error following error that

D:\Documents and Settings\Administrator>brconnect -u system/admin -f chpass -o sapr3 -p sap

BR0801I BRCONNECT 6.40 (15)

BR0824E Owner SAPR3 not found in database or not SAP owner

BR0182E Checking parameter/option 'chpass_owner/-o' failed

BR0280I BRCONNECT time stamp: 2000-08-12 16.33.17

BR0804I BRCONNECT terminated with errors

But in SAPUSER table SAPR3 password is sap.

Please suggest..............

[Former Member]

The notes 50088 and 400241 helped in solving the issue.