ITPub博客

EBS 11i用户的请求无法提交，一直等待。检查并发管理器发现有几个并发管理器没有起来。1.停止并发管理器 ./adcmctl.sh stop apps/apps2.确保没有并发管理器的进程运行。ps -ef |grep FNDLIBR ps -ef |grep FNDSMps -ef |grep FNDOPP3.如果有，使用系统命令kill -9杀并发管理器的进程。ps -ef |grep FNDLIBR |...

1 HRMS APP连接DB报错Booting server processes ...exec PSWATCHSRV -A -- -ID 73380 -C psappsrv.cfg -D HRMSUATO -S PSWATCHSRV :        process id=9665 ... Started.exec PSAPPSRV -s@../psappsrv.lst -- -C psappsrv.cfg -D HRMSUATO -S PSAPPSRV :   &...

最近对数据库打补丁，和克隆。发现/etc/oraInst.loc在引导Oracle DB安装和补丁安装。非常重要。i copy the directory named oraInventory from UAT DB /home/orauat/oraInventory  to DEV DB /home/oradcrp/oraInventory.And modify /etc/oraInst.log as follow,my problem has solve .Thank for your patient.i...

最近碰到一个问题。因为EBS 11i log文件太多引起请求无法提交。重建log文件路径就解决了。查看EBS的请求，报需要一个到二个并发管理器处理请求。还有请求无法保存log。查看log路径的文件，有6G的log文件。[whatsupgold@szfms01 ~]$ cd /u02/fmsprd/fmsprdcomn/admin[whatsupgold@szfms01 admin]$ pwd/u02/fmsprd/fmsp...

To start mysqld at boot time you have to copysupport-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:  ./bin/mysqladmin -u root password 'new-password'&nbsp...

1. How can we find these sessions according these sql id?The answer is check the view dba_hist_active_sess_history, for example:select snap_id,dbid,sample_time,session_id,sql_id from dba_hist_active_...

cat /etc/modprobe.confalias eth0 bnx2alias eth1 bnx2alias eth2 be2netalias eth3 be2netalias scsi_hostadapter ccissalias scsi_hostadapter1 qla2xxxalias scsi_hostadapter2 usb-storagealias bond0 bondin...

1.Entry $ORACLE_HOME/sqlplus/admin,edit glogin.sql,add as follow SQL statement behind.[hrmsoraclone@hrmodbt01 admin]$cp  glogin.sql  glogin.sql.bak[hrmsoraclone@hrmodbt01 admin]$vi glogin.s...

一、        安装ftp [root@ocmrac1 Server]# rpm -ivhftp-0.17-35.el5.i386.rpm[root@ocmrac1Server]# service vsftpd start二、&nbsp...

    下载catcti中文版和rrdtool软件。rrdtool-1.4.4.tar.gz   cacti-0.8.7b-cn-utf8.tar.gz   一,配置监控服务端（10.70.38.161）配置Cacti监控服务端需要AMP(Apache,Mysq...

通过文件句柄恢复数据文件 1.删除数据文件[hrmsoraclone@hrmodbt01 HRMCLONE]$ rm -f paapp.dbf  2.查询dbwr进程pid[hrmsoraclone@hrmodbt01 HRMCLONE]$ ps -ef|grep dbw|grep -v grep506 &nb...

应税所得2适用税率速算扣除数级数0-150003%011500-4500150010%10524500-9000450020%55539000-35000900025%1005435000-550003500030%2755555000-800005500035%55056...

 RDA的使用（一）RDA的帮助1. 解压RDA文件p15929817_430_LINUX.zip[hrmsoraclone@hrmodbt01 tmp]$ unzip p15929817_430_LINUX.zip2. 使用RDA的帮助[hrmsoraclone@hrmodbt01 tmp]$ cd rda/[hrmsoraclone@hrmo...

hrmsdbset environment variables for restoreexport NLS_LANG=American_America.UTF8export NLS_DATE_FORMAT="mm-dd-yyyy:hh24:mi:ss"rman target /startup nomount;set dbid 2948431088;1. restore controlfile...

 补丁：p8202632_10205_linux_x86-64.zip 1.export DISPLAY=localhost:0.02.xhost +3../runInstaller 1.Start the database in the UPGRADE mode:SQL> STARTUP UPGRADE2.Set the system to spo...

1、关闭szmmisu01上的数据库和上面的mmis服务。2、在SB40上分配60G空间给szmmisu01.3、在szmmisu01对新分配的磁盘进行分区。Fdisk  /dev/sdbCommand (m for help): nCommand action   e ...

升级OPenssh到OpenSSH_6.1p1 一、开启telnet，防止ssh中断后无法远程连接服务器。#vi /etc/xinetd.d/krb5-telnet 把yes该为no,# /etc/init.d/xinetd start加载windows的共享盘到Linux中mount -t cifs -o ...

IO 阻塞时 每秒物理读 1769 * 8k = 13MPhysical reads:         1,769.5         141.0      &nb...

1.普通数据文件alter database datafile '/u02/fmsprd/fmsprddatasystem01.dbf' offline;mv fmsprddatasysaux01.dbf   sysaux01.dbfalter database rename file '/u02/fmsprd/fmsprddatasysaux01.dbf' ...

1、找出所有受影响的对象vi checkdb.shrman target  / nocatalog <<EOFrun{allocate channel d1 type disk;allocate channel d2 type disk;allocate channel d3 type disk;allocate channel d4 type disk;backu...