手工建库后 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的内容复制到里面,两边内容完全一致

请使用浏览器的分享功能分享到微信等