高手帮忙,新建数据库连接问题 Oracle的服务端口缺省为1521,配置监听时,用IP地址代替主机名,注意一定要是Oracle客户端。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 给一个listener.ora例子# LISTENER.ORA Network Configuration File: /home/oracle/product/9.2.0/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1521)) ) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = om) (ORACLE_HOME = /home/oracle/product/9.2.0) (SID_NAME = om) ) (SID_DESC = (GLOBAL_DBNAME = hum) (ORACLE_HOME = /home/oracle/product/9.2.0) (SID_NAME = hum) ) )LISTENERa = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1522)) ) ) )SID_LIST_LISTENERa = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = a) (ORACLE_HOME = /home/oracle/product/9.2.0) (SID_NAME = a) ) )一共有两个listener,一个叫listener,另一个叫listenera;其中listener为两个实例服务,listenera为一个实例服务这是我在linux上装的oracle9i.此外,你想要连到新建的数据库,首先是要把环境变量中的ORACLE_SID设为你新建的实例名。此时再运行sqlplus什么的就没问题了。 在DBA studio中为什么只看到一个实例名?怎样才能看到我建立的两个实例? 数据库 编程 急!急! TNS: 协议适配器错误 请教一个SQL效率的问题 寻找高手!!!!!(100分) ORACLE怎么样复制数据库下的所有表的结构呢,不要数据? 如果找回sys/system密码? 数据库设计 字符串的问题 麻烦!!!300分求oracle 8.17版,分不够可以加,只要能找到8.17版! 在家里想访问公司里的oracle数据库 ERROR 位于第 1 行: ORA-01861: 文字与格式字符串不匹配 ora-01578错 经查询是LOBSEGMENT数据块损坏,请问如何解决?急急
# LISTENER.ORA Network Configuration File: /home/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = om)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = om)
)
(SID_DESC =
(GLOBAL_DBNAME = hum)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = hum)
)
)LISTENERa =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1522))
)
)
)SID_LIST_LISTENERa =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = a)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = a)
)
)一共有两个listener,一个叫listener,另一个叫listenera;
其中listener为两个实例服务,listenera为一个实例服务这是我在linux上装的oracle9i.此外,你想要连到新建的数据库,首先是要把环境变量中的ORACLE_SID设为你新建的实例名。此时再运行sqlplus什么的就没问题了。