NNL-00020: warning: no TNSNAMES.ORA file and no preferred name servers in SQLNET.ORA

NNL-00020: warning: no TNSNAMES.ORA file and no preferred name servers in SQLNET.ORA
Cause: The control program was unable to find a TNSNAMES.ORA file and was unable to find a default name server in SQLNET.ORA. The control program will operate in this state, but will be unable to resolve any names until a default server has been set, and that server must be set using its raw TNS address.
Action: The control program's SQLNET.ORA file must exist in the correct system-specific location, and must be readable by the control program. The file must contain a names.preferred_servers entry with valid name server addresses. The first server in the preferred-server list must be running, and there must be network connectivity between the control program and that server. Alternatively, a TNSNAMES.ORA file with valid name server information must exist in the correct system-specific location.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:48

NNL-00020：warning：没有TNSNAMES.ORA文件，SQLNET.ORA中没有首选的名称服务器,
.原因：控制程序无法找到TNSNAMES.ORA文件，并且无法在SQLNET.ORA中找到默认名称服务器。控制程序将在此状态下运行，但在设置默认服务器之前无法解析任何名称，并且必须使用其原始TNS地址设置该服务器。,
.操作：控制程序的SQLNET.ORA文件必须存在于正确的系统特定位置，并且必须由控制程序读取。该文件必须包含具有有效名称服务器地址的names.preferred_servers条目。首选服务器列表中的第一台服务器必须正在运行，控制程序和该服务器之间必须有网络连接。或者，具有有效名称服务器信息的TNSNAMES.ORA文件必须存在于正确的系统特定位置。,
.

aiaiDBA

13718043309

010-86462881

NNL-00020: warning: no TNSNAMES.ORA file and no preferred name servers in SQLNET.ORA

1 个回答

相似问题