遠端登入sys使用者報錯:ORA-01017: invalid username/password; logon denied
遠端登入sys使用者報錯:ORA-01017: invalid username/password; logon denied
今天有個客戶反應資料庫不能用sys使用者遠端登陸
情況如下:
SQL> conn sys/system123@xxxx as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn sys/system@xxx as sysdba
Connected.
1.重建密碼檔案
orapwd file=/oracle/app/11.2.0/db_1/dbs/orapwxxx1 password=system123 entries=5
orapwd file=/oracle/app/11.2.0/db_1/dbs/orapwxxx2 password=system123 entries=5
重建密碼檔案需要重啟資料庫
保險起見在資料庫中修改下sys密碼
SQL> alter user sys identified by system123
SQL> conn sys/system123@xxxx as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
遠端登陸依然不行
2.檢查remote_login_passwordfile引數
檢視資料庫,該引數值預設為none,如果要使sys遠端登入,必須要改為exclusive才可以。
修改該引數:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 7 20:11:59 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show prameter REMOTE_LOGIN_PASSWORDFILE
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
remote_login_passwordfile string
NONE
SQL>alter system set remote_login_passwordfile=exclusive scope=spfile;
RAC 環境兩邊都要重啟後生效。
$ sqlplus sys/"system123"@xxxxx as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 7 20:22:05 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> -------遠端方式成功登陸sys使用者
今天有個客戶反應資料庫不能用sys使用者遠端登陸
情況如下:
SQL> conn sys/system123@xxxx as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn sys/system@xxx as sysdba
Connected.
1.重建密碼檔案
orapwd file=/oracle/app/11.2.0/db_1/dbs/orapwxxx1 password=system123 entries=5
orapwd file=/oracle/app/11.2.0/db_1/dbs/orapwxxx2 password=system123 entries=5
重建密碼檔案需要重啟資料庫
保險起見在資料庫中修改下sys密碼
SQL> alter user sys identified by system123
SQL> conn sys/system123@xxxx as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
遠端登陸依然不行
2.檢查remote_login_passwordfile引數
檢視資料庫,該引數值預設為none,如果要使sys遠端登入,必須要改為exclusive才可以。
修改該引數:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 7 20:11:59 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show prameter REMOTE_LOGIN_PASSWORDFILE
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
remote_login_passwordfile string
NONE
SQL>alter system set remote_login_passwordfile=exclusive scope=spfile;
RAC 環境兩邊都要重啟後生效。
$ sqlplus sys/"system123"@xxxxx as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed May 7 20:22:05 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> -------遠端方式成功登陸sys使用者
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29371470/viewspace-1156279/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- sqlplus / as sysdba報錯ORA-01017: invalid username/password; logon deniedSQLGo
- 【YashanDB資料庫】YAS-02143 invalid username/password, login denied資料庫
- sys使用者遠端登入報ORA-01031 insufficient privileges
- ubuntu ssh: connect to host ** port 22: Connection refused ssh登入遠端伺服器時提示Permission denied (publickey,password)Ubuntu伺服器
- 19c登入pdb密碼報錯ORA-01017密碼
- sqlplus as sysdb登入報ora-01017SQL
- 啟動報錯:Access denied for user 'root'@'localhost' (using password:YES)localhost
- 報錯”ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)”Errorlocalhost
- MSSQL不能遠端登入--使用者 'sa' 登入失敗。 (Microsoft SQL Server,錯誤: 18456)SQLROSServer
- RAC下使用者登入失敗ORA-01017
- Navicat遠端連線MySQL 提示1045 - Access denied for user 'root'@'223.74.158.192'(using password:YES)MySql
- 修改sys密碼報錯:ORA-01994: Password file missing or disabled密碼
- 客戶端登入Oracle 12.2伺服器報ORA-01017的解惑客戶端Oracle伺服器
- 除錯環境 寶塔 mysql root 遠端登入除錯MySql
- Linux 遠端 ssh 登入Linux
- SSH遠端登入原理
- rocky one 遠端登入
- redis - 遠端登入指令Redis
- 怎麼登入遠端伺服器 遠端登入VPS伺服器伺服器
- vue專案中連線MySQL時,報錯ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'localhost' (using password:YES)VueMySqlErrorlocalhost
- ssh遠端登入協議協議
- 雲伺服器設定多使用者遠端登入伺服器
- Windows遠端桌面設定多使用者同時登入Windows
- linux SSH服務允許root使用者遠端登入Linux
- 登入harbor報錯
- 阿里雲mysql遠端登入報ERROR 2027(HY000)阿里MySqlError
- Solaris 11 設定root使用者允許SSH遠端登入
- 如何遠端登入Linux系統?Linux
- 如何遠端登入Windows系統?Windows
- python urllib socks5 auth username password 設定Python
- 使用putty遠端登入Ubuntu時,報Network error:Connection refused錯誤及解決(記錄)UbuntuError
- vnc登入,vnc遠端登入工具的使用方法VNC
- windows ssh遠端登入阿里雲遇到permissions are too open的錯誤Windows阿里
- windows oracle11g資料庫使用sqlplus登入的時候出現ora-01017報錯WindowsOracle資料庫SQL
- Linux錯誤 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)LinuxErrorlocalhost
- Unable to unwrap data, invalid status [CLOSED]-服務端webSocket報錯服務端Web
- 【配置】伺服器遠端建立索引報錯access denied ("java.io.FilePermission""........\IKAnalyzer.cfg.xml""read"伺服器索引JavaXML
- 遠端登入和複製檔案
- CentOS 配置Mysql允許遠端登入CentOSMySql