手工建庫後 sql developer連線不上新資料庫 出現 ora-12514錯誤

1,Oracle 上找到 tnsnames.ora  目錄：$ORACLE_HOME/network/admin

   LISTENER_TESTDB =

  (ADDRESS = (PROTOCOL = TCP)(HOST = solaris102.cuug.net)(PORT = 1521))

 

 

TESTDB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = solaris102.cuug.net)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = testdb)

    )

  )

2,在本地找到E:\app\asus\product\11.2.0\client_1\NETWORK\ADMIN 找到tnsnames.ora 將1的內容複製到裡面，兩邊內容完全一致