一、监听器(listener)
listener是Oracle基于服务器端的一种网络服务器,用于监听客户端向数据库服务器端提出的链接请求。
listener是Oracle基于服务器端的一种网络服务器,用于监听客户端向数据库服务器端提出的链接请求。
二、本地服务名(tnsname)
oracle客户端与服务器端的连接是通过客户端发出连接请求,由服务器端监听器对客户端连接请求进行合法检查。
tnsname是oracle客户端网络配置的一种,还有oracle names server等等。
oracle客户端与服务器端的连接是通过客户端发出连接请求,由服务器端监听器对客户端连接请求进行合法检查。
tnsname是oracle客户端网络配置的一种,还有oracle names server等等。
三、配置
1)netmgr
2)直接修改配置文件(/u01/app/oracle/product/10.2.0/db_1/network/admin)
四、启动,关闭,查看状态
1)lsnrctl start [listener]
2)lsnrctl stop [listener]
3)lsnrctl status [listener]
Service "orclg" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
#UNKNOWN 表示静态监听
#READY 表示实例可以接受连接请求
#BLOCKED 表示实例不能接受连接请求
五、连接
1)sqlplus
scott/tiger@myorcl
2)sqlplus
sys/oracle@myorcl as sysdba
3)sqlplus
scott/tiger@61.8.168.228:1521/orclg 指定ip,port连接
[oracle@cms2 admin]$ cat listener.ora
SID_LIST_LISTENER =
( SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orclg)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)
)
( SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orclg)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 61.8.168.228)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 61.8.168.228)(PORT = 1521))
)
[oracle@cms2 admin]$ cat tnsnames.ora
MYORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 61.8.168.228)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclg)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 61.8.168.228)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclg)
)
)
注意:
1)tnsnames.ora-service_name = listener.ora-global_dname
2)sid_name = oracle sid
3)如果修改了LISTENER,那么启动和关闭时需要加上监听器的名字,默认是listener不用加。
4)修改注册端口后,tnsnames.ora端口也需要修改。或指定端口连接。
5)SID_LIST部分表示静态注册。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10565106/viewspace-695610/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10565106/viewspace-695610/