oracle 11g instant client

1.下載instant client
Basic is necessary,sql plus is optional

2.配置環境變數：PATH 變數中加入 ;D:\instantclient_11_1 及增加 SQLPATH , LOCAL , TNS_ADMIN 三個使用者環境變數路徑也是對應到 D:\instantclient_11_1。接著再配置 tnsnames.ora 和 sqlnet.ora 兩個檔案Client本機應該會找不到可從安裝 Oracle Server上 Copy 過來使用，之後更改 tnsnames.ora 檔案中的 host 改成遠端 Oracle Server 的 IP 位址。

3.到hosts增加oracle server
Done!sqlplus可以連遠端資料庫了!

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

原因:listener沒設定好(很奇怪用configuration manager 新增的listener不能用)
手動改了listener.ora之後就好了

LISTENER =
(DESCRIPTION_LIST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = cimsdb)(PORT = 1521))
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  )
)
SID_LIST_LISTENER=
(SID_LIST=
  (SID_DESC=
    (GLOBAL_DBNAME=cimsTrai)
    (ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1)
    (SID_NAME=cimsTrai))
  (SID_DESC=
    (SID_NAME=plsextproc)
    (ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1)
    (PROGRAM=extproc)))

順便紀錄一下tnsnames.ora的內容

# tnsnames.ora Network Configuration File:C:\app\Administrator\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

CIMSPROD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = cimsdb)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cimsProd)
    )
  )

CIMSTRAI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cimsdb)(PORT = 1521))
    )
    (CONNECT_DATA =
  (SERVER = DEDICATED)
      (SERVICE_NAME = cimsTrai)
    )
  )