在你的電腦上安裝oracle客戶端,然後在你安裝的oracle客戶端目錄下查詢tnsnames.ora檔案,找到以後加上:YOUR_ORACLE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TEST) ) )如果你的資料庫是SID為TEST,請把(SERVICE_NAME = TEST)改成(SID = TEST)如果用SQLPLUS連線,請寫成sqlplus tzm/777@your_oracle如果用TOAD或者其他工具連線資料庫:
寫對方的ip地址和資料庫名
如:sqlplus scott/[email protected]/orcl
sqlplus nc/[email protected]:1521/ngb
在你的電腦上安裝oracle客戶端,然後在你安裝的oracle客戶端目錄下查詢tnsnames.ora檔案,找到以後加上:YOUR_ORACLE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = TEST) ) )如果你的資料庫是SID為TEST,請把(SERVICE_NAME = TEST)改成(SID = TEST)如果用SQLPLUS連線,請寫成sqlplus tzm/777@your_oracle如果用TOAD或者其他工具連線資料庫: