随笔分类 -  Oracle DB

关于TNS_ADMIN环境变量
摘要：很多oracle产品都有自己的TNS文件，如果你的系统里装了多个Oracle的产品的话，那么客户端连instance的时候，到底是使用那个tnsnames.ora呢？这个时候就需要看TNS_ADMIN这个参数了。Question:What is thetns_adminparameter and how do I usetns_admin to define a common location for my TNS files?Answer:Thetns_adminparameter determines the location of the tns administration files 阅读全文

posted @ 2012-06-28 15:44 h2内存数据库 阅读(366) 评论(0) 推荐(0)

ORA-12560: TNS:protocol adapter error(TNS:协议适配器错误)
摘要：这种问题一般是因为客户端不知道要连那个instance或者不知道要使用哪个TNS Alias可能的原因1.服务没有起来下边是Tom的一个Test Case来说明OracleServiceSID服务没有起来的话，是会引起ORA-12560错误的。C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. 阅读全文

posted @ 2012-06-28 15:11 h2内存数据库 阅读(1049) 评论(0) 推荐(0)

Initialization Parameter files: PFILEs vs. SPFILEs
摘要：Initialization Parameter files: PFILEs vs. SPFILEsSubmitted by admin on Sun, 2003-08-03 19:29 RDBMS ServerWhen an Oracle Instance is started, the characteristics of the Instance are established by parameters specified within the initialization parameter file. These initialization parameters are eith 阅读全文

posted @ 2012-05-30 11:27 h2内存数据库 阅读(254) 评论(0) 推荐(0)

Oracle Parameters
摘要：如何查看数据库的parameter方法1-show parameterSQL>show parameter NAME TYPE VALUE ————————— ———– —————————— background_core_dump string partial background_dump_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN \ORCL\BDUMP backup_tape_io_slaves boolean FA... 阅读全文

posted @ 2012-05-30 11:17 h2内存数据库 阅读(375) 评论(0) 推荐(0)

TNSNAMES.ORA, LISTENER.ORA and SQLNET.ORA
摘要：Oracle uses three files (listener.ora, tnsnames.ora & sqlnet.ora) for network configuration.Oracle Net is configured by configuration files. These include (but are not limited to):TNSNAMES.ORA - This file contains a list of service names, which translate into the instances the client can connect 阅读全文

posted @ 2012-05-29 00:38 h2内存数据库 阅读(373) 评论(0) 推荐(0)

EBS表后缀的意义
摘要：Object NameFunction of the objectE.g._ALLUnderlying table with all the valuesPO_DISTRIBUTIONS_ALL_BBase of underlying table, same as _ALLMTL_SYSTEM_ITEMS_B_TLLanguage translation table with translation of descriptive fields in different languagesFND_RESPONSIBILITY_TL_VLView based on translation tabl 阅读全文

posted @ 2012-04-26 17:38 h2内存数据库 阅读(190) 评论(0) 推荐(0)

导航