台灣最大程式設計社群網站
線上人數
640
 
會員總數:244676
討論主題:188773
歡迎您免費加入會員
討論區列表 >> Oracle >> 新手oracle連線問題
[]  
[我要回覆]
回應主題 加入我的關注話題 檢舉此篇討論 將提問者加入個人黑名單
新手oracle連線問題
價值 : 10 QP  點閱數:1239 回應數:0

樓主

遲緩兒
門外漢
0 2
57 1
發送站內信

我想自己摸索oracle
所以立馬就投入了下載(oracle 12 + JDK)我沒有下載client
我也不知道還要下載甚麼
我也沒有很多錢可以買書或補習(所以我都去圖書館借一些舊書來看...8.9的版本)
結果發現沒有人教真的很累
我希望能繼續堅持
所以請各位不吝嗇指教

(我爬文爬了兩個禮拜也重灌很多次...包括OS)
以下是我遇到的問題
https://imageshack.com/i/p6ai8Niej

這邊是我試圖解決問題所拿出來的一些資訊
https://imageshack.com/i/f0Ltj5YTj
https://imageshack.com/i/ez12T8eHj
https://imageshack.com/i/f04NkG4Jj

我的sqlnet.ora
//--------------------------------------------------------------

# sqlnet.ora Network Configuration File: E:\app\a2346257\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

//--------------------------------------------------------------
我的tnsnames.ora
//--------------------------------------------------------------

# tnsnames.ora Network Configuration File: E:\app\a2346257\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = 192.168.1.101)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)



//--------------------------------------------------------------
我的listener.ora

# listener.ora Network Configuration File: E:\app\a2346257\product\12.1.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\a2346257\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\a2346257\product\12.1.0\dbhome_1\bin\oraclr12.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = thunder-PC)(PORT = 1521))
)
)


可以請問一下我的問題到底出在哪裡呢?.....先感謝各位幫我回答的人


搜尋相關Tags的文章: [ oracle ] ,
本篇文章發表於2014-08-03 15:34
別忘捐VP感謝幫助你的人 新手會員瞧一瞧
目前尚無任何回覆
   

回覆
如要回應,請先登入.