Oracle DBA Place

Creating trace file, writing to alert.log and retrieve using Amazon RDS for Oracle

noreply@blogger.com (Yossi Nixon) — Mon, 06 Jan 2020 15:00:00 +0000

Since in Oracle RDS environment, we don't have a direct access to the operating system I have recently been asked to provide a workaround from the database. A procedure that: 1. Write to the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Connect to Oracle Database server through ssh tunnel

noreply@blogger.com (Yossi Nixon) — Mon, 28 Oct 2019 15:00:00 +0000

Last week I needed to connect a database from remote using VPN. The VPN is connected to a secured network, so I couldn’t connect directly to the database. Since I am using Toad for Oracle which is...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Using ssh X11 tunnel through a bastion host to connect to a database server

noreply@blogger.com (Yossi Nixon) — Tue, 01 Oct 2019 16:00:00 +0000

Hi, I succeeded running Oracle dbca, xclock & virt-viewer using Bastion over VPN (with root) 😊 Theoretical Steps:First, connect to machine B and forward [localPort] to C:22 through B A$ ssh -L...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

How to install Oracle Linux in kvm without a need to X server

noreply@blogger.com (Yossi Nixon) — Tue, 24 Sep 2019 16:00:00 +0000

Hi, I managed to install Oracle Linux on kvm guest without a need to X console (no GUI, vnc or X11) 1. We can see the PXE menu 2. We can select image to install 3. We need to add console=ttyS0 to the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

rlwrap and auto completion in sqlplus

noreply@blogger.com (Yossi Nixon) — Wed, 18 Sep 2019 16:00:00 +0000

It is a while I am following the blog of Mariami Kupatadze, it seems that our background and daily work is around the same area and interest as mine. This week she posted a simple Linux adjustment...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Oracle 19c Updates on Active Data Guard using DML Redirection

noreply@blogger.com (Yossi Nixon) — Sun, 17 Feb 2019 07:38:00 +0000

Previously, you could only update Global Temp Tables on Active Data Guard standby database. From Oracle 19c, you can also update regular tables. Updates on Active Data Guard:Update will be...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Oracle Database Auto Discovery

noreply@blogger.com (Yossi Nixon) — Mon, 07 Jan 2019 15:00:00 +0000

Hi, I was asked by our development team to provide the best way to identify database parameters from database host, I was surprised to find so many options.Identifying all instances on the current...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Creating SNMP Plug-In for Enterprise Manager Cloud Control

noreply@blogger.com (Yossi Nixon) — Mon, 31 Dec 2018 15:00:00 +0000

Putting it In my previous blog (Enterprise Manager Cloud Control, SNMP, and Plug-Ins – The Background), I shared my frustration in trying to create a plug-in in OEM. Here are the technical steps for...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Enterprise Manager Cloud Control, SNMP, and Plug-Ins – The Background

noreply@blogger.com (Yossi Nixon) — Mon, 24 Dec 2018 15:00:00 +0000

Hi, I have been using Oracle Enterprise Manager (OEM or Cloud Control) since it was a client application. (I’m not sure whether it was in the era of Oracle 7 or Oracle 8). In the early stages, OEM...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Setup additional local DNS - to add scan addresses

noreply@blogger.com (Yossi Nixon) — Mon, 17 Dec 2018 15:00:00 +0000

In this document I demonstrate how to add local DNS server to be added additionally to an existing DNS, I had this need for creating some additional IP addresses in the DNS for Real Application...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Oracle open world 2017 short summary

noreply@blogger.com (Yossi Nixon) — Wed, 12 Dec 2018 09:07:00 +0000

Hi,The main subject in this conference was Autonomous Database, it's engine is used by another buzzword called: Machine Learning. Oracle claim they are investing in autonomous to...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Oracle Linux ASM docker recipe

noreply@blogger.com (Yossi Nixon) — Mon, 10 Dec 2018 15:00:00 +0000

General informationIn this setup we are: Installing dockerCreating Non-root user (ynixon) with sudo and docker privilegesASM device: /dev/sdb1Enabling sqlnet + ssh to the containerDefault ASM port is...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Bypassing the Listener and Connecting the Instance without a Password from Java Code

noreply@blogger.com (Yossi Nixon) — Mon, 03 Dec 2018 15:00:00 +0000

In the past I wrote a post about Bypassing the listener and connecting to ASM without a password from Python code Now, I've been asked to prove that it can be done in Java. The solution is...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Automatic restart in Grid Infrastructure for Far Sync

noreply@blogger.com (Yossi Nixon) — Mon, 26 Nov 2018 15:00:00 +0000

Hi, Checking if the Far Sync instance is configured to restart automatically after reboot / shutdown of the host / cluster: $ crsctl stat res ora.fdb1.db -f |grep...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Query Historical messages of RMAN

noreply@blogger.com (Yossi Nixon) — Mon, 19 Nov 2018 15:00:00 +0000

Hi,Recently I realized that this very small and useful feature of RMAN is not known to many of us. I have just learned about this option just two years ago. I am talking about the ability to query...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

My impressions from Oracle OpenWorld 2018

noreply@blogger.com (Yossi Nixon) — Mon, 12 Nov 2018 15:00:00 +0000

Hi,This was my third time at Oracle OpenWorld, and still I was thrilled like the first time. Howard Street was dressed in big, red banners everywhere—just take a picture and share it in a social...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Orphaned Files in ASM

noreply@blogger.com (Yossi Nixon) — Tue, 06 Nov 2018 15:00:00 +0000

Hi, In our lab environments we test Data Guard on a daily basis, and we frequently “play” with failover, switchover, and flashback . The output of this playground is that we have some leftovers in...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Data Guard Broker 19c

noreply@blogger.com (Yossi Nixon) — Thu, 01 Nov 2018 13:56:00 +0000

Hi, In an earlier version of Data Guard, when the broker had problems, one of the automatic answers I got from support was to recreate the broker configuration. In other words: Drop the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

SLOB

noreply@blogger.com (Yossi Nixon) — Tue, 07 Aug 2018 14:30:00 +0000

SLOB is an Oracle I/O workload generation tool kit, supports testing extreme REDO logging I/O (minimal amount of CPU overhead) The SLOB package can be downloaded from Kevin Closson's Blog: SLOB...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Swingbench Short cookbook commands

noreply@blogger.com (Yossi Nixon) — Mon, 23 Jul 2018 14:00:00 +0000

In this example we are using Swingbench 2.6 with Order Entry stress test - using a configuration file (SOE_Server_Side_V2.xml) Connection String: The connection will always be defined to pluggable...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Steps To Shutdown / Startup The Exadata

noreply@blogger.com (Yossi Nixon) — Mon, 16 Jul 2018 13:55:00 +0000

ShutDownLog in to the first database server as root.Change to the OneCommand directory# cd /opt/oracle.SupportTools/onecommandNote whether the Grid Infrastructure is currently enabled for autostart,...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Install Oracle Internet Directory (OID) in Standalone mode

noreply@blogger.com (Yossi Nixon) — Wed, 04 Jul 2018 18:05:00 +0000

Oracle Internet Directory (OID) is an LDAP server which uses an Oracle database as a datastore. Client machines can use the OID for all TNS lookups. With OID. Once all client machines are configured...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Managing AWR in Active Data Guard Standby Databases

noreply@blogger.com (Yossi Nixon) — Mon, 07 May 2018 15:43:00 +0000

Problem - Automatic Workload Repository (AWR) snapshots cannot be taken in a read-only standby environment. - Performance monitoring and analysis is limited to basic STATSPACK functionality...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Extract Data Guard Commands on Oracle 12.2

noreply@blogger.com (Yossi Nixon) — Thu, 08 Feb 2018 16:33:00 +0000

Hi,These days I am starting to work on Oracle 12.2, leaving behind the old versions. Since my main domain is Oracle Data Guard, I posted a blog about Oracle 12c Release 2 New Features for...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Coloring alert.log output via tail and less

noreply@blogger.com (Yossi Nixon) — Mon, 29 Jan 2018 17:00:00 +0000

Making my day to day job easier and convenient I like having some utilities and some aliases.We, the DBAs nation, have a need to look at the alert.log file frequently. So basically, I did the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]