virtualbox shared storage create on linux

create shared storage: data: [code]for i in {1..10};do vboxmanage createhd —filename asm_$i —size 10240 —format VDI —variant Fixed; done[/code] OCR: [code]for i in {1..3};do vboxmanage createhd —filename vote_$i —size 1200 —format VDI —variant Fixed; done[/code] make disk shareable: [code]for i in `ls -1 *.vdi`; do vboxmanage modifyhd $i —type shareable; done[/code] add disk to virtual […]

offline oracle agent install on windows

get list of supported platform: [code] [oracle@monitoring tmp]$ emcli get_supported_platforms ———————————————— Version = Platform = Linux x86-64 ———————————————— Version = Platform = Microsoft Windows x64 (64-bit) ———————————————— Version = Platform = Oracle Solaris on SPARC (64-bit) ———————————————— Version = Platform = Linux x86-64 ———————————————— Version = Platform = Microsoft Windows […]

Oracle: latch: cache buffers chains

save at my blog, original Waits on the cache buffer chains latch, ie the wait event «latch: cache buffers chains» happen when there is extremely high and concurrent access to the same block in a database. Access to a block is normally a fast operation but if concurrent users access a block fast enough, repeatedly […]

perf-tools linux

perf-tools looks awesome example : [code language=»bash»] [root@nb-abushmelev perf-tools] # ./iosnoop -Q -ts -Qp 28951 Tracing block I/O issued by PID 28951. Ctrl-C to end. STARTs ENDs COMM PID TYPE DEV BLOCK BYTES LATms 439471.905014 439471.909309 ora_ckpt_orc 28951 WS 8,0 89272384 16384 4.29 439471.909341 439471.914798 ora_ckpt_orc 28951 WS 8,0 0 0 5.46 439471.914874 439471.914930 ora_ckpt_orc […]

rman catalog sbt_tape backup piece

[code] RMAN> configure channel device type ‘SBT_TAPE’ parms=’ENV=(NB_ORA_SERVER=dc1-nb01,NB_ORA_CLIENT=DC1-DWHODI)’; new RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE’ PARMS ‘ENV=(NB_ORA_SERVER=dc1-nb01,NB_ORA_CLIENT=DC1-DWHODI)’; new RMAN configuration parameters are successfully stored [/code] now catalog works fine: [code] RMAN> catalog device type ‘SBT_TAPE’ backuppiece ‘al_11820_1_834711630’; allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=3 device type=SBT_TAPE channel ORA_SBT_TAPE_1: Veritas NetBackup for Oracle — Release […]

PRCD-1229 : after manual upgrade of oracle rac

[oracle@p00xxxdb01 ~]$ srvctl status database -d p00xxx PRCD-1027 : Failed to retrieve database p00xxx PRCD-1229 : An attempt to access configuration of database p00xxx was rejected because its version differs from the program version Instead run the program from /oracle/app/base/db/ [oracle@p00xxxdb01 ~]$ srvctl upgrade database -d p00xxx -o /oracle/app/base/db/ [oracle@p00xxxdb01 ~]$

oracle install to do

[code language=»sql»] groupadd —gid 54321 oinstall; groupadd —gid 54322 dba; groupadd —gid 54323 asmdba; groupadd —gid 54324 asmoper; groupadd —gid 54325 asmadmin; groupadd —gid 54326 oper; groupadd —gid 54327 backupdba; groupadd —gid 54328 dgdba; groupadd —gid 54329 kmdba; useradd —uid 54321 —gid oinstall —groups ‘dba,oper,asmdba,asmoper,backupdba,dgdba,kmdba’ oracle; useradd —uid 54322 —gid oinstall —groups ‘dba,asmadmin,asmdba,asmoper’ grid; ## […]