oracle登陆有两种认证方式：os认证和密码文件认证
Password File/Operating System Authentication
1、os认证需要把登陆用户加入到os相应的用户组
Operating System Group UNIX User Group Windows User Group
OSDBA dba ORA_DBA
OSOPER oper ORA_OPER

本机
CONNECT / AS SYSDBA
CONNECT / AS SYSOPER

远程

CONNECT /@net_service_name AS SYSDBA
CONNECT /@net_service_name AS SYSOPER

2、密码文件认证，密码文件在不同的os平台下，路径和默认的名称不同。
ORAPWD FILE=filename PASSWORD=password ENTRIES=max_users force =y
REMOTE_LOGIN_PASSWORDFILE=none/exclusive/share
none/exclusive(可以修改增加用户)/share(不可修改)
CONNECT oe/oe AS SYSDBA
select * from V$PWFILE_USERS;

[@more@]

ITPub博客

oracle两种登陆认证方式

最新文章