oracle的sqlnet.ora与password文件试验
先看有没有sqlnet.ora
[oracle@localhost ~]$ cd $oracle_home
[oracle@localhost dbhome_1]$ cd network
[oracle@localhost network]$ cd admin
[oracle@localhost admin]$ ls
listener.ora  samples  shrept.lst
[oracle@localhost admin]$
vmware+linux+oracle 10g rac全程详细图解
在centos 6.4下安装oracle 11gr2(x64)
oracle 11gr2 在vmware虚拟机中安装步骤
debian 下 安装 oracle 11g xe r2
oracle 11gr2 在vmware虚拟机中安装步骤
手动创建一个sqlnet.ora文件
[oracle@localhost admin]$ touch sqlnet.ora
[oracle@localhost admin]$ vim sqlnet.ora
[oracle@localhost admin]$ cat sqlnet.ora
sqlnet.authentication_services=(none);
[oracle@localhost admin]$
试验登陆情况：
[oracle@localhost admin]$ sqlplus / as sysdba
sql*plus: release 11.2.0.4.0 production on tue apr 15 08:26:25 2014
copyright (c) 1982, 2013, oracle.  all rights reserved.
error:
ora-01017: invalid username/password; logon denied
enter user-name:
*********************************
查看口令文件情况：
[oracle@localhost dbs]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/dbs
[oracle@localhost dbs]$ ls
hc_orcl.dat  init.ora  initorcl.ora  lkorcl  orapworcl  spfileorcl.ora
[oracle@localhost dbs]$
现在执行口令文件处理：
用老的口令文件改口令不被允许：
[oracle@localhost dbs]$ orapwd file=orapworcl password=gaojian
opw-00005: file with same name exists - please delete or renam
只好再作一个新的：
[oracle@localhost dbs]$ orapwd file=orapwgaojian password=gaojian
[oracle@localhost dbs]$ ls
hc_orcl.dat  initorcl.ora  orapwgaojian  spfileorcl.ora
init.ora    lkorcl        orapworcl
[oracle@localhost dbs]$
用刚刚作好的口令，还是不行（因为它和oracle中的sys口令不一致，是我随便设的，所以不行，其实登陆到哪个实例，就会用哪个口令文件--orapw）：
[oracle@localhost admin]$ sqlplus / as sysdba
sql*plus: release 11.2.0.4.0 production on tue apr 15 08:32:23 2014
copyright (c) 1982, 2013, oracle.  all rights reserved.
error:
ora-01017: invalid username/password; logon denied
enter user-name: sys as sysdba
enter password:
error:
ora-01017: invalid username/password; logon denied
enter user-name: sys
enter password:
error:
ora-01017: invalid username/password; logon denied
sp2-0157: unable to connect to oracle after 3 attempts, exiting sql*plus
[oracle@localhost admin]$
*******************************
考虑删除orapworcl （这个操作实际上有一定的危险性）:
[oracle@localhost dbs]$ rm orapworcl
[oracle@localhost dbs]$
一样也是登陆不进去：
[oracle@localhost admin]$ sqlplus / as sysdba
sql*plus: release 11.2.0.4.0 production on tue apr 15 08:34:24 2014
copyright (c) 1982, 2013, oracle.  all rights reserved.
error:
ora-01017: invalid username/password; logon denied
enter user-name: sys as sysdba
enter password:
error:
ora-01017: invalid username/password; logon denied
enter user-name: sys
enter password:
error:
ora-01017: invalid username/password; logon denied
sp2-0157: unable to connect to oracle after 3 attempts, exiting sql*plus
[oracle@localhost admin]$
*******************************
把sqlnet.ora中的 sqlnet.authentication_services=(none); 注释掉，再试验：
[oracle@localhost admin]$ cat sqlnet.ora
#sqlnet.authentication_services=(none);
[oracle@localhost admin]$
[oracle@localhost dbs]$ strings orapwgaojian
]\[z
oracle remote password file
internal
fe406c76b620912c
861baf16e111b672
[oracle@localhost dbs]$
登陆到数据库中，，来更改口令：
[oracle@localhost admin]$ sqlplus / as sysdba
sql*plus: release 11.2.0.4.0 production on tue apr 15 08:44:08 2014
copyright (c) 1982, 2013, oracle.  all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.2.0.4.0 - 64bit production
with the partitioning, olap, data mining and real application testing options
sql> alter user sys identified by oracle;
user altered.
sql>exit
[oracle@localhost dbs]$ strings orapwgaojian
]\[z
oracle remote password file
internal
fe406c76b620912c
861baf16e111b672
[oracle@localhost dbs]$
口令文件似乎无变化。
还是登陆不进去：
[oracle@localhost admin]$ sqlplus / as sysdba
sql*plus: release 11.2.0.4.0 production on tue apr 15 08:45:41 2014
copyright (c) 1982, 2013, oracle.  all rights reserved.
error:
ora-01017: invalid username/password; logon denied
enter user-name: sys as sysdba
enter password:
error:
ora-01017: invalid username/password; logon denied
enter user-name:
*******************************
看来还得用orapw的文件来对应。
[oracle@localhost dbs]$ orapwd file=orapworcl