Saturday, March 07, 2015. Converting non-CDB database to a PDB when TDE is in use. Converting a non-CDB database to a PDB is a rather straightforward process.

Its well known that reliable interconnect connectivity is vital for normal cluster setup, so many DBAs and sysadmins implemented some kind of NIC bonding or teaming to protect from switch or cable failure.

How-to make cross-domain URL call work in javascript. I was quite busy in the past 2014. I only wrote one blog post in the whole year. I hope I can post more in 2015 to help others and help me as well. Normal URL call with JQuery.

My experiences and views on Oracle Database. 1 Host or Host Address. To connect any PostgreSQL db, you can use. The default port number for PostgreSQL is 5432. PgAdmin4 and phpPgAdmin are Graphical Administrations tools.

I am glad to announce that I have completed AWS Solutions Architect Associate. This is a completely new world with lots of opportunities to learn new things. Below is the list of things that I used for doing the certification. This will be helpful for anyone who is aspiring for AWS solutions architect associate certification.

Thursday, April 28, 2011. We started our Data Warehouse quest adventure on Tru64 back in 2003. At that time the Oracle 9i RAC and Tru64 was the best fastest platform on TPCH tests. We used OCFS2 as file system on the newly 2 node RAC environment. The migration went fine and the performance seems fine for most of the business users. Evidently blame the storage groups! On the.

Transportable Tablespace for Source and Target. Check tablespace and send email. New objects created in last week. Script to Check RMAN Backup Status in Real-Time. Check mount point status and send email. Spool Table output to CSV Excel file.

Oracle TimesTen and other Oracle Technologies. In this post I would like to install Oracle R Enterprise 1. Step 1 - Oracle R 3. Check that everything works fine. Step 2 - Oracle R Enterprise. Step 3 - Install packages. Step 4 - create a Database User.

DBA Internals of the Oracle Autonomous Database. On March 28, 2018. After starting using the Autonomous Data Warehouse Cloud. 2 You cannot create indexes on columns, you cannot partition tables, you cannot create materialized views, etc.

Avoid checking bind values in SQL. As SQL query developers, there should always be try to write and design simple sqls and not complex ones . Checking all the binds in the sql is way of writing generic code. Bind values which are passed in SQL are marked as bold.