linux oracle lsnrctl tns-12541,linux – Oracle客户端抛出ORA-12541：TNS：没有监听器

当我试图连接我的远程服务器时 –

sqlplus SYSTEM/oracle@192.168.0.171:1521/kannel

它告诉我这个错误 –

SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 15 15:36:52 2013

copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:

ORA-12541: TNS:no listener

我检查了我的听众,它正在运行

[root@roracle bin]# ./lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 15-NOV-2013 15:42:24

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

tnsnames.ora文件包含 –

KANNEL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = kannel)

)

)

listener.ora文件包含

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = kannel)

(ORACLE_HOME = /opt/u01/app/product/11.2.0/dbhome_1)

(SID_NAME = kannel)

)

)

LISTENER=

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

)

)

)

sqlnet.ora文件包含 –

SQLNET.AUTHENTICATION_SERVICES= (ALL)

NAMES.DIRECTORY_PATH= (TNSNAMES,ONAMES,HOSTNAME)

Oracle主路径 –

$ORACLE_HOME=/opt/u01/app/product/11.2.0/dbname_1

Oracle基本路径 –

$ORACLE_BASE=/opt/u01/app

我已经设置了环境变量

[root@roracle bin]# env | sort

}

_=/bin/env

CVS_RSH=ssh

G_BROKEN_FILENAMES=1

HISTCONTROL=ignoredups

HISTSIZE=1000

HOME=/root

HOSTNAME=roracle

LANG=en_IN

LESSOPEN=|/usr/bin/lesspipe.sh %s

LOADEDMODULES=

LOGNAME=root

LS_COLORS=rs=<......something........>:

MAIL=/var/spool/mail/root

module=() { eval `/usr/bin/modulecmd bash $*`

MODULEPATH=/usr/share/Modules/modulefiles:/etc/modulefiles

MODULESHOME=/usr/share/Modules

OLDPWD=/root

ORACLE_BASE=/opt/u01/app/

ORACLE_HOME=/opt/u01/app/product/11.2.0/dbhome_1

ORACLE_SID=kannel

PATH=/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

PWD=/opt/u01/app/product/11.2.0/dbhome_1/bin

QTDIR=/usr/lib64/qt-3.3

QTINC=/usr/lib64/qt-3.3/include

QTLIB=/usr/lib64/qt-3.3/lib

SHELL=/bin/bash

SHLVL=1

SSH_CLIENT=192.168.0.83 35604 22

SSH_CONNECTION=192.168.0.83 35604 192.168.0.171 22

SSH_TTY=/dev/pts/0

TERM=xterm

USER=root

当我作为localhost访问数据库时 –

./sqlplus / as sysdba[oracle@roracle bin]$./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 15 16:04:02 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL> select v$database;

select v$database

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

我不明白我错在哪里…..有人可以帮忙吗？

解决方法:

可能是你以root身份启动了监听程序进程吗？我可以看到你正在以root用户身份尝试lsnrctl状态,所以请确保以oracle用户身份启动监听器进程,然后启动数据库(也作为Oracle用户)

此外,如果您“连接到空闲实例”,这意味着您正在连接到未运行的实例,或者您已将环境设置为错误,无法连接到要连接的实例.

确保路径中包含Oracle软件目录,例如/u01/app/oracle/product/11.0/dbhome_1/bin

和ORACLE_SID设置为数据库实例名称.

标签：linux,oracle

来源： https://codeday.me/bug/20190805/1593799.html