h2内存数据库

摘要： Symptom访问Help->Diagnostics->Examine报"Function not available to this responsibility.Change responsibilities or contact your System Administrator."的错误提示CauseUpgraded to 12.1.3- or -Applied Patch 9734709Solution - Log in as System Administrator- Choose Profile/System- Change the profile 阅读全文

摘要： 数据库启动监听addlnctl.sh start instance启动数据库addbctl.sh start启动应用服务器adstrtal.sh停止应用服务器adstpall.sh查看HTTP/OC4J Statusadopmnctl.sh statussample output:Processes in Instance: mc3yd213_bej301441.bej301441.cn.oracle.com---------------------------------+--------------------+---------+---------ias-component | proc 阅读全文

摘要： EBS adpatch的时候报ORA-03113: end-of-file on communication channel从adpatch的日志中看到================adpatch.log====================================== Running utl_recomp.recomp_parallel(4), if it exists OWNER NUM_INVALID ------------------------------ ----------- SERVICES 24 PROJMFG 24 PSBE... 阅读全文

摘要： 对于EBS数据库管理员用户，可以把db/tech_st/10.2.0下的<CONTEXT_NAME>.env设置到/home/user下的.bash_profile文件（隐藏文件）中，这样和DB相关的一些环境变量就会自动在登录时加载（比如ORACLE_HOME，ORACLE_SID，PATH，TNS_ADMIN，CONTEXT_NAME，LIBPATH等）eg.把/u01/oracle/mc3yd213/db/tech_st/11.1.0/mc3yd213_bej301441.env加到.bash_profile对于EBS Application管理员用户，可以把apps/apps 阅读全文

摘要： ===For Applmgr User===APPL_TOP: 11i:<APPS_BASE>/<SID>applR12:<APPS_BASE>/apps/apps_st/applNOTE:Oracle Applicaitons product files,including $INV_TOP,$AU_TOP....COMMON_TOP:11i:<APPS_BASE>/<SID>comnR12:<APPS_BASE>/apps/apps_st/comn(Common files such as Java&HTML) 阅读全文

摘要： 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 阅读全文