看看吧,就这样(怪吧!我是用手工创建的,一切都很正常呀,为什么会这样呀):
SQL> conn sys/sys as sysdba
Connected.
SQL> alter user system
2 identified by system;
User altered.
SQL> select username from dba_users;
USERNAME
------------------------------------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
WAXBIN
SQL> conn system/system
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL>
SQL> conn sys/sys as sysdba
Connected.
SQL> alter user system
2 identified by system;
User altered.
SQL> select username from dba_users;
USERNAME
------------------------------------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
WAXBIN
SQL> conn system/system
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL>
你在alter user system
2 identified by system;这一步之后 先commit; 一下 就可以了
可是还是不行呀
据我所知这算DDL,应该是隐式提交的
还是不行:
SQL> conn sys/sys as sysdba
Connected.
SQL> alter user system
2 identified by system;
User altered.
SQL> commit;
Commit complete.
SQL> conn system/system
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL>
没办法,不是我不想清扫垃圾。
有谁遇到过上面的问题呀。。或者给我点问题可能出在哪的提示。。
小弟万分感谢!
sqlnet.authentication_services = securid
改为
sqlnet.authentication_services = (beq,securid)
就一切OK了。其中可选的认证有:beq,none,all,kerberos5,cybersafe,securid,identitx
没想到就犯在beq上面!
加上""