Linux 和Windows下面的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)

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 /

Linux 和Windows下面的Oracle 外部身份认证 本地登录