Database

In order to use WorkBench, the database must be available at the place where you installed it and MySQL Server must be installed for this. You can access the installation from this link.

We first link to the MySQL WorkBench download page, http://dev.mysql.com/downloads/workbench/

On the following page, click No thanks, just start my download link, you can sign up and download if you want.

Say Run to the incoming alert.

You’ll get a warning like the following, so keep saying OK because this application can’t work because Microsoft Visual C ++ 2013 Redistributable package is not installed.

I will talk about two ways to do this. The first method is how we can do this from the MySQL official page. Once the image is linked to the page, click the Download tab.

Then click the Windows tab.

After clicking the MySQL installer tab on the page that opens,

Here you can download and install from the links at the bottom of the page. The first link is the internet installation package if you have an internet connection, the second link is the local installation file that contains the entire recommended installation package for users who do not have an internet connection. The page is also available in the installation guide (MySQL Installer Documentation). But there is a situation,

Login to Mysql with an authorized user.

> mysql -u root -p

If more than one database exists, it can be listed with the following command.

> show databeses;

Then the database where the user is located is selected.

> use “database_name”;

The following command also lists the tables in the database.

> show tables;

You can list the fields in the table with the following command.

> describe “tables_name”;

You can use the following command to see all the data in the table.

Error:

During an RMAN backup, we may receive the following errors.

ORA-00245: check file backup operation failed, we receive a warning.

RMAN-08132: WARNING: cannot update recovery area reclaimable file list, we see the warning.

Reason:

The directory supplied as Snapshot Controlfile in the RMAN configuration cannot be accessed from all RAC servers.
What do we have to do for this?

Solution:

Settings need to be changed. This directory must be given a public directory that is accessible to all servers in the RAC environment.

Error:

When clients attempt to connect to the database, they can not connect with the error “ORA-12502: TNS: listener received no CONNECT_DATA from the client”.

Now we will try to find out both the causes and how to solve this problem.

Reason:

Missing host definition in the local_listener parameter.

Solution:

The definition in the local_listener parameter should be changed as follows.

Missing Host Definition:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = node-VIP) (PORT = 1521))))

Correct Host Definition:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = node-vip.domain.local) (PORT = 1521))))

If the database is RAC, the definition of sid = ‘XX’ should also be added.