在oracle中怎样判断网络连接,oracle网络连接

数据库主机：82

service_name：目的，把实例名对客户端进行屏蔽，客户端连接的时候 只需知道服务名即可连接指定的数据库(前提：配好TNS)

> vi tnsnames.ora

# tnsnames.ora Network Configuration File: /opt/oracle/product/11g/db/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORA11G =

(DESCRIPTION =

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ora11g)

)

)

wxdlut =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.137.23.82)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SID = ora11g)

)

> sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Mar 14 20:07:33 2012

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

SQL>