A widely-used open-source operating system that is particularly popular on servers.

learn more… | top users | synonyms

2
votes
1answer
10 views

Oracle 11g Administration Tools

i'm recently install oracle 11g XE in linux mint using this guide: https://mikesmithers.wordpress.com/2011/11/26/installing-oracle-11gxe-on-mint-and-ubuntu/ (doing all it's works, and yeah i know why ...
0
votes
0answers
10 views

Install oracle 12c database preinstallation RPM without yum

Question: Is it possible to install oracle 12c database pre-installation without yum? If so how? What I have found on the internet is to use yum, I cannot use yum because the proxy just does not ...
2
votes
1answer
45 views

CRON and RMAN Backups

We run RMAN backups via CRON jobs, but find the out-of-the-box emails with CRON to almost do what we want. I know we can channel the RMAN output to /dev/null so no email is sent, which for any ...
2
votes
3answers
64 views

using tnsnames.ora and sqlplus client without installing oracle 11g server on linux client [closed]

I want to create a connection to remote Oracle server using SQLplus client and tnsnames.ora without installing Oracle 11g server on the Linux client. I used debian and bash script to generate reports ...
0
votes
0answers
19 views

network Adapter could not establish the connection in netbeans with oracle11g in linux

I am using fedora 23 64 bit. My system is up to date. I have installed oracle 11g xe. I have downloaded the jdbc driver 'ojdbc6" , now i am trying to connect netbeans with the oracle database but it ...
0
votes
1answer
39 views

Upgrading to MySQL 5.5 from 5.0 looks broken

I was using SLES SP3, and had earlier MySQL 5.0.67. I upgraded it to 5.5.48 (available with the CD) after upgrading my OS to SP4. I edited the /etc/my.cnf file, and replaced skip-locking to ...
0
votes
0answers
7 views

Is it advisable to configure huge pages on SLES for MySQL

What is a general opinion on using huge pages with MySQL server? As described in here: https://dev.mysql.com/doc/refman/5.7/en/large-page-support.html Or is it best to leave things as is and not ...
1
vote
3answers
38 views

Any script to auto test tune and benchmark mysql config?

I'm looking or willing to do a script to benchmark mysql config variations for a specific system. A script that would change certain mysql config values and do a sysbench, save results, change ...
0
votes
2answers
69 views

Error during Oracle database 12c Release 1 installation

I am trying to install Oracle database 12c on Oracle Linux 7 version. But it is keep on failing with the below error. [INS-30131] Initial setup required for the execution of installer validations ...
0
votes
0answers
44 views

mysqldbcompare SELECT command denied to user

I am trying to run mysqldbcompare to see the difference between two tables: mysqldbcompare --server1=server1:2016@localhost --server2=server2:2016@localhost user:user --difftype=sql --run-all-tests ...
0
votes
0answers
36 views

connecting to MySQL Database on local network

I'm trying to connect to my SQL database on my beagle bone black (Debian 3.8.13 MySQL version: 5.5.47) from my raspberry pi (Debian Jessie 4.1.13 MySQL version: 5.5.44). Both are on the same local ...
1
vote
1answer
25 views

Is there anyway that I can manually create a PID for the MySQL instance?

I am running MySQL on a linux server. I have taken a copy-back mysql enterprise backup from another linux full backup. Ever sense then I have had problems getting MySQL to start. The problem is ...
0
votes
0answers
29 views

myisamchk: Why is there a huge time difference running myisamchk in real and user time?

We have some MySQL MyISAM databases, whose backups are taken using mysqlhotcopy Thought to check the backups integrity, and errors (if any) and hence run myisamchk. I was tracking the possible ...
0
votes
1answer
159 views

missing files, installing Oracle DB 12c on Oracle Linux 7.2

when I try to Install the Database I get this error message: Source location is incomplete. Make sure you have downloaded and extracted all the relevant archives. I did try this twice with the same ...
1
vote
2answers
52 views

scaling options for mysql on linux vm (ubuntu) : how to scale when the RAID 0 is out of space

I was asked to give a scaling road map for our mysql database. Currently, I have a single mysql instance v5.6.28 running on an ubuntu VM on azure. It has a (software) RAID 0 disk made with two 1TBs. ...
0
votes
0answers
16 views

MongoDB job on CentOS 7 has file permission errors

I have a CentOS 7 server and I've been trying to start using MongoDB. At some point, I changed group & file permissions for the following: /var/lib/mongo /var/run/mongodb /var/log/mongodb What ...
0
votes
2answers
41 views

How to get when MySQL instance went down last

Is it possible to determine when a MySQL instance went down last? Is there a log file or literally anything at all that logs the server status in MySQL? I have trolled through countless articles ...
3
votes
1answer
29 views

how to “revoke” a “GRANT OPTION” from an mysql user/database?

i have a mysql installation with lots of users and grants. But one grant is unique, since its supposed to be a simple DB user and usually does not need GRANT privileges. However someone added it when ...
1
vote
2answers
45 views

How to log MySQL downtime

If I wanted to see the date, time and length of downtime on a MySQL instance/database, how would I go about doing that? For example, if I wanted to see if the MySQL database went down at all last ...
1
vote
1answer
13 views

Is there a limit to the number of database connections from a single machine in PostgreSQL?

We are planning on setting up multiple front ends behind a load balancer. I think our database can handle the load because I'm currently measuring a database TPS of about 450 for approximately ...
0
votes
0answers
71 views

MySQL Too Many Connections (Max Connections Limit Not Reached)

Running a PHP 5.6 application that connects via MySQLi to a MySQL database (5.5) that intermittently errors with the "Too many connections error" however this seems to be a red herring to another ...
1
vote
2answers
204 views

How to run Mongodb as a non root user in Linux?

I can start MongoDB as $sudo service mongod start. When I start without sudo it gives me this error: /etc/init.d/mongod: line 58: ulimit: open files: cannot modify limit: Operation not permitted ...
0
votes
0answers
28 views

Resetting deadlock count statistics

It seems that just restarting the PostgreSQL service doesn't clear / reset the detected deadlock count. How can it be restarted to zero? select version(); PostgreSQL 9.4.5 on ...
1
vote
0answers
76 views

Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error

Error creating SQL Model Connection connection to TSMDB1. (Error: [jcc][t4][2010][11246][3.68.61] Connection authorization failure occurred. Reason: Local security service non-retryable error. ...
1
vote
1answer
63 views

Is there any trick to Resize LVM online that raw by UDEV rule without filesystem?

Here is the Logic Volume for example: lvcreate -L2G -n Lv_OraD1 vg_db lvcreate -L180G -n Lv_OraD2 vg_db lvdisplay /dev/mapper/Lv_OraD* UDEV rule to raw the LV: vi ...
1
vote
2answers
21 views

MySQL server feature gap on Windows and Linux

Is there any gap or difference in features of MySQL Server on Windows and Linux? Feature refers to below aspects: common DBMS functionalities such as Stored Procedures, Updateable Views, ...
0
votes
2answers
106 views

mysql too many connections in linux/nginx/php-fpm/php server

One of my mysql client reports "too many connections" of the mysql server. With the processlist of the mysql server, I find many connections come from a client with LNMP(linux nginx mysql php). The ...
1
vote
1answer
38 views

lat, long based search with $near shutdown my mongodb on Linux server

Hey guys i am stuck on critical problem & unable to resolve it. I have a project where there is a collection of UK postcodes having 18,00,000 sample postcode records. I have a search query where i ...
0
votes
1answer
32 views

Possible aproach for MySQL replication

This might be a duplicate questions asked before. But I need to understand a possible approach for my ENV running innodb engine. Is it possible to upgrade a Master MySQL Server to 5.5 to 5.6 and ...
0
votes
0answers
79 views

From RAC to Standby RAC With Active Dataguard

I have oracle database 11.2.0.3 with RAC feature , with 2 node on oracle linux 6.4 : ol6-112-rac1 and ol6-112-rac2 I want to create active data guard with RAC feature from this database , these ...
-1
votes
1answer
99 views

mongodb not working after install

I followed these steps at http://www.liquidweb.com/kb/how-to-install-mongodb-on-ubuntu-14-04/ as I usually do, since everyone on ubuntu knows the mongo docs don't work. I'm actually on kubuntu 15 I ...
0
votes
1answer
51 views

Reject Specific Database PostgreSQL User Authentication [closed]

Lets say I have two databases: Sales and Inventory And two users: A and B I want user A to be able to do: psql sales B But user A must not be able to do: psql inventory B Right now user A can ...
0
votes
0answers
51 views

oracle update statement is too slow

I have oracle database 11.2.0.4 on oracle linux 6.4 I have configure huge page on this OS . After 5 months of my projects , when i want to update any tables their have over 20,000,000 records , this ...
0
votes
2answers
67 views

ulimit 'open files' and MySQL max_connection

When running mysql on SSD, does max_connections, if set more than the kernel's ulimit open files, be limited to the kernel's limit? My understanding is that if the kernel's ulimit open files is 1024 ...
0
votes
0answers
47 views

Replication Error_code: 1032

I an unable to fix this as I don't know what cause this error. Replication was stoped for maintenance activity and after completing the maintenance we started it and then after some point the ...
0
votes
1answer
292 views

Slave not getting replicated SERVER_UUID error

Unable to start replication Master-Slave, I have searched a lot for this but unable to get the Server-UUID of both the server. Do we have any solution for this. Scenario: I have created new slave ...
0
votes
3answers
173 views

Error while installing MySQL on RedHat Linux

I am new to RedHat Linux and am referring to this link for the installation :https://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html I finished the first two steps and ...
0
votes
0answers
48 views

Mysql Replication break Error_code: 1032

Created new slave replication, it was working fine but suddenly after 2 days its giving me this error and the replication stopped. Both on Centos 6.7 Master Version ...
0
votes
1answer
93 views

MySQL Tuning and optimization

How to Tune and Optimize MySQL Database, as a reference we are using mysqltuner.pl and we got the below output of slave host which we created recently. our future plan is the perform this same action ...
2
votes
1answer
28 views

Search and Replace in multiple MySQL databases

I have multiple MySQL databases(50+) and I want to replace a string in all of them, is there anyway to search and replace in all the databases? Server is CentOS and I have SSH root access.
0
votes
2answers
839 views

Setting root password in fresh mysql 5.7 installation

I am trying to install mysql in a serving having CentOS Linux release 7.2.1511. Take a look to the process installation: # sudo yum install mysql-server Output: Dependencies Resolved ...
1
vote
1answer
203 views

Slave Waiting to reconnect

I have added new slave host to master for replication, but missing some of the parameters. mysql> show slave status\G *************************** 1. row *************************** ...
0
votes
0answers
30 views

MySQL replication Got fatal error 1236

I am getting this error when starting a new slave replication from master. Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded ...
0
votes
1answer
23 views

Mysql Replication backup and restoration failed multipal time

I tried restoring MySQL backup several time but unfortunately it gets failed by some or the new reason. I have 2 host Master & Slave with below details. Server1_Master os-centos6.7 mysql- ...
0
votes
2answers
94 views

unable to connect to oracle in linux terminal in oracle VM ,TNS listner not connected

i installed oracle VM , new to oracle vm. Can some help me in connecting to oracle in Linux termial and TNS listner is not responding with IO failure on sql developer when pressing test button ...
0
votes
1answer
86 views

Restoring MySQL dump ERROR 1449

I took hot backup (dump) from my Master MySQL DB with below command mysqldump -uroot -p --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=2 -A > ~/dump.sql ...
0
votes
0answers
53 views

MySQL performance issue after migration

I have a MySQL performance issue with a brand new server, and am somewhat of a beginner as a database administrator (I'm mostly a general-purpose Linux sysadmin). I'm looking for pointers where to ...
3
votes
0answers
32 views

Bandwidth-efficient, fail-safe database resync with long backlogs

I'm looking for a DB system that allows slaves to resync even if there exists a long backlog. In addition these resyncs must be as bandwidth-efficent as possible as the nodes are connected over ...
2
votes
2answers
272 views

Filesystem tuning for PostgreSQL

I want to install PostgreSQL 9.x version in an Ubuntu 14.04 workstation and I'm looking for a recommendation on how to set it up in order to get a good read-write (50/50-balance) performance keep a ...
1
vote
0answers
46 views

mysql innodb - strange data loss

I am running a mysql database on linux with several InnoDB tables. At some point, the ibdata1 file got quite big and I wanted to delete it. So I made a dump, deleted the file and restarted the server. ...