cmd下面输入 lsnrctl start 报如下错误:
Message 1070 not found; No message file for product=NETWORK, facility=TNS TNS-12557:
Message 12557 not found; No message file for product=NETWORK, facility=TNS TNS-12560:
Message 12560 not found; No message file for product=NETWORK, facility=TNS TNS-00527:
Message 527 not found; No message file for product=NETWORK, facility=TNS在网上搜了下,大致都说是两个配置文件的问题,可是我查了下,没有问题
listener.orgSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)tnsnames.orgORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)说明一下,我是用的笔记本无线网络,自动获取的IP地址刚装好的时候还是好好的,服务都自动启动了,然后我把服务设置成手动启动,然后就启动不起来了请高人解决啊,100分送上!
Message 1070 not found; No message file for product=NETWORK, facility=TNS TNS-12557:
Message 12557 not found; No message file for product=NETWORK, facility=TNS TNS-12560:
Message 12560 not found; No message file for product=NETWORK, facility=TNS TNS-00527:
Message 527 not found; No message file for product=NETWORK, facility=TNS在网上搜了下,大致都说是两个配置文件的问题,可是我查了下,没有问题
listener.orgSID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)tnsnames.orgORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)说明一下,我是用的笔记本无线网络,自动获取的IP地址刚装好的时候还是好好的,服务都自动启动了,然后我把服务设置成手动启动,然后就启动不起来了请高人解决啊,100分送上!
lsnrctl start是启动listener,这里只是和listener.ora有关所以tnsname.ora可以不去关注。根据你的描述,你最好启动netca,然后先删除掉原有的listener。然后新建一个listener。注意你是笔记本,最好把host设置为机器名,或者127.0.0.1BTW,看叻你的listener.ora的内容。你的Oracle安装到c盘叻,这从软件管理方面考虑是不好的。
现在机器在裸奔啊 , 只有个 360安全卫士
IOException: 无法创建 NetProperties: c:\Ora10InstantClient\network\tools\NetProp
erties (系统找不到指定的路径。)
IOException: 无法创建 NetProperties:Oracle Net Services 配置:java.lang.Error: Error loading image: c:\Ora10InstantClient\network\tools\images
\netcaIntro.gif
at oracle.net.ca.NetCA.loadImage(Unknown Source)
at oracle.net.ca.NetCA.init(Unknown Source)
at oracle.net.ca.NetCA.<init>(Unknown Source)
at oracle.net.ca.NetCA.main(Unknown Source)
Oracle Net Services 配置失败。退出代码是-1
c:\Ora10InstantClient\network\tools这个是即时客户端的目录
2、path 把路径内容贴出来看看
这位老兄说对了,我试先装了server,后来又装了个client。这个要怎么改?怎么做才能让路径正确呢?这个是我服务的路径
C:\oracle\product\NETWORK\tools
:54Copyright (c) 1991, 2005, Oracle. All rights reserved.Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-125
57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=NETWORK, facili
ty=TNS
TNS-00527: Message 527 not found; No message file for product=NETWORK, facilit
y=TNS在 cmd 下面输入 lsnrctl start报如下信息LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 30-JUL-2009 09:11
:01Copyright (c) 1991, 2005, Oracle. All rights reserved.Message 1070 not found; No message file for product=NETWORK, facility=TNSTNS-125
57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=NETWORK, facili
ty=TNS
TNS-00527: Message 527 not found; No message file for product=NETWORK, facilit
y=TNS
path环境变量 没有问题啊C:\oracle\product\bin;C:\Program Files\Java\jdk1.5.0_07\bin;C:\windows\system32\用ORACLE_Server安装的路径/bin/lsnrctl start 还是报同样的错误C:\oracle\product\BIN>lsnrctl startLSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 30-JUL-2009 17:22
:46Copyright (c) 1991, 2005, Oracle. All rights reserved.Message 1070 not found; No message file for product=NETWORK, facility=TNSTNS-125
57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=NETWORK, facili
ty=TNS
TNS-00527: Message 527 not found; No message file for product=NETWORK, facilit
y=TNS注册表的ORACLE_HOME的值 也没有问题啊 C:\oracle\product
操作:
运行:services.msc
启动OracleXXXXXXXXListener
启动OracleServiceXXXXX
cmd LSNRCTL
status
LSNRCTL> status
没有错误就是起来了!当然你那个估计是错误的!
2、检查环境变脸以及注册表中的OARCLE_SID是否和正确!并非Oracle_HOME。
3、确认没有任何应用程序占用监听程序的端口!
net stat -a
监听程序不配置,你应该可以登陆你的Oracle数据库的!
1、用netca重配监听(楼主的netca起不了)
2、防火墙问题,在装LINUX的时候,楼主应该把防火墙禁用了吧,如果没有就重新配置禁用。
3、路径以及配置问题。我以前有这样的问题,一台机子上装了SERVER和client,配置ORACLE_HOME后就出问题了。结果把ORACLE_HOME删除就OK。不过楼主的问题应该不在这里。做个标记,等待高人出手。
http://www.360doc.com/content/11/0615/10/80517_127050460.shtml