PL/SQL通过修改配置文件的方式实现数据库的连接

 

Oracle10g所在目录大概是:

E:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/tnsnames.ora

 

Oracle9i所在目录大概是:

D:/oracle/ora90/network/admin/tnsnames.ora

 

# TNSNAMES.ORA Network Configuration File: D:/oracle/ora90/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

MAO =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = maowenlei)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mao.name)
    )
  )

APP_172.22.22.6 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.22.6)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = app)
      (SERVER = DEDICATED)
    )
  )

APP_172.22.22.1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.22.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = app)
      (SERVER = DEDICATED)
    )
  )

APP_CESHI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.141.200)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = APP)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = maowenlei)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

APP_10.10.141.200 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.141.200)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = app)
      (SERVER = DEDICATED)
    )
  )