matthewdba.wordpress.com
Matthew Walden - Oracle DBA | Random findings from the Oracle Database worldRandom findings from the Oracle Database world
http://matthewdba.wordpress.com/
Random findings from the Oracle Database world
http://matthewdba.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.2 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
5
SSL
EXTERNAL LINKS
21
SITE IP
192.0.78.12
LOAD TIME
0.172 sec
SCORE
6.2
Matthew Walden - Oracle DBA | Random findings from the Oracle Database world | matthewdba.wordpress.com Reviews
https://matthewdba.wordpress.com
Random findings from the Oracle Database world
matthewdba.wordpress.com
TFA – Trace File Analyzer | Matthew Walden - Oracle DBA
https://matthewdba.wordpress.com/2015/03/08/tfa-trace-file-analyzer
Matthew Walden – Oracle DBA. Random findings from the Oracle Database world. TFA – Trace File Analyzer. A few highlights before diving down into a little more detail –. 8211; Collect all relevant logs from all nodes of a cluster, and collate on a single node ready for sending to Oracle. 8211; Cluster aware (many commands including installation run across cluster). 8211; On Exadata. Will recognise storage cells and collect logs from them too. 8211; Installed by default on ODA. Now a little more detail.
Foreign configuration(s) found on adapter | Matthew Walden - Oracle DBA
https://matthewdba.wordpress.com/2016/08/12/foreign-configurations-found-on-adapter
Matthew Walden – Oracle DBA. Random findings from the Oracle Database world. Foreign configuration(s) found on adapter. This is an interesting one to be ready for, before that 3am wake up call. It seems that under certain circumstances an X5-2 server (Exadata storage server in this case) doesn’t come back too cleanly after a power outage. In this case, it was unable to see any of it’s storage and was complaining that “Foreign configuration(s) found on adapter”. August 12, 2016 at 11:35 AM. You are commen...
GoldenGate 12.2 – New Features (Oracle Open World 2015) | Matthew Walden - Oracle DBA
https://matthewdba.wordpress.com/2015/10/27/goldengate-12-2-new-features-oracle-open-world-2015
Matthew Walden – Oracle DBA. Random findings from the Oracle Database world. GoldenGate 12.2 – New Features (Oracle Open World 2015). Today I attended a “deep dive” session on GoldenGate 12.2 new features, and I really cannot wait for this version to be released! No more definitions files. Validation of parameter files. Makes it easier to configure GoldenGate high availability and Manager process startup/shutdown. Uses new XAG ENABLE parameters as well as the AGCTL utility. This is another really nice fe...
GoldenGate – Clusterware Installation with RAC | Matthew Walden - Oracle DBA
https://matthewdba.wordpress.com/2015/11/19/goldengate-clusterware-installation-with-rac
Matthew Walden – Oracle DBA. Random findings from the Oracle Database world. GoldenGate – Clusterware Installation with RAC. In this mini series of blog entries I’m demonstrating GoldenGate installation on a cluster with a RAC database, with Oracle Dataguard also thrown into the mix. This first blog entry just covers the clusterware and RAC side. I’ve set up a demonstration environment as follows –. Two node RAC cluster with nodes exa1db01, exa1db02. Both run on the exa1 cluster. At the time of writing, ...
Exadata: Changing Private IP Addresses | Matthew Walden - Oracle DBA
https://matthewdba.wordpress.com/2016/04/03/exadata-changing-private-ip-addresses
Matthew Walden – Oracle DBA. Random findings from the Oracle Database world. Exadata: Changing Private IP Addresses. I think this is going to be of somewhat niche interest! A requirement to change private IP addresses rarely comes up on Exadata, but there are a couple of documentation bugs with the 12.1.2.3.0 software that currently make it more difficult that it needs to be. The process is generally quite well documented in the Exadata maintenance guide and basically covers –. Cellcli -e alter cell inte...
TOTAL PAGES IN THIS WEBSITE
5
Hack Oracle Database Vault using DBMS_SCHEDULER | Abdellatif Abugharbieh
https://abugharbieh.wordpress.com/2016/04/30/hack-oracle-database-vault-using-dbms_scheduler
Skip to main content. Skip to secondary content. Some of my Oracle notes. Hack Oracle Database Vault using DBMS SCHEDULER. April 30, 2016. Oracle Database Vault restricts access to specific areas in an Oracle database from any user, including users who have administrative access. For example, you can restrict administrative access to employee salaries, customer medical records, or other sensitive information. Sqlplus / as sysdba. With the Partitioning, Oracle Label Security, OLAP, Data Mining,. Job actio...
Howto know the processor type (Power 5, power6 or power7) on AIX | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/howto-know-the-processor-type-power-5-power6-or-power7-on-aix
My technical work (Oracle Database, Scripting, Linux, etc …). Howto know the processor type (Power 5, power6 or power7) on AIX. Lsattr -E -l proc0. Output should be similar to:. Frequency 3000000000 Processor Speed False smt enabled true Processor SMT enabled False smt threads 4 Processor SMT threads False state enable Processor state False type PowerPC POWER7 Processor type False. Always check the OS level (version) using:. January 20, 2016. Posted by Luis on January 20, 2016. Leave a Reply Cancel reply.
January | 2016 | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01
My technical work (Oracle Database, Scripting, Linux, etc …). All posts for the month January, 2016. How to move your ubuntu to another computer. Step 1: Store the list of installed packages. Run the following command on the source machine to store the installed packages names in. Sudo dpkg - get-selections sed "s/.*deinstall/ " sed "s/install$/ g" /pkglist. Step 2: Transfer your config. Or even a flash drive to transfer your home directory (. The source list (. From the source machine to the target one.
Check CRC errors on Emulex HBA | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/02/24/check-crc-errors-on-emulex-hba
My technical work (Oracle Database, Scripting, Linux, etc …). Check CRC errors on Emulex HBA. The command to check that on each HBA port:. You’ll see something like this. And watch for that Invalid CRC count to increase. This indicated either the HBA or fibre channel wire are having issues. I would start by replacing the wire…. Check http:/ www.emulex.com/files/solutions/oracle/pdfs/using-oracle.pdf. February 24, 2016. Posted in Oracle Database. Posted by Luis on February 24, 2016. Enter your comment here.
NUMA related | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/numa-related
My technical work (Oracle Database, Scripting, Linux, etc …). Nfob is a variable used to determine the size of numa pool size parameter. Nfob=1 ( 0.1*nprocs)*nfiles). January 20, 2016. Posted in Oracle Database. Posted by Luis on January 20, 2016. Https:/ luiscalvolopez.wordpress.com/2016/01/20/numa-related/. Ssh still ask for password in spite of a passwordless configuration. Obtain all locks and resource information from a RAC instance (also works for standalone). Leave a Reply Cancel reply. Christoph&...
Obtain all locks and resource information from a RAC instance (also works for standalone) | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/obtain-all-locks-and-resource-information-from-a-rac-instance-also-works-for-standalone
My technical work (Oracle Database, Scripting, Linux, etc …). Obtain all locks and resource information from a RAC instance (also works for standalone). This will dump all information needed to locate locks and resources hold on different instances:. Sqlplus "/ as sysdba" oradebug setmypid oradebug unlimit oradebug -g all lkdebug -A res oradebug -g all lkdebug -A lock oradebug -g all hanganalyze 3 oradebug -g all dump systemstate 267 quit. Destinations for new files. Lkdebug -O 0x0 0x0 CF. Please log in ...
ssh still ask for password in spite of a passwordless configuration | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/ssh-still-ask-for-password-in-spite-of-a-passwordless-configuration
My technical work (Oracle Database, Scripting, Linux, etc …). Ssh still ask for password in spite of a passwordless configuration. You are trying to configure a linux account so it can be used as RAC owner for software install. You has followed all steps:. Created the rsa and dsa keys. Added the pub keys to the authorized keys file of the current node and the rest of nodes. Checked that permissions for. Is 700 and for. However the problem persists. You try to debug the sshd client and copy. As default va...
February | 2016 | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/02
My technical work (Oracle Database, Scripting, Linux, etc …). All posts for the month February, 2016. Check CRC errors on Emulex HBA. The command to check that on each HBA port:. You’ll see something like this. And watch for that Invalid CRC count to increase. This indicated either the HBA or fibre channel wire are having issues. I would start by replacing the wire…. Check http:/ www.emulex.com/files/solutions/oracle/pdfs/using-oracle.pdf. February 24, 2016. Posted in Oracle Database. Jon Adams, OCP, MCTS.
Hang Stuff: V$Wait_Chains, Procwatcher, Hanganalyze, and Systemstate Dump Levels | Luis's Blog
https://luiscalvolopez.wordpress.com/2016/01/20/hang-stuff-vwait_chains-procwatcher-hanganalyze-and-systemstate-dump-levels
My technical work (Oracle Database, Scripting, Linux, etc …). Hang Stuff: V$Wait Chains, Procwatcher, Hanganalyze, and Systemstate Dump Levels. This is taken from an email from Mike Polanski. There are many good alternatives to getting huge systemstate dumps in v11 that impact the customer’s system far less. I wanted to take this opportunity to mention some…. 8211; Troubleshooting Database Contention With V$Wait Chains. However, it turns out the reason for the excessive systemstate times at levels 266 an...
TOTAL LINKS TO THIS WEBSITE
21
matthewdayler.com
Matthew Day Perez
Matthew Day Perez Received his BFA from Illinois State University and his MFA from the Rhode Island School of Design. Continuously experimenting with the potential of combining, subverting, and exploiting materials Matthew works with a diverse set of media; glass, printed matter, digital media, and installation.
Matthew Dayton's Blog | Just another SQL / BI Blog
Matthew Dayton's Blog. Just another SQL / BI Blog. How to know which tables are being replicated. December 16, 2011. This will be brief. I wanted to share this tidbit I recently ran into when wanting to audit and add database security to tables that are not being replicated. And as always I wanted to do this thru SQL and not using the GUI. Next I located the MSreplication objects table that resides in the database that I am trying to verify. I find this a much better solution to the problem. Now this is ...
Avoiding Quiet Desperation...
Meditations on Life, Culture, Travel, and Faith. Monday, June 1, 2009. The Beauty of Espresso. Well- I have a confession to make. I have fallen in love.again. No need to doubt my fidelity however, this love is not of the romantic variety. This love is of the frothy, strong, and exhilarating variety. This love is for a little drink called espresso. Why did no one ever show me espresso before? Of course I had heard. Notice the cup in my hand. Group of college students from the church. Links to this post.
Default Parallels Plesk Panel Page
Web Server's Default Page. This page is generated by Parallels Plesk Panel. The leading hosting automation software. You see this page because there is no Web site at this address. You can do the following:. Create domains and set up Web hosting using Parallels Plesk Panel. Parallels is a worldwide leader in virtualization and automation software that optimizes computing for consumers, businesses, and Cloud services providers across all major hardware, operating systems, and virtualization platforms.
Matthew Walden - Oracle DBA | Random findings from the Oracle Database world
Matthew Walden – Oracle DBA. Random findings from the Oracle Database world. Foreign configuration(s) found on adapter. This is an interesting one to be ready for, before that 3am wake up call. It seems that under certain circumstances an X5-2 server (Exadata storage server in this case) doesn’t come back too cleanly after a power outage. In this case, it was unable to see any of it’s storage and was complaining that “Foreign configuration(s) found on adapter”. Continue reading →. Continue reading →.
Matthew Ballard – Fantasy Author
Shard Knight – Chapter One. Echoes Across Time – Prequel. November 16, 2016. I’m working on a new novel or maybe it’s a novelette? November 7, 2016. Here’s what’s on my to do list:. 1) I’m working on a new novel this one in the Sci-Fi genre. Specifically the time travel sub genre. Details to come. Prim’s Law On Sale Now! October 22, 2016. I have a new book out! Prim’s Law is now for sale on Amazon. Caught between his family and his country, Ethan fights to clear his sister’s name. After discovering h...
Matthew Bauer, L.Ac. and Author of “The Healing Power of Acupressure and Acupuncture”
Matthew D. Bauer. Licensed Acupuncturist and Author of. The Healing Power of Acupressure and Acupuncture". Matthew D. Bauer, L.Ac. Matthew is interviewed by AcupunctureSchools.com. Thank you for visiting my site. I am excited about the publication of my book - " The Healing Power of Acupressure and Acupuncture. The Healing Power of Acupressure and Acupuncture. Thanks again for visiting and "Good Health! Matthew D. Bauer, L.Ac. This is a comprehensive, honest, and informed look at the history, theory, and...
Matthew D. Beda Designs
I am a Design Nerd. What do I do for fun? I make Websites, and designs. What do I do when I'm not making website? I know that engaging the user is half the battle. My philosophy is simple. Keep it simple! If a user can't navigate your site what good is the site. I don't oversell the interface I keep it in line with your target demographic. A Good design does not have to be fancy, it just needs to work. I can lead you to a design that works without scaring away customers. Some of My Clients.
The 200lb Man
Friday, June 22, 2012. I'd let him turn this in as an assignment, if he paid me. Links to this post. Tuesday, June 12, 2012. It's like the Swan Station, but with more Playstation and less electro-magnetism. Let me start off this post by saying what is exactly on my mind: Whatever is wrong with me, blame my kids. I think this is old news. Did I talk about the bookcase? Or had I built it yet? The Books and the Bookcase. My bookcase, which I made from a tree I chopped down in my front yard (three times!
SOCIAL ENGAGEMENT