本地遠(yuǎn)程虛擬機(jī)數(shù)據(jù)庫(kù)
時(shí)間:2023-06-26 02:24:02 | 來(lái)源:網(wǎng)站運(yùn)營(yíng)
時(shí)間:2023-06-26 02:24:02 來(lái)源:網(wǎng)站運(yùn)營(yíng)
本地遠(yuǎn)程虛擬機(jī)數(shù)據(jù)庫(kù):個(gè)人經(jīng)驗(yàn)備份,以備下次遇到此類(lèi)問(wèn)題用
虛擬機(jī)版本:vmware workstation pro 16
服務(wù)器版本:Windows server 2012 數(shù)據(jù)中心
數(shù)據(jù)庫(kù)版本:oracle 11.2.03
plsql developer版本:14.02
主機(jī)系統(tǒng):win10企業(yè)版
1.本地安裝plSQL developer和instantclient
2.復(fù)制oracle數(shù)據(jù)庫(kù)中的network文件到instantclient中
3.更改instantclient/NETWORK/ADMIN下listener和tnsnames以及sqlnet
4.listener:
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.10 )(PORT = 1521)) ) )
5.sqlnet:
SQLNET.AUTHENTICATION_SERVICES= (NONE)
6.tnsnames增加一行
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 虛擬機(jī)IP)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
7.服務(wù)器防火墻出入站規(guī)則放行1521端口
8.虛擬機(jī)防火墻出入站規(guī)則啟用文件和打印機(jī)文件共享
關(guān)鍵詞:數(shù)據(jù),虛擬,遠(yuǎn)程,本地