Hostname: node1.idc.oracle.com VIP Hostname: node1-vip.idc.oracle.com Database Service_names: service.idc.oracle.com SID: sid1 Node2: Hostname: node2.idc.oracle.com VIP Hostname: node2-vip.idc.oracle.com Database Service_names: service.idc.oracle.com SID: sid2 3.2.2Node1配置 (1...
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错误解决 原文:http://www.cnblogs.com/arxive/p/5989210.html...
官网信息如下: LOCAL_LISTENER specifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are running on the same machine as this instance). The address or address list is specified in the TNSNAMES.ORA file or other address repos...
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
Parameter type String Syntax REMOTE_LISTENER = network_name Default value There is no default value. Modifiable ALTER SYSTEM Basic Yes 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 ...
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的身份启动数据库; ...
Parameter type String Syntax REMOTE_LISTENER = network_name Default value There is no default value. Modifiable ALTER SYSTEM Basic Yes 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 ...
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位...
今天安装Oracle12 c后发现启动Oracle的时候报错 ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_INSPUR' 经过晚上发现是监听配置问题 解决步骤如下: 以管理员身份启动命令提示符 ...