http://www.mrbustonian.com

如下是我启动实例的报错及监听配置和Service启动情况

第一次配置监听和实例后,正常启动和访问,电脑重启后,再次打开,数据库实例启动报错:ora-00119和ora-00130的。如下是我启动实例的报错及监听配置和Service启动情况。如下是listener.ora的配置。#listener.oraNetworkConfigurationFile:C:appproduct11.2.0dbhome_1networkadminlistener.ora#GeneratedbyOracleconfigurationtools.SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=CLRExtProc)(ORACLE_HOME=C:appproduct11.2.0dbhome_1)(PROGRAM=extproc)(ENVS="EXTPROC_DLLS=ONLY:C:如下是我启动实例的报错及监听配置和Service启动情况。appproduct11.2.0dbhome_1binoraclr11.dll"))(SID_DESC=(GLOBAL_DBNAME=ALM)(SID_NAME=ALM))(SID_DESC=(SID_NAME=CLRExtProc)(ORACLE_HOME=C:appproduct11.2.0dbhome_1)(PROGRAM=extproc)(ENVS="EXTPROC_DLLS=ONLY:C:appproduct11.2.0dbhome_1binoraclr11.dll"))(SID_DESC=(SID_NAME=CLRExtProc)(ORACLE_HOME=C:appproduct11.2.0dbhome_1)(PROGRAM=extproc)(ENVS="EXTPROC_DLLS=ONLY:C:appproduct11.2.0dbhome_1binoraclr11.dll")))LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6.100)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))))ADR_BASE_LISTENER=C:app如下是tnsnames.ora的配置#tnsnames.oraNetworkConfigurationFile:C:appproduct11.2.0dbhome_1networkadmintnsnames.ora#GeneratedbyOracleconfigurationtools.ORACLR_CONNECTION_DATA=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))(CONNECT_DATA=(SID=CLRExtProc)(PRESENTATION=RO)))ALM=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6.100)(PORT=1521))(CONNECT_DATA=(SERVER=ALM)(SERVICE_NAME=ALM)))

图片 1

郑重声明:本文版权归俄罗斯254娱乐网址所有,转载文章仅为传播更多信息之目的,如作者信息标记有误,请第一时间联系我们修改或删除,多谢。