[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 <listener name>

// - 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).