ITPub博客

查询数据量的大小

[root@rac1 ~]# /u01/app/oracle/product/10.2.0/crs/root.shWARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by rootWARNING: directory '/u01/app/oracle/product' is not owned by rootWARNING: directory '/u01/app/oracle' is not owned by rootWARNING: directory '/u01/app' is not owned by...

datefmt=` date "+%Y_%m_%d-%H_%M_%S" `mkdir    /mmis/MMIS_BUILD/config/8081_log_back/ejb/"${fmt}"mkdir    /mmis/MMIS_BUILD/config/8081_log_back/web/"${fmt}"cp -r -f  /mmis/MMIS_BUILD/jboss/jboss_4.2.2_ejb1/server/default/log/*   /mmis/MMIS_BUIL...

net.ipv4.ip_local_port_range = 9000 65500kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 101365net.core.rmem_default = 1048576net.core.rmem_max = 1048576net.core.wmem_default = 262144net.core.wmem_max = 262144fs.aio-max-nr = 3145728# Allocate 256*2MiB for HugePageTables (...

 orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password="qazwsx123" entries=20;alter user disadmin identified by "qazwsx123";alter user system identified by "qazwsx123";alter user sysman identified by "qazwsx123";select * from v$pwfile_users;

psadmin角色的权限点击(此处)折叠或打开DROP ROLE PSADMIN;CREATE ROLE PSADMIN NOT IDENTIFIED;GRANT DROP USER TO PSADMIN WITH ADMIN OPTION;GRANT ALTER USER TO PSADMIN WITH ADMIN OPTION;GRANT ANALYZ...

需要一个域账号，进去sql server数据库检查运行的ssis请求是否失败。在sql server中，这个域账号需要的权限是服务器角色：public用户映射：FCSDB --public               msdb -- public,SQLAgentOperatorRole,SQLAgentReaderRole,SQLAgentUser...

linux同步时间30 0 * * * /usr/sbin/ntpdate 10.70.8.31;/sbin/hwclock -w

测试的过程如下：点击(此处)折叠或打开drop directory MTR_UTL_FILE_DIR ;create or replace directory MTR_UTL_FILE_DIR as \'/tmp\';grant read,write on directory MTR_UTL_FILE_DIR to apps;select * from dba_directo...

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...