DATABASE/ORACLE

[Net8] 복잡한 내컴 tnsname.ora 파일 + listener.ora 파일 환경

몰라욧 2012. 7. 11. 17:33

윈도우2000(db8i + 클라이언트9i) SID = db9i

# SQLNET.ORA Network Configuration File: D:\Oracle\Ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


----------------------------------------------------------------------------------------

# TNSNAMES.ORA Network Configuration File: D:\Oracle\Ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORA920 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.194.130)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora920)
    )
  )



리눅스 파란(db9i) SID = ora920

# LISTENER.ORA Network Configuration File: D:\Oracle\Ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = linux1)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/9.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ora920)
      (ORACLE_HOME = /opt/oracle/product/9.2.0)
      (SID_NAME = ora920)
  )
)