Linux 和Windows下面的Oracle 外部身份认证 本地登录
Linux 下面 登录用户名:Oracle
sqlplus / as sysdba
alter system set os_authent_prefix='' scope =spfile;
startup force;
create user oracle identified externally;
grant connect to oracle;
退出当前会话 再su到oracle
exit
su - oracle
passwd ...
sqlplus / as sysdba
conn /
Windows下面: 主机名DELL 登录用户名linuxidc
1.修改注册表:HKEY_LOCAL_MACHINE\SOFTWARE\ORACLEHOMEID
增加注册表字符串 OSAUTH_PREFIX_DOMAIN 值为 false (注意,默认没有,表示值为true)
2.
sqlplus / as sysdba
alter system set os_authent_prefix='' scope =spfile;
startup force;
create user dell identified externally; (为主机名非登录用户名)
grant connect to dell;
exit
sqlplus / as sysdba
conn /
相关推荐
lklong 2020-11-22
oraclemch 2020-11-06
shilukun 2020-10-10
周嘉笙 2020-11-09
iilegend 2020-10-19
EricRay 2020-10-16
zhuzhufxz 2020-09-16
dataminer 2020-08-17
bfcady 2020-08-16
Hody 2020-08-16
FightFourEggs 2020-08-16
数据库设计 2020-08-16
Seandba 2020-08-16
Omega 2020-08-16
zjyzz 2020-08-16
yanghuatong 2020-08-16
ktyl000 2020-08-16
dbasunny 2020-08-16