[20181204] Low version toad 9.6 Direct and indirect ora-12505.txt

--// We still have one in our production system AMERICAN_AMERICA.US7ASCII Character set database , Such as toad The new version does not support the Chinese display of this character set .
--// I always keep toad 9.6 Version of , And this version is 32 Bit , I have to install another on my machine 10g 32 Bit version of the client , So you can connect to the database .

--// Some time ago, my colleagues encountered a connection problem using this version , I've solved , link :http://blog.itpub.net/267265/viewspace-2219005/

--// A few days ago, my colleague told me to configure tnsnames.ora There's no problem with the connection . While using toad Next direct connection model report ora-12505 error . The database is 18c Version of
--//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.

--// It's a bit strange that I use the service name to connect directly , Why TNS:listener does not currently know of SID given in connect descriptor.
--// It's about sid The information of ?

1. Environmental Science :
SYS@orclcdb> select BANNER from v$version ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

--// First I try to use toad 9.6 Direct connection cdb database ,ok No problem . And the problem is connecting pdb database .

$ lsnrctl status
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 04-DEC-2018 09:10:36
Copyright (c) 1991, 2018, Oracle.  All rights reserved.
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).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "74a69dc145f5662be0558253dd747177" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Service "orclcdb" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
Service "orclcdbXDB" has 1 instance(s).
  Instance "orclcdb", status READY, has 1 handler(s) for this service...
The command completed successfully

--// Pay attention to the service name orcl The example pointed to inside is orclcdb.
--// Suddenly I think of links :http://blog.itpub.net/267265/viewspace-2140061/ Test of .
--// It's the same with the tips
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
Warning: You are no longer connected to ORACLE.
--// I use the service name connection to access the database , Why sid Or something like that .

--// Depending on toad 9.6 The direct connection mode of the version is also very strange , Depending on who's going to be sid.
--// Modify listening profile ./u01/app/oracle/product/18.0.0/grid_home/network/admin/listener.ora
--// Add the following :
USE_SID_AS_SERVICE_listener=on

--// Note the location of the file , Our database is very special , Single instance asm. To be modified /u01/app/oracle/product/18.0.0/grid_home/network/admin/ The listening configuration file in the directory .
--// Monitoring and restart also need to be executed :
$ srvctl stop listener ; srvctl start listener

--// Use it again toad There is no problem with the direct connection mode , Connect cdb And pdb No problem .
--// I finally found out that this version of toad(9.6) Yes bug( Service name and sid There's no problem with the connection ), If you use toad 12 The above version does not have this problem .

--// I have the following configuration in my test environment :
SYS@book> @ ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-DEC-2018 09:50:59
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(ARGV0=LLLLLL)(HOST=0.0.0.0)(PORT=1521)(ARGV0=KKKKK)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                20-SEP-2018 09:52:59
Uptime                    74 days 23 hr. 58 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/11.2.0.4/dbhome_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "BOOKSHARE" has 1 instance(s).
  Instance "book", status READY, has 1 handler(s) for this service...
Service "booK123" has 1 instance(s).
  Instance "book", status UNKNOWN, has 1 handler(s) for this service...
Service "book" has 1 instance(s).
  Instance "book", status READY, has 2 handler(s) for this service...
Service "bookXDB" has 1 instance(s).
  Instance "book", status READY, has 1 handler(s) for this service...
The command completed successfully

--// To configure 2 A service bookshare,book123. bookshare It's a dynamic service name ,book123 It's static service .

SYS@book> show parameter service
NAME          TYPE   VALUE
------------- ------ ---------------
service_names string BOOK, BOOKSHARE

--// Monitoring configuration is as follows :
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

#SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

SID_LIST_LISTENER =
   (SID_LIST =
    (SID_DESC =
      (SDU=32767)
      (GLOBAL_DBNAME = booK123)
      (ARGV0=myapp0)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)
      (SID_NAME=book)
      )
    )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(ARGV0=LLLLLL)(HOST = 0.0.0.0)(PORT = 1521)(ARGV0=KKKKK))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  )
 )

SECURE_REGISTER_LISTENER = (TCP)
ADR_BASE_LISTENER = /u01/app/oracle
DIAG_ADR_ENABLED_LISTENER=OFF
USE_NS_PROBES_FOR_DCD=true
INBOUND_CONNECT_TIMEOUT_LISTENER=10

--// Use toad 9.6 The connection uses the service name bookshare,book123 Metropolitan newspaper ora-12505 error . And using the new version toad 12 Can't .

[20181204] Low version toad 9.6 Direct and indirect ora-12505.txt More articles about

  1. Fedora12 Next yum Install the lower version gcc

    1.Fedora12 Next gcc The location and version are as follows : 2. According to need , To install a lower version of gcc, Direct use "yum install gcc" The latest version is installed by default gcc, as follows : 3. You can go through first & ...

  2. xcode Low version debugging high version real system

    Low version xcode Debug the high version system of the real machine // Open this path and copy the latest file here /Applications/Xcode.app/Contents/Developer/Platforms/iPhon ...

  3. Low version GCC The compatibility problem of program migration to higher version

    The lower version gcc Porting compiled programs to higher versions GCC when , There may be some compatibility issues . as a result of , In order to adapt to the new standards , Some old grammar rules have been abandoned . Some specific information in this regard can be found here . This is just one of my own experiences ...

  4. android Import lower version in project Possible compilation problems ( from : Victor@Beijing)

    Use a higher version of SDK Then import the previous version of project when , There will be some compatibility issues . (1)Unable to resolve target 'android-5'  Because this machine is now using 2.2 Of SDK ...

  5. Sql Server Local high version backup data backup to remote low version database method

    Want to Sqlserver Restore the data from high version backup to low version SqlServer2008R2 Up , But in the SqlServer There is no way to restore the database directly , It can be restored smoothly by the following methods . Generated by high version sql The script is in the lower version ...

  6. Let the lower version of Android The project shows Material Click effect of style

    It's a happy and unfortunate life to be entangled with different needs every day , This is not our family dear designers let us in the low version of Android It's similar to Material Design Click effect of . Although we all know Mater ...

  7. android In the use of ViewAnimationUtils.createCircularReveal() Not compatible with lower versions , In addition, the circle is realized scale Animation

    ViewAnimationUtils.createCircularReveal() An introduction to the : ViewAnimationUtils.createCircularReveal() It's Android 5.0 It was introduced , Fast ...

  8. Higher version -&gt; Low version migration , Low version client connects to high version database EXP Export error EXP-00008,ORA-01455,EXP-00000

    Production environment : Source database :RHEL + Oracle 11.2.0.3 Target database :HP-UX + Oracle 10.2.0.4   demand : Migrate partial tables   11.2.0.3-->10.2.0.4, if ...

  9. Android5.0 TimePicker,DatePicker Return to low version scrolling mode

    In the new edition TimePicker DatePicker Remote control is not supported , To return to low version scrolling mode, just xml Just add a sentence to the document : android:datePickerMode="spinner ...

Random recommendation

  1. If you use css Of border Attribute to draw a triangle

    Suppose there is a div, How to use css Make a triangle . This is used in our project. Let's sum it up a little bit today . By the way, it's great to write a blog secretly div { width: 0; height: 0; border-top: ...

  2. ubuntu/mint install google Chinese Pinyin input method

    sudo apt-get install fcitx sudo apt-get install fcitx-googlepinyin im-config Can finish google Input method of Restart the computer . On the right ...

  3. NET Basics (4): Reference type and value type

    CLR Two types are supported : Reference type and value type . although FCL Most types of are reference types , But most programmers use reference types , Reference types are always assigned from the managed heap ,c# Of new Operator returns the memory address of the object - The memory address of the object data . Use citation ...

  4. Use ftp Software upload and download php Missing line feed on file bug

    just writing :   In the use of ftp Software upload and download php Source file , We occasionally find that locally windows Next notepad++ It's written by the editor php file , In the use of ftp Upload to linux After the server ,php All line breaks in the file are missing , ...

  5. ewebeditor Editor ASP/ASPX/PHP/JSP Version vulnerability exploitation summary and solutions

    This editor is divided by script into 4 A version ,ASP/ASPX/PHP/JSP Every version has vulnerabilities to exploit . Judge whether the website uses eWebEditor Look at the source code , See if there is something similar in the source code ”ewebeditor.as ...

  6. SQL Server 2008 Copy publish subscribe ( Data synchronization )

    Database synchronization problem 1. There is a master database server A And another database server B, The client first accesses the database B, When B Access when the database server is down A, When it comes to databases B Conduct DML In operation , At the same time A updated , If A And B Communication failure between , Will ...

  7. if elseif else

    1)if,else if It needs to be followed by a judgment expression , Only when the conditions are met and else The statement can only be executed when the previous conditions are not satisfied (2) One if...else if...else Statement can have more than one else if sentence , ...

  8. 【 original 】leetCodeOj --- Sliding Window Maximum Problem solving report

    God , I have no confidence in this question “ water ” 了 ... Address : https://leetcode.com/problems/sliding-window-maximum/ Topic content : Given an arr ...

  9. PHP Developers are right JAVA Of WEB Introduction to development ( First edition - obsolete )

    Recently, I'm going to report to other departments PHP Development of children's shoes to do a right JAVA Training . Enemy and know yourself , you can fight a hundred battles with no danger of defeat , I need to know something about it first PHP, To confirm their foundation , Achieve good teaching effect . PHP( Originally Personal Home Page Abbreviation , Houzheng ...

  10. Linux Study 5-CentOS install Python3.6 The environment and pip3

    Preface centos7 Bring with you python, But it was python2 Version of python, If you want to install a python3 What shall I do? ? If you delete python2 Words , May cause other problems , Because some things are ...