問題描述:orcl伺服器要連接orclstd 想要sqlplus sys/410526@orclstd as sysdba 連接orclstd資料庫,但是發現啥意思密碼不對,就對sys密碼進行重新設置 1.在orcl伺服器上連接orclstd伺服器 [oracle@orcl orcl]$ sqlpl ...
問題描述:orcl伺服器要連接orclstd
想要sqlplus sys/410526@orclstd as sysdba 連接orclstd資料庫,但是發現啥意思密碼不對,就對sys密碼進行重新設置
1.在orcl伺服器上連接orclstd伺服器
[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
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
2.在orclstd上連接orcl伺服器
[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
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
3.不確定sys密碼,重新設置sys密碼,orcl跟orclstd都設置密碼
[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.重新使用新密碼連接,發現還是連接不上
[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
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
5.密碼已經修改了,發現為什麼還連接不上,ping IP地址以及tnsping 實例名都沒有問題,想起來之前已經給orclstd傳過一次密碼文件,於是給orclstd密碼文件刪掉,重新scp傳輸一下
我的密碼文件的路徑是在:[oracle@orclstd ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs
6.刪掉密碼文件重新傳輸一下密碼文件,因為我這個都是通的,所以可以直接上傳
[oracle@orcl dbs]$ scp orapworcl 192.168.1.5:/u01/app/oracle/product/11.2.0/dbhome_1/dbs
7.給傳輸到orclstd,並給新的密碼文件改個名字
8.在兩個伺服器上重新連接一下,發現可以通了