剖析Oracle的网络结构轻松解决连接问题

LSNRCTL>; help 
The following operations are available 
An asterisk (*) denotes a 
modifier or extended command: 
start         stop      status 
services      version   reload 
save_config   trace     change_password 
quit          exit      set* 
show* 
LSNRCTL>; status 
 :em11:

C:\>;tnsping orcl 

TNS Ping Utility for 32-bit 
Windows: Version 10.1.0.2.0 - Production on 16-8月 - 
2005 09:36:08 

Copyright (c) 1997, 2003, Oracle.  All rights reserved. 

Used parameter files: 
E:\oracle\product\10.1.0\Db_2\network\admin\sqlnet.ora 

Used TNSNAMES adapter to resolve the alias 
Attempting to contact 
(DESCRIPTION = (ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP) 
(HOST = 127.0.0.1)(PORT = 1521))) 
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_ 
NAME = orcl))) 
OK (20 msec)

SQL>; select open_mode from v$database; 
查看数据库是打开还是mount状态。 
OPEN_MODE 
---------- 
READ WRITE  


#-----------------

#监听器的配置文件listener.ora 
#使用host naming则不再需要tnsname.ora文件做本地解析 
# listener.ora Network Configuration File: 
d:\oracle\product\10.1.0\db_1\NETWORK\ADMIN\listener.ora 
# Generated by Oracle configuration tools. 
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
  #    (SID_NAME = PLSExtProc) 
(SID_NAME = orcl) 
(GLOBAL_DBNAME = boway) 
      (ORACLE_HOME = d:\oracle\product\10.1.0\db_1) 
  #    (PROGRAM = extproc) 
    ) 
  ) 

LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) 
    ) 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = TCP)
(HOST = boway)(PORT = 1521)) 
    ) 
  )