SYS使用者遠端登入報錯:ORA-01017: invalid username/password; logon denied
今天下午,有同事說有個資料庫sys使用者無法遠端登入,總是報密碼錯誤:
ORA-01017: invalid username/password; logon denied
連過去發現果然是這樣:
SQL> conn as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn as sysdba
Connected.
Connected.
懷疑是remote_login_passwordfile引數的問題,檢視資料庫,果然是這個引數的問題,該引數值為none,如果要使sys遠端登入,必須要改為exclusive才可以。於是按照下面的操作讓他修改引數的值:
16:37:14 > alter system set REMOTE_LOGIN_PASSWORDFILE=none scope=spfile;
System altered.
16:37:16 > shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
16:39:43 idle> startup
ORACLE instance started.
Total System Global Area 263049216 bytes
Fixed Size 2212448 bytes
Variable Size 239078816 bytes
Database Buffers 16777216 bytes
Redo Buffers 4980736 bytes
Database mounted.
Database opened.
Fixed Size 2212448 bytes
Variable Size 239078816 bytes
Database Buffers 16777216 bytes
Redo Buffers 4980736 bytes
Database mounted.
Database opened.
16:39:53 idle> conn as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
16:40:02 idle> conn / as sysdba
Connected.
Connected.
16:40:43 > alter system set remote_login_passwordfile=exclusive scope=spfile;
System altered.
16:41:26 > shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
16:41:37 > startup
ORACLE instance started.
Total System Global Area 263049216 bytes
Fixed Size 2212448 bytes
Variable Size 239078816 bytes
Database Buffers 16777216 bytes
Redo Buffers 4980736 bytes
Database mounted.
Database opened.
Fixed Size 2212448 bytes
Variable Size 239078816 bytes
Database Buffers 16777216 bytes
Redo Buffers 4980736 bytes
Database mounted.
Database opened.
16:41:49 > conn as sysdba
Connected.
16:42:02 >
但是,同事一會說他這樣做了之後依然不行。覺得很是奇怪~~最後突然想到,這個庫是很久以前的庫,裝完資料庫之後修改過sys使用者的密碼,所以懷疑之後修改的sys密碼和密碼檔案裡的密碼不一致造成的。
這樣可以透過兩種方法解決:
1、把sys的密碼修改成最初建庫時的密碼。
2、按照現在的sys密碼重建密碼檔案。
這兩種方法都不難,都可以很容易解決問題。於是,我猜了一下當初建庫時可能的密碼:change_on_install ~~~
當在sqlplus裡把sys密碼改成change_on_install之後,果然成功~~~~
相信重建密碼檔案也是可以達到這樣的效果。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/751371/viewspace-712565/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 遠端登入sys使用者報錯:ORA-01017: invalid username/password; logon deniedGo
- ORA-01017:invalid username/password; logon deniedGo
- sqlplus / as sysdba報錯ORA-01017: invalid username/password; logon deniedSQLGo
- AD Administration error:ORA-01017: invalid username/password; logon deniedErrorGo
- ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from TESTGo
- 【DG】搭建DG時報錯:ORA-01017、ORA-17627、ORA-17629 invalid username/password
- 【YashanDB資料庫】YAS-02143 invalid username/password, login denied資料庫
- SYS使用者無法遠端登入ORA-01017、ORA-01031
- RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password;ErrorUXDatabase
- sys使用者遠端登入報ORA-01031 insufficient privileges
- 使用TortoiseHg克隆遠端目錄報錯"abort: Access is denied"
- sys不能遠端登入。ora-01031
- 禁止root使用者遠端登入
- ora-01031錯誤(在客戶端以SYS使用者登陸報錯)客戶端
- SYS使用者登入Oracle報錯ORA-01031: insufficient privilegesOracle
- MSSQL不能遠端登入--使用者 'sa' 登入失敗。 (Microsoft SQL Server,錯誤: 18456)SQLROSServer
- The password supplied with the username Domain\UserName was not correct. Verify that it was entered ...AI
- 啟動報錯:Access denied for user 'root'@'localhost' (using password:YES)localhost
- 19c登入pdb密碼報錯ORA-01017密碼
- ConfigureGC.pl Reports - Invalid Username/Password. (文件 ID 602750.1)GC
- Oracle遠端登入報錯:ora-01031:insufficient privilegesOracle
- SSH遠端登入原理
- sysdba不能遠端登入
- redis - 遠端登入指令Redis
- rocky one 遠端登入
- 除錯環境 寶塔 mysql root 遠端登入除錯MySql
- 報錯”ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)”Errorlocalhost
- solaris預設無法遠端root使用者登入
- 怎麼登入遠端伺服器 遠端登入VPS伺服器伺服器
- 【MySQL】5.6.x sha256_password外掛登入使用者時報錯MySql
- sqlplus as sysdb登入報ora-01017SQL
- Linux 遠端 ssh 登入Linux
- xmanger遠端登入LinuxLinux
- 用SSH KEY遠端登入
- X window遠端登入(轉)
- ssh遠端登入協議協議
- MySQL 登入資料庫報錯'ERROR 1045 (28000): Access denied for user'..'@'localhost''MySql資料庫Errorlocalhost
- ssh只能遠端登陸到普通使用者,不能以root遠端登陸