今天在做oracle10gR2新特性透明加密(TDE)的时候,建立wallet默认路径和修改sqlnet.ora文件都 报ORA-28368和ORA-28353错误,而且修改sqlnet.ora文件后,监听程序起不来,后来在sqlnet.ora文件里加入NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)问题解决。
下面简单介绍下我对NAMES.DIRECTORY_PATH连接参数的了解:
NAMES.DIRECTORY_PATH常用的值有tnsnames,hostname,onames和ezconnect和ldap,cds,nis不常用的值,默认值是(tnsnames,onames,hostname)。
如果设置NAMES.DIRECTORY_PATH=(tnsnames),那么客户端就只会从tnsnames.ora查找你要连接的字符串(如orcl)记录,如果tnsname.ora文件中没有此记录,则连接不上数据库。
如果设置NAMES.DIRECTORY_PATH=(tnsnames,hostname),那么客户端首先会从tnsnames.ora查找你要连接的字符串(如orcl)记录,如果tnsname.ora文件中没有此记录,则尝试把你要连接的字符串(如orcl)当作一个主机名,通过网络的途径去解析它的ip地址然后去连接这个ip上GLOBAL_DBNAME=连接字符串(如orcl)这个实例,当然这里连接字符串(如orcl)并不是一个主机名,最后会尝试以ezconnect的方式连接数据库。
下面是oracle官方文档对这些值的介绍:
tnsnames:local naming naming method
Set to resolve a net service name through the tnsnames.ora file on the client.
hostname:host naming method
Set to resolve a host name alias through an existing names resolution service or a centrally-maintained set of /etc/hosts files.
onames:Oracle Names method
Set to resolve database objects through a Oracle Names server.
ldap:directory naming naming method
Set to resolve a database service name, net service name, or net service alias through a directory server.
cds:Cell Directory Services (CDS) external naming method
Set to resolve an Oracle database name in a Distributed Computing Environment (DCE) environment.
nis:Network Information Service (NIS) external naming method
Set to resolve service information through an existing NIS.
Ezconnect:The easy connect naming method eliminates the need for service name lookup in the tnsnames.ora files for TCP/IP environments; in fact, no naming or directory system is required if you use this method.
分享到:
相关推荐
cpu_top.names_drv_tbl
NCL 显示正确的中国地图 NCL 官网的中国地图不准确,本例作了更改
Gets the name of the source file where the test part took place, or NULL if it s unknown.
resource file for graphopper routing
Signal name/number conversion routines for Linux.
首先是pd.read_excel的参数:函数为: pd.read_excel(io, sheetname=0,header=0,skiprows=None,index_col=None,names=None, arse_cols=None,date_parser=None,na_values=None,thousands=None, convert_float=True...
这个文件类似于unix 的hosts文件,提供的tnsname到主机名或者ip的对应,只有当sqlnet.ora中类似NAMES.DIRECTORY_PATH= (TNSNAMES) 这样,也就是客户端解析连接字符串的顺序中有TNSNAMES时,才会尝试使用这个文件。...
Idk how to name this file again
批量修改,替换当前目录下的文件名。在处理数据文件时非常有用的
All trademarks and trade names are the properties of their respective owners and Digilent, Inc. disclaims any proprietary interest or right in trademarks, service marks and trade names other than ...
tinydir, 轻量级便携和易于集成C目录和文件阅读器。用法: void get_file_names(string dir_name, vector<string> & names) ... names.push_back(file.path); } tinydir_next(&dir;); } tinydir_close(&dir;); }
This file defines all the register names and addresses div hr di
stubs.input_isdk-stubs.input_i.lensdk-stubs.namessdk-stubs.names.keystreamsdk-stubs.names.keystream.lensdk-stubs.names.lensdk-stubs.names_isdk-stubs.names_i.lensdk-stubs.versionlib/commons-compress-...
It is a phone directory written in C++ which stores phone numbers and names. You can also edit and save the numbers and names.
DDM(Delicate Document Manager) is a tool for... It provides an Explorer-like view of PDF files with their titles instead of file names. It embeds a fast incremental search function for finding PDF files.
data.sheet_names() 相当于进入文件中的一个工作表。 table = data.sheet_by_name('Sheet1') 查看工作表一共有几行 rowNum = table.nrows 查看工作表一共有几列 colNum = table.ncols 查看第一行所有的名称...
self.sheet_names 当前工作簿(excel)拥有sheet(表格)列表 5. self.active_sheet 当前sheet(表格)对象 功能: 基础: 1. create_sheet() 创建sheet(表格) 2. switch_sheet() 切换sheet(表格) 3. save() 保存...
For Pascal/Delphi, fixed a bug where namespace names given in the Namespaces option were not used for 'uses' statement names that were dotted names (for example, namespace System was not prepended to ...
Since this is only used in stats socket , we give meaning names instead of the REAL names.
pstables.h PostScript glyph names.