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