- android - RelativeLayout 背景可绘制重叠内容
- android - 如何链接 cpufeatures lib 以获取 native android 库?
- java - OnItemClickListener 不起作用,但 OnLongItemClickListener 在自定义 ListView 中起作用
- java - Android 文件转字符串
我有:red hat 6 服务器、带 TCPS 连接设置的远程 Oracle 数据库、从 rpms 安装的 oracle 即时客户端(basic、odbc、sqlplus)。
我正在尝试设置 oracle 即时客户端以连接到远程数据库。输入命令时:
/usr/lib/oracle/11.2/client64/bin/sqlplus /@AVAYAPDSDB
我得到错误:
SQL*Plus: Release 11.2.0.4.0 Production on Sat Aug 29 12:04:39 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR: ORA-28759: failure to open file
不幸的是,我附近没有工程师可以帮助我解决这个问题,所以我真的希望在堆栈的社区。
Google 搜索了一段时间并搜索了哪些可以帮助我解决所有问题,我意识到跟踪 sqlplus 请求将是一个不错的起点。所以现在它的痕迹看起来像这样:
(1309189888) [29-AUG-2015 12:04:39:133] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
(1309189888) [29-AUG-2015 12:04:39:133] New trace stream is /tmp/ora/cli_30063.trc
(1309189888) [29-AUG-2015 12:04:39:133] New trace level is 16
(1309189888) [29-AUG-2015 12:04:39:133] --- TRACE CONFIGURATION INFORMATION ENDS ---
(1309189888) [29-AUG-2015 12:04:39:133] --- PARAMETER SOURCE INFORMATION FOLLOWS ---
(1309189888) [29-AUG-2015 12:04:39:133] Attempted load of system pfile source /usr/lib/oracle/11.2/client64/network/admin/sqlnet.ora
(1309189888) [29-AUG-2015 12:04:39:133] Parameter source loaded successfully
(1309189888) [29-AUG-2015 12:04:39:133]
(1309189888) [29-AUG-2015 12:04:39:133] Attempted load of local pfile source /root/.sqlnet.ora
(1309189888) [29-AUG-2015 12:04:39:133] Parameter source loaded successfully
(1309189888) [29-AUG-2015 12:04:39:133]
(1309189888) [29-AUG-2015 12:04:39:133] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
(1309189888) [29-AUG-2015 12:04:39:133] Successful parameter table load
(1309189888) [29-AUG-2015 12:04:39:133] -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
(1309189888) [29-AUG-2015 12:04:39:133] SSL_SERVER_DN_MATCH = FALSE
(1309189888) [29-AUG-2015 12:04:39:133] DIAG_ADR_ENABLED = OFF
(1309189888) [29-AUG-2015 12:04:39:133] SSL_CIPHER_SUITES = (SSL_RSA_EXPORT_WITH_RC4_40_MD5)
(1309189888) [29-AUG-2015 12:04:39:133] TRACE_LEVEL_CLIENT = SUPPORT
(1309189888) [29-AUG-2015 12:04:39:133] SSL_VERSION = 0
(1309189888) [29-AUG-2015 12:04:39:133] SQLNET.WALLET_OVERRIDE = TRUE
(1309189888) [29-AUG-2015 12:04:39:133] NAMES.DIRECTORY_PATH = (TNSNAMES)
(1309189888) [29-AUG-2015 12:04:39:133] SQLNET.AUTHENTICATION_SERVICES = (TCPS, BEQ)
(1309189888) [29-AUG-2015 12:04:39:133] WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY =/usr/lib/oracle/11.2/client64/network/admin/AVAYAPDSDB)))
(1309189888) [29-AUG-2015 12:04:39:133] TRACE_DIRECTORY_CLIENT = /tmp/ora
(1309189888) [29-AUG-2015 12:04:39:133] SSL_CLIENT_AUTHENTICATION = TRUE
(1309189888) [29-AUG-2015 12:04:39:133] --- PARAMETER SOURCE INFORMATION ENDS ---
(1309189888) [29-AUG-2015 12:04:39:133] --- LOG CONFIGURATION INFORMATION FOLLOWS ---
(1309189888) [29-AUG-2015 12:04:39:133] Log stream will be "/usr/lib/oracle/11.2/client64/sqlnet.log"
(1309189888) [29-AUG-2015 12:04:39:133] Log stream validation not requested
(1309189888) [29-AUG-2015 12:04:39:133] --- LOG CONFIGURATION INFORMATION ENDS ---
(1309189888) [29-AUG-2015 12:04:39:134] nlstdipi: entry
(1309189888) [29-AUG-2015 12:04:39:134] nlstdipi: exit
(1309189888) [29-AUG-2015 12:04:39:134] nigini: entry
(1309189888) [29-AUG-2015 12:04:39:134] nigini: Count in the NL global area is now 1
(1309189888) [29-AUG-2015 12:04:39:134] nigini: Count in NI gbl area now: 1
(1309189888) [29-AUG-2015 12:04:39:134] nrigbi: entry
(1309189888) [29-AUG-2015 12:04:39:134] nrigbni: entry
(1309189888) [29-AUG-2015 12:04:39:134] nrigbni: Unable to get data from navigation file tnsnav.ora
(1309189888) [29-AUG-2015 12:04:39:135] nigini: Count in NI gbl area now: 3
(1309189888) [29-AUG-2015 12:04:39:135] nigini: exit
(1309189888) [29-AUG-2015 12:04:39:135] niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
(1309189888) [29-AUG-2015 12:04:39:135] nnfgiinit: entry
(1309189888) [29-AUG-2015 12:04:39:135] nncpcin_maybe_init: default name server domain is [root]
(1309189888) [29-AUG-2015 12:04:39:135] nnfgiinit: Installing read path
(1309189888) [29-AUG-2015 12:04:39:136] nnfgsrsp: entry
(1309189888) [29-AUG-2015 12:04:39:136] nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
(1309189888) [29-AUG-2015 12:04:39:136] nnfgsrdp: entry
(1309189888) [29-AUG-2015 12:04:39:136] nnfgsrdp: Setting path:
(1309189888) [29-AUG-2015 12:04:39:136] nnfgsrdp: checking element TNSNAMES
(1309189888) [29-AUG-2015 12:04:39:136] nnfgsrdp: Path set
(1309189888) [29-AUG-2015 12:04:39:136] nnfun2a: entry
(1309189888) [29-AUG-2015 12:04:39:136] nlolgobj: entry
(1309189888) [29-AUG-2015 12:04:39:136] nnfgrne: entry
(1309189888) [29-AUG-2015 12:04:39:136] nnfgrne: Going though read path adapters
(1309189888) [29-AUG-2015 12:04:39:136] nnfgrne: Switching to TNSNAMES adapter
(1309189888) [29-AUG-2015 12:04:39:136] nnftboot: entry
(1309189888) [29-AUG-2015 12:04:39:136] nlpaxini: entry
(1309189888) [29-AUG-2015 12:04:39:136] nlpaxini: exit
(1309189888) [29-AUG-2015 12:04:39:136] nnftmlf_make_local_addrfile: entry
(1309189888) [29-AUG-2015 12:04:39:136] nnftmlf_make_local_addrfile: construction of local names file failed
(1309189888) [29-AUG-2015 12:04:39:136] nnftmlf_make_system_addrfile: entry
(1309189888) [29-AUG-2015 12:04:39:136] nnftmlf_make_system_addrfile: system names file is /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora
(1309189888) [29-AUG-2015 12:04:39:136] nnftmlf_make_system_addrfile: exit
(1309189888) [29-AUG-2015 12:04:39:136] nnftboot: exit
(1309189888) [29-AUG-2015 12:04:39:136] nnftrne: entry
(1309189888) [29-AUG-2015 12:04:39:136] nnftrne: Original name: AVAYAPDSDB
(1309189888) [29-AUG-2015 12:04:39:136] nnfttran: entry
(1309189888) [29-AUG-2015 12:04:39:136] nncpdpt_dump_ptable: --- /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora TABLE HAS THE FOLLOWING CONTENTS ---
(1309189888) [29-AUG-2015 12:04:39:136] nncpdpt_dump_ptable: AVAYAPDSDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = ccpdsdko)(PORT = 2484))) (CONNECT_DATA = (SERVICE_NAME = orastd)))
(1309189888) [29-AUG-2015 12:04:39:136] nncpdpt_dump_ptable: --- END /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora TABLE ---
(1309189888) [29-AUG-2015 12:04:39:136] nnfttran: exit
(1309189888) [29-AUG-2015 12:04:39:136] nnftrne: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = ccpdsdko)(PORT = 2484))) (CONNECT_DATA = (SERVICE_NAME = orastd))) for name AVAYAPDSDB
(1309189888) [29-AUG-2015 12:04:39:136] nnftrne: exit
(1309189888) [29-AUG-2015 12:04:39:137] nigtrm: Count in the NI global area is now 2
(1309189888) [29-AUG-2015 12:04:39:137] nigtrm: Count in the NL global area is now 2
(1309189888) [29-AUG-2015 12:04:39:137] nigini: entry
(1309189888) [29-AUG-2015 12:04:39:137] nigini: Count in the NL global area is now 3
(1309189888) [29-AUG-2015 12:04:39:137] nigini: Count in NI gbl area now: 3
(1309189888) [29-AUG-2015 12:04:39:137] nigini: exit
(1309189888) [29-AUG-2015 12:04:39:137] niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
(1309189888) [29-AUG-2015 12:04:39:137] nnfun2a: entry
(1309189888) [29-AUG-2015 12:04:39:137] nlolgobj: entry
(1309189888) [29-AUG-2015 12:04:39:137] nnfgrne: entry
(1309189888) [29-AUG-2015 12:04:39:137] nnfgrne: Going though read path adapters
(1309189888) [29-AUG-2015 12:04:39:137] nnfgrne: Switching to TNSNAMES adapter
(1309189888) [29-AUG-2015 12:04:39:137] nnftrne: entry
(1309189888) [29-AUG-2015 12:04:39:137] nnftrne: Original name: AVAYAPDSDB
(1309189888) [29-AUG-2015 12:04:39:137] nnfttran: entry
(1309189888) [29-AUG-2015 12:04:39:137] nncpdpt_dump_ptable: --- /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora TABLE HAS THE FOLLOWING CONTENTS ---
(1309189888) [29-AUG-2015 12:04:39:137] nncpdpt_dump_ptable: AVAYAPDSDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = ccpdsdko)(PORT = 2484))) (CONNECT_DATA = (SERVICE_NAME = orastd)))
(1309189888) [29-AUG-2015 12:04:39:137] nncpdpt_dump_ptable: --- END /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora TABLE ---
(1309189888) [29-AUG-2015 12:04:39:137] nnfttran: exit
(1309189888) [29-AUG-2015 12:04:39:137] nnftrne: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = ccpdsdko)(PORT = 2484))) (CONNECT_DATA = (SERVICE_NAME = orastd))) for name AVAYAPDSDB
(1309189888) [29-AUG-2015 12:04:39:137] nnftrne: exit
(1309189888) [29-AUG-2015 12:04:39:137] nlolfmem: exit
(1309189888) [29-AUG-2015 12:04:39:137] nigtrm: Count in the NI global area is now 2
(1309189888) [29-AUG-2015 12:04:39:137] nigtrm: Count in the NL global area is now 2
(1309189888) [29-AUG-2015 12:04:39:137] nigini: entry
(1309189888) [29-AUG-2015 12:04:39:137] nigini: Count in the NL global area is now 3
(1309189888) [29-AUG-2015 12:04:39:137] nigini: Count in NI gbl area now: 3
(1309189888) [29-AUG-2015 12:04:39:137] nigini: exit
(1309189888) [29-AUG-2015 12:04:39:137] niqname: Hst is already an NVstring.
(1309189888) [29-AUG-2015 12:04:39:137] niqname: Inserting CID.
(1309189888) [29-AUG-2015 12:04:39:137] nigtrm: Count in the NI global area is now 2
(1309189888) [29-AUG-2015 12:04:39:137] nigtrm: Count in the NL global area is now 2
(1309189888) [29-AUG-2015 12:04:39:137] nigini: entry
(1309189888) [29-AUG-2015 12:04:39:137] nigini: Count in the NL global area is now 3
(1309189888) [29-AUG-2015 12:04:39:137] nigini: Count in NI gbl area now: 3
(1309189888) [29-AUG-2015 12:04:39:137] nigini: exit
(1309189888) [29-AUG-2015 12:04:39:137] niqname: Hst is already an NVstring.
(1309189888) [29-AUG-2015 12:04:39:137] niqname: Inserting CID.
(1309189888) [29-AUG-2015 12:04:39:137] niotns: entry
(1309189888) [29-AUG-2015 12:04:39:137] niotns: niotns: setting up interrupt handler...
(1309189888) [29-AUG-2015 12:04:39:137] nigsui: entry
(1309189888) [29-AUG-2015 12:04:39:138] nigsui: Set User Interrupt: hdl=1, prc=0x4f9596f0, ctx=0x1bb32d0.
(1309189888) [29-AUG-2015 12:04:39:138] nigsui: exit (0)
(1309189888) [29-AUG-2015 12:04:39:138] snsgblini: Max no of descriptors supported is 4096
(1309189888) [29-AUG-2015 12:04:39:138] snsgblini: exit
(1309189888) [29-AUG-2015 12:04:39:138] snldlldl: Couldn't load shared library nque
(1309189888) [29-AUG-2015 12:04:39:138] snldlldl: Err: /usr/lib/oracle/11.2/client64/lib/libnque11.so: cannot open shared object file: No such file or directory
(1309189888) [29-AUG-2015 12:04:39:138] snsbitini_ts: entry
(1309189888) [29-AUG-2015 12:04:39:138] snsbitini_ts: normal exit
(1309189888) [29-AUG-2015 12:04:39:138] snsbitini_ts: entry
(1309189888) [29-AUG-2015 12:04:39:138] snsbitini_ts: normal exit
(1309189888) [29-AUG-2015 12:04:39:138] niotns: Not trying to enable dead connection detection.
(1309189888) [29-AUG-2015 12:04:39:138] niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=ccpdsdko)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=orastd)(CID=(PROGRAM=sqlplus)(HOST=cc-allplus.msk.vtb24.ru)(USER=root))))
(1309189888) [29-AUG-2015 12:04:39:138] nsgettrans_bystring: entry
(1309189888) [29-AUG-2015 12:04:39:138] nsgettrans_bystring: exit
(1309189888) [29-AUG-2015 12:04:39:138] nscall: entry
(1309189888) [29-AUG-2015 12:04:39:138] nsmal: entry
(1309189888) [29-AUG-2015 12:04:39:138] nsmal: 272 bytes at 0x1bca160
(1309189888) [29-AUG-2015 12:04:39:138] nsmal: normal exit
(1309189888) [29-AUG-2015 12:04:39:138] nscall: connecting...
(1309189888) [29-AUG-2015 12:04:39:138] nlad_expand_hst: Expanding ccpdsdko
(1309189888) [29-AUG-2015 12:04:39:138] snlinGetAddrInfo: entry
(1309189888) [29-AUG-2015 12:04:39:139] snlinGetAddrInfo: exit
(1309189888) [29-AUG-2015 12:04:39:139] snlinGetNameInfo: entry
(1309189888) [29-AUG-2015 12:04:39:139] snlinGetNameInfo: exit
(1309189888) [29-AUG-2015 12:04:39:139] nlad_expand_hst: Adding IP 10.64.245.211
(1309189888) [29-AUG-2015 12:04:39:139] snlinFreeAddrInfo: entry
(1309189888) [29-AUG-2015 12:04:39:139] snlinFreeAddrInfo: exit
(1309189888) [29-AUG-2015 12:04:39:139] nlad_expand_hst: Result: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=10.64.245.211)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=orastd)(CID=(PROGRAM=sqlplus)(HOST=cc-allplus.msk.vtb24.ru)(USER=root))))
(1309189888) [29-AUG-2015 12:04:39:139] nladini: entry
(1309189888) [29-AUG-2015 12:04:39:139] nladini: exit
(1309189888) [29-AUG-2015 12:04:39:139] nladget: entry
(1309189888) [29-AUG-2015 12:04:39:139] nladget: exit
(1309189888) [29-AUG-2015 12:04:39:139] nsmal: entry
(1309189888) [29-AUG-2015 12:04:39:139] nsmal: 171 bytes at 0x1bcbc50
(1309189888) [29-AUG-2015 12:04:39:139] nsmal: normal exit
(1309189888) [29-AUG-2015 12:04:39:139] nsc2addr: entry
(1309189888) [29-AUG-2015 12:04:39:139] nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=10.64.245.211)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=orastd)(CID=(PROGRAM=sqlplus)(HOST=cc-allplus.msk.vtb24.ru)(USER=root))))
(1309189888) [29-AUG-2015 12:04:39:139] ntzini: entry
(1309189888) [29-AUG-2015 12:04:39:139] ntzSetupConnection: entry
(1309189888) [29-AUG-2015 12:04:39:139] ntzgbhapip: entry
(1309189888) [29-AUG-2015 12:04:39:139] ntzgbhapip: no value for bhapi parameter specified - using default value: "TRUE"
(1309189888) [29-AUG-2015 12:04:39:139] ntzgbhapip: exit
(1309189888) [29-AUG-2015 12:04:39:139] nzsuppgp_get_parameter: entry
(1309189888) [29-AUG-2015 12:04:39:139] nzsuppgp_get_parameter: parameter "trace_level_server" does not exist.
(1309189888) [29-AUG-2015 12:04:39:139] nzsuppgp_get_parameter: exit
(1309189888) [29-AUG-2015 12:04:39:140] nzsuppgp_get_parameter: entry
(1309189888) [29-AUG-2015 12:04:39:140] nzsuppgp_get_parameter: value retrieved for parameter "trace_level_client": 0.
(1309189888) [29-AUG-2015 12:04:39:140] nzsuppgp_get_parameter: exit
(1309189888) [29-AUG-2015 12:04:39:140] nztysgs_genseed: entry
(1309189888) [29-AUG-2015 12:04:39:143] nzsuppgp_get_parameter: entry
(1309189888) [29-AUG-2015 12:04:39:143] nzsuppgp_get_parameter: parameter "ssl.renegotiate" does not exist.
(1309189888) [29-AUG-2015 12:04:39:143] nzsuppgp_get_parameter: exit
(1309189888) [29-AUG-2015 12:04:39:143] ntzSetupConnection: exit
(1309189888) [29-AUG-2015 12:04:39:143] ntzSetupConnection: entry
(1309189888) [29-AUG-2015 12:04:39:143] ntzgbhapip: entry
(1309189888) [29-AUG-2015 12:04:39:143] ntzgbhapip: no value for bhapi parameter specified - using default value: "TRUE"
(1309189888) [29-AUG-2015 12:04:39:143] ntzgbhapip: exit
(1309189888) [29-AUG-2015 12:04:39:143] nzsuppgp_get_parameter: entry
(1309189888) [29-AUG-2015 12:04:39:143] nzsuppgp_get_parameter: parameter "trace_level_server" does not exist.
(1309189888) [29-AUG-2015 12:04:39:143] nzsuppgp_get_parameter: exit
(1309189888) [29-AUG-2015 12:04:39:143] nzsuppgp_get_parameter: entry
(1309189888) [29-AUG-2015 12:04:39:143] nzsuppgp_get_parameter: value retrieved for parameter "trace_level_client": 0.
(1309189888) [29-AUG-2015 12:04:39:143] nzsuppgp_get_parameter: exit
(1309189888) [29-AUG-2015 12:04:39:143] nztysgs_genseed: entry
(1309189888) [29-AUG-2015 12:04:39:146] nzsuppgp_get_parameter: entry
(1309189888) [29-AUG-2015 12:04:39:146] nzsuppgp_get_parameter: parameter "ssl.renegotiate" does not exist.
(1309189888) [29-AUG-2015 12:04:39:146] nzsuppgp_get_parameter: exit
(1309189888) [29-AUG-2015 12:04:39:146] ntzSetupConnection: exit
(1309189888) [29-AUG-2015 12:04:39:146] ntzcsgtab: entry
(1309189888) [29-AUG-2015 12:04:39:146] ntzcsgtab: exit
(1309189888) [29-AUG-2015 12:04:39:146] ntzini: exit
(1309189888) [29-AUG-2015 12:04:39:146] nttbnd2addr: entry
(1309189888) [29-AUG-2015 12:04:39:146] snlinGetAddrInfo: entry
(1309189888) [29-AUG-2015 12:04:39:146] snlinGetAddrInfo: exit
(1309189888) [29-AUG-2015 12:04:39:146] nttbnd2addr: using host IP address: 10.64.245.211
(1309189888) [29-AUG-2015 12:04:39:146] snlinFreeAddrInfo: entry
(1309189888) [29-AUG-2015 12:04:39:147] nsopenalloc_nsntx: nlhthput on mplx_ht_nsgbu:ctx=1bd5fe0, nsntx=1bd6610
(1309189888) [29-AUG-2015 12:04:39:147] nsopenmplx: normal exit
(1309189888) [29-AUG-2015 12:04:39:147] nsopen: opening transport...
(1309189888) [29-AUG-2015 12:04:39:147] ntzconnect: entry
(1309189888) [29-AUG-2015 12:04:39:147] ntzCreateConnection: entry
(1309189888) [29-AUG-2015 12:04:39:147] nttcon: entry
(1309189888) [29-AUG-2015 12:04:39:147] nttcon: toc = 1
(1309189888) [29-AUG-2015 12:04:39:147] nttcnp: entry
(1309189888) [29-AUG-2015 12:04:39:147] nttcnp: creating a socket.
(1309189888) [29-AUG-2015 12:04:39:147] nttcnp: exit
(1309189888) [29-AUG-2015 12:04:39:147] nttcni: entry
(1309189888) [29-AUG-2015 12:04:39:147] nttcni: Tcp conn timeout = 60000 (ms)
(1309189888) [29-AUG-2015 12:04:39:147] nttcni: TCP Connect TO enabled. Switching to NB
(1309189888) [29-AUG-2015 12:04:39:147] nttctl: entry
(1309189888) [29-AUG-2015 12:04:39:147] nttctl: Setting connection into non-blocking mode
(1309189888) [29-AUG-2015 12:04:39:147] nttcni: trying to connect to socket 4.
(1309189888) [29-AUG-2015 12:04:39:147] ntt2err: entry
(1309189888) [29-AUG-2015 12:04:39:147] ntt2err: exit
(1309189888) [29-AUG-2015 12:04:39:147] ntctst: size of NTTEST list is 1 - not calling poll
(1309189888) [29-AUG-2015 12:04:39:147] sntpoltst: No of conn to test 1, wait time 60
(1309189888) [29-AUG-2015 12:04:39:147] sntpoltst: fd 4 need 1 readiness events
(1309189888) [29-AUG-2015 12:04:39:147] sntpoltst: fd 4 has 1 readiness events
(1309189888) [29-AUG-2015 12:04:39:147] sntpoltst: exit
(1309189888) [29-AUG-2015 12:04:39:147] nttctl: entry
(1309189888) [29-AUG-2015 12:04:39:147] nttctl: Clearing non-blocking mode
(1309189888) [29-AUG-2015 12:04:39:147] snlinGetNameInfo: entry
(1309189888) [29-AUG-2015 12:04:39:147] snlinGetNameInfo: exit
(1309189888) [29-AUG-2015 12:04:39:147] nttcni: connected on ipaddr 10.64.245.240
(1309189888) [29-AUG-2015 12:04:39:147] nttcni: exit
(1309189888) [29-AUG-2015 12:04:39:147] nttcon: NT layer TCP/IP connection has been established.
(1309189888) [29-AUG-2015 12:04:39:147] nttcon: set TCP_NODELAY on 4
(1309189888) [29-AUG-2015 12:04:39:147] nttcon: exit
(1309189888) [29-AUG-2015 12:04:39:147] ntzAllocate: entry
(1309189888) [29-AUG-2015 12:04:39:147] ntzAllocate: allocating 304 bytes of memory.
(1309189888) [29-AUG-2015 12:04:39:147] ntzAllocate: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzConfigure: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzgsvp: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzGetStringParameter: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzGetStringParameter: found value for "ssl_version" configuration parameter: "0"
(1309189888) [29-AUG-2015 12:04:39:148] ntzGetStringParameter: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzConvertToNumeric: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzConvertToNumeric: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzgsvp: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzgcpp: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzAllocate: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzAllocate: allocating 16 bytes of memory.
(1309189888) [29-AUG-2015 12:04:39:148] ntzAllocate: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzGetStringParameter: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzGetStringParameter: found value for "ssl_cipher_suites" configuration parameter: "SSL_RSA_EXPORT_WITH_RC4_40_MD5"
(1309189888) [29-AUG-2015 12:04:39:148] ntzGetStringParameter: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzgcpp: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzCreateCipherSpec: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzCreateCipherSpec: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzgcap: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzgcap: retrieved value "TRUE" for client authentication parameter
(1309189888) [29-AUG-2015 12:04:39:148] ntzgcap: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzConfigure: client authentication is required.
(1309189888) [29-AUG-2015 12:04:39:148] ntzgwrl: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzgwrlFromFile: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzGetStringParameter: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzGetStringParameter: found value for "wallet_location" configuration parameter: "SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY =/usr/lib/oracle/11.2/client64/network/admin/AVAYAPDSDB))"
(1309189888) [29-AUG-2015 12:04:39:148] ntzGetStringParameter: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzAllocate: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzAllocate: allocating 111 bytes of memory.
(1309189888) [29-AUG-2015 12:04:39:148] ntzAllocate: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzAllocate: entry
(1309189888) [29-AUG-2015 12:04:39:148] ntzAllocate: allocating 63 bytes of memory.
(1309189888) [29-AUG-2015 12:04:39:148] ntzAllocate: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzgwrlFromFile: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzlogin: Wallet open failed with error 28759
(1309189888) [29-AUG-2015 12:04:39:148] ntzlogin: returning NZ error 28759 in result structure
(1309189888) [29-AUG-2015 12:04:39:148] ntzlogin: failed with error 540
(1309189888) [29-AUG-2015 12:04:39:148] ntzlogin: exit
(1309189888) [29-AUG-2015 12:04:39:148] ntzConfigure: failed with error 540
(1309189888) [29-AUG-2015 12:04:39:148] ntzConfigure: exit
(1309189888) [29-AUG-2015 12:04:39:149] ntzCreateConnection: failed with error 540
(1309189888) [29-AUG-2015 12:04:39:149] ntzconnect: failed with error 540
(1309189888) [29-AUG-2015 12:04:39:149] ntzconnect: exit
(1309189888) [29-AUG-2015 12:04:39:149] nserror: entry
(1309189888) [29-AUG-2015 12:04:39:149] nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=540, nt[1]=0, nt[2]=0; ora[0]=28759, ora[1]=0, ora[2]=0
(1309189888) [29-AUG-2015 12:04:39:149] nsopen: unable to open transport
(1309189888) [29-AUG-2015 12:04:39:149] snsbitts_ts: entry
(1309189888) [29-AUG-2015 12:04:39:149] snsbitts_ts: acquired the bit
(1309189888) [29-AUG-2015 12:04:39:149] snsbitts_ts: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] nsbfr: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] nsiofrrg: exit
(1309189888) [29-AUG-2015 12:04:39:149] nsiocancel: exit
(1309189888) [29-AUG-2015 12:04:39:149] nsvntx_dei: entry
(1309189888) [29-AUG-2015 12:04:39:149] nsvntx_dei: exit
(1309189888) [29-AUG-2015 12:04:39:149] nsopenfree_nsntx: nlhthdel from mplx_ht_nsgbu, ctx=1bd5fe0 nsntx=1bd6610
(1309189888) [29-AUG-2015 12:04:39:149] nsiocancel: entry
(1309189888) [29-AUG-2015 12:04:39:149] nsiofrrg: entry
(1309189888) [29-AUG-2015 12:04:39:149] nsiofrrg: exit
(1309189888) [29-AUG-2015 12:04:39:149] nsiocancel: exit
(1309189888) [29-AUG-2015 12:04:39:149] snsbittrm_ts: entry
(1309189888) [29-AUG-2015 12:04:39:149] snsbittrm_ts: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] snsbitts_ts: entry
(1309189888) [29-AUG-2015 12:04:39:149] snsbitts_ts: acquired the bit
(1309189888) [29-AUG-2015 12:04:39:149] snsbitts_ts: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] snsbitcl_ts: entry
(1309189888) [29-AUG-2015 12:04:39:149] snsbitcl_ts: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: entry
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: 2760 bytes at 0x1bd6610
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: entry
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: 1576 bytes at 0x1bd5fe0
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] nsopen: error exit
(1309189888) [29-AUG-2015 12:04:39:149] nsclose: entry
(1309189888) [29-AUG-2015 12:04:39:149] nsclose: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] nladget: entry
(1309189888) [29-AUG-2015 12:04:39:149] nladget: exit
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: entry
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: 171 bytes at 0x1bcbc50
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: entry
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: 272 bytes at 0x1bca160
(1309189888) [29-AUG-2015 12:04:39:149] nsmfr: normal exit
(1309189888) [29-AUG-2015 12:04:39:149] nladtrm: entry
(1309189888) [29-AUG-2015 12:04:39:149] nladtrm: exit
(1309189888) [29-AUG-2015 12:04:39:149] nscall: error exit
(1309189888) [29-AUG-2015 12:04:39:149] nioqper: error from nscall
(1309189888) [29-AUG-2015 12:04:39:149] nioqper: ns main err code: 12560
(1309189888) [29-AUG-2015 12:04:39:149] nioqper: ns (2) err code: 0
(1309189888) [29-AUG-2015 12:04:39:149] nioqper: nt main err code: 540
(1309189888) [29-AUG-2015 12:04:39:149] nioqper: nt (2) err code: 0
(1309189888) [29-AUG-2015 12:04:39:149] nioqper: nt OS err code: 0
(1309189888) [29-AUG-2015 12:04:39:149] niomapnserror: entry
(1309189888) [29-AUG-2015 12:04:39:149] niqme: entry
(1309189888) [29-AUG-2015 12:04:39:149] niqme: reporting ORA-28759 error
(1309189888) [29-AUG-2015 12:04:39:150] niqme: exit
(1309189888) [29-AUG-2015 12:04:39:150] niomapnserror: exit
(1309189888) [29-AUG-2015 12:04:39:150] niotns: Couldn't connect, returning 28759
(1309189888) [29-AUG-2015 12:04:39:150] niotns: exit
(1309189888) [29-AUG-2015 12:04:39:150] nigcui: entry
(1309189888) [29-AUG-2015 12:04:39:150] nigcui: Clr User Interrupt: hdl=1, prc=0x4f9596f0, ctx=0x1bb32d0.
(1309189888) [29-AUG-2015 12:04:39:150] nigcui: exit (0)
(1309189888) [29-AUG-2015 12:04:39:150] snsbittrm_ts: entry
(1309189888) [29-AUG-2015 12:04:39:150] snsbittrm_ts: normal exit
(1309189888) [29-AUG-2015 12:04:39:150] snsbittrm_ts: entry
(1309189888) [29-AUG-2015 12:04:39:150] snsbittrm_ts: normal exit
(1309189888) [29-AUG-2015 12:04:39:150] nsbfrfl: entry
(1309189888) [29-AUG-2015 12:04:39:150] nsbrfr: entry
(1309189888) [29-AUG-2015 12:04:39:150] nsbrfr: nsbfs at 0x1bcbfe0, data at 0x1bd70e0.
(1309189888) [29-AUG-2015 12:04:39:150] nsbrfr: normal exit
(1309189888) [29-AUG-2015 12:04:39:150] nsbfrfl: normal exit
(1309189888) [29-AUG-2015 12:04:39:150] nigtrm: Count in the NI global area is now 2
(1309189888) [29-AUG-2015 12:04:39:150] nigtrm: Count in the NL global area is now 2
请放轻松!任何人!我只看到一个 .so 文件丢失了。我在任何地方都找不到关于相同问题的任何信息,也许是其他 .so 文件,建议是像这样制作符号链接(symbolic link):
/usr/sbin/semanage fcontext -a -t textrel_shlib_t $ORACLE_HOME/lib/libnque11.so
但是系统提示我没有“semanage”。任何建议将不胜感激!?!
[更新 1]我的/usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora
AVAYAPDSDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = ccpdsdko)(PORT = 2484))
)
(CONNECT_DATA =
(SERVICE_NAME = orastd)
)
)
我的/usr/lib/oracle/11.2/client64/network/admin/sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (TCPS, BEQ)
SSL_VERSION = 0
SSL_CLIENT_AUTHENTICATION = TRUE
NAMES.DIRECTORY_PATH= (TNSNAMES)
SSL_SERVER_DN_MATCH = FALSE
SSL_CIPHER_SUITES = (SSL_RSA_EXPORT_WITH_RC4_40_MD5)
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY =/usr/lib/oracle/11.2/client64/network/admin/AVAYAPDSDB)
)
)
SQLNET.WALLET_OVERRIDE = TRUE
DIAG_ADR_ENABLED = OFF
TRACE_LEVEL_CLIENT = SUPPORT
TRACE_DIRECTORY_CLIENT = /tmp/ora
最佳答案
我遇到了 2 个问题。首先是 wallet 的 url 指向比我的文件所在目录高 1 级的目录,其次,我使用的是连接的短语法。我正在使用这个:
# /usr/lib/oracle/11.2/client64/bin/sqlplus /@AVAYAPDSDB
成功的似乎是:
# /usr/lib/oracle/11.2/client64/bin/sqlplus login/password@AVAYAPDSDB
所以现在我要将 sqlplus 添加到 PATH 并开始设置 php 环境))
希望这一切对任何人都有用。我对面临类似问题的任何人的主要建议:打开客户端跟踪!!!
祝你好运!
p.s:一段时间过去了,我意识到,重要的是要提到如何在 linux 上轻松跟踪任何进程,而无需任何特殊设置。
为此使用命令 strace
。示例:
strace -o /tmp/log_of_trace.txt ./configure
您可以调用 oracle 客户端连接或您想要跟踪的任何其他进程,而不是 ./con...。在日志中,您将获得所有必要的信息和错误,并且都在堆栈跟踪中!这非常有帮助!!
很多信息用于搜索问题隐藏的位置 =)
祝大家好运!
关于linux - Oracle 即时客户端 : ORA-28759: failure to open file,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/32284692/
我想知道是否可以访问放在 tomcat 的 conf 文件夹中的文件。通常我会在这个文件中放置多个 webapp 的配置,在 war 之外。 我想使用类路径独立于文件系统。 我过去使用过 lib 文件
我有一个 PowerShell 脚本,它获取文件列表并移动满足特定条件的文件。为什么即使对象为空,foreach 循环也会运行? 我假设如果 $i 不存在,它就不会运行。但是如果 $filePath
我已将 BasicAccountRule.drl 放置在我的 Web 应用程序中,位置为:C:/workspace/exim_design/src/main/resources/rules/drl/i
我使用 File.open('file.txt').class 和 File.open('file.txt').readlines.class 以及前者进行了检查一个返回 File,后者返回 Arra
我正在尝试使用 FileOutputStream 删除文件,在其中写入内容后。这是我用来编写的代码: private void writeContent(File file, String fileC
我正在尝试使用 flink 和 python 批处理 api 测试 Wordcount 经典示例。我的问题是,将数据源从 env.from_elements() 修改为 env.read_text()
我正在尝试制作一个可以同时处理多个不同文件的程序。我的想法是制作一个包含 20 个 FILE* 的数组,以便在我达到此限制时能够关闭其中一个并打开请求的新文件。 为此,我想到了一个函数,它选择一个选项
我有两个文件A和B文件A: 976464 792992 文件B TimeStamp,Record1,976464,8383,ABCD 我想搜索文件 A 和文件 B 中的每条记录并打印匹配的记录。打印的
我有一些保存在 map 中的属性文件。示例: Map map = new HashMap<>(); map.put("1", "One"); map.put("2", "Two"); map.put(
我正在尝试找出一个脚本文件,该文件接受一个包含文件列表的文件(每一行都是一个文件路径,即 path/to/file)并将它们合并到一个文件中。 例如: list.text -- path/to/fil
为了使用 File.CreateText() 和 File.AppendText() 你必须: 通过调用这些方法之一打开流 写消息 关闭流 处理流 为了使用 File.AppendAllText()
使用rsync时,如何在使用--files-from参数复制时重命名文件?我有大约190,000个文件,在从源复制到目标时,每个文件都需要重命名。我计划将文件列表放在一个文本文件中传递给--files
我在非服务器应用程序中使用 Spring(只需从 Eclipse 中某个类的 main() 编译并运行它)。 我的问题是作为 new FileSystemXmlApplicationContext 的
QNX (Neutrino 6.5.0) 使用 ksh 的开源实现作为其 shell 。许多提供的脚本,包括系统启动脚本,都使用诸如 if ! test /dev/slog -ef /dev/slog
当我尝试打开从我的应用程序下载的 xls 文件时,出现此错误: excel cannot open the file because the file format or file extension
有一些相关的概念,即文件指针、流和文件描述符。 我知道文件指针是指向数据类型 FILE 的指针(在例如 FILE.h 和 struct_FILE.h 中声明)。 我知道文件描述符是 int ,例如成员
好吧,这应该很容易... 我是groovy的新手,我希望实现以下逻辑: def testFiles = findAllTestFiles(); 到目前为止,我想出了下面的代码,该代码可以成功打印所有文
我理解为什么以下内容会截断文件的内容: Get-Content | Out-File 这是因为 Out-File 首先运行,它会在 Get-Content 有机会读取文件之前清空文件。 但是当我尝
您好,我正在尝试将文件位置表示为变量,因为最终脚本将在另一台机器上运行。这是我尝试过的代码,然后是我得到的错误。在我看来,python 是如何添加“\”的,这就是导致问题的原因。如果是这种情况,我如何
我有一个只包含一行的输入文件: $ cat input foo bar 我想在我的脚本中使用这一行,据我所知有 3 种方法: line=$(cat input) line=$( input"...,
我是一名优秀的程序员,十分优秀!