Oracle 11G无法从模板创建数据库

Question

我正在尝试从Oracle 11G中的现有模板创建一个新的数据库。在使用dbca之前，我已经这样做了，并且没有出现问题，但是现在我遇到了以下错误：

TNS-04404: no error caused by oracle.net.ConfigException: 
TNS-04414: File error caused by: 
TNS-04610: No literals left, reached end of NV pair

经过一些研究，我发现TNS-04610很可能是tnsnames.ora文件的一个问题。我在$ORACLE_HOME/network/admin/目录中找到了这个文件。这些文件包含以下内容：

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_3/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.




BASE_901_NEW =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = BASE_901_new)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.domain.com)
    )
  )

BASE_901 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = Base_901)
    )
  )

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = Test)
    )
med =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = med)
    )

据我所知，那个文件看上去是正确的。有没有我不知道的语法错误？

该文件不是由我创建的，据我所知，没有人手动编辑该文件。

任何线索都很感激，因为我一直找不到任何线索。

Answer 1

后两个条目有不平衡的括号。你不能关闭最高级的家长。

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = Test)
    )
  )              -- add this
med =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = med)
    )
  )              -- add this

(但不要添加评论。)

可能是一个好主意，在任何地方都要与套管保持一致(尽管我不确定这真的很重要)。如果您调用数据库TEST，那么将TEST放在任何地方，而不是在某些地方放置Test，在其他地方放置TEST。