远程访问本机19c(pdb容器)数据库配置教程

最新推荐文章于 2025-11-23 05:14:55 发布

原创最新推荐文章于 2025-11-23 05:14:55 发布 · 248 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#服务器 #运维

背景:本地安装WINDOWS.X64_193000_db_home,用另一台电脑访问本机19c数据。

1.打开本地防火墙

这个请自行搜索关闭防火墙即可

2.确定当前为pdb容器

操作步骤可参考这篇

https://blog.youkuaiyun.com/pgmzyy/article/details/152126407?spm=1001.2014.3001.5502

3.配置listener.ora

安装地址\WINDOWS.X64_193000_db_home\network\admin\listener.ora

# listener.ora Network Configuration File: E:\App\WINDOWS.X64_193000_db_home\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\App\WINDOWS.X64_193000_db_home)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\App\WINDOWS.X64_193000_db_home\bin\oraclr19.dll")
    )
	(SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = E:\App\WINDOWS.X64_193000_db_home)
      (GLOBAL_DBNAME = orclpdb)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
	(DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 111.11.11.111)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

注意需要重启监听才能生效！！！

用管理员打开命令窗口，执行

停止监听：lsnrctl stop 

启动监听：lsnrctl start

4.配置tnsnames.ora

ORCLPDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orclpdb)
    )
  )