Search

Top 60 Oracle Blogs

Recent comments

microsoft

PASS Summit 2019 is NEXT WEEK!

I’m getting ready for SQL Saturday Oregon this weekend, (taking the train up from Eugene to Portland…) but its about time I talked about the exhilarating and exhausting event we call PASS Summit.

This year I was lucky enough to be chosen as a speaker and a blogger.  Bloggers at the conference get the opportunity to sit in special zones during keynotes and we write about the event.  We also get special access to Microsoft PMs, (although I may be the only one who works for Microsoft attending vs. running them… :)) I look forward to all of the blogger perks and recommend it to anyone who has a passion for writing about our community and tech.

The Complexity Defense and Other DBA Crimes

No matter how far my career and role has shifted, I will always view myself as a database administrator.  I know this because when I fill out any form asking me what role I fulfill in IT, I still choose “DBA” from the list.  No matter what claims the media and leading sources state, DBAs are an important role, even as technology shifts and traditional database tasks move to the cloud.  Deeper relational database skills are still quite relevant when working in complex technical scenarios.

The Experts

Companies work to ensure they hire the right technical specialists.  They don’t understand database and other deep technology, so they hire someone who does.  The challenge arises when the technologist may fear responsibility for a problem or an incident, so decides to use the technical complexity to disqualify their technical area, such as a database, suspect.

October 2nd, #SQLSatOregon in Portland and the #SQLTrain!

I’m still not sure where October went….well, actually I do-  it was a flurry of travel, writing, (but not blogging!) and working with customers on a ton of new projects for the next quarter.  With the end of October, comes the preparation for PASS Summit.  Last year, I had to pass on the SQL Train, but this year?

SQL Train is the annual pilgrimage from SQL Saturday Oregon, in Portland, to PASS Summit in Seattle via Amtrak train.  Chris Hyde is the poor, tortured soul responsible for organizing this, but I hear that if you say you’ll volunteer, it’s like Hotel California-  you can check in, but you can never check out!

Oracle on Azure- Options, Options, Options

I’ve been very busy allocating 60% of my time towards Oracle on Azure migrations.  The biggest challenge right now isn’t getting Oracle on Azure, but keeping my percentage of time allocated to only 60%.

#24HOP and PASS Summit 2019

You know how busy I am by the amount of time I DON’T blog and yes, it’s been over a month.  I think that’s the longest I haven’t blogged in YEARS.

24 HOP and Facebook Live

I just finished my 24HOP, (24 hrs of PASS) session back on September 9th, the PASS Facebook Live session this last Monday and I’m thrilled with these virtual events each year I get the chance to participate. If you’re not familiar with 24HOP, its a preview of some of the sessions at Summit, the annual tech conference from PASS.  Twenty four presenters are chosen to offer a preview on their talk.  As mine is on Linux Scripting, I decided to do a tips and tricks session that had three goals:

Azure VMs with Oracle- Next Steps

Microsoft has done a great job of documenting how to create a VM with the appropriate VM image and Oracle version, then how to log in, startup the listener and create the database.  I just have some enhancements I’d like to make to it, hoping to help it move up one level.

I Bequeath to You

All instructions provided by the Microsoft documentation show how to connect to the database using a bequeath, (BEQ) connection.  This is done by the following command, using SQL Plus, (or similar):

sqlplus / as sysdba

It bypasses the need for a connection string, only requiring the SID to be set at the environment level:

export ORACLE_SID=

This information, for Oracle DBAs, is often gathered from a running database server executing the following command:

Linux Scripting, Part IV- Scripting for Longevity

We’ve learned a lot about commands, utilities and how to create a script, but we need to discuss the importance of scripting for longevity.

What is Scripting for Longevity?  We have a tendency to focus on scripting to automate something WE might not want to perform manually, but avoid what we think might void our value.  We may try to ensure there is necessity for our role or our knowledge as we create scripts.  This can be built into the execution process, scheduling, arguments, pre-run or post-run steps.  This doesn’t make us an asset, but a liability and against what I call, “the Code of Conduct” when automating.

Questions

The questions you have to ask yourself as you script out solutions are:

Create an Oracle VM on Azure in Less than 5 Minutes

If there’s one thing I’ve been able to prove this week, it’s that even with the sweet 4G LTE, Wi-Fi setup in my RV, Montana still has the worst Wi-Fi coverage in the US.  Lucky for me, I work in the cloud and automate everything, because if there’s one thing I love about automating with scripts, is that I can build out a deployment faster and less resource intensive than anyone can from the portal.

Oracle Virtual Machines in Azure

When you build out an Azure VM, with Oracle, you’ll also need to have the supporting structure and a sufficiently sized additional disk for your database.  This can be a lot of clicks inside a portal, but from a script, a few questions and bam, you have everything you need.

Best Practices for Oracle Data Guard on Azure

I keep saying I’m going to start sharing what I’m doing in the Analytics space soon, but heck, there’s too much I need to keep adding to on the Oracle in Azure arena!

So, as most people know, I’m not a big fan of Oracle RAC, (Real Application Cluster).  My opinion was that it was often sold for use cases that it doesn’t serve, (such as HA) and the resource demands between the nodes, as well as what happens when a node is evicted to those that are left are not in the best interest for most use cases.  On the other hand, I LOVE Oracle Data Guard, active or standard, don’t matter, the product is great and it’s an awesome option for those migrating their Oracle databases to Azure VMs.

Oracle and Microsoft’s Cross-Cloud Partnership

A couple weeks back, Oracle and Microsoft announced their cross-cloud partnership.  This was wonderful news to me, as I’ve been working on numerous Oracle projects at Microsoft with Azure.

The Gist

To know that there is now a partnership between the two clouds and that there’s also a large amount of documentation about working between the two clouds is very helpful vs. the amount I’ve been working on based off just my knowledge.  Just as anyone appreciates a second set of eyes, I now have two company’s worth!