The sys password modification problem in the connection of two servers in Oracle-Tech Notes

The sys password modification problem in the connection of two servers in Oracle

Technical otaku 2022-11-26

Problem description: Orcl server needs to connect to orclstd

I want sqlplus sys/410526@orclstd as sysdba to connect to the orclstd database, but if I find that the password is incorrect, reset the sys password

1.Connect to the orclstd server on the orcl server

[ Oracle @orcl orcl]$ sqlplus sys/410526@orclstd as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 27 19:32:01 2019

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

2.Connect to orcl server on orclstd

[oracle@orcl orcl]$ sqlplus sys/410526@orcl as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 27 19:32:01 2019

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

3.Unsure of the sys password, reset the sys password, orcl and orclstd both set the password

[oracle@orcl dbs]$ orapwd file=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworclorclstd

Enter password for SYS:

[oracle@orclstd dbs]$ orapwd file=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworclorclstd

Enter password for SYS:

4.Re-connect with the new password, but still can’t connect

[oracle@orcl orcl]$ sqlplus sys/oracle@orclstd as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 27 19:33:51 2019

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

5.The password has been changed, and I found out why I still can’t connect.There is no problem with ping IP address and tnsping instance name.I remembered that the password file was sent to orclstd once, so I deleted the password file for orclstd and re-transmit with scp