ITPub博客

TNSPING位于ORACLE HOME/bin下，TNSPING只用于测试Listener是否可用(检查Socket是否可以连通)，特别注意它不能检测数据库是否已经启动。原理：类似于TCP/IP工具ping，tnsping会发送一个Message给DB Server Listener，DB listener会给出一个回复。如果返回TNS-12541: TNS: no listener，一般表示服务端的Listener没有启动。如果返回TNS-12154: TNS: Could not resolve service name，很可能是你的TNSNAMES.ORA有问题。C:\Documents

Background Oracle Apps的架构非常复杂，使用了非常多技术（或服务）。比如Apache Web server, Apache Jserv, Forms Listener servlet (或forms server) 等等，每一个服务都有着自己的配置文件，只有都设置正确了，系统才能正常运作。而且，Oracle Apps使用了许多的Profile Options（比如Applications Web Agent, Applications Framework Agent等），这些也需要都设置正确，人工管理这么多配置文件，其实并不容易，对

冷备份系统后，然后重启DB Listener和DB没报什么错误，再起通过命令adstrtal.sh apps/apps来启动Apps Server的时候报错 [oracle@bej301441 scripts]$ adstrtal.sh apps/password You are running adstrtal.sh version 120.15.12010000.3 adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong. USAGE:  adstrtal.sh <appsusername/appspassword>         adstrtal.sh <

停止应用服务器 使用应用系统管理员用户登陆 cd $INST_TOP/admin/scripts(或者cd $ADMIN_SCRIPTS_HOME) 此时目录在/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441/admin/scripts下，使用以下命令停止应用服务 ./adstpall.sh apps/apps 使用下面命令检查服务是否关闭,如果没有关闭，则需要等待 ps -ef | grep applmgr ps -ef | grep FND ps -ef | grep http 停止数据库服务 使用数据库系统管理员用户登陆 cd /

Why call it Apps and not Oracle ERP ? 以前就很想知道为什么人们常常把Oracle E-Business Suite称作"Apps"？就因为Apps是Oracle Applications的缩写么？也许是。其实这个问题给了我一个很好地理由来解释APPS schema的进化史。 九年前我开始从事Oracle Financials的工作，那时每一个模块都有它自己database schema（当然现在还有,比如po,inv,wip,ar...），对于一个做采购的用户（EBS 10.6版本前）

Concurrent FND scripts$FND_TOP/sql 下有很多现成Concurrent Program相关脚本afimchk.sql Tells the status of the ICMafcmstat.sql Lists active manager processesafrqrun.sql Lists all the running, waiting and Terminating requests（列出所有正在Running的脚本）afrqwait.sql Lists requests that are constrained and waiting for the ICM to release them.afrqscm.sql Prints log file name of managers that can run a given request.afcmcreq.sql Prints the log file name of the manager that proce

Oracle Apps Concurrent Request Table Relationship for pdf version,you can download from "Concurrent Request Tables.pdf" FND_CONCURRENT_PROGRAMS eTRM:FND_CONCURRENT_PROGRAMS stores information about concurrent programs. Each row includes a name and description of the concurrent program. Each row also includes the execution methods for the program (EXECUTION_METHOD_CODE), the argument method (ARGUMENT_METHOD_CODE), and whether the program is constrained (QUEUE_METHOD_CODE)

Looking on how to check long running concurrent request in Oracle Apps 11i or R12? Here’s the overview of the SQL query script to detect the session information of each program.First you need to get the listing of running concurrent request in Oracle Apps 11i or R12. You can use the SQL query script as below to obtain the list of running request. SELECT a.request_id ,a.oracle_process_id "SPID" ,frt.responsibility_name ,c.concurrent_program_name || \': \' || ctl.user_concurrent_p

知道Form执行文件的名字情况下，如何来查找对应的功能名称 SELECT a.form_name||\' : \'||nvl(b.description, b.user_form_name) FROM APPS.FND_FORM a, APPS.FND_FORM_TL b WHERE a.form_id = b.form_id AND a.form_name IN (\'INVTTMTX\');Output:INVTTMTX : Perform miscellaneous transactions 知道功能名称的情况下，如何来查找对应的fmx名称 SELECT a.form_name,b.description FROM APPS.FND_FORM a, APPS.FND_FORM_TL b WHERE a.form_id = b.form_id AND Upper(b.descript

EBS中的Program是可以根据需求周期性运行的，比如‘Purge Logs and Closed System Alerts’ Program，我们需要每天运行来清理日渐庞大的日志表,周期性运行Program的方法。 路径：Submit Request > Schedule 1.As Soon as Possible:立即运行你的Program 2.Once:在一个具体的时间点上运行Program 3.Periodically:周期的运行你的Program,每分钟/每小时/每天/每周/每月，并制定开始时间和结束时间。

很多oracle产品都有自己的TNS文件，如果你的系统里装了多个Oracle的产品的话，那么客户端连instance的时候，到底是使用那个tnsnames.ora呢？这个时候就需要看TNS_ADMIN这个参数了。 Question: What is the tns_admin parameter and how do I use tns_admin to define a common location for my TNS files? Answer:  The tns_admin parameter determines the location of the tns administration files (e.g. tnsname

这种问题一般是因为客户端不知道要连那个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. Connected to: Oracle Database 10g Enterprise E

系统版本信息装了哪些模块，以及版本信息select \'Current Application Release: \'||ver||\' (\'||bug||\')\' "Description" from ( select x.* from (select 1 seq, \'1939818\' bug,\'11.5.0\' pv,\'11.5.6\' ver from dual union select 2,\'2123967\',\'11.5.0\',\'11.5.7\' from dual union select 3,\'2293243\',\'11.5.0\',\'11.5.8\' from dual union select 4,\'2669606\',\'11.5.0\',\'11.5.9 MP\' from dual union select 5,\'3126422\',\'11.5.0\',\'11.5.9 Update1\' from dual union select 6,\'3171663\',\'11.5.0\',\'11.5.9 Up

How to Re-Compile All Invalid for Oracle EBS Package/Package Body set serveroutput on size 1000000 declare sql_statement varchar2(200); cursor_id number; ret_val number; CURSOR cur_invalid IS select object_type, owner, object_name from sys.dba_objects o where o.status = \'INVALID\' and o.object_type in (\'PACKAGE\', \'PACKAGE BODY\') AND object_name LIKE \'PO%\';--重新编译PO开头的Package begin dbms_output.put_line(chr(0)); dbms_output.put_line(\'Re-compilation of Invalid Objects\'); db

列出所有Scheduled Concurrent Program select r.request_id, p.user_concurrent_program_name || case when p.user_concurrent_program_name = \'Report Set\' then (select \' - \' || s.user_request_set_name from apps.fnd_request_sets_tl s where s.application_id = r.argument1 and s.request_set_id = r.argument2 and language = \'US\' ) when p.user_concurrent_program_name =

订单的关闭是自动的，在所有行工作流结束（Close或者Cancel）后0.5天，订单头也将在Workflow Background Process的推动下关闭。 还有另外一种说法：you can wait until month-end and the “Order Flow – Generic” workflow will close it for you. 所以造成了很多时候订单行已经关闭了，但订单头还是处于Booked状态，这个时候如果你想Close订单头，你可以手动运行Workflow Background Process来关闭订单，也可以

Order&Shipping Transactions Status Summary Step Order Header Status Order Line Status Order Flow Workflow Status (Order Header) Line Flow Workflow Status (Order Line) Shipping Transaction  Status(RELEASED_STATUS in WDD)   1. Enter an Order Entered Entered Book Order Manual Enter – Line                              N/A   2. Book the Order

AutoInvoice运行报错，查看RA_INTERFACE_ERRORS_ALL，SELECT Message_text FROM RA_INTERFACE_ERRORS_ALL WHERE INTERFACE_LINE_ID = 1149459; 错误信息如下： You must supply an invoice number when your batch source indicates manual invoice numbering; otherwise you must leave invoice number blank 原因： RA_INTERFACE_LINES_ALL的trx_number有值， 但AR SETUP -> TRANSACTION -> SOURCES里，我们勾上Automatic Transaction Numbering，这表示，系统会自动

如果忘记了EBS登陆页面的链接怎么办,如果你还可以访问数据库，有尝试用下边两个SQL来查看登陆页面链接 方法1： SELECT home_url FROM icx_parameters; output like:http://xxx.com:8001/OA_HTML/AppsLogin 方法2：SELECT profile_option_value FROM fnd_profile_option_values WHERE profile_option_id= (SELECT profile_option_id FROM fnd_profile_options WHERE profile_option_name = \'APPS_FRAMEWORK_AGENT\')

EBSGuideOracle® Applications Flexfields Guide Release 12Oracle® ApplicationsFlexfields Guide Release 11Oracle® Applications ConceptsRelease 11i (11.5.10) Part No. B13892-01Oracle Applications Developer’s GuideRELEASE 11iOracle® Applications System Administrator\'s Guide - ConfigurationRelease 12 Part No. B31453-04Oracle® Applications System Administrator’s Guide: MaintenanceRelease 11i  Part No. B13924-01Oracle Applications Release 11i Technical Reference Manualshtt