Skip to main content

INSTALLING DATABASE SERVERS ON UBUNTU ® | LINUX SERIES


Database servers are used mainly to store databases and keep data into it in collaboration
with application or web application servers.

The most famous database servers are:
MySQL and Oracle DB 12c

Let us go ahead and install each one of these and we will start with:

INSTALLING AND CONFIGURING MYSQL SERVER


To install MySQL server, you will need to run the following command:
sudo apt-get install mysql-server


Some other people install maria db package and this will be done using the following
command:
sudo apt-get install maria-db

Then for security reasons, you may run the following command to get your server up and
running securely:
mysql_secure_install

The last thing, we need to install is oracle 12c database server express edition.

INSTALLING AND CONFIGURING ORACLE DATABASE SERVER12C EXPRESS EDITION


Oracle Database Server 12c Express Edition is one of the mostly highly ranked database
server in 2017 and it acts exactly as the data container that holds applications or web
applications data.

Download the latest application of oracle database server using the following link:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-
linux-download-2240591.html

Run the following command to install oracle 12c and walk through the wizard:

path/to/db/runInstaller


Peace Out.
@suhaibbinyounis

Comments

Popular posts from this blog

Make money with Quora Partner Program | Explained

Earning money ain't it...
I know we all have some time wondered if it is possible to earn money online and believe me there are many ways to do that and it is all amazing.
In this post I will specifically talk about Quora Partner Program, QPP.

Quora came out with this amazing program that allows anyone in world to make a living out of writing. But speaking the truth it is not that much. It quite a hard work and less pay job.
Bascially, all you do is ask questions and then these questions will receive Ad impressions for which you get paid.

But here is the deal, you can monetize a question only for 1 year only. After that Quora owns the question.


So, how do you get started?

As of now there is no direct way of joining the QPP. The only way for you to join is if you receive a email from Quora itself which is quite random and obviously how active you are on quora will play a part.


So, how much can i earn?
Well, there is no limit on how much you can earn. Generally the money is way too low but t…

RESOLVING NETWORK ISSUES ON LINUX | LINUX SERIES

Dealing with networking issues can be a very challenging task. A packet sent from a client to a server (or vice versa) might be dropped in various locations and for various reasons. Some of the most common cases are -
1. A firewall that is blocking the packet. It can be a firewall on the server side, on the client side or any firewall along the way between the server and the client. The blocking may be based on an ip (source and/or destination), ports (in case of tcp/udp) or any other layer 3,4 criteria.

2. Lack of layer 2 connectivity.

3. Routing configurations that are not set properly.

Fortunately, Linux command line tools supply significant information that might help us narrow down the problem. From my experience those are my top 8 tools that will help you overcome networking issues.
 ping
This is the most fundamental command when troubleshooting a networking issue. The ping command will test the network connectivity between your host and the server. This is definitely the first comman…

Magic SysRq key | Linux Rescue | Frozen Linux | LINUX SERIES

The magic SysRq key is a key combination which allows the user to perform various low-level commands regardless of the system's state. If your Linux machine freezes or you want to reboot your Linux machine without corrupting the filesystem you can use this magic SysRq key combination. This key combination provides access to powerful features and thus needs some knowledge to use it. Please do not proceed without knowing about these combinations as you may put your system in a critical state. Please note that this magic SysRq key cannot work under certain conditions, such as a kernel panic or a hardware failure preventing the kernel from running properly.
Commads:The key combination consists of Alt+SysRq and another key, which controls the command issued. SysRq may be released before pressing the command key, as long as Alt remains held down.
These combinations always assume the QWERTY keyboard layout.
1. Immediately reboot the system, without unmounting or syncing filesystems - b 2. Perfor…