在用plsql用sys用户登录时报ora-01031错误。但在服务器本地是可以的。经测试，不在本地服务器登录都会报这个错误。这与三方面有关，以下是处理过程：

-bash-3.2$ sqlplus /nolog

SQL*Plus: Release 9.2.0.8.0 - Production on Wed Apr 24 15:41:56 2013

SQL> connect sys/sys123 as sysdba
Connected.
SQL> select *
2 from v$pwfile_users;

no rows selected

SQL> select name,value
2 from v$parameter
3 where name like '%pass%";
ERROR:
ORA-01756: quoted string not properly terminated

SQL> select name,value
2 from v$parameter
3 where name like '%pass%';

NAME
----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
remote_login_passwordfile
NONE

SQL> alter system set remote_login_passwordfile=EXCLUSIVE scope=spfile;

System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 674829224 bytes
Fixed Size                   451496 bytes
Variable Size             402653184 bytes
Database Buffers          268435456 bytes
Redo Buffers                3289088 bytes
Database mounted.
Database opened.
SQL> select *
2 from v$pwfile_users;

USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE

SQL> select name,value
2 from v$parameter
3 where name like '%pass%';

NAME
----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
remote_login_passwordfile
EXCLUSIVE

SQL>

-bash-3.2$ orapwd file=/opt/oracle/product/9ir2/dbs/orapw password=sys123

ITPub博客

处理ORA-01031

最新文章