server 2012 (64bit)+11g 64
在create一個「TOC64」的db時,結果出現以下錯誤畫面:
 |
| 第一次看到這樣的錯誤,真的會很不知所措 |
請打開Net Manager:
1. 看一下「服務命名」是否有沒有把db加入(如果沒有,那就真的無救了,正常是會有的)
2.切換到Listener,IP形態的位址要指定(日後外部連入會用的到)
3.重點來了!!,請切換到listener的「其他服務」
請新增一個「服務」,指定其「程式名稱」、「SID」及「ORACLE本位目錄」
Oracle本位目錄不知道的話,直接copy第一個服務的那個欄位來用就可以了
設定完後,儲存網路組態,再去服務中把Oracle Listener 的服務重新啟動(其相對的「OracleService你的DB」也重啟服務吧)
用toad在本機連看看吧
----後記--------------------------
事實上最快的方式是直到修改listener.ora & tnsnames.ora,修改完後,用tns name(在toad中手動輸入)直接去連就可以了
----後記--------------------------
事實上最快的方式是直到修改listener.ora & tnsnames.ora,修改完後,用tns name(在toad中手動輸入)直接去連就可以了
---listener.ora--參考內容
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_2)
)
(SID_DESC =
(PROGRAM = ttcs64)
(SID_NAME = ttcs64)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_2)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-A2HVFKEQJ1M)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_2)
)
(SID_DESC =
(PROGRAM = ttcs64)
(SID_NAME = ttcs64)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_2)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-A2HVFKEQJ1M)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator
=========================================
------------tnsnames.ora參考內容-----------------
# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
TOC64 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-A2HVFKEQJ1M)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TOC64)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
TTCS64 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TTCS64)
)
)
LISTENER_TTCS64 =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
===============================================
以上,大家加油吧
