2012年5月29日

摘要: 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 阅读全文
posted @ 2012-05-29 18:08 h2内存数据库 阅读(307) 评论(0) 推荐(0) 编辑
摘要: 数据库启动监听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 阅读全文
posted @ 2012-05-29 14:00 h2内存数据库 阅读(421) 评论(0) 推荐(0) 编辑
摘要: 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... 阅读全文
posted @ 2012-05-29 13:53 h2内存数据库 阅读(346) 评论(0) 推荐(0) 编辑
摘要: 对于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 阅读全文
posted @ 2012-05-29 01:00 h2内存数据库 阅读(421) 评论(0) 推荐(0) 编辑
摘要: ===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) 阅读全文
posted @ 2012-05-29 00:54 h2内存数据库 阅读(346) 评论(0) 推荐(0) 编辑
摘要: 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内存数据库 阅读(346) 评论(0) 推荐(0) 编辑

导航