What you have learnt is equivalent to the amount of sand you can hold in your hand. What you haven't is everything outside - Tamil Proverb


Labels

Wednesday, July 23, 2014

Tweet by Franck Pachot



Franck Pachot (@FranckPachot)

7/23/14 7:02 AM

#Oracle12c #inmemory Be careful most of the licensed options are always installed. Few exceptions are: pic.twitter.com/touhR7PmaO



Sent from my iPhone

Tweet by Syed Jaffer Hussain



Syed Jaffer Hussain (@sjaffarhussain)

7/23/14 7:20 AM

Oracle 12.1.0.2 supports Force Full Database Caching Mode. Anticipate a lot of debate over this in the coming days.



Sent from my iPhone

Tweet by James Murtagh



James Murtagh (@jmurts)

7/23/14 7:40 AM

Jonathan Lewis' (@JLOracle) new post on #oracle execution plans: allthingsoracle.com/execution-plan… Part of a series on allthingsoracle.com



Sent from my iPhone

Sunday, July 20, 2014

Tweet by SQL Performance Tips



SQL Performance Tips (@SQLPerfTips)

7/20/14, 4:55 PM

The Trouble with [Oracle] Parsing: youtube.com/watch?v=1oddFE… Soft/Hard Parse: use-the-index-luke.com/l/sql/glossary… Bind Parameters: use-the-index-luke.com/l/sql/where-cl…



Sent from my iPad

Tweet by nixCraft Linux Blog



nixCraft Linux Blog (@nixcraft)

7/20/14, 6:24 PM

Confused by #Bash shell Initialization files? See when bash init scripts run via solipsys.co.uk/new/BashInitia… #unix #linux pic.twitter.com/PYoaiBW3R3



Sent from my iPad

Saturday, July 19, 2014

Tweet by Kevin



Sent from my iPhone

Tweet by Fuad Arshad



Fuad Arshad (@fuadar)

7/18/14 3:09 PM

"ASM Metadata, Internals and Diagnostic Utilities" buff.ly/1zQt5jt good read



Sent from my iPhone

Tweet by kragen



kragen (@kragen)

7/18/14 7:16 PM

redsymbol.net/articles/unoff… I've been programming in sh for 20+ years and I still didn't know most of this. YOU MUST READ THIS if you shellscript



Sent from my iPhone

Tweet by Pete Sharman



Pete Sharman (@SharmanPete)

7/18/14 9:16 PM

Database Consolidation (PDBaaS) – Setup wp.me/p40a3L-4J



Sent from my iPhone

Tweet by OraNA.info



OraNA.info (@orana)

7/18/14 10:55 PM

Database Consolidation (PDBaaS) – Setup dlvr.it/6Mb92J #oracle



Sent from my iPhone

Tweet by oaktable network



oaktable network (@oakies_blog)

7/19/14 12:00 AM

New post by pete.sharman - Database Consolidation (PDBaaS) – Setup - tinyurl.com/qdt8mbt



Sent from my iPhone

Friday, July 18, 2014

Tweet by Hemant K Chitale



Sent from my iPhone

Thursday, July 17, 2014

Tweet by OraNA.info



OraNA.info (@orana)

7/16/14 3:06 PM

What's New in Oracle Event Processing 12c? dlvr.it/6LVM0y #oracle



Sent from my iPhone

Tweet by OraNA.info



OraNA.info (@orana)

7/16/14 5:15 PM

Oracle MAA Part 2: Bronze HA Reference Architecture dlvr.it/6LXHpP #oracle



Sent from my iPhone

Tweet by Pete Sharman



Pete Sharman (@SharmanPete)

7/16/14 5:36 PM

A new video by Jagan Athreya (Product Manager for AWR Warehouse) that's well worth watching youtube.com/watch?v=StydMi…



Sent from my iPhone

Tweet by Pete Sharman



Pete Sharman (@SharmanPete)

7/16/14 6:54 PM

Delivering DBaaS using EM12c wp.me/p40a3L-4y



Sent from my iPhone

Tweet by oaktable network



oaktable network (@oakies_blog)

7/16/14 7:00 PM

New post by pete.sharman - Delivering DBaaS using EM12c - tinyurl.com/pvaluxl



Sent from my iPhone

Tweet by Rene Antunez



Rene Antunez (@grantunez)

7/16/14 7:46 PM

2nd platform will have an 0.5% CAGR, 3rd platform will have 10.6% CAGR between 2013-2020, so get on the bus ! #DBAAS tcs.com/SiteCollection…



Sent from my iPhone

Wednesday, July 16, 2014

Tweet by OraNA.info



OraNA.info (@orana)

7/16/14 9:32 PM

Get Your ZFS On dlvr.it/6LbrZx #oracle



Sent from my iPhone

Tuesday, July 15, 2014

Tweet by Oracle University



Oracle University (@Oracle_Edu)

7/14/14 4:40 AM

Now Available On Demand: Oracle Database 12c: Backup and Recovery Workshop ora.cl/nwu



Sent from my iPhone

Monday, July 14, 2014

Tweet by OracleBlogs



OracleBlogs (@OracleBlogs)

7/13/14 11:18 PM

Oracle Cloud: Oracle's Platform and Infrastructure Services, Amit Zavery ow.ly/2K6pb5



Sent from my iPhone

Sunday, July 13, 2014

Tweet by Tanel Poder



Tanel Poder (@TanelPoder)

7/13/14 1:28 AM

Good stuff from past: Beyond Oracle Wait Interface - Part 2 bit.ly/ZYdidL



Sent from my iPhone

Tweet by Deiby Gómez



Deiby Gómez (@hdeiby)

7/13/14 12:44 AM

ASM 12c: The maximum number of ASM Disk Group is increased from 63 to 511.



Sent from my iPhone

Tweet by OraNA.info



OraNA.info (@orana)

7/13/14 5:25 AM

Create diskgroup in ASM dlvr.it/6JkV77 #oracle



Sent from my iPhone

Tweet by OraNA.info



OraNA.info (@orana)

7/13/14 5:41 AM

Force option in ASM dlvr.it/6Jl4pR #oracle



Sent from my iPhone

Tweet by OraNA.info



OraNA.info (@orana)

7/13/14 6:31 AM

Exadata storage indexes and DML dlvr.it/6JmkWq #oracle



Sent from my iPhone

Friday, July 11, 2014

Tweet by OracleBlogs



OracleBlogs (@OracleBlogs)

7/11/14 6:19 PM

Friday Spotlight: How to Get Started Using DTrace on Oracle Linux ow.ly/2JZVrj



Sent from my iPhone

Tweet by OraNA.info



OraNA.info (@orana)

7/11/14 9:37 PM

Friday Spotlight: How to Get Started Using DTrace on Oracle Linux dlvr.it/6J3vHR #oracle



Sent from my iPhone

Tweet by Allan Robertson



Allan Robertson (@dba_hba)

7/11/14 6:57 AM

Invoker Rights in Oracle Database 12c : Some more articles pulse.me/s/1Fm45y



Sent from my iPhone

Tweet by Xavier Picamal



Xavier Picamal (@CondeBond)

7/11/14 7:31 AM

Run $ cat $ORACLE_HOME/install/portlist.ini | grep "Enterprise Manager Console" to find the port where it is running #OracleTricks



Sent from my iPhone

Thursday, July 10, 2014

Tweet by Ronald Vargas ACED



Ronald Vargas ACED (@rovaque)

7/10/14 1:44 AM

c.c @brost Thks to @ChandlerDBA for SPM background tips in #db12c in chandlerdba.wordpress.com Hugs.. @hdeiby



Sent from my iPhone

Tweet by VitalSoftTech



VitalSoftTech (@VitalSoftTech)

7/10/14 2:30 AM

Need Help Setting Up Active Data Guard Database for Your Oracle 12c? #oracle #12c ow.ly/yWoM7



Sent from my iPhone

Tweet by Gokhan Atil



Gokhan Atil (@gokhanatil)

7/10/14 3:06 AM

ODAT - Oracle Database Attacking Tool hack-tools.blackploit.com/2014/07/odat-o…



Sent from my iPhone

Tweet by nixCraft Linux Blog



nixCraft Linux Blog (@nixcraft)

7/10/14 5:55 AM

Good work. Checkout excellent video tutorials on #Linux and #DevOps from Sysadmin Casts sysadmincasts.com



Sent from my iPhone

Wednesday, July 9, 2014

Exadata in Laptop - again !

Paulo Portugal
Paulo
Oracle Database Architect at F2C
Top Contributor
Hi Arup,

How are you?

I need to organize, but for now I made this (sorry, something is still in portuguese):

1-Install OEL5U9 64 bit

2-Download Exadata Cell Software 12.1

3-SCP Exadata Cell Software to your vm

scp ExaCell121110.zip root@192.168.56.2:/tmp

4-Unzip and install jdk and cell rpm

unzip ExaCell*

5-Untar cell software on boots/cell


6-Configurar YUM

7-Criar o diretorio abaixo:

mkdir /var/log/oracle
chmod 775 /var/log/oracle


8-Ediatr o arquivo /etc/bash colocando a linha abaixo n final:

export DISPLAY=:0.0

9-Editar o arquivo /etc/sysctl.conf colocando as linhas abaixo:

fs.file-max = 65536
fs.aio-max-nr=50000000

net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=2097152


OBS: rodar sysctl -p

10-Editar o arquivo /etc/security/limits.conf colcoando as linhas abaixo:

* soft nofile 65536
* hard nofile 65536


11-Configurar RDS conforme abaixo:

[root@cell12 raw]# lsmod | grep rds
[root@cell12 raw]# modprobe rds
[root@cell12 raw]# modprobe rds_tcp
[root@cell12 raw]# modprobe rds_rdma
[root@cell12 raw]# lsmod | grep rds
rds_rdma 82580 0
rds_tcp 10455 0
rds 96059 2 rds_rdma,rds_tcp
rdma_cm 36793 2 rds_rdma,ib_iser
ib_core 66577 7 rds_rdma,ib_iser,rdma_cm,ib_cm,iw_cm,ib_sa,ib_mad


12-Criar o arquivo conforme abaixo:

more /etc/modprobe.d/rds.conf
install rds /sbin/modprobe –ignore-install rds && /sbin/modprobe rds_tcp && /sbin/modprobe rds_rdma

13-Editar o /etc/hosts como abaixo:

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
#::1 localhost6.localdomain6 localhost6
192.168.56.2 exacel01


14-Instalar JDK que está no cellrpms.tbz

15-Instalar pacote net-snmp pelo yum

yum install net-snmp*

16-Instalar exadtaa com yum

yum install exadata*

17-Instalar rpm da celula

rpm -Uvh cell-12.1.1.1.0_LINUX.X64_131219-1.x86_64.rpm

18-Criar discos na VM e depois links no SO

echo $T_WORK
mkdir -p
[root@exacel01 ~]# fdisk -l 2>/dev/null | grep "2147 MB" | awk '{ printf "%s%02d\n", "ln -s "$2" exacel01_DISK", NR }'|sed "s/://"
ln -s /dev/sda exacel01_DISK01
ln -s /dev/sdb exacel01_DISK02
ln -s /dev/sdc exacel01_DISK03
ln -s /dev/sdd exacel01_DISK04
ln -s /dev/sde exacel01_DISK05
ln -s /dev/sdf exacel01_DISK06
ln -s /dev/sdg exacel01_DISK07
ln -s /dev/sdh exacel01_DISK08
ln -s /dev/sdi exacel01_DISK09
ln -s /dev/sdj exacel01_DISK10
ln -s /dev/sdk exacel01_DISK11
ln -s /dev/sdl exacel01_DISK12
[root@exacel01 ~]#

[root@exacel01 raw]# fdisk -l 2>/dev/null | grep "4294 MB" | awk '{ printf "%s%02d\n", "ln -s "$2" exacel01_FLASH", NR }'|sed "s/://"
ln -s /dev/sdm exacel01_FLASH01
ln -s /dev/sdn exacel01_FLASH02
ln -s /dev/sdo exacel01_FLASH03
ln -s /dev/sdp exacel01_FLASH04
[root@exacel01 raw]# ln -s /dev/sdm exacel01_FLASH01
[root@exacel01 raw]# ln -s /dev/sdn exacel01_FLASH02
[root@exacel01 raw]# ln -s /dev/sdo exacel01_FLASH03
[root@exacel01 raw]# ln -s /dev/sdp exacel01_FLASH04
[root@exacel01 raw]#


19-Criar celula e discos

cellcli
alter cell exacel01 interconnect1=eth1

list lun
create celldisk all
create griddisk all harddisk prefix=DISK
create griddisk all flashdisk prefix=FLASH



Best Regards,
Paulo Portugal

jc nars (@jcnars) shared a conversation with you!

     
jcnars jc nars saw this and thought of you!
     
 
 
 
laurentsch @laurentsch
 

in memory option: Oracle 12cR1 patchset 1 is due this month and there is a new parameter that you can set to b... bit.ly/1rRHr0y

   
  07:17 AM - 09 Jul 14
   
 
 
 
 
 
     

jc nars (@jcnars) shared a conversation with you!

     
jcnars jc nars saw this and thought of you!
     
 
 
 
Mythics @Mythics
 

Fantastic tutorial by Nathan Tsang on Building #oracle @oraclewebcenter portal. Step by step guide & lessons learned tinyurl.com/onbmc3j

   
  07:43 AM - 09 Jul 14
   
 
 
 
 
 
     

My Blog List

Blog Archive

Total Pageviews


Custom Search