CONNECT failed with sql error '1017'

[Former Member]

Dear Team,

I have fresh installed SAP 4.7 on Windows 2003.Its sucessfull installed.

After installation when i Restart Server. Its dispatcher not working.

I check dev_w0 file.

ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Sun Aug 15 23:43:41 2010

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\IDE\SYS\exe\run\dboraslib.dll' ...

B

B Sun Aug 15 23:43:43 2010

B Library 'C:\usr\sap\IDE\SYS\exe\run\dboraslib.dll' loaded

B Version of 'C:\usr\sap\IDE\SYS\exe\run\dboraslib.dll' is "620.02", patchlevel (0.112)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 2176

M

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

I MtxInit: -2 0 0

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 Sun Aug 15 23:44:14 2010

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\ora81 from environment

C Client NLS settings: AMERICAN_AMERICA.WE8DEC

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

C Connecting as /@IDE on connection 0 ...

C Attaching to DB Server IDE (con_hdl=0,svchp=06B2ACE8,svrhp=06B2AAF4)

C Starting user session (con_hdl=0,svchp=06B2ACE8,srvhp=06B2AAF4,usrhp=06B6B71C)

C

C Sun Aug 15 23:44:15 2010

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

[dboci.c 3718]

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

[dboci.c 9536]

C Try to connect with default password

C Connecting as SAPIDE/<pwd>@IDE on connection 0 ...

C Starting user session (con_hdl=0,svchp=06B2ACE8,srvhp=06B2AAF4,usrhp=06B6B71C)

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

[dboci.c 3718]

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

[dboci.c 9536]

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

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

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

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

M *

M * LOCATION SAP-Server testserver_IDE_00 on host testserver (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sun Aug 15 23:44:15 2010

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8408

M * COUNTER 1

M *

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

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

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

[sunny_pahuja2 · Accepted solution]

Hi,

Check SAP note 400241.

Thanks

Sunny

[Former Member · Accepted solution]

Dear ,

I have read this note 400241 but not cleared.

I will be very thanksfull if you give me step by step activity on my SAP IDES Server.

From last 3 days i am facing this problme .

Thanks in adnaced.............................

sunil

[Former Member · Accepted solution]

Hi Sunil,

As the log is saying about the login problem of user SAPIDE (schema user), you can directly try to change the password of this user using the below command.

brconnect -u system/<password> -f chpass -o SAPIDE -p <new_password>

or

login as ora<sid> user and give the below command:

brconnect -u / -f chpass -o SAPIDE -p <new_password>

(you can also try changing password as "sap" which is default password for schema user...)

Once password change is successful, then try to start the SAP again.

I hope, youi have correctly set ORACLE_SID and ORACLE_HOME environment variable.

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi,

One simple solution is that change the SCHEMA user's password to SAP

then your problem get solved.

Here is the proccedure

brconnect -u / -f chpass -o sapr3 -p SAP

here sapr3 is the schema user, check the schema in your system and replace sapr3 with that and then execute the above command.

Thanks,

Chaitanya.

[Former Member · Accepted solution]

Dear ,

Thanks for nice reply.

How I check that what is my schema user?

How I replace schema user?

its is sap 4.7 with oracle 8.1 I thinh in this SAPDBA.

Should I run this command with sidadm or Administrator Login.

C:> brconnect -u / -f chpass -o sapr3 -p SAP

[Former Member · Accepted solution]

Dear

Should I run as below command because during installation I am set only this password admin123 for everywhere

C:\Documents and Settings\ideadm>brconnect -u / -f chpass -o SAPIDE -p admin123

Then restart system.

[markus_doehr2 · Accepted solution]

> its is sap 4.7 with oracle 8.1 I thinh in this SAPDBA.

Oracle 8.1.x is ancient an no more supported.

I won't run properly under Windows 2003, it never did and it was never supported.

Your efforts are pointless, get a current Oracle installation DVD media and a new installation DVD set.

Markus

[Former Member · Accepted solution]

Hi Sunil,

Yes... Markus is right...

But for some reason if you still you want to use this platform, you can change the password as suggested in previous post..

First you can try with "admin123". If it doesn't work, use default password "sap".

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Dear,

When I check via SAPDBAit give below messege

C:\usr\sap\IDE\SYS\exe\run>sapdba

SAPDBA: The environment variable NLS_LANG = AMERICAN_AMERICA.WE8DEC

differs from DB value = AMERICAN_AMERICA.WE8ISO8859P1

Adjust the environment according to the DB value!

SAPDBA terminates, because data corruption would be

likely while working with the wrong character set.

C:\usr\sap\IDE\SYS\exe\run>brconnect -u / -c -f check

BR801I BRCONNECT 6.20 (13)

BR805I Start of BRCONNECT processing: cedximpm.chk 2010-08-16 19.23.22

BR280I Time stamp 2010-08-16 19.23.22

BR301E SQL error -1017 at location db_connect-2

ORA-01017: invalid username/password; logon denied

BR310E Connect to database instance IDE failed

BR280I Time stamp 2010-08-16 19.23.22

BR301E SQL error -1017 at location thr_db_connect-4

ORA-01017: invalid username/password; logon denied

BR310E Connect to database instance IDE failed

BR806I End of BRCONNECT processing: cedximpm.chk 2010-08-16 19.23.22

BR280I Time stamp 2010-08-16 19.23.22

BR804I BRCONNECT terminated with errors

When I check user ID for OPS$

SQL> select * FROM DBA_USERS WHERE USERNAME = 'OPS$TS1ADM';

no rows selected

SQL> select username from all_users;

USERNAME

-

---

SYS

SYSTEM

OUTLN

DBSNMP

AURORA$JIS$UTILITY$

OSE$HTTP$ADMIN

AURORA$ORB$UNAUTHENTICATED

ORDSYS

ORDPLUGINS

MDSYS

CTXSYS

USERNAME

-

---

SCOTT

ADAMS

JONES

CLARK

BLAKE

MTSSYS

17 rows selected.

SQL>

[Former Member · Accepted solution]

Dear I am not able to do these activity

C:\usr\sap\IDE\SYS\exe\run>brconnect -u / -c -f check

BR801I BRCONNECT 6.20 (13)

BR805I Start of BRCONNECT processing: cedximpm.chk 2010-08-16 19.23.22

BR280I Time stamp 2010-08-16 19.23.22

BR301E SQL error -1017 at location db_connect-2

ORA-01017: invalid username/password; logon denied

BR310E Connect to database instance IDE failed

BR280I Time stamp 2010-08-16 19.23.22

BR301E SQL error -1017 at location thr_db_connect-4

ORA-01017: invalid username/password; logon denied

BR310E Connect to database instance IDE failed

BR806I End of BRCONNECT processing: cedximpm.chk 2010-08-16 19.23.22

BR280I Time stamp 2010-08-16 19.23.22

BR804I BRCONNECT terminated with errors

If I RUn or Check that SAPDBA is working

C:\usr\sap\IDE\SYS\exe\run>sapdba

SAPDBA: The environment variable NLS_LANG = AMERICAN_AMERICA.WE8DEC

differs from DB value = AMERICAN_AMERICA.WE8ISO8859P1

Adjust the environment according to the DB value!

SAPDBA terminates, because data corruption would be

likely while working with the wrong character set.

If I run via SQL .it give below messege

SQL> select * FROM DBA_USERS WHERE USERNAME = 'OPS$SAP1ADM';

no rows selected

I have format 2 or 3 times my IDES Server but again same problem come.

Its the Windows 2003 issue or SAP issue or I am SAP installing incorrectelly.

Plz help me

Regards

[Former Member · Accepted solution]

Hi sunil,

If you can login to sql you can create OPS$ users manually.

All the steps are given in the note 400241.

Still find the steps below:

C:\sqlplus / as sysdba
SQL>CREATE USER OPS$<SID>ADM IDENTIFIED EXTERNALLY;
SQL>GRANT CONNECT,RESOURCE,SAPDBA TO OPS$<SID>ADM;
SQL>DROP TABLE "<owner>".SAPUSER;
SQL>CREATE TABLE "OPS$<sid>ADM".SAPUSER
  (USERID VARCHAR2(256), PASSWD VARCHAR2(256));
INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<schemauser>', '<password>');

Please note, schema user will be SAPSR3 or SAP<SID>. create SAPService<SID> user as below,

SQL>CREATE USER OPS$SAPSERVICE<SID> IDENTIFIED EXTERNALLY;
SQL>GRANT CONNECT,RESOURCE,SAPDBA TO OPS$SAPSERVICE<SID>;
SQL>CREATE SYNONYM "OPS$SAPSERVICE<sid>".SAPUSER FOR
  "OPS$<sid>ADM".SAPUSER;

Then change the password of schema user using brconnect.

For example.

brconnect -u / -f chpass -o SAPIDE -p admin123

If you change the password as "sap" instead of "admin123", sap will ignore OPS$ mechanism to connect to database and use this password for the same.

If brconenct fails, you can do it at sql level.

For example,

ALTER USER SAPIDE IDENTIFIED BY sap;

Again recommending go through SAP Note again, all these steps are explained in details in the note.

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Dear ,

Why this happning during SAP 4.7 installaing on Windows 2003.Whats the reasion come for below error

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

[dboci.c 9536]

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

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

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

M in_ThErrHandle: 1

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

Why this error comes. Whats the reasion?

I want to root cause of this problem????

Plz help

[markus_doehr2 · Accepted solution]

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

> [dboci.c 9536]

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

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

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

> M in_ThErrHandle: 1

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

>

> Why this error comes. Whats the reasion?

I have installed and copied many systems before and all I can say is, that if you follow the installation guide attentively, those errors do not arise. They may e. g. happen if you install Oracle using "setup.exe" instead of the SAP provided script "sapserver.cmd" because environment variables for the installation are missing which are expected by the installation tools.

Markus

[Former Member · Accepted solution]

Dear Markus,

Thanks for nice and correct ansure.....................Now i am installting Oracle via startsap .Now This error not comming.

Thanks againg markus..

Regards

Sunil

[Former Member · Accepted solution]

Dear ,

I have read this note 400241 but not cleared.

I will be very thanksfull if you give me step by step activity on my SAP IDES Server.

From last 3 days i am facing this problme .

Thanks in adnaced.............................

sunil

[former_member204746 · Accepted solution]

run sapdba_role as per the note and this will clear your problem.

[Former Member]

Hi,

Logon as OPS$-user to get SAPIDE's password C Connecting as /@IDE on connection 0 ... C Attaching to DB Server IDE (con_hdl=0,svchp=06B2ACE8,svrhp=06B2AAF4) C Starting user session (con_hdl=0,svchp=06B2ACE8,srvhp=06B2AAF4,usrhp=06B6B71C) C C Sun Aug 15 23:44:15 2010 C *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017 [dboci.c 3718] C *** ERROR => CONNECT failed with sql error '1017'

There is a problem with OPS$ authentication mechanism. Please check the below note as suggested by Sunny..

[Note 400241 - Problems with ops$ or sapr3 connect to Oracle|https://service.sap.com/sap/support/notes/400241]

It will solve your problem.

Regards.

Rajesh Narkhede