oracle 大小写秘密码,[原创]oracle id和密码忽略大小写连接参数

Oracle 隐含参数：_case_sensitive_logon 的事例

隐含参数：_case_sensitive_logon

开关： True/False 默认是True

状态： Spfile

如下：

[email protected]> conn lyn/Oracle

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

@> conn / as sysdba

Connected.

[email protected]> alter system set _case_sensitive_logon=false;

alter system set _case_sensitive_logon=false

*

ERROR at line 1:

ORA-00911: invalid character

[email protected]> alter system set "_case_sensitive_logon"=false;

alter system set "_case_sensitive_logon"=false

*

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

[email protected]> alter system set "_case_sensitive_logon"=false scope=spfile;

System altered.

[email protected]> startup force;

ORACLE instance started.

Total System Global Area 418484224 bytes

Fixed Size 1345352 bytes

Variable Size 281020600 bytes

Database Buffers 130023424 bytes

Redo Buffers 6094848 bytes

Database mounted.

Database opened.

[email protected]> conn lyn/OraclE

Connected.

[email protected]>

注意点

1，默认值是True

2，修改时要加双引号

3，修改状态范围是Spfile，需要重启生效