Oracle DB链路连接配置文件

Question

我想在oracle中创建分布式数据库和快照。我在一个本地网络中的两台笔记本电脑上安装了db。我试图编辑两个配置文件(tnsnames。Ora和listener.ora)，并使用tnnames . Ora中的别名创建db链接。但是，如果我尝试运行select引用第二个数据库，oracle抛出Ora-12541: TNS -没有监听器。你能帮我解决这个问题吗?

我以及

。ora文件:

PC1 ip 192.168.1.100

MIRASCONNECT =  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.103)(PORT = 1521))
(CONNECT_DATA =
  (SERVICE_NAME = orl)
)  )

PC2 ip 192.168.1.103

mirassecond =  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
  (SERVICE_NAME = database)
)  )

在侦听器。或者我尝试只编辑sid name:

PC1:

SID_LIST_LISTENER =  (SID_LIST =
(SID_DESC =
  (SID_NAME = database) (GLOBAL_DBNAME = database)
  (ORACLE_HOME = D:appPiotrekproduct11.2.0dbhome_1)
  (PROGRAM = extproc)
  (ENVS = "EXTPROC_DLLS=ONLY:D:appPiotrekproduct11.2.0dbhome_1binoraclr11.dll")
)  )

PC2:

SID_LIST_LISTENER =   (SID_LIST =
(SID_DESC =
  (SID_NAME = orl) (GLOBAL_DBNAME = orl)
  (ORACLE_HOME = D:appPiotrekproduct11.2.0dbhome_1)
  (PROGRAM = extproc)
  (ENVS = "EXTPROC_DLLS=ONLY:D:appPiotrekproduct11.2.0dbhome_1binoraclr11.dll")
)  )

创建dblink:

CREATE PUBLIC DATABASE LINK MIRAS_CONNECTION CONNECT TO MIREK IDENTIFIED BY pwdmirek USING 'MIRASCONNECT'

和我的选择看起来像:

select * from test_table@miras_connection

Answer 1

没有一个监听器是容易理解的。您没有在192.168.1.103上启动侦听器

试

lsnrctl start