title: Oracle TNS-12505 Error
body: <p>I am working with Oracle and what I had to do was to export the existing database to new installation.</p>
  
  <p>I have installed  new oracle client 8.1 (Previous was 8.0), I have successfully imported all the instance of database,(Users,Roles, everything).</p>
  
  <p>Basically it is Server and from other individual clients it shares data.
  What I am facing a problem now is , 
  any XYZ client can not varify its login credentials. I am getting two different types of erros. below I will mention:</p>
  
  <ol>
  <li>TNS-12505: TNS:listener could not resolve SID given in connect descriptor</li>
  <li>TNS-12500: TNS:listener failed to start a dedicated server process
   TNS-12560: TNS:protocol adapter error
    TNS-00530: Protocol adapter error</li>
  </ol>
  
  <p>I have tried almost every option by googling the specified errors.</p>
  
  <p>I have configured the TNSNAMES.ora and LISTENER.ora at server installation and test , they are working well.</p>
  
  <p>But the issue is when I connect through client after configuring TNSNAMES using "Net8 Assitant" it shows the following error.</p>
  
  <pre><code>TNS-12505: TNS:listener could not resolve SID given in connect descriptor
  </code></pre>
  
  <p>I will try to attach the Configuration files data:
  <strong>TNSNAMES.ora @ Server</strong></p>
  
  <pre><code># D:\ORANT\NETWORK\ADMIN\TNSNAMES.ORA Configuration   File:d:\orant\NETWORK\ADMIN\tnsnames.ora
  # Generated by Oracle Net8 Assistant
  
   DATA =
     (DESCRIPTION =
       (SOURCE_ROUTE = OFF)
       (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.109)(PORT = 1521))
       )
       (CONNECT_DATA =
         (SERVICE_NAME = data)
         (GLOBAL_NAME = data)
         (SRVR = DEDICATED)
       )
     )
  </code></pre>
  
  <p><strong>LISTENER.ora @ Server</strong></p>
  
  <pre><code># D:\ORANT\NETWORK\ADMIN\LISTENER.ORA Configuration File:d:\orant\NETWORK\ADMIN\listener.ora
  # Generated by Oracle Net8 Assistant
  
  LISTENER =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rwr_mis)(PORT = 1521))
      (PROTOCOL_STACK =
        (PRESENTATION = TTC)
        (SESSION = NS)
      )
    )
  </code></pre>
  
  <p>And Finally <strong>TNSNAMES.ora @ Client</strong></p>
  
  <pre><code># C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\orant\net80\admin\tnsnames.ora
  # Generated by Oracle Net8 Assistant
  
  data =
    (DESCRIPTION =
     (ADDRESS_LIST =
          (ADDRESS =
            (PROTOCOL = TCP)
            (Host = 192.168.0.109)
            (Port = 1521)
          )
      )
      (CONNECT_DATA = (SID = ORCL)
      )
    )
  </code></pre>
  
  <p>From above settings I am gettin gthe followin gerror at Client side:</p>
  
  <p><em><strong>TNS-12505: TNS:listener could not resolve SID given in connect descriptor</em></strong></p>
  
  <p>kindly suggest any solution, I will be very thankful .</p>