linux:oracle用户登录系统 windows:登录系统打开cmdsqlplus / as sysdba alter user sys identified by oracle; alter user system identified by oracle;--如果 sqlplus / as sysdba 登陆不上去 --修改文件:D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora 内容改为: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
linux:oracle用户登录系统 windows:登录系统打开cmdsqlplus / as sysdba alter user sys identified by oracle; alter user system identified by oracle;--如果 sqlplus / as sysdba 登陆不上去 --修改文件:D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora 内容改为: SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
windows:登录系统打开cmdsqlplus / as sysdba
alter user sys identified by oracle;
alter user system identified by oracle;--如果 sqlplus / as sysdba 登陆不上去
--修改文件:D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora 内容改为:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
windows:登录系统打开cmdsqlplus / as sysdba
alter user sys identified by oracle;
alter user system identified by oracle;--如果 sqlplus / as sysdba 登陆不上去
--修改文件:D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora 内容改为:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
这样,就可以 用system登录oracle,而不需要密码。1楼的方法,在有些oracle的版本中,是找不到那个文件的,不通用