[20181204]低版本toad 9.6直连与ora-12505.txt

--//我们生产系统还保留有一台使用AMERICAN_AMERICA.US7ASCII字符集的数据库,这样由于toad新版本不支持该字符集的中文显示.

--//我一直保留toad 9.6的版本,并且这个版本是32位的,我必须在我的机器另外安装10g 32位版本的客户端,这样才能连上数据库.

--//同事前一段时间遇到使用该版本的连接问题,我已经解决,链接:http://blog.itpub.net/267265/viewspace-2219005/

--//前几天同事告诉我配置tnsnames.ora连接没有问题.而使用toad下直连模式报ora-12505错误.数据库是18c的版本

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

$ oerr ora 12505

12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor"

// *Cause: The listener received a request to establish a connection to a

// database or other service. The connect descriptor received by the listener

// specified a SID for an instance (usually a database instance) that either

// has not yet dynamically registered with the listener or has not been

// statically configured for the listener. This may be a temporary condition

// such as after the listener has started, but before the database instance

// has registered with the listener.

// *Action:

// - Wait a moment and try to connect a second time.

// - Check which instances are currently known by the listener by executing:

// lsnrctl services

// - Check that the SID parameter in the connect descriptor specifies

// an instance known by the listener.

// - Check for an event in the listener.log file.

--//有点奇怪的是我明明直连使用服务名连接,为什么报TNS:listener does not currently know of SID given in connect descriptor.

--//而是有关sid的信息呢?

1.环境:

SYS@orclcdb> select BANNER from v$version ;

BANNER

--------------------------------------------------------------------------------

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

--//首先我尝试使用toad 9.6直连cdb数据库,ok没有问题.而问题出现在连接pdb数据库.

$ lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 04-DEC-2018 09:10:36

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production

Start Date 04-DEC-2018 09:06:09

Uptime 0 days 0 hr. 4 min. 27 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/18.0.0/grid_home/network/admin/listener.ora

Listener Log File /u01/app/oracle_base/diag/tnslsnr/hosp2/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hosp2)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM", status READY, has 1 handler(s) for this service...

Service "+ASM_DATA" has 1 instance(s).

Instance "+ASM", status READY, has 1 handler(s) for this service...

Service "64a52f53a7683286e053cda9e80aed76" has 1 instance(s).