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@]