用orapwd 重建password 文件.
1. set up the environment to use Password Authentication A. remove any existing users in the NT/2000 user group ORA_DBA or ORA_<sid>_DBA
( I think this step is very important but easy to be ignored )
B. set the REMOTE_LOGIN_PASSWORDFILE parameter in init.ora to
EXCLUSIVE or SHARED
C. set SQLNET.AUTHENTICATION_SERVICES parameter in sqlnet.ora to NONE
2. now set the password for internal and sys
shutdown database
orapwd file=pwd<sid>.ora password=black_snail entries=10
be sure to place the file in the same location of initsid.ora ( as the default location )
startup
3. now you can connect as sysdba by using password file authentication
try this to see the difference between internal Vs sys and sysdba Vs sysoper
1. set up the environment to use Password Authentication A. remove any existing users in the NT/2000 user group ORA_DBA or ORA_<sid>_DBA
( I think this step is very important but easy to be ignored )
B. set the REMOTE_LOGIN_PASSWORDFILE parameter in init.ora to
EXCLUSIVE or SHARED
C. set SQLNET.AUTHENTICATION_SERVICES parameter in sqlnet.ora to NONE
2. now set the password for internal and sys
shutdown database
orapwd file=pwd<sid>.ora password=black_snail entries=10
be sure to place the file in the same location of initsid.ora ( as the default location )
startup
3. now you can connect as sysdba by using password file authentication
try this to see the difference between internal Vs sys and sysdba Vs sysoper
oracle\ora90\rdbms\utlpwdmg.sql
中将
SQLNET.AUTHENTICATION_SERVICES= (NONE)
中的NONE改为NTS,即:
SQLNET.AUTHENTICATION_SERVICES= (NTS)修改密码后将此参数改回为none不过碰到过有的机器没有sqlnet文件,那就试试楼上的哈.
alter user SYSTEM identified by password;
HQ.Wang 海清