Tns-12505:tns:listener does not currently know of SID given in Connect descriptor

Log.xml Error Messages in Oracle

Tns-12505:tns:listener does not currently know of SID given in Connect descriptor

Plsql Login Error message:

Unable to request service in descriptor

Baidu has a lot of, is a kind of processing method, but to me here completely regardless of use, below is I encountered two times unusual solution method:

1, see /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora this configuration file

# 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.230.21.55) (PORT = 1521))

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

)

)

Adr_base_listener =/u01/app/oracle

Before the red place is localhost, but the hostname is not this, changed to host IP or the current hostname, successfully handle the problem.

2, the above treatment method has not worked, the error message is still the same,

The final discovery is/etc/hosts this configuration file

[Email protected] 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.21.55Esboracle55

The marked Red Place commented out, successfully solved the problem.

Files that may exist for SIDS

Tnsname.ora

Listerner,ora

Profile

[Email protected] admin]# su-oracle

[Email protected] ~]$ 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= ' [\[email protected]\h \w]\$ '; # Default Value

Tns-12505:tns:listener does not currently know of SID given in Connect descriptor