CONNECT failed with sql error '1017'

[Former Member]

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

Priyanshu Srivastava

[Former Member]

Hi All,

nus650pa:oradv8 9% more beolwbvv.anf

BR051I BRBACKUP 6.20 (133)

BR055I Start of database backup: beolwbvv.anf 2014-08-07 23.10.19

BR280I Time stamp 2014-08-07 23.10.20

BR301E SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR310E Connect to database instance DV8 failed

BR280I Time stamp 2014-08-07 23.10.20

BR301E SQL error -1017 at location BrDbConnect-2

ORA-01017: invalid username/password; logon denied

BR310E Connect to database instance DV8 failed

Please help!

Thanks

Priyanshu

[Former Member]

Dear

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

Regards

[Sriram2009]

Hi

Could you check this SAP Notes Error message

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

BR310E Connect to database instance DV8 failed"

1576837 - ORA-01017: invalid username/password;

1860519 - SAP fails to connect to the database

BR

SS

[Former Member]

Dear

recreate ops$user

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

Regards

[former_member188883]

Hi Priyanshu,

Please use SAP note 400241 -  Problems with ops$ or sapr3 connect to Oracle

to setup correct OPS$ mechanism.

Post this check the results .

Regards,

Deepak Kori