1.客户端连接

看下tns_admin有配,找到sqlnet ，没配到主目录($ORACLE_HOME/network/admin)找sqlnet,找sqlnet中的连接方式NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT),找到tnsnames.ora,如果是动态注册，找service_name.

sqlnet.ora文件内容

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tnsname.ora文件内容

FJEAMCS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.33)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = eamcs)
    )
  )

其中service_name指的是服务器端的全局数据库名,它由数据库名+域名组成,我们可以查看下

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------
db_name                              string      eamcs
SQL> show parameter db_domain

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------
db_domain                            string
SQL> show parameter service_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------
service_names                        string      eamcs