cancel
Showing results for 
Search instead for 
Did you mean: 

CONNECT failed with sql error '1017'

Former Member
0 Kudos

Hello,

nus650pa:dv8adm 23% more trans.log

4 ETW000 R3trans version 6.05 (release 46D - 12.07.06 - 16:40:00).

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

4 ETW000

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 date&time   : 14.08.2014 - 16:58:18

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

4 ETW000  [developertra,00000]  Thu Aug 14 16:58:19 2014                          170924  0.170924

4 ETW000  [developertra,00000]  db_con_init called                                  1225  0.172149

4 ETW000  [developertra,00000]  create_con (con_name=R/3)                          22426  0.194575

4 ETW000  [developertra,00000]  Loading DB library '/usr/sap/DV8/SYS/exe/run/dboraslib.so' ...

4 ETW000                                                                             136  0.194711

4 ETW000  [developertra,00000]  load shared library (/usr/sap/DV8/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000                                                                          369207  0.563918

4 ETW000  [developertra,00000]  Library '/usr/sap/DV8/SYS/exe/run/dboraslib.so' loaded

4 ETW000                                                                             174  0.564092

4 ETW000  [developertra,00000]  function DbSlExpFuns loaded from library /usr/sap/DV8/SYS/exe/run/dboraslib.so

4 ETW000                                                                             694  0.564786

4 ETW000  [developertra,00000]  Version of library '/usr/sap/DV8/SYS/exe/run/dboraslib.so' is "46D.00", patchlevel (0.2186)

4 ETW000                                                                           15725  0.580511

4 ETW000  [developertra,00000]  function dsql_db_init loaded from library /usr/sap/DV8/SYS/exe/run/dboraslib.so

4 ETW000                                                                              60  0.580571

4 ETW000  [developertra,00000]  function dbdd_exp_funs loaded from library /usr/sap/DV8/SYS/exe/run/dboraslib.so

4 ETW000                                                                             121  0.580692

4 ETW000  [developertra,00000]  New connection 0 created                              96  0.580788

4 ETW000  [developertra,00000]  db_con_connect (con_name=R/3)                      14511  0.595299

4 ETW000  [developertra,00000]  find_con found the following connection for reuse:

4 ETW000                                                                              53  0.595352

4 ETW000  [developertra,00000]  Got ORACLE_HOME=/oracle/DV8/920_64 from environment

4 ETW000                                                                           73038  0.668390

4 ETW000  [developertra,00000]  -->oci_initialize                                    589  0.668979

4 ETW000  [developertra,00000]  Got ORACLE_SID=DV8 from environment                   56  0.669035

4 ETW000  [developertra,00000]  Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000                                                                              52  0.669087

4 ETW000  [developertra,00000]  Logon as OPS$-user to get SAPR3's password            33  0.669120

4 ETW000  [developertra,00000]  Connecting as /@DV8 on connection 0 ...               91  0.669211

4 ETW000  [developertra,00000]  -->oci_logon(con_hdl=0, user='', dbname='DV8')       999  0.670210

4 ETW000  [developertra,00000]  Thu Aug 14 16:58:20 2014                          245280  0.915490

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'olog' failed: rc = 1017       263  0.915753

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

4 ETW000                                                                             858  0.916611

4 ETW000  [developertra,00000]  Try to connect with default password                  38  0.916649

4 ETW000  [developertra,00000]  Connecting as SAPR3/<pwd>@DV8 on connection 0 ...

4 ETW000                                                                              53  0.916702

4 ETW000  [developertra,00000]  -->oci_logon(con_hdl=0, user='SAPR3', dbname='DV8')

4 ETW000                                                                              46  0.916748

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'olog' failed: rc = 1017    118256  1.035004

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

4 ETW000                                                                              86  1.035090

4 ETW000  [developertra,00000]  Got ORACLE_SID=DV8 from environment                  716  1.035806

4 ETW000  [developertra,00000]  Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000                                                                              55  1.035861

4 ETW000  [developertra,00000]  Logon as OPS$-user to get SAPR3's password            33  1.035894

4 ETW000  [developertra,00000]  Connecting as /@DV8 on connection 0 ...               29  1.035923

4 ETW000  [developertra,00000]  -->oci_logon(con_hdl=0, user='', dbname='DV8')        28  1.035951

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'olog' failed: rc = 1017    126719  1.162670

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

4 ETW000                                                                             165  1.162835

4 ETW000  [developertra,00000]  Try to connect with default password                  36  1.162871

4 ETW000  [developertra,00000]  Connecting as SAPR3/<pwd>@DV8 on connection 0 ...

4 ETW000                                                                              47  1.162918

4 ETW000  [developertra,00000]  -->oci_logon(con_hdl=0, user='SAPR3', dbname='DV8')

4 ETW000                                                                              42  1.162960

4 ETW000  [dboci.c     ,00000]  *** ERROR => OCI-call 'olog' failed: rc = 1017    123784  1.286744

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

4 ETW000                                                                              70  1.286814

4 ETW000  [dblink      ,00627]  ***LOG BY2=>sql error 1017   performing CON         1140  1.287954

4 ETW000  [dblink      ,00627]  ***LOG BY0=>                                          42  1.287996

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

Please help.

Thanks and Regards

Priyanshu Srivastava

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Dear

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





Regards

Former Member
0 Kudos

Dear

you can try this also

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

Former Member
0 Kudos

Dear

create ops$user

OPS$ users based on sap note 50088 - Creating OPS$ users on Windows NT/Oracle

Regards

Former Member
0 Kudos

Dear

First to say that the OPS$ user seems to be properly configured as it connects without problems and it is able to read the SAPUSER table to get the password for the SAP user:

> 4 ETW000 dev trc ,00000 Got SAPSR3's password from OPS$-user 506 0.058556

but using this password fails.

Reason: The password for this user has been changed using ORACLE tools.

That is wrong, if you do so then you get this problem.

If you want to change the password for the SAP user then you must use SAP tools (BRCONNECT):

brconnect -u system/<syst_pwd> -f chpass -o sap<sid> -p <new_sap_pwd>

former_member186228
Active Participant
0 Kudos

Hi,

Please refer  sap note 951167

Regards,

Jithin M