oracle为了让其能进行远程连接,
通过程序的jdbc和客户端的plsql进行远程连接。
需要修改的地方:
E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
中:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xcl)(PORT = 1521))
)
)
中的HOST值改为本机的主机名,如这里的本机主机名为xcl
E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
中把本机数据库设置如下:
VTS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xcl)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = vts)
)
)
HOST的值改为本机主机名。如这里的本机主机名为xcl
LISTENER_VTS =
(ADDRESS = (PROTOCOL = TCP)(HOST = xcl)(PORT = 1521))
也需要将这行的HOST的值改为本机主机名。如这里的本机主机名为xcl
如果不知道本机主机名,可以通过cmd命令的ipconfig -all来查看
通过程序的jdbc和客户端的plsql进行远程连接。
需要修改的地方:
E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
中:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xcl)(PORT = 1521))
)
)
中的HOST值改为本机的主机名,如这里的本机主机名为xcl
E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
中把本机数据库设置如下:
VTS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xcl)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = vts)
)
)
HOST的值改为本机主机名。如这里的本机主机名为xcl
LISTENER_VTS =
(ADDRESS = (PROTOCOL = TCP)(HOST = xcl)(PORT = 1521))
也需要将这行的HOST的值改为本机主机名。如这里的本机主机名为xcl
如果不知道本机主机名,可以通过cmd命令的ipconfig -all来查看