①找到D:\app\husong\product\11.2.0\dbhome_1\NETWORK\ADMIN目錄下的tnsnames.ora文件
②修改tnsnames.ora文件殃恒,新增如下內(nèi)容:
# 新增遠(yuǎn)程數(shù)據(jù)庫(kù)連接.
別名 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 遠(yuǎn)程ip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 數(shù)據(jù)庫(kù)名)
)
)
③打開(kāi)plsql developer植旧,輸入用戶名和密碼登錄: