Firefox tab crashes by loading maps.google.com on ubuntu 16.04

On a ubuntu 16.04 system firefox crashes by loading maps.google.com:

 The only way to fix this was going to "about:config":

On this page search for "webgl.disabled" and change the value from false
to true:

After that, maps.google.com loads without any problem...

Safe Harbor Statement – Oracle

Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

 

The post Safe (more...)

Oracle ERP DB Exadata migration + AC-50480: Internal error occurred + ORA-12154

I was recently involved in a project to migrate an Oracle ERP database to an Exadata server. The ERP database was a non-RAC Oracle 12cR1 running on RHEL with Oracle EBusiness suite 12.1.3.

The migration involved only migrating the ERP database from traditional storage/server technologies to Exadata machine. Upgrade from non-RAC database to RAC. The application remains on the same host. Though similar migration projects were successfully done earlier, this time, I faced (more...)

18c is now available (but only on the Cloud)

On Friday afternoon (16th February) we started to see tweets and blog posts from people in Oracle saying that Oracle 18c was now available. But is only available on Oracle Cloud and Engineered Systems.

It looks like we will have to wait until the Autumn before we can install it ourselves on our own servers :-(

Here is the link to the official announcement for Oracle 18c.

Oracle 18c is really Oracle 12.2.0. (more...)

Shredding and Querying with Oracle Offline Persistence in JET

I think offline functionality topic should become a trend in the future. Its great that Oracle already provides solution for offline - Oracle Offline Persistence toolkit. This is my second post related to offline support, read previous post - Oracle Offline Persistence Toolkit - Simple GET Response Example with JET. I have tested and explained with sample app how it works to handle simple GET response offline. While today I would like to go one (more...)

First login to Oracle 18c

Database administrators have specific responsibilities and must understand how to complete database administration tasks. To get started with database administration, you must understand basic database concepts, such as the types of database users, database security, and privileges. You must also be able to complete basic tasks, such as submitting commands and SQL to the database and creating a password file

Below is first login Oracle Database 18c.

Stay Tuned for More Information on Oracle 18c

(more...)

Oracle Database 18c Released : How to Get Started

Just in case you missed it, Oracle Database 18c was released on Friday. You can read the announcement in this post.

How to Get Started

You might be a bit disappointed if you don’t have an Oracle Cloud account, or an engineered system. Not to worry. You can try Oracle Database 18c on Live SQL.

The documentation is already available. You (more...)

Oracle Database 18c

Yup…it’s arrived!

New name obviously, because we’ve jumped to our new naming model to align with the calendar year as opposed to version number.  You might be thinking “So what?” but it’s a significant change in the way we getting software to customer.  Mike Dietrich blogged about this at length here so I won’t repeat what has been said, but in TL;DR form:

More frequent releases, with smaller amounts of change per (more...)

Display the sql_id for a query in Oracle 18c

The SET FEEDBACK command has an SQL_ID option to display the sql_id for the currently executed SQL or PL/SQL statements. The sql_id will be assigned to the predefined variable SQL_ID.

Displays the number of records returned by a script when a script selects at least n records. SQL_ID returns the sql_id for the SQL or PL/SQL statements that are executed. The sql_id will be assigned to the predefined variable SQL_ID.

SQL> SET FEEDBACK ON SQL_ID
SQL>  (more...)

SET LINESIZE window in Oracle 18c

Sets the total number of characters that SQL*Plus displays on one line before beginning a new line.

WINDOW adjusts the linesize and pagesize for the formatted output according to the width and height of the screen. If the output is longer than the screen width, then the output is wrapped accordingly

Example
To set the linesize for the output to 30, enter
SQL> SET LINESIZE 30
SQL> SHOW LINESIZE
linesize 30

To dynamically change the (more...)

SQL Server Operations Studio

Since I reformatted my Surface Pro 4 so I could have my Docker running again, I also needed to recover my local SQL Server instance I like to have available on my PC.

This was a perfect time to get everything up and running, but instead of my standard way of doing this, use SQL Server Operations Studio, (SSOS).

The Lesson

Most SQL Server DBAs have a GUI took to assist in managing their (more...)

Oracle Database 18c and it’s features

Finally, Oracle officially released Oracle Database 18c with Oracle Documentation available on Oracle Public Cloud(OPC).  To get more detailed on Oracle 18c release read Oracle Support Document 2285040.1.

List of some new features in Oracle 18c:

Data Guard

  • Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups
  • Automatic Correction of Non-logged Blocks at a Data Guard Standby Database

Application Continuity

  • Server Draining ahead of relocating or (more...)

Oracle Adaptive Intelligent Applications for ERP

Recently Oracle announced new AI-based Apps for Finance Leaders to empower CFOs w/ data-driven insights to adapt to change, develop new #markets & increase profitability! With Oracle Adaptive Intelligent Applications for ERP, finance leaders can benefit from: Better insight: Making use of analytics and synthetic intelligence to finance can enhance efficiency and will increase agility […]

I want your vote!

Are you a member of the UKOUG? Read on…

ukoug_logo

I’m currently standing for the role of Member Advocate. But why?

I’ve been volunteering at the UKOUG for over 10 years, and speaking at the conferences and SIGs for the last 5 years or so.  I’ve been deputy chairing or chairing a SIG for all of this time and I’m currently the RAC SIG Chairperson. I’m also involved with our main conference, having helped on (more...)

Network link in expdp

The export operation is performed with data that is consistent up to the specified SCN. If the NETWORK_LINK parameter is specified, then the SCN refers to the SCN of the source database.

Follow following steps to the export database using network-link.

Source database: demo

Target database: uat

Database platform : 11.2.0.4.0

Step 1 : Create a tnsnames.ora entry with source database.

demo =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL  (more...)

Will I Be The Next President Of The UK Oracle User Group?

I’ve decided to put myself forward to be President Elect of the UK Oracle User Group (UKOUG). The position of President Elect is, in effect, President-in-waiting. You shadow the current president before taking over the role when their comes to an end. In this case, that will be in a year.

I think this is a very sensible manner in which to introduce a new person into the role of President. The UKOUG is one (more...)

Blocking Session not visible in v$ Views

I had to troubleshoot an issue on a company ERP systems database, where several sessions were waiting for ‘enq: TX row lock contention’. It was a table containing print server nodes and this caused no more printouts. Usually troubleshooting locking issues is quite straightforward in recent versions of oracle database, but this time, the column “v$session.blocking_session” was not populated and there was no entry in v$lock for the blocker. This was strange, so I (more...)

Full Scale Data Architecture College Tour

Yesterday I attended the Full Scale Data Architecture College Tour. A unique opportunity to step into the boardroom and find out what an executive thinks about IT, architects, architecture and data in particular. The host of the event; Ronald Damhof and Sylvia Butzke (COO at PGGM Investments) did a great job of keeping the conversation going. … Continue reading "Full Scale Data Architecture College Tour"

Docker and Windows 10 1709 Patch, The End

So if you read my last post on my challenges with Docker containers running on Windows 10 after the 1709 patch, I thought I was close to solving it once I was granted the admin password to disable and uninstall Sophos Endpoint.

Once I uninstalled Sophos, I noted I ended up with a different line number error.  The question was, has the problem shifted from Sophos to a new issue or is it more (more...)

AskTOM Office Hours for DBA’s

We had the first AskTOM Office Hours Q&A for Database Administrators yesterday.  Thanks to everyone that showed up, and thanks for the questions.

If you missed it, you can catch a replay here