getting error in SUM tool sps19 while updating the patch level

[Former Member]

Dear all,

we are trying to update the patch level on development server but we are getting the error

which we have attached below, please assist on this.

Best Regards,

Dharmendra

[jayanth_velugati]

Hi Ramesh

Can you check the password for user system . Check the user status , if user is not locked and if you want to reset the password using below commands

sqlplus " / as sysdba "

SQL > SELECT username, account_status,lock_date, expiry_date FROM dba_users;

SQL > alter user SYSTEM account unlock; --- command to unlock user

SQL> alter user SYSTEM identified by <password>; -- command to reset password

Enter the changed password in SUM screen and continue your upgrade.

Thank You

Jayanth

[Former Member]

Dear Jayanth,

Thank you very much for your quick reply...

we have already reset the SYSTEM password and same has been used in SUM tool but still its not accepting.

Regards,

Ramesh

[jayanth_velugati]

Do you have SSFS configured ? Do you have any other SAP instance running on the same machine.

System is unable to resolve the identifier, can you run command tnsping <SID>.

check for any missing entries or syntax errors in tnsnames.ora.

check for permissions for director .oracle under /tmp , /var/opt

Thank You

Jayanth

[Former Member]

Dear jayanth ,

you are right Quality system and development system are running on the same host, but as per your suggestion

i have done tnsping <SID> from both User and below is the output.

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = bileccdq) (PORT = 1527))) (CONNECT_DATA = (SID = BED) (GLOBAL_NAME = BED.WORLD))) OK (0 msec)

i changed permission for .oracle folder as sidadm:sapsys but stll getting same error.

please suggest.

Regards,

Rameh J

[jayanth_velugati]

Folder permissions should be to ora<sid> or oracle user (for 12c) .

Can you try to rename the .oracle and try again.

Thank You

Jayanth

[Former Member]

Hi Jayanth,

The issue has been resloved..

Thanks for your suggestions.

brgds