[oracle@localhost bin]$ ./lsnrctl startLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 21-FEB-2008 10:23:40Copyright (c) 1991, 2005, Oracle. All rights reserved.Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 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-00515: Message 515 not found; No message file for product=network, facility=TNS
Linux Error: 2: No such file or directory请高手指点一下,哪里出错了?在线等~
TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
Linux Error: 2: No such file or directory请高手指点一下,哪里出错了?在线等~
解决方案 »
- oracle的alert日志中报出以下错误,求解?
- oracle:新手请教用户更改表空间的相关问题
- 求助,关于一条sql查询语句的编写,
- 请问各位在写代码时,用的什么工具?那些帮助文档那里有(比如查找某个函数的用法等)? 多谢.
- 我想要ocp的真题.300分相送
- Oracle 新手疑问3:
- oracle中在循环中如何实现像c里面的continue这样的功能?--小问题--急!
- Win2k中启动OracleOraHome81TNSListener服务错误,求救!
- drop use 的问题
- 关于大数据量的查询问题,我用了两个WHILE,但发觉速度为什么这么慢,请有经验的人来评评(在线等待)
- 用IMP导入数据后,表的initial设定值为什么变了?
- 触发器锁表的问题
TNS-12560: Message 12560 not found; No message file for product=network, facili ty=TNS
TNS-00511: Message 511 not found; No message file for product=network, facilit y=TNS
Linux Error: 111: Connection refused
[oracle@localhost bin]$ vi ../n
network/ nls/
[oracle@localhost bin]$ vi ../n
network/ nls/
[oracle@localhost bin]$ cat ../network/admin/listener.ora
# listener.ora Network Configuration File: /usr/oracle/oracle/product/10.2.0/db_ 1/network/admin/listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
)[oracle@localhost bin]$
是ORACLE用户在启动监听么?把localhost 换成本机的IP
贴一下oracle用户的 profile
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATH
unset USERNAMEORACLE_BASE=/usr/oracle
ORACLE_SID=orcl
ORACLE_HOME=/usr/oracle
export ORACLE_BASE ORACLE_SID ORACLE_HOME
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
) LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
)
设置你这里的ORACLE_HOME
ORACLE_SID=orcl
ORACLE_HOME=/usr/oracle
export ORACLE_BASE ORACLE_SID ORACLE_HOME ORACLE_HOME=/usr/oracle/oracle/product/10.2.0/db_1
umask 022
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
当我登录linux是总是报错:
-bash: /etc/profile: line 54: syntax error near unexpected token `then'
-bash: /etc/profile: line 54: ` if [ $SHELL = "/bin/ksh" ]; then'
但还是启动不了
profile 中的ORACLE_HOME等信息没在你的oracle 用户下.....你先这样试一下
全部手动....su - oracleexport ORACLE_HOME=/usr/oracle/oracle/product/10.2.0/db_1
export ORACLE_SID=orcl
./usr/oracle/oracle/product/10.2.0/db_1/bin/lsnrctl start