1、设置listener.ora
首先找到自己电脑上的listener.ora文件,以下是我自己的地址:D:\app\UZ\product\11.2.0\dbhome_1\NETWORK\ADMIN
将HOST=localhost改HOST = 主机名,因为使用localhost不能进行远程访问。主机名可在我的电脑里查询到
listener.ora
# listener.ora Network Configuration File: D:\app\UZ\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\UZ\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\UZ\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = UZ-PC)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\UZ
# listener.ora Network Configuration File: D:\app\UZ\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\UZ\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\UZ\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = UZ-PC)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\UZ
2、然后设置tnsnames.ora
同样也是在这个文件夹下:D:\app\UZ\product\11.2.0\dbhome_1\NETWORK\ADMIN
①将HOST=localhost改为HOST = UZ-PC
②将ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = UZ-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
复制一份做一些简单的改动:
zhangqian =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.15.109)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
tnsnames.ora
# tnsnames.ora Network Configuration File: D:\app\UZ\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = UZ-PC)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = UZ-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
zhangqian =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.15.109)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
两个配置文件改动之后就可以访问10.1.15.109下的Oracle数据库了: