Error: ORA-01017: invalid username/password when installing NW713 on SUSE Linux

[former_member831390]

Hi Expert,

when I install the NW731 on SUSE Linux, an error occurred and stopped at phrase: Create ICM userstore and prevented the install process, below is the error message:

Execution of the command "/usr/sap/SLT/SYS/exe/uc/linuxx86_64/saplikey pf=/usr/sap/SLT/SYS/profile/SLT_DVEBMGS00_isap -install_first_temp J1744025188 XXXXXX" finished with return code 2. Output:

saplikey: failed to connect to the database.

below is the log for dev_likey and saplikey.log:

dev_likey.log:

---------------------------------------------------

trc file: "dev_likey", trc level: 1, release: "720"

---------------------------------------------------

Mon Jul 29 13:43:10 2013

MtxInit: 0 0 0

Loading DB library '/usr/sap/SLT/SYS/exe/run/dboraslib.so' ...

Library '/usr/sap/SLT/SYS/exe/run/dboraslib.so' loaded

Version of '/usr/sap/SLT/SYS/exe/run/dboraslib.so' is "720.00", patchlevel (0.114)

read_con_info_ssfs(): DBSL supports extended connect protocol

  ==> connect info for default DB will be read from ssfs

Register application info.

Oracle client version: 11.2.0.3.0, V1, default build, (dbsl 720 081211, UNICODE[2])

Installed Oracle client patches:

# Patch  13508485     : Created on 21 Dec 2011, 13:23:38 hrs PST8PDT

# Patch Description: Created on  3 Jan 2012, 02:50:27 hrs PST8PDT

# Patch  11742262     : Created on  7 Mar 2012, 12:22:41 hrs CET

Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'

Connecting as SAPSR3/<pwd>@SLT on connection 0 (nls 0) ... (dbsl 720 081211, UNICODE[2])

Attaching to database server SLT (con=0, svchp=123eb30, srvhp=1241038)

Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=123eb30, srv=1241038, usr=12778a8)

Mon Jul 29 13:43:20 2013

   OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

   ORA-01017: invalid username/password; logon denied

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

[dbsloci.c    14533]

***LOG BY2=> sql error 1017   performing CON [dblink       540]

***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink       540]

*** ERROR => saplikey: failed to connect to the database. [saplikey_w.c 762]

I followed the instruction of the note: 400241 created the table SAPUSER for OPS$SLTADM:

CREATE TABLE "OPS$SLTADM".SAPUSER (USERID VARCHAR2(256), PASSWD VARCHAR2(256));

INSERT INTO "OPS$SLTADM".SAPUSER VALUES ('SAPSR3','ISAPcomlab00');

Here is what I inserted to table SAPUSER:

SQL> select * from SAPUSER;

USERID

--------------------------------------------------------------------------------

PASSWD

--------------------------------------------------------------------------------

SAPSR3

ISAPcomlab00

SAPSR3-CRYPT

V01/0058ZctvSB67Wv1bO7wfAXOQL8Fn+BAzE289hsWrHW3+eRg=

until now, I still cannot connect to oracle:

isap:sltadm 52> R3trans -d

This is R3trans version 6.22 (release 720 - 18.11.11 - 11:29:00).

unicode enabled version

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

R3trans finished (0012).

here is the log:

4 ETW000  [     dev trc,00000]  Mon Jul 29 13:54:40 2013                                             10020119  10.102298

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR                  48  10.102346

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:              125  10.102471

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied                                                                

4 ETW000                                                                                                  38  10.102509

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

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL error code 1017                                     32  10.102579

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=1017)                                        30  10.102609

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 1017                                   107  10.102716

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied                                                                

4 ETW000                                                                                                  52  10.102768

4 ETW000  [     dev trc,00000]     DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB                            50  10.102818

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 1017   performing CON                               94  10.102912

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied            44  10.102956

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

this is really drive me to crazy, pls help, help!

[former_member831390 · Accepted solution]

Thanks guys, issue solved by replace an new kernel mentioned in the note: 1680045.

in the install master of NW731, sap suggest use Software Provisioning Manager 1.0 to do installation. I used the new 720 EXT kernel instead of old one and the installation process complete successfully.

[Former Member · Accepted solution]

Hi Team,

We  are facing same issue.Could please help on this.

SAP NWA7.3 ,Kernel level 731.

[Former Member]

This message was moderated.

[Kanyin]

Hi Liang

thanks for sharing.

I had the same problem because of using the wrong kernel. But after changing the kernel I have retried the step which failed, I still got the same error message. Test with "R3trans -d" failed also. The I guess that the db default user password saved in the SSFS storage may be wrong. See note 1639578.

So I  (as sidadm) reset the password to the master password which I defined in the early steps of SWPM:

rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD Welcome123

Now the SWPM can connect to the Oracle DB and the installation ends successfully. I hope this will help someone.

Best regards

[fabianlarav]

Thank you Kanyin Cai,

Your reply was the most complete and actually solved my issue.

Best Regards,

Fabian

[stefan_koehler]

Hi Liang,

> I followed the instruction of the note: 400241 created the table SAPUSER for OPS$SLTADM:

SAPnote #400241 is for the old OS based (remote) authentication mechanism, but you are already using the new SSFS connection / authentication mechanism, if you look closely at your work process trace file.

read_con_info_ssfs(): DBSL supports extended connect protocol
  ==> connect info for default DB will be read from ssfs

So revert all the stuff you have done and change the password stored in SSFS according to the database user SAPSR3 (or change both).

Details can be found here:

• SAPnote #1622837
• SAPnote #1639578

Regards

Stefan

[Former Member]

Hi,

Two things:

1. Check your listener is running lsnrctl status

2. Try the following:

sqlplus "/as sysdba"

select username,ACCOUNT_STATUS from dba_users; -> This will list accounts and account status
select password from user$ where name='SYSTEM'; -> Check system account it will list password in alpha numeric value

Now run following command:

alter user system identified by values '4A416A1';

Now try again if not working try following.

Now that you have done this please change password with command from Mr. Vimalan.

Regards,

J

[divyanshu_srivastava3]

Did you check these

Remove env var "rsdb_ssfs_connect" and from profile.

SQL> alter system set remote_os_authent=TRUE;

Retart DB

SQL> show parameter os_authent;

grant connect to user

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

SQL> select username, account_status, profile from dba_users where username in ('SAPSR3', 'SAPSR3DB');

[Former Member]

Hi Liang,

Did you get chance to execute the following command that is mentioned in the note 400241.

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

If not, try to execute and try to run R3trans and check whether it helps.

Thanks and Regards,

Vimal

[former_member188883]

Hi Liang,

Looks like issue with saplikey in kernel, Please try with latest kernel of 720 and let us know.

Hope this helps.

Regards,

Deepak Kori