Shulou(Shulou.com)06/01 Report--

Log.xml error message in oracle

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

Plsql login error message:

Unable to request the service in the descriptor

Baidu has a lot of things, all of which are a way to deal with them, but it doesn't work for me at all. Here are the solutions to the two exceptions I encountered:

1. Look at the configuration file / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# listener.ora Network Configuration File: / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 10.23.room.55) (PORT = 1521))

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

)

)

ADR_BASE_LISTENER = / u01/app/oracle

Before the red mark, it was localhost, but the host name was no longer this, so it was changed to the host IP or the present host name, and the problem was dealt with successfully.

2. The above processing method is no longer effective, and the error message is still the same.

It turns out to be the configuration file / etc/hosts.

[oracle@esboracle55 admin] $cat / etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6

# 192.168.67.236 localhost.localdomain

# 127.0.0.1esboracle55

10.230.The esboracle55.

If the mark is commented out, the problem will be solved successfully.

There may be files for SID

Tnsname.ora

Listerner,ora

Profile

[root@esboracle55 admin] # su-oracle

[oracle@esboracle55 ~] $cat .bash _ profile

# .bash _ profile

# Get the aliases and functions

If [- f ~ / .bashrc]; then

. ~ / .bashrc

Fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

Export PATH

# use_for_oracle

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_SID=orcl

# export ogg=/oracle/ogg

# export JAVA_HOME=/ora_bck/java/jdk1.6.0_32

# export CLASSPATH=/lib/dt.jar:/lib/tools.jar

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

Export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/ccs/bin:/bin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

Export ORACLE_TERM=xterm

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/lib64:/usr/lib64

Export NLS_DATE_FORMAT= "YYYY-MM-DD HH24:MI:SS"

Export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Export PS1=' [\ u@\ h\ W]\ $'; # default value

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.