摘要：很多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
阅读全文
摘要：这种问题一般是因为客户端不知道要连那个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.
阅读全文
摘要：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
阅读全文
摘要：如何查看数据库的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...
阅读全文
摘要：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
阅读全文
摘要：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
阅读全文
