REMOTE_LISTENER specifies a network name that resolves to an address or address list of Oracle Net remote listeners (that is, listeners that are not running on the same machine as this instance). The address or address list is specified in the TNSNAMES.ORA file 二. LOCAL_LISTENER 与动态注册...
Parameter type String Syntax LOCAL_LISTENER =network_name Default value (ADDRESS = (PROTOCOL=TCP)(HOST=hostname)(PORT=1521))wherehostnameis the network name of the local host. Modifiable ALTER SYSTEM Modifiable in a PDB Yes Basic No
E:\Files\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN PS: 不推荐使用注册表修改数据库的自动启动方式,再在命令行中启动"SQL> startup;". Oracle数据库启动时:ORA-00119: invalid specification for system parameter LOCAL_LISTENER; ORA-00132错误解决...
Database Service_names: service.idc.oracle.com SID: sid2 3.2.2Node1配置 (1)修改Listener.ora文件 LISTENER_NODE1= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.idc.oracle.com)(PORT = 1521)(IP=FIRST))--私有IP (ADDRESS = (PROTOCOL = TCP)(HOST = node...
ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ORCLWENG' 3. 在数据库的Net Configuration Assistant中进行连接测试,提示如下错误。 ORA-12505 4. 平台 Win7 64位,Oracle database server 11gr2 64位,相应客户端为32位,32位...
ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name ‘LISTENER_ORACLE’ 运行结果: 这里我理解为00119就是oracle没有启动! 二、 解决办法 这种方式每次电脑重启以后,都需要用sysdba的身份启动数据库; ...
ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ORCLWENG' 3. 在数据库的Net Configuration Assistant中进行连接测试,提示如下错误。 ORA-12505 4. 平台 Win7 64位,Oracle database server 11gr2 64位,相应客户端为32位,32位...
LOCAL_LISTENERspecifiesanetworknamethatresolvestoanaddressoraddresslistofOracleNetlocallisteners(thatis,listenersthatarerunningonthesamemachineasthisinstance).TheaddressoraddresslistisspecifiedintheTNSNAMES.ORAfileorotheraddressrepositoryasconfiguredforyoursystem. 1.2REMOTE_LISTENER 官网说明： Property Descriptio...
ORACLE之手动注册监听listener。alter system set local_listener="XXX" 记录下刚刚做的一个为一个数据库(t02)配置多个监听(listener)的实验,过程有点小曲折。 (1)新增两个测试的监听,listener.ora的配置内容(可纯手动编辑该文件或使用netca)如下: (LISTENER为系统原有;L1、L2为测试用新增的监听)...
今天安装Oracle12 c后发现启动Oracle的时候报错 ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_INSPUR' 经过晚上发现是监听配置问题 解决步骤如下: 以管理员身份启动命令提示符 ...