Base-Oracle-2

,TIPTOP,数据库管理（,Oracle,）,（二）,TIPTOP,事业部,课程大纲,网络原理,客户端配置,lsnrctl,工具介绍,sqlplus,工具介绍,网络原理,怎样配置一个数据库连接,怎样诊断数据库中出现的问题,Oracle,数据库有哪些环境变量,课程简介,Oracle,网络原理,监听器,效劳器,客户端,Dedicated,效劳器进程,1,2,3,客户端请求连接,监听器响应请求并创立一个效劳器进程,客户端通过效劳器进程对实例进行操作,网络配置文件,listener.ora,监听器,客户端,效劳器,tnsnames.ora,sqlnet.ora,网络配置文件,效劳配置文件,监听配置文件,上述文件位于,$ORACLE_HOME/network/admin/,目录下,配置监听器,全部使用默认设置即可,监听配置文件（,listener.ora,）,LISTENER=,(DESCRIPTION_LIST=,(DESCRIPTION=,(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=TCP)(HOST=topprod)(PORT=1521),(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1),SID_LIST_LISTENER=,(SID_LIST=,(SID_DESC=,(SID_NAME=PLSExtProc),(ORACLE_HOME=D:oracleora92),(PROGRAM=extproc),LISTENER=,(DESCRIPTION_LIST=,(DESCRIPTION=,(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=TCP)(HOST=topprod)(PORT=1521),(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1),SID_LIST_LISTENER=,(SID_LIST=,(SID_DESC=,(SID_NAME=PLSExtProc),(ORACLE_HOME=D:oracleora92),(PROGRAM=extproc),配置命名方法,命名方法配置文件（,sqlnet.ora,）,SQLNET.AUTHENTICATION_SERVICES=(NTS),NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME),SQLNET.AUTHENTICATION_SERVICES=(NTS),NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME),配置Net效劳,这里填入要连接的,ORACLE_SID,这里填入效劳器IP,要进行测试,出现这种错误，检查效劳器端的监听器是否翻开,出现这种错误，检查前面输入的,ORACLE_SID,是否正确,出现这种错误，检查,system,用户的密码,这里输入net效劳名,Net效劳配置文件（tnsnames.ora）,TOPDB,=,(DESCRIPTION=,(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=,TCP,)(HOST=,192.168.180.129,)(PORT=,1521,),),(CONNECT_DATA=,(SERVICE_NAME=,topdb,),),),TOPDB,=,(DESCRIPTION=,(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=TCP)(HOST=,192.168.180.129,)(PORT=1521),),(CONNECT_DATA=,(SERVICE_NAME=,topdb,),),),可以直接编辑该文件来配置网络效劳（蓝色局部为需设定工程）,Net效劳测试工具 tnsping,tnsping,服务名,C:Documents and SettingsLifengtnsping topdb,TNS Ping Utility for 32-bit Windows:Version 9.2.0.1.0-Production on 10-2,月,-2,008 21:53:51,Copyright(c)1997 Oracle Corporation.All rights reserved.,已使用的参数文件,:,D:oracleora92networkadminsqlnet.ora,已使用,TNSNAMES,适配器来解析别名,Attempting to contact(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP),(HOST=192.168.180.129)(PORT=1521)(CONNECT_DATA=(SERVICE_NAME=topdb),OK,（,0,毫秒）,C:Documents and SettingsLifeng,C:Documents and SettingsLifengtnsping topdb,TNS Ping Utility for 32-bit Windows:Version 9.2.0.1.0-Production on 10-2,月,-2,008 21:53:51,Copyright(c)1997 Oracle Corporation.All rights reserved.,已使用的参数文件,:,D:oracleora92networkadminsqlnet.ora,已使用,TNSNAMES,适配器来解析别名,Attempting to contact(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP),(HOST=192.168.180.129)(PORT=1521)(CONNECT_DATA=(SERVICE_NAME=topdb),OK,（,0,毫秒）,C:Documents and SettingsLifeng,监听器管理工具,lsnrctl start/stop/status/reload/help lsnr_name,lsnrctl,LSNRCTLcommand,LSNRCTLquit,lsnrctl,LSNRCTLcommand,LSNRCTLhelp,命令行方式,提示符方式,start stop status,services version reload,save_config trace spawn,change_password quit exit,set*show*,start stop status,services version reload,save_config trace spawn,change_password quit exit,set*show*,Lsnrctl 的另一个作用：,当管理员需要对oracle进行一些操作时，,为了防止TIPTOP用户登录和使用，可以,使用lsnrctl stop停掉监听器，这样可以在,不关闭效劳器的情况下防止客户端登入,监听器管理工具,LSNRCTLset option,LSNRCTLset,LSNRCTLshow option,LSNRCTLshow,LSNRCTLset option,LSNRCTLset,LSNRCTLshow option,LSNRCTLshow,password rawmode,Displaymode trc_file trc_directory trc_level,log_file log_directory log_status current_listener startup_waittime save_config_on_stop,password rawmode,Displaymode trc_file trc_directory trc_level,log_file log_directory log_status current_listener startup_waittime save_config_on_stop,设置,/,显示选项,跟踪监听器异常,维护,listener.ora,，增加,trace,设定,LISTENER=,(DESCRIPTION_LIST=,(DESCRIPTION=,(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=TCP)(HOST=topprod)(PORT=1521),(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1),SID_LIST_LISTENER=,(SID_LIST=,(SID_DESC=,(SID_NAME=PLSExtProc),(ORACLE_HOME=D:oracleora92),(PROGRAM=extproc),TRACE_LEVEL_LISTENER =16,TRACE_DIRECTORY_LISTENER=/u1/out,TRACE_ =listener,LISTENER=,(DESCRIPTION_LIST=,(DESCRIPTION=,(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=TCP)(HOST=topprod)(PORT=1521),(ADDRESS_LIST=,(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1),SID_LIST_LISTENER=,(SID_LIST=,(SID_DESC=,(SID_NAME=PLSExtProc),(ORACLE_HOME=D:oracleora92),(PROGRAM=extproc),TRACE_LEVEL_LISTENER =16,TRACE_DIRECTORY_LISTENER=/u1/out,TRACE_ =listener,设定跟踪级别,设定,trace,文件位置,设定,trace,文件名,lsnrctl start,LSNRCTL for Linux:Version 10.2.0.1.0-Production on 18-FEB-2008 17:55:25,Copyright(c)1991,2005,Oracle.All rights reserved.,Starting/u2/oracle/10g/bin/tnslsnr:please wait.,TNSLSNR for Linux:Version 10.2.0.1.0-Production,System parameter /u2/oracle/10g/network/admin/listener.ora,Log messages written to/u2/oracle/10g/network/log/listener.log,Error listening on:(ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1),No longer listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=heliserver3)(PORT=1521),TNS-12546:TNS:permission denied,TNS-12560:TNS:protocol adapter error,TNS-00516:Permission denied,Linux Error:30:Read-only,Listener failed to start.See the error message(s)above.,lsnrctl start,LSNRCTL for Linux:Version 10.2.0.1.0-Production on 18-FEB-2008 17:55:25,Copyright(c)1991,2005,Oracle.All rights reserved.,Starting/u2/oracle/10g/bin/tn