ITPub博客

Linux下可以使用ps命令来查看Oracle相关的进程 使用ps来查看Oracle数据库相关的服务 Oracle Listener 这个命令会列出Oracle Net Listener的进程 [oracle@bej301441 ~]$ ps -ef | grep tnslsnr oracle 1999 29986 0 09:47 pts/2 00:00:00 grep tnslsnr oracle 3647 1 0 Jul03 ? 00:00:34 /u01/oracle/mc3yd213/db/tech_st/11.1.0/bin/tnslsnr mc3yd213 -inherit oracle 6431 1 0 Jul03 ? 00:00:00 /u01/oracle/mc3yd213/apps/tech_st/10.1.2/

Windows下的任务管理器虽然不好用(个人更喜欢Process Explorer些)，但也算方便，可以方便的查看进程，CPU，内存...也可以很容易的结束进程 没有图形化界面下的Linux，也有命令可以实现Windows的任务管理器功能，这个命令就是"top"，用户可以使用top来对进程排序，结束进程等. top 命令是 Linux 下常用的性能分析工具，能够实时显示系统中各个进程的资源占用状况，默认5

Call Inventory Transaction Manager set serveroutput on; declare --retmsg varchar2(1000); retmsg varchar2(240); retval number; trxhdrid number := \'&1\'; prnmsg varchar2(256); x_msg_data varchar2(256); x_msgcnt number; begin retval := INV_LPN_TRX_PUB.PROCESS_LPN_TRX( p_trx_hdr_id => trxhdrid, p_commit => fnd_api.g_false, x_proc_msg => retmsg, p_proc_mode => 1, p_process_trx => fnd_api.g_true, p_atomic => fnd_api.g_false); if (length(retmsg) > 200)

使用V$PROCESS，V$SESSION能做什么 查看哪些用户连到了DB上，使用什么Program连接 SET LINESIZE 100 COLUMN spid FORMAT A10 COLUMN username FORMAT A10 COLUMN program FORMAT A45 SELECT s.sid, --Session identifier s.serial#,--Session serial number. Used to uniquely identify a session\'s objects. p.spid, --Operating system process identifier p.pid, --Oracle process identifier s.username,--Oracle DB username s.osuser,--Operating system cl

Linux Tutorial System Administration Guide Copyright ? 2005 Red Hat, Inc. ISBN: N/A Table of ContentsIntroduction 1. Changes To This Manual2. Architecture-specific Information3. Document Conventions4. Activate Your Subscription 4.1. Provide a Red Hat Login4.2. Provide Your Subscription Number4.3. Connect Your System 5. Using the Mouse6. Copying and Pasting Text With X7. More to Come 7.1. Send in Your Feedback I. Installation-Related Informati

Every concurrent Request uses some resources for running. If we find that the concurrent request is taking long time and decided to terminate the concurrent request , the resources may not be released soon. These processes are called runaway processes. So we need to manually kill the processes at database and os level to have the resources released to the system. Terminate the concurrent request from the front end. Then SQL>select request_id,oracle_process_id,os_process_id from fnd

发现有的时候，EBS会报连接数不足的问题。所以尝试着提高了processes和sessions，EBS安装完之后，数据库init参数processes默认为200,sessions默认为400.这里我把DB的processes和sessions提高到了500和1000。 processes                       = 500    # Max. no. of users x 2 sessions       &nbs

1.vi .bash_history 关于.bash_history的配置 export HISTCONTROL=ignoreboth Don’t save duplicates export HISTSIZE=10000 这个是针对history命令的设置，The number of commands to remember in the command history. The default value is 500. export HISTFILESIZE=10000 这个是针对history文件(.bash_history)的设置，The maximum number of lines contained  in  the  history file.  When this variable is assigned a value, the his-tory file is truncate

<<Stop Server Command Order>> 1.Apps Management User,cd $ADMIN_SCRIPTS_HOME stop apps server ./adstpall.sh apps/apps 2.DB Admin User, cd $RDBMS_ORACLE_HOME/appsutil/scripts/<SID_hostname> (eg./u01/oracle/mc3yd213/db/tech_st/11.1.0/appsutil/scripts/mc3yd213_bej301441) Stop DB Listener ./addlnctl.sh stop mc3yd213    Stop DB Server ./addbctl.sh stop abort/normal/immediate <<Start Server Command Order>> 1.DB Admin User, cd $RDBMS_ORACLE_HOM

使用sqlplus "/ as sysdba"连DB,报错:ORA-01031: insufficient privileges [oracle@bej301441 lib]$ sqlplus "/ as sysdba" SQL*Plus: Release 10.1.0.5.0 - Production on Tue Jul 3 03:58:50 2012 Copyright (c) 1982, 2005, Oracle.  All rights reserved. ERROR: ORA-01031: insufficient privileges Enter user-name: system Enter password: 解决过程： vi /u01/oracle/mc3yd213/db/tech_st/11.1.0/rdbms/lib/config.c /*  $Header: config_ux.tmp 120.0 2005/10/13 10:

What\'s main code logic while performing query in material workbench form(INVMWBIV.fmb).   Key File: INVMWBIV.fmb INVMWQMB.pls - INV_MWB_QUERY_MANAGER INVMWCTB.pls - INV_MWB_CONTROLLER Key Table: MTL_MWB_GTMP mtl_onhand_quantities_detail ===================== First Delete All records from MTL_MWB_GTMP. DELETE FROM MTL_MWB_GTMP(Happen at INV_MWB_CONTROLLER.initialize) INV_MWB_CONTROLLER.Event |-INV_MWB_CONTROLLER.initialize ===================== INV_MWB_CONTROLLER.initia

客户可以通过Help > Diagnostics > Custom Code > Personalize，来对Form做个性化的设置。如何通过脚本来查看Form做了哪些个性化 SELECT * FROM FND_FORM_CUSTOM_RULES WHERE form_name = \'INVTOMAI\';--Input your Form Name SELECT * FROM FND_FORM_CUSTOM_ACTIONS WHERE RULE_ID IN (SELECT ID FROM fnd_form_custom_rules WHERE form_name = \'INVTOMAI\') --Input your Form Name ORDER BY SEQUENCE; SELECT * FROM FND_FORM_CUSTOM_SCOPES WHERE RULE_ID IN (SELECT ID F

THIS WORKS WITH ORACLE R12 Here is a wonderful oracle seeded Procedure fnd_web_sec.get_guest_username_pwd which will help us to find out user password. This will be handy for consultants in resolving the issues. Please use with this care and dont misuse this. To achieve this you need to create a small package and run a query which I wrote below --Package Specification CREATE OR REPLACE PACKAGE get_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2;

Oracle Apps Script to create a new User Login Account--CREATE a new user account DECLARE p_user_name VARCHAR2 (200) := \'PTIAN\'; p_owner VARCHAR2 (200) := NULL; p_unencrypted_password VARCHAR2 (200) := \'welcome\'; p_session_number NUMBER := USERENV (\'sessionid\'); p_start_date DATE := SYSDATE; p_end_date DATE := NULL; p_last_logon_date DATE

用户可以在Profile文件中加入环境变量，比如ORACLE_HOME,HOME...这样重新登录之后，这些环境变量都会得以设置，不用每次都手工设置。 Unix/Linux有两个profile文件 1./etc/profile:是全局profile文件，设置后会影响到所有用户 2./home/username/.profile或.bash_profile是针对特定用户的，可以针对用户，来配置自己的环境变量。 注意:profile是unix上才有的;bash_profile是Linux下有的(Linux下，用户目录

Oracle Apps R12下如何定义一个简单的Hello World的Concurrent Program 定义一个表和一个Procedure先 create table ptian_table ( message_text VARCHAR2(100) ,creation_date DATE ) ; CREATE OR REPLACE PROCEDURE PTIAN_HELLO (errbuf OUT VARCHAR2, retcode OUT VARCHAR2) IS BEGIN INSERT INTO ptian_table VALUES (\'Hello World\' ,SYSDATE); END PTIAN_HELLO; --两个参数用于concurrent program和pl/sql Program的交互 Application Developer职责下： Concurrent > Executa

1.Using script to submit INV Manager to process MMTT/* * When prompted for user_id, resp_id and resp_appl_id, ask ct enter the correct values for * these variables. The values can be obtained by logging into Inventory * reponsibility and from menu Help->Diagnostics->Examine, select block as * $PROFILES and field as the 3 variables and note down the values of each. */ SET SEVEROUTPUT ON declare l_header_id number; p_userid NUMBER := &user_id; p_respid NUMBER := &resp_id;

Transaction Type = Transaction Source Type + Transaction Action eg.Move Order Issue = Move Order + Issue From Stores Below is the script to check Txn Type, Txn Source Type, Txn Action(Lookups) --Txn Type SELECT TRANSACTION_TYPE_ID, TRANSACTION_TYPE_NAME,TRANSACTION_SOURCE_TYPE_ID,TRANSACTION_ACTION_ID FROM MTL_TRANSACTION_TYPES ORDER BY TRANSACTION_TYPE_ID; --Source Type SELECT TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_SOURCE_TYPE_NAME FROM MTL_TXN_SOURCE_TYPES ORDER BY T

Window下环境变量的设置，可以在我的电脑>属性>高级>环境变量里进行设置，也可以在命令行(cmd)里执行下边语句来设置 set ORACLE_SID=orclps:cmd下查看环境变量方法,输入set ORACLE_SID Linux下环境变量的设置可以用下边的命令 dev_home=$HOME/dev cd $dev_home就能进入/home/ptian/dev目录了 但是这种环境变量的设置，只能保证它在当前的shell下有效，如果你重新启动一个shell或者启动

The MTL_CC_ENTRIES_INTERFACE table serves as the interface between users and Oracle Inventory\'s Enter/Approve Cycle Count Request functionality. Users populate the interface table, and a PL/SQLconcurrent program, launched by the user, processes the information in this table, inserts/updates the MTL_CYCLE_COUNT_ENTRIES table, and spawns adjustment material transactions, if necessary. Expected behavior ----------------------- Cycle count open interface brings the counts in the count