关于oracle 双监听问题。。 我现在有一个监听器可以访问2个数据库了。。但是。。我想同时在管理里面开启2个监听器,,为什么开启不鸟。 就是我在CMD下面先开启 lsnrctl start m1 后来在开lsnrctl start m2。。为什么不行。 请问怎么解决这个问题。。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://liyanhui.javaeye.com/blog/262658这篇文章讲得很详细了,呵呵,原来还可以这样用 参考这个例子SID_LIST_LSNR_A = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = sid1) (ORACLE_HOME = /home/oracle/Ora10g) (SID_NAME = sid1) ) )LSNR_A = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) ) )SID_LIST_LSNR_B = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = sid2) (ORACLE_HOME = /home/oracle/Ora10g) (SID_NAME = sid2) ) )LSNR_B = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1522)) ) ) ) 空格全给吃掉啦,再试试SID_LIST_LSNR_A = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = sid1) (ORACLE_HOME = /home/oracle/Ora10g) (SID_NAME = sid1) ) )LSNR_A = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) ) )SID_LIST_LSNR_B = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = sid2) (ORACLE_HOME = /home/oracle/Ora10g) (SID_NAME = sid2) ) )LSNR_B = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1522)) ) ) ) 想问一个关于查询排名的问题 oracle 中函数拼凑sql语句并返回值的问题 这样的存储过程怎么写?利用它产生唯一主键 9i中建立回滚段出错,ORA-30019 数据库出问题了,打不开。好像是文件损坏了。我该怎么办? 1??????????????? 在VIEW中可以写触发器吗?如果可以这样的复杂的触发器该怎么写呢?(有点难度) 请教下面的一个问题,急,请帮忙 大佬们看看这个为啥报错 各位大神,谁能帮我将下面mssql语句转换成oracle的? 如何解决Oracle imp导入空间不足,initial extent过大的问题? 在问一个oracle的小问题、、
这篇文章讲得很详细了,呵呵,原来还可以这样用
SID_LIST_LSNR_A =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = sid1)
(ORACLE_HOME = /home/oracle/Ora10g)
(SID_NAME = sid1)
)
)LSNR_A =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
)
)SID_LIST_LSNR_B =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = sid2)
(ORACLE_HOME = /home/oracle/Ora10g)
(SID_NAME = sid2)
)
)LSNR_B =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1522))
)
)
)
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = sid1)
(ORACLE_HOME = /home/oracle/Ora10g)
(SID_NAME = sid1)
)
)LSNR_A =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
)
)SID_LIST_LSNR_B =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = sid2)
(ORACLE_HOME = /home/oracle/Ora10g)
(SID_NAME = sid2)
)
)LSNR_B =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1522))
)
)
)