Category: Oracle
-
Starting Oracle SQL Developer with Custom Parameters
I recently worked at a Client that had the Windows desktop setup in a non-English language. Naturally, I did not get admin rights on the Client owned desktop so I could not change the sqldeveloper.conf SQL Developer config file which was stored in a ‘protected’ location.
Written by
·
-
Setup a VirtualBox based Database Lab Environment
Oracle provides a lot of useful Oracle VirtualBox Pre-built Appliances. In this blog post, I will describe the few extra steps I take after download in order to setup my lab environment on my work MacBook Pro.
Written by
·
-
How to monitor SQL with Oracle SQL Developer
The easiest way to monitor the SQL’s currently executing
Written by
·
-
I am speaking at SPOUG20
Autonomous Database is the best Cloud Database but many Clients wonder about its security! This talk will address those concerns! Oracle Autonomous Database might be the answer to the most database security challenges. In this presentation, I will walk through the way the Oracle’s Autonomous database products protect against the security threats. By design. We…
Written by
·
-
Is Oracle Autonomous Database the answer to the many database security issues? (II)
In the previous article, I discussed the main differentiating capabilities of the Autonomous, what makes it special on the market. In this post, I will discuss how are those capabilities implemented.
Written by
·
-
Is Oracle Autonomous Database the answer to the many database security issues? (I)
There is no surprise that typical Database setups are the main target of the hacking attacks worldwide. The reason is obvious: cracking a database will result in access to the data which is the main ‘merchandise’ to be shared or sold on the dark corners of the World Wide Web.
Written by
·
-
SQL*Plus Client connections to several Oracle Autonomous (Always-Free)
Oracle Autonomous is a great service and Always-Free is a nice offering launched at OpenWorld 2019. But what happens if I need to connect via SQL*Plus to two or more ADB from the same machine/terminal? The Oracle documentation provides good reference usable when connectiong to one autonomous database but if we need to use several…
Written by
·
-
It is now possible to clone a database in Autonomous Cloud
Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud.
Written by
·
-
Oracle Autonomous Transaction Processing: Client Setup
a. First step is the database creation. Quite straightforward:
Written by
·
-
Oracle Instant Client for macOS
Oracle does not release anymore full client packages for the Mac clients. Therefore, we need to use the Instant Client from:
Written by
·
-
Strange error when renaming a table
ORA-14047: ALTER TABLE INDEX RENAME may not be combined with other operations
Written by
·
