- 博客(40)
- 资源 (3)
- 收藏
- 关注
RSS订阅原创 critical steps for by setup 12c rac on vmware exsi using dns(no gns)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 4
2014-01-02 10:35:33
805
原创 dns ,dhcp for gns setup
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32cat /etc/named.confoptions { // FORWARDERS: Forward any name
2014-01-01 16:40:18
622
原创 install db node for exadata
nothing special but add the two files to let the oracle database and grid control know where is the cell node.add one line into cellinit.ora vi /etc/oracle/cell/network-config/cellinit.ora ipaddress1=
2013-12-30 14:58:44
1138
原创 install cell node is so simple
1.make sure the virtual machine's memory less than 4G.2.upload cellImageMaker_11.2.3.2.0_LINUX.X64_120713-1.x86_64.tar file into server then untar it (the file was unzipped from V33693-01.zip which
2013-12-30 03:03:56
876
原创 how to install oracle linux 5 with paravirtual scsi controler over vmware exsi
this article is the preparation for the oracle exadata installation, as we know that it's so fast to install and do some work under os ORACLE linux 6 which default scsi controler is paravirtual scsi.
2013-12-30 02:26:03
814
原创 silent install oracle 12c
if you are used to use silent installation for the oracle database software you need to provide additional parameters:oracle.install.db.BACKUPDBA_GROUP, oracle.install.db.DGDBA_GROUP and oracle.in
2013-08-07 14:47:55
2213
原创 impdp/expdp 的query 一切特殊字符都要用\来转意
impdp corecat/corecat directory=dir_map dumpfile=map.dmp TABLE_EXISTS_ACTION=replace TRANSFORM=SEGMENT_ATTRIBUTES:n parfile=2.parQUERY=CLASSIFIER_MAP:\"where ERD_CMA_TYPE_VALUE_D in\(\'TAG CLASSIFIC
2013-07-11 18:04:09
1931
原创 ogg sourceistable extract parameter files - as an etl tool
--FISCAL_PERIOD f_00ADD EXTRACT f_00, SOURCEISTABLEEXTRACT f_00USERID ggs_owner, PASSWORD ggs_ownerFORMATASCII, NONAMES, DELIMITER '|' ,NOQUOTE , NOHDRFIELDS, NULLISSPACEEXTFILE /oraarch/CN
2013-07-08 11:11:06
1448
原创 a script to generate sqlldr control file
DECLARE str varchar2(100); u_name varchar2(100); tab_name varchar2(100); Type Tab_L is Table of Varchar2(100); T_Tab Tab_L := Tab_L('CORECAT.FISCAL_PERIOD','CRX_COR.CORPORATE_ACTION',
2013-07-08 11:09:26
565
转载 ssh 登录速度慢的解决
相信很多朋友在使用Linux系统的时候因为安全性的原因摒弃了telnet rlogin 或者 X-window，而把openssh作为自己默认的远程登录方式。 然而经常会遇到的一个情况是telnet到server速度很快，但是ssh连接的时候却很慢，大概要等半分钟甚至更久。ping的速度也非常好，让人误以为是ssh连接不上。 下面说下如何解决这样的问题， 最为常见的原
2013-06-05 15:51:35
433
原创 linux 中文包
linux安装中文语言包 相关配置如下： yum install fonts-chinese.noarch yum install m17n-db-common-cjk yum install m17n-db-chinese安装上面的几个语言包重启就正常了 yum groupinstall chinese-support
2013-06-05 10:56:23
475
原创 Executing root.sh errors with "Failed To Upgrade Oracle Cluster Registry Configuration" [ID 466673.1
https://updates.oracle.com/ARULink/PatchDetails/process_form?patch_num=4679769 the bug 很坑爹 这个补丁装好之后也要dd 一下，不然还是没法继续。linux上oracle rac 装起来bug好多，先是unset LD_ASSUME_KERNEL 然后是oifcfg setif 当然第一个bug 经
2013-05-28 14:38:11
426
原创 updated
listener.oralistener=(description=(address_list=(address=(protocol=tcp)(port=1521)(host=ocm.localdomain)))listener1=(description=(address_list=(address=(protocol=tcp)(port=1421)(host=ocm.localdoma
2013-05-14 16:38:39
537
原创 本地yum 库
vi /etc/yum.repos.d/base.repo[base]name=basebaseurl=file:///mnt/Server/enabled=1gpccheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle # grub.conf generated by anaconda##
2013-05-13 13:52:14
530
原创 dbms_lob.instr
insert into tab select rowid,systimestamp from tab1 where dbms_lob.instr(tab1.description ,'Oracle9i' ,3)>0 SQL> insert into clob values(1,'aa','oracle');1 row created.SQL> insert into c
2013-05-09 18:29:20
762
原创 outline
SQL> create table t (id number , value number, name varchar2(30));Table created.SQL> insert into t select FILE_ID,BLOCKS,TABLESPACE_NAME from dba_data_files;4 rows created.SQL> commit;Comm
2013-05-08 16:03:41
503
原创 ora_rowscn & scn_to_timestamp
SQL> select ora_rowscn from tt;ORA_ROWSCN---------- 286928 286928 286928 286928 286928 286928 286928 286928 286928 28692810 rows selected.SQL>
2013-05-07 14:01:32
938
原创 trailing nulcols:difference between external table and sqlldr:create external table from controlfile
the table definiton :SQL> desc tt; Name Null? Type ----------------------------------------- -------- ---------------------------- A
2013-05-03 17:16:56
1208
原创 looks so easy while hard to do -standby in 60minutes
when facing the requirement to configue a dataguard and switch over it twice in 60 minutes, I feel so hard. network need configue , database archive mode ,force logging ,password file , ssh ,paramet
2013-05-02 17:03:05
575
原创 silent install oracle response file
RESPONSEFILE_VERSION=2.2.1.0.0UNIX_GROUP_NAME="oinstall"FROM_LOCATION="/u01/database/stage/products.xml"ORACLE_HOME="/u01/app/oracle/product/10.2.0.0/database"ORACLE_HOME_NAME="OraDb10g_home
2013-05-02 13:36:22
649
原创 e2label , fstab, mkfs, partprobe, fdisk
[root@ocm raw]# cat /etc/fstabLABEL=/1 / ext3 defaults 1 1LABEL=/u01 /u01 ext3 defaults 1 2LABEL=/u02
2013-04-30 17:13:08
679
原创 the simplest sample of listener.ora and tnsnames.ora
for listener.ora file LISTENER = (ADDRESS = (PROTOCOL = TCP)(HOST = ocm.localdomain)(PORT = 1521))SID_LIST_LISTENER =(SID_DESC= (SID_NAME = clone)(ORACLE_HOME = /u01/oracle/product/database))
2013-04-28 13:51:27
526
转载 sqlldr
转载自http://www.cnblogs.com/jk8158/archive/2008/10/22/1317022.htmlhttp://blog.sina.com.cn/s/blog_a7e2684901012558.html sqlldr的介绍 SQL*LOADER是ORACLE的数据加载工具，通常用来将操作系统文件（数据）迁移到ORACLE数据库中。SQL*LOADE
2013-04-27 17:31:18
821
转载 rman create script and execute script
backup as compressed backupset database format '/u01/oracle/rman/clean/compress_db_%U.dbf' ; RMAN> create script lvl_1 { backup incremental level 1 database format '/u01/oracle/rman/ocm/db_%U.db
2013-04-27 15:29:08
840
原创 manully typing the partiton table script is a hard work
CREATE TABLE sample_regional_sales (deptno number, item_no varchar2(20), txn_date date, txn_amount number, state varchar2(2)) PARTITION BY RANGE (txn_date) SUBPARTITION BY LIST (sta
2013-04-26 18:37:57
477
原创 resource manager tesing and explain
for the testing purpose , I assgin oracle user DD to batch group and QDL to oltp group , oltp can switch to batch group when switch condition are meet.two consume groups are batch and oltp .see co
2013-04-23 18:10:08
579
原创 grub install oracle linux on linux
firstly you should have the dvd iso file in some of the partition on the existing linux server , for me its in /dev/hda2 ,note : don't change the file name.mount -t iso9660 /iso/Enterprise-R5-U6-Ser
2013-04-23 13:50:32
641
原创 rman clone db prerequests
as a prerequest for the duplicate database command is set log_file_name_convert and db_file_name_convert parameter for the auxiliary database init.ora file . another prerequest is modify the liste
2013-04-23 13:11:11
499
原创 remove a rac completely
to minimize the time for an virtual vmare server setup:cd /usr/local/bin/ and rm the three filesrm -rf /var/tmp/.oraclevi /etc/inittab remove the 3 bottom linescd /etc/init.d rm -rf i
2013-04-17 22:44:13
549
原创 pragma autonomous_transaction : restrict_references(<fuctionname>,wnds) and serially_resumable
pragma : serially_reusableSQL> CREATE PACKAGE pkg1 IS PRAGMA SERIALLY_REUSABLE; num NUMBER := 0; PROCEDURE init_pkg_state(n NUMBER); PROCEDURE print_pkg_state;END pkg1;/ 2
2013-04-17 17:25:46
674
原创 standard fga and fga
two categories: standard audit and fga audit enable standard audit :parameters : audit_file_dest = , audit_trail = db_extended ,audit_sys_operations =truecommand : audit all on ; audit selec
2013-04-17 15:44:22
514
原创 create the mview with fast refresh - the lazy way
in 10g before creating an complex mview , thinking through how and is it possible to create the mview with refresh fast on commit enable qurey rewrite funtion?remember count(*) is the key for an
2013-04-16 17:43:33
483
转载 vmware workstation 9 rac vmx file setting . oifcfg
here I create scsi1:0 scsi1:1 scsc1:2 scsc1:3 scsc1:4 scsc1:5 disk on vmware workstation 9 and modified the vmx for both nodes by adding the following lines : the locking and sharedbus are the key
2013-04-15 21:05:32
1083
原创 small cases
external table of an oracle_datapump type create directory dir as '/u01/oracle/directory';grant read,write on dir to public; as sys :create table ext_tab organization external (type oracle
2013-04-15 16:09:59
368
转载 external table sample : from oracle document
CREATE TABLE sales_delta_xt ( prod_id NUMBER, cust_id NUMBER, time_id DATE, channel_id CHAR(2), promo_id NUMBER, quantity_sold NUMBER(3), amount_sold NUMBER(10,2) )
2013-04-15 01:20:39
477
转载 flashback ,an all around aritcle
http://trailblizer.blog.163.com/blog/static/59630364201032674712579/
2013-04-15 00:32:35
345
原创 find & vi
After grid control sccessfully install on server db2 , I added listener1 using port 1821 and modified tnsnames.ora using the new listener.then the repostory couldn't be connected , I then go to sys
2013-04-14 17:20:06
597
原创 seamless physical dataguard creation and swichover
prerequest : primary database name is ocmdb , standby database's directory strutrue is different than primary (ocmdb,ocmdg) maximize protection mode1. create database2. alter database force loggin
2013-04-13 11:34:38
564
转载 aq_tm_processes
QMNC和Qnnn：高级队列QMNC进程对于AQ表来说就相当于CJQ0进程之于作业表。QMNC进程会监视高级队列，并警告从队列中删除等待消息的“出队进程”（dequeuer）：已经有一个消息变为可用。QMNC和Qnnn还要负责队列传播（propagation），也就是说，能够将在一个数据库中入队（增加）的消息移到另一个数据库的队列中，从而实现出队（dequeueing）。Qnnn进
2013-03-15 23:22:19
8589
原创 about shared pool
select a.ksppinm , b.ksppstvl from x$ksppi a , x$ksppcv b where a.indx=b.indx and a.ksppinm like '%dsidx_count'_kghdsidx_count 参数决定了share pool 的sub pool的个数多用v$sqlstats 而不是v$sql 因为代价更小
2013-03-14 17:38:13
610
oracle-valided rpms part2
2013-04-17
oracle-valided rpms for oracle-linux5 update6
2013-04-14
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人