測試環境:Oracle Enterprise Linux 64-bit (5.8版本) + Oracle 11g 64位
相關說明: Oracle11g64位軟件的安裝位置為/u01/app/oracle/product/11.2.0/dbhome_1 ,數據庫名為默認的orcl,Linux虛擬機的IP設置為192.168.1.121
一、修改listener.ora文件內容
命令:[oracle@gpdb ~]$ vi /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
內容:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME= orcl)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME=orcl)
)
)
LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.121)(PORT=1521)))
ADR_BASE_LISTENER = /u01/app/oracle
二、修改tnsnames.ora文件內容
命令:[oracle@gpdb ~]$ vi /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
內容:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS &#