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_MACHINESOFTWAREORACLEHOMEID
增加注册表字符串 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 /