Oracle設定檔問題的初步處理

在念龍華在職專班時跟同學們相互切磋的過程,紀錄起來方便日後查詢用.

# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER3 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
      )
    )

#(DESCRIPTION =
#(ADDRESS_LIST =
#(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
#)
#)

  )
LOGGING_LISTENER3 = OFF
TRACE_LEVEL_LISTENER3 = OFF

#的部份是怪的地方正常來說一個Listener只有一個對應Prot案例的設定檔有辦法同時存在兩個Port是一件非常神奇的事

以下是猜測的原始設定,因為沒帶筆電上班,請協助看一下listener.ora原始檔案設定
LISTENER2 =

  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1520))
      )
    )
  )
LOGGING_LISTENER2 = ON<-----請參照原始檔應該要是on
TRACE_LEVEL_LISTENER2 = ON<-----請參照原始檔應該要是on