Page 4 of 9

Oracle 18c – Install binaries on Oracle Linux 7

In this blog, I’ll go through oracle 18c installation on oracle Linux 7.4. Oracle 18c is not officially announced for on-premises database. But for study purpose, I thought to use Oracle 18c binaries from oracle edelivery which is available for Oracle Exadata. Other option is to try 18c on Oracle SQL live which I explained here.

My environment is all ready to go. I am using Oracle virtual box 5.2.2 with Oracle Linux 7.4, 4GB memory and extra disk for oracle binaries and data files.

Oracle recommends that when you install Oracle Linux 6 or Oracle Linux 7 and use Oracle Preinstallation RPM to configure your operating systems for Oracle Database and Oracle Grid Infrastructure installations. The Oracle Preinstallation RPM will automatically creates standard (not role-allocated) Oracle installation owner and groups, and sets up other kernel configuration settings as required for Oracle installations. 18c preinstall rpm is not available yet so used 12R2 as its compatible with 18c. Continue reading → Oracle 18c – Install binaries on Oracle Linux 7

Oracle 18c – Private Temporary Tables

Oracle 18c introduced, Private temporary tables concept which are temporary database objects that are dropped at the end of a transaction or session. Private temporary tables are stored in memory and each one is visible only to the session that created it.

The “CREATE PRIVATE TEMPORARY TABLE” statement to create a private temporary table. The ON COMMIT clause indicates if the data in the table is transaction-specific (the default) or session-specific.

Here is my explanation on Oracle Live SQL.

This statement creates a private temporary table that is transaction specific: Continue reading → Oracle 18c – Private Temporary Tables

Oracle 18c – Get it started

Oracle 18c already released and it’s time to upgrade your skills with latest version. As 18c is only available on the Oracle cloud and Oracle engineered systems so how to get familiar with new version if you don’t have oracle cloud account. Don’t worry, you can try oracle 18c on Live SQL.

“Oracle Database 18c” as “Oracle Database 12c Release 2 12.2.0.2” with some new features. The change in the naming to reflect the year in which the product is released hence the skip of 6 releases. New naming convention is more for simplicity of yearly release model and the patching process.

Another important thing to note, Oracle Database 18c is not an Autonomous database but it’s a cloud service that has new features that makes it easier to build an autonomous database. The on-premises 18c (when released) won’t be autonomous. DBA’s need to script it up to automate the build process etc…

Now it time to start playing with Oracle 18c and here is how you can quickly fire some sql commands on oracle 18c database.
Continue reading → Oracle 18c – Get it started

DataGuard 12.1 – FastSync and FarSync

From 12c onwards, Data Guard maximum availability supports the use of the noaffirm redo transport parameter. It enables Maximum Availability protection mode at larger distances with less performance impact then before. In “LogXptMode=FASTSYNC” mode, standby database returns receipt acknowledgment to its primary database as soon as redo is received in memory. The standby database does not wait for the Remote File Server (RFS) to write to a standby redo log file.

This is how FastSync set up: Continue reading → DataGuard 12.1 – FastSync and FarSync

MySQL 5.7 – Server Logs

MySQL can write to various types of logs;

    • Error Log – Records diagnostic messages regarding startup, shutdown and abnormal conditions.
      • Windows – host_name.err or errors can also logged to the event viewer
      • Linux – host_name.err or log-error=file_name option to log files.
    • General Query Log – Records all statements that the server receives from clients. The general query logs can be very useful when you suspect an error in a client and want to know exactly what the client sent to mysqld.
      • By default, the general query log is disabled.
      • The global general_log and general_log_file server variables provide runtime control over the general log.
      • Set general_log=0 or OFF to disable the log and 1 or ON to enable it.
      • Set general_log_file=file_name to specify the log file. If a file is already open, it is closed and the new log file is opened. If no file name is given then by default host_name.log is created under data directory.
      • The output is written to any destination specified by –log-output option which can be table, file or None.

Continue reading → MySQL 5.7 – Server Logs

MySQL 5.7 – Installation

MySQL is available for several operating systems. In this blog, I’ll cover windows and Linux only.

For MySQL 5.7, there are multiple installation package formats to choose from when installing MySQL on Windows.

MySQL Installer:  The package has the file name (mysql-installer-community-5.7.21.0.msi or mysql-installer-commercial-5.7.21.0.msi) for community and commercial use. The Installer option will download and apply updates to itself and each of the product installed. MySQL installer can install and manage many other products, including..

  • Application – MySQL workbench, MySQL notifier, MySQL utilities etc..
  • Connectors – MySQL connector/C, C++ , Connector/Python etc…
  • documentation – MySQL Manual (PDF format), samples and examples

Community Edition is further of two type: Web and Full. Continue reading → MySQL 5.7 – Installation