LINUX 字体安装
今天接触了 Linux 下字体安装方面的内容,本实验以安装宋体( simsun.ttf ) 为例,记录下安装过程。--1 下载字体 可以在网上下载,也可以在 windows 目录下找到对应字体,这里是从另一套系统上 copy simsun.ttf 文件。--2 查看当前系统中已安装...
编译form ebs12 and wfload
HDMSCFNSCW.fmbStep 1:Transfer the file(HDMSCFNSCW.fmb) to path: /u01/oracle/PROD/apps/apps_st/appl/au/12.0.0/forms/USStep 2:Complie the file use the follow commandsource APPS*.envcd $AU_TOPcd formscd USfrmcmp_batch module=HDMSCFNSCW.fmb Userid=apps/hdge20131011 output_file=/u01/ora...
cmclean.sql
set verify off; set head off; set timing off set pagesize 1000 column manager format a20 heading 'Manager short name' column pid heading 'Process id' column pscode format a12 heading 'Status code' column ccode format a12 heading 'Control code' colum...
adoacorectl.sh Failed
adstrtal.sh start 来启动应用的时候,曾遇到过有些service没有办法启动的问题,日志如下:Web Application Services OACORE OC4J Instance szxxapp-01 adoacorectl.sh Failed Web Application Services FORMS OC4J Instance szxxapp-01 adformsctl.sh  ...
清除ebs12目录数据
1>临时文件目录2〉erp日志文件记录3〉erp报表out目录4>归档日志。
ebs12 sendmail配置
Sendmail邮件配置安装包(sendmail-8.13.8-2.el5.i386.rpm,sendmail-cf-8.13.8-2.el5.i386.rpm,m4-1.4.5-3.el5.1.i386.rpm)由于sendmail的真正配置文件作者是用一种生僻的语言写的,号称天书,没几个人看得懂,所以我们配置的时候是配置的/etc/mail/sendmail.mc,这个比较好懂,每次修改后...
ebs克隆后必须步骤。
1>编译无效的数据对象。2>修改系统名称。3>修改环境变量和adautocfg.sh4>修改icx_parameter5>修改邮件地址。6>检查服务器状态。select replace(logfile_name,'/u01/oracle/PROD/inst/apps/PROD_hdgesvapprd01','/u01/oracle/UAT/inst/apps/UAT_hdgesvapuat01') from fnd_concurrent_requests;update fnd_con...
R12克隆步骤
资料来源:http://blog.chinaunix.net/uid-15866552-id-3579958.html R12克隆详细步骤Total: 16 hours(10M bankwidth)#############...
ORACLE EBS INSTALL of ebs12 install packages
package list:Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here (Part 1 of 4) B53824-01 Part 1 of 4 29M Download Oracle E-Business Suite Release 12.1.1 Rapid Install Start Here (Part 2 of 4) B53824-01 Part 2 of 4 97M Download Oracle E-Business Suite Release 12...
查看历史最多资源
select * from dba_high_water_mark_statistics;
awk命令复习
awk 用法:awk ' pattern {action} ' 变量名 含义ARGC 命令行变元个数ARGV 命令行变元数组FILENAME 当前输入文...
最常用的数据库命令,脚本
杀进程:alter system kill session 'serial number, sesssion number';kill -9 process_number;增加undo表空间:alter tablespace undo add datafile ' /ddfu.dbf' size 1000M;
配置恢复目录管理器
Step by step setup recovery manager:1>set ORACLE_SID= orarc sql>connect / as sysdba sql>create user rman/rman identified by "abc" sql>grant dba, resource ,recovery_catalog_owner to rman rman>connect catalog rman/rman;...
exchange partition
logfileSQL> alter table t_part exchange partition t_p1 with table t_part1;Table altered SQL> alter table t_part exchange partition t_p2 with table t_part2;Table altered
恢复数据,数据块恢复
10231 忽略受损的数据块.1>alter session set events '10231 trace name context forever,level 10'instanse 级别 :parameter :event='10231 trace name context forever ,level 10'方法2:execute dbms_repair.skip_corrupt_blocks('system','table_1')2>检查数据块错误:rman>backup...
备份
备份:rman:rman>backup database;rman>backup as copydatabase;rman>backup as compressed backupset database;backup as copy db_file_name_convert=('+data/aa','/backup/test') database1>备份视图:v$rman_configrationv$rman_outputv$rman_statusv$block_change_tracking al...
备份,恢复ocr,votedisk
1>votedisk啥时候需要备份:1>安装clusterware后,2>增加节点.前提是所有节点关闭clusterware,并且切换到root下。3>增加votedisk或删除votedisk后。备份votedisk命令:dd if= of=恢复:dd if= of=备份恢复ocr:ocrconfig -replace ocr /dev/raw/raw1ocrcon...
TNS学习
TEST08 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.13.229)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = test08)))替换下划线的版本为:TEST08 =__(DESCRIPTION =____(ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.13.229)(PORT = 1521))____(CONNECT_DATA =__...
RAC体系架构理解
1>CRS resoruce: NODEAPPS:GSD,ONS,VIP ,LISTENER. Database-Related Resource: Database ,Instance,service(racgimon来监控,启动,停止,切换) OCR content:1>system OCR-backup,CSS, CRS,local_only,ORA_CRS_HOME,evm.2>database ONS_HOST,DATABASE ,ASM,LOG,VIP_RANGE....
整理碎片3---表压缩
随着数据库的增长,我们可以考虑使用oracle的表压缩技术。表压缩可以节省磁盘空间、减少data buffer cache的内存使用量、并可以显著的提升读取和查询的速度。当使用压缩时,在数据导入和DML操作时,将导致更多的CPU开销,然而,由于启用压缩而减少的I/O需求将抵消CPU的开销而产生的成本。表的压缩对于应用程序来说是完全...