修改oracle密码:
(1)前提:已经配置好相关环境变量
1.ORACLE_HOME=B:\oracle\product\10.2.0\db_1
2.path中加入%ORACLE_HOME%\bin;
3.新增变量TNS_ADMIN=%ORACLE_HOME%\NETWORK\ADMIN
4.新增字符集变量NLS_LANG = AMERICAN_AMERICA.AL32UTF8
(2)修改B:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.ora
加入SQLNET.AUTHENTICATION_SERVICES=(NTS),表示当请登录用户可以访问数据库服务器
(3)在cmd命令窗口登录
sqlplus / as sysdba
alter user system identified by manager;
alter user sys identified by change_on_install;
(4)在Pl/SQL中用system用户可以登录;sys却不能登录解决方案如下:
http://www.yuloo.com/news/104346.html