网络配置

oracle205

---

---

网络配置

对三个文件进行解析：

这三个文件可以手动的更改，也可以通过natca来配置

listener1501111AM4254.bak samplessqlnet.oratnsnames.ora
listener.ora shrept.lst tnsnames1501111AM4254.bak
[oracle@localhost admin]$ pwd
/u01/app/product/11.2.0/db_1/network/admin

1.sqlnet.ora的解释说明

[oracle@localhost admin]$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/product/11.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

#这个选项是说明是否允许sql / as sysdba的方式登录到数据库中，假如不允许则为NONE
SQLNET.AUTHENTICATION_SERVICES= (NTS);

#下面的EZCONNECT意思是使用简单方式登录，也就是没有经过tnsnames.ora的解析直接登录

#sqlplus hr/hr@192.168.91.3:1521/jiagulun

[oracle@localhost admin]$sqlplus hr/hr@192.168.91.3:1521/jiagulun

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 11 01:57:31 2015

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:
ERROR:
ORA-01017:invalid username/password; logon denied


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@localhost admin]$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/product/11.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)

ADR_BASE = /u01/app/oracle

[oracle@localhost admin]$ vi sqlnet.ora
[oracle@localhost admin]$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/product/11.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

ADR_BASE = /u01/app/oracle

[oracle@localhost admin]$ sqlplus hr/hr@192.168.91.3:1521/jiagulun

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 11 01:58:41 2015

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

#TNSNAMES的意思是通过本地命名的方式登录sqlplus hr/hr@jiagulun

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/app/oracle

2. listener.ora的解释说明