手机网站布局,在线网站免费,做网站需要哪些证书,梧州论坛最新主题原理 客户端向服务器端发送连接请求#xff0c;监听器监听到客户端德连接请求监听器监听到客户端德连接请求后#xff0c;把客户端德连接请求交给数据库服务器处理客户端和服务器端建立连接#xff0c;连接建立后#xff0c;服务器端和客户端直接通信#xff0c;而不再需要… 原理 客户端向服务器端发送连接请求监听器监听到客户端德连接请求监听器监听到客户端德连接请求后把客户端德连接请求交给数据库服务器处理客户端和服务器端建立连接连接建立后服务器端和客户端直接通信而不再需要监听器的参与。 监听器启动会读取listener.ora文件 LISTENER 是监听的名称可以自定义SID_NAME监听器监听的数据库实例名PROTOCOL 是监听器监听的协议HOST 指定数据库服务器的主机名或IP地址PORT 监听器指定的端口号[oracleprod1 admin]$ more listener.ora
LISTENER (DESCRIPTION_LIST (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST 192.168.137.127)(PORT 1521))))SID_LIST_LISTENER(SID_LIST(SID_DESC(GLOBAL_DBNAMEbeijing)(SID_NAMEPROD)(ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1))) TNS文件 SERVER指定连接请求的服务类型是专有服务器连接dedicated还是共享服务器连接shared[oracleprod1 admin]$ more tnsnames.ora
bj(DESCRIPTION(ADDRESS (PROTOCOLtcp)(HOSTprod1)(PORT1521))(CONNECT_DATA(SERVICE_NAMEbeijing)(SERVERdedicated))) 登录远程数据库方式 #查看监听状态
[oracleprod1 admin]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-FEB-2015 18:49:04Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOST192.168.137.127)(PORT1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 19-FEB-2015 11:45:07
Uptime 0 days 7 hr. 3 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/prod1/listener/alert/log.xml
Listening Endpoints Summary...(DESCRIPTION(ADDRESS(PROTOCOLtcp)(HOST192.168.137.127)(PORT1521)))
Services Summary...
Service beijing has 1 instance(s).Instance PROD, status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully 使用连接字符串登录 [oracleprod1 admin]$ sqlplus system/beijing192.168.137.127:1521/beijing 使用网络服务名登录 #根据tns文件
bj(DESCRIPTION(ADDRESS (PROTOCOLtcp)(HOSTprod1)(PORT1521))(CONNECT_DATA(SERVICE_NAMEbeijing)(SERVERdedicated)))[oracleprod1 admin]$ sqlplus system/beijingbj 监听常见的错误 1 TNS-12541: TNS:no listener 可能原因 客户端指定的目标主机IP有误客户端指定的端口号有误客户端指定的SID有误服务器端监听没开启#查看服务器端监听状态如果是如下显示
[oracleprod1 admin]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-FEB-2015 20:33:21Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOST192.168.137.127)(PORT1521)))
TNS-12541: TNS:no listenerTNS-12560: TNS:protocol adapter errorTNS-00511: No listenerLinux Error: 111: Connection refused
#开启监听
[oracleprod1 admin]$ lsnrctl start 2 [oracleprod1 dbs]$ sqlplus sys/beijingbj as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 19 20:49:38 2015Copyright (c) 1982, 2009, Oracle. All rights reserved.ERROR:
ORA-01031: insufficient privileges 出现这个错误说明oracle试图去找口令文件但是找不到 解决方法 file 指定口令文件的名称及路径password 指定用户sys的口令entries 指定最多可以有多少个超级用户具有sysdba权限force 是否覆盖已经存在的口令文件#生成口令文件
[oracleprod1 dbs]$ orapwd file/u01/app/oracle/product/11.2.0/db_1/dbs/orapwPROD passwordbeijing entries5 forcey#SYSDB为true说明sys已经有了sysdba权限
sysPROD select * from v$pwfile_users; USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE FALSE
#重新连接
[oracleprod1 dbs]$ sqlplus sys/beijingbj as sysdba 3 禁止以操作系统认证方式登录oracle [oracleprod1 admin]$ vi sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES(NTS)
