win7系统中装的oracle 11g。相关参数配置如下:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)os_authent_prefix = OPS$
remote_os_authent = false
remote_login_passwordfile = EXCLUSIVE执行 conn / as sysdba可以成功。
但是执行如下语句,在连接时会报错:
create user ops$administrator identified externally;
grant connect,resource to ops$administrator;
conn /
ORA-01017。比较急,希望大牛们指点一下。
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)os_authent_prefix = OPS$
remote_os_authent = false
remote_login_passwordfile = EXCLUSIVE执行 conn / as sysdba可以成功。
但是执行如下语句,在连接时会报错:
create user ops$administrator identified externally;
grant connect,resource to ops$administrator;
conn /
ORA-01017。比较急,希望大牛们指点一下。
SQL> conn ops$administrator/externally
ERROR:
ORA-01017: invalid username/password; logon denied
SQL> conn ops$administrator/externally
ERROR:
ORA-01017: invalid username/password; logon denied
首先用户要解锁
alter user ops$administrator account unlock;
其次他创建用户密码的命令不对, identified by,创建语句掉了一个by
alter user ops$administrator identified by externally;
以上两个语句可以合并执行
alter user ops$administrator identified by externally account unlock;
再通过用户密码连接
conn ops$administrator/externally
SQL> conn ops$administrator/externally
ERROR:
ORA-01017: invalid username/password; logon denied
首先用户要解锁
alter user ops$administrator account unlock;
其次他创建用户密码的命令不对, identified by,创建语句掉了一个by
alter user ops$administrator identified by externally;
以上两个语句可以合并执行
alter user ops$administrator identified by externally account unlock;
再通过用户密码连接
conn ops$administrator/externally
我查了一下用户状态是OPEN你在本机上测试你的方法可以吗?
是那个版本的数据库?