修改Oracle的配置檔案

LuiseDalian發表於2014-01-21
Oracle

點選(此處)摺疊或開啟

  1. --修改/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora,將localhost都改為你的主機名
  2. LISTENER_TESTDB11 =
  3.   (ADDRESS = (PROTOCOL = TCP)(HOST = S1011.cuug.net)(PORT = 1521))


  6. TESTDB11 =
  7.   (DESCRIPTION =
  8.     (ADDRESS = (PROTOCOL = TCP)(HOST = S1011.cuug.net)(PORT = 1521))
  9.     (CONNECT_DATA =
  10.       (SERVER = DEDICATED)
  11.       (SERVICE_NAME = TestDB11.cuug.net)
  12.     )
  13.   )
  14.   
  15. --修改/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora, 將localhost改為你的主機名
  16. LISTENER =
  17.   (DESCRIPTION_LIST =
  18.     (DESCRIPTION =
  19.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  20.       (ADDRESS = (PROTOCOL = TCP)(HOST = S1011.cuug.net)(PORT = 1521))
  21.     )
  22.   )

  24. ADR_BASE_LISTENER = /u01/app/oracle

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1073478/，如需轉載，請註明出處，否則將追究法律責任。

相關文章