全部博文
-
编辑 删除
oracle中os认证，参数remote login passwordfile,口令文件（转）
1、os认证 oracle安装之后默认情况下是启动os认证。os认证的意思是把登录到数据库的用户和口令校验放在了操作系统一级。如果以安装oracle时的用户登录os ，那么登录oracle数据库时不需要任何验证如： SQL> conn test/oracle as sysdba Connected. SQL> conn test/oracle@orcl as sysdba Connected. SQL> conn /as sysdba Connected. SQL> conn ss/ss as sysdba Connected. SQL> conn ss/ss@orcl as sysdba Connected. SQL> conn test/ss@orcl as sysdba Connected. SQL> conn test/oracle@orcl as sysdba Conne
