0

getting error in SUM tool sps19 while updating the patch level

Apr 21 at 08:54 AM

68

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

error.png (54.2 kB)
log.png (46.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jayanth Velugati Apr 21 at 09:03 AM
0

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

Show 5 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0

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

0

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

0

Hi Jayanth,

The issue has been resloved..

Thanks for your suggestions.

brgds

0