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

learn more… | top users | synonyms

2
votes
1answer
29 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
2k 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
373 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
64 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
24 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
116 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
118 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
65 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
33 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 GSM/...
2
votes
2answers
466 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
49 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. ...
0
votes
2answers
47 views

MySQL Database Dump To Project Folder [duplicate]

Currently I am dumping my database (running under Linux Mint), from the command line, using the following:- mysqldump -u[user] -p[password] MyDatabase > MyDatabase.sql Now rather than dumping to ...
3
votes
2answers
43 views

Restore PostgreSQL database (or db names) to new version, from files?

Scenario in short: a development laptop broke old HDD is still readable new laptop has PostgreSQL 9.4 instead of 9.1 both laptops use a flavor of Ubuntu Linux Question 1: Is my understanding ...
2
votes
3answers
559 views

How to identify how many instances of Oracle are installed on Linux environment

Last day, I was at one training for Oracle installation and service start & shutdown. There I came to know about some Linux commands to start and shutdown an Oracle instance on a Linux machine. ...
0
votes
3answers
479 views

lsnrctl is not working on Ubuntu 14.04

I have managed to install Oracle 11g on Ubuntu 14.04 through lots of pain. I managed to install it in the end but listener does not seem to be working and even responding any command. My /home/...
0
votes
0answers
12 views

Mtop - How to reset ID numbers?

Using Mtop for slow queries logging in our InnoDB. Since there is actually high database usage, the log IDs in front when using the mtop command are increasing rapidly and I would like to reset them, ...
0
votes
0answers
40 views

One Listener for two Oracle Versions

I've got an dev machine with Oracle 10 and 11 running (on separate users) So I want to use only one Listener (the new from 11). I deleted the Listener of Oracle10 and created one on Oracle11. After ...
2
votes
1answer
67 views

how many cores uses gbak (firebird) on restoring?

I'm restoring db, and I see that firebird uses only one core of my CPU for gbak and fb_smb_server: Is it normally? I've 4 cores in my CPU. CpuAffinityMask parameter in firebird.conf is commented out....
0
votes
0answers
30 views

Auto Insert new entry's in different database

I have 2 websites with similar MySQL database and both on same server (Linux) When a user register on website A I want to copy the user data to website B database (adb.users to bdb.users). Is there a ...
0
votes
1answer
485 views

Why does Oracle Database Configuration failed on ubuntu?

I'm trying to install Oracle Database 11g Express Edition on my ubuntu server. After running command: sudo service oracle-xe start I get following result after configuration: Starting Oracle Net ...
0
votes
1answer
152 views

Size of Binary log file in Mysql Replication

I have a master - server replication setup in Linux servers. Master Configuration details : MySQL version is 5.1 and replication mode is MIXED type. Slave Configuration details : MySQL version ...
0
votes
1answer
111 views

RHEL Postgresql 9.4 and PostGIS

I'm a dba new to postgresql. I have Linux RedHat 7 without openshift. I have to install some DB on 9.4 version with postgis. My sysadmin has published the following repositories : RHEL 7 server ...
0
votes
0answers
56 views

What the exact different between Oracle Fusion Middleware and alternative (Non -Fusion)?

I have properly working CentOS release 6.7 (Final) and I have installed Oracle Database 11g Express Edition, Oracle SQL Developer (Working properly). Now I want to install Oracle Forms and Reports ...
0
votes
2answers
190 views

mysql using 100% cpu on one core

I have a mysql 5.1.61 on a Linux Production server with kernel 2.6.32-131.0.15.el6.x86_64 having 2 CPU. However i find that a single select query makes the cpu go 100% on only one core. Eg of select ...
0
votes
1answer
60 views

Oracle 11g: SQLDeveloper

How would I use the pre-installed SQLDeveloper that comes packaged within Oracle 11g if I am invoking it with a user that has no oracle or admin rights on linux? Would it be enough just to change ...
1
vote
1answer
53 views

Is MongoDB Connections getting too high?

I currently have my MongoDB running in Production Environment. It has 1 Primary, 1 secondary and an Arbiter. Configuration of the ubuntu machines are pretty decent, it's got 56GB of RAM and about ...
0
votes
1answer
617 views

ERROR 2026 (HY000): SSL connection error: Unable to get private key

I need help with mysql replication with ssl. I got a problem when i'm turn on ssl on my slave - error connecting to master 'replica@1.2.3.4:3306' - retry-time: 60 retries: 1 Here is my setup Master ...
0
votes
0answers
63 views

Error Code: 1146. Table 'mysql.slave_relay_log_info' doesn't exist MySQL 5.7.9

I'm trying to do a multi source replication using MySQL 5.7.9, my main server is Windows Server 2012 and 2 other servers using Oracle Linux 7.1 My problem is that I have to enable TABLE for the ...
0
votes
1answer
274 views

what is oracle shiphome?

I am trying to install oracle grid, One of the Oracle installation steps says, set the variable ORA_SHIPS to the path location where you are going to extract the 11.2.0.4 shiphomes Please ...
0
votes
1answer
27 views

Scenario/Method (idea) for transfering database from one server to another

The scenario is next. Every day on linux mysql server script copy from samba share wich is "/var/lib/mysql/db2223" to another backup server over network lets say windows server. Database has lets say ...
0
votes
1answer
801 views

Oracle 12c Installation (Grid) on RHEL 7.1 CLSRSC-214: Failed to start 'ohasd' [duplicate]

root.sh script execution failing with following error please advice ./root.sh Performing root user operation for Oracle 12c The following environment variables are set as: ORACLE_OWNER= grid ...
1
vote
2answers
1k views

Problem Installing 11.2.0 on RHEL 7 64 Bit

I have problem in stalling Oracle ASM on RHEL 7, Please advice [root@localhost grid]# ./root.sh Performing root user operation for Oracle 11g The following environment variables are set as: ...
0
votes
1answer
24 views

MySQL Linux and Windows entity changes [closed]

I have a trigger on an entity that copies the row and saves it in a different entity. I also have 2 MySQL servers one on Linux and the other on Windows. It seems the order of the columns in the same ...
0
votes
0answers
37 views

Rule of Thumb on OS Free Space

This may be a difficult question to answer, but I have a PostgreSQL database running on a Linux server with 1.3 TB of storage. I'm currently at 73% utilization of storage space with a slow but steady ...
1
vote
0answers
98 views

Connecting to MS SQL server from a Linux box

I am trying to connect to MS SQLServer from an application that I have written (using Qt) which runs on Linux. Here are some details of the setup: The SQLServer box (SQLBox) is part of my domain (...
0
votes
1answer
34 views

MySQL Database Replication in Fedora 21

I have a MySQL 5.6 Community Edition server running on a machine with Fedora 21 which was installed via the YUM repository. I want to enable MySQL replication on the Server, but since I am limited to ...
0
votes
1answer
88 views

cannot repair database in mongodb

I accidentally deleted 2 data (mydb.47, mydb.62) files from my /data/db of my mongodb. I have rest of the files in place... Now my mongodb won't start up..I tried repairing it using this command ...
0
votes
1answer
115 views

SQLAnywhere : Installation PHP extension - variable LD_LIBRARY_PATH not detected by extension

I'm trying to install the SQLAnywhere php extension to connect my website on a distant Sybase database. But I can't declare the LD_LIBRARY_PATH variable which isn't detected by the extension. A ...
2
votes
0answers
128 views

How to start MySQL after the year 2038?

I am using MySQL 5.5. For some reason, I need to change the date of my system to after 2038. Unfortunately, the MySQL service won't start after the year 2038: root@sd-84962:~# date Sat Sep 24 18:41:...
1
vote
1answer
71 views

Optimize slow query

I have this query that takes over half an hour to run on our Linux MySQL db... SELECT ls.emailaddress , lse.subscriberid , lse.eventtype , count(lse.eventtype) as total FROM ...
6
votes
1answer
1k views

Skip multiple rules during SQL Server installation

I want to install SQL Server 2008, but I get 2 errors which prevent me from going forward. I know from this post how to skip one rule. Is there a method to skip both? I am using Wine (PayOnLinux) on ...
1
vote
1answer
178 views

Cannot read from /tmp with PostgreSQL COPY, but able to read the same file from another directory with the exact same permissions

I have a file /tmp/foo.csv that looks like this: 1,2 10,20 100,200 I have the same exact file in another directory /mydata/foo.csv. Both directories and files have the same exact permissions, owner,...
0
votes
0answers
128 views

Discard tablespace of temporary innodb table in MySQL

I have following problem, i need to discard tablespace of temporary table(file is present, i want to delete this file too) or somehow completely remove this table. This table can't be shown with ...
0
votes
1answer
432 views

mongod 2.6 corruption (Assertion failure isOk() src/mongo/db/storage/extent.h 80)

I have been using mongo 2.6.0 for some time on 64-bit centos (with journaling enabled). One fine day when we were testing to insert a document to one of the collections, we started seeing data ...
0
votes
2answers
862 views

bash: sqlplus: command not found

I have installed oracle correctly and also set ORACLE_HOME correctly on server,still sqlplus command is not working in my PC while it is working in others PC. I think I missed out some important step ...
2
votes
1answer
63 views

MySQL connection process slow for non-root user

I'm using Percona server 5.6 on Linux. When I connect to MySQL from the command line as the root user, it connects immediately. I have also created a new user in the database, but when I try to ...
1
vote
1answer
92 views

Monitor disk usage with MongoDB Ops Manager

We use MongoDB Ops Manager 1.6.2.251. I searched Activity -> Alert Settings. Is there a way to monitor disk usage? To get an alert if this changes to 90%: # df -h /data/ Filesystem ...
0
votes
0answers
22 views

Create db2 alert for automatic failover

We have two servers in automated failover HADR (TSA installed and haicu configured). How can we create an alert that fires when a failover happens i.e. when the primary server goes down and the ...
3
votes
1answer
175 views

Any risks in updating the system time on a mysql 5.5 server?

We just discovered one of our mysql systems has not been running ntp, with the result that the time has drifted a bit. If I enable ntp, and synchronize the time while the system is running are ...
0
votes
0answers
108 views

Fetching the data from the Oracle database is slow in Linux as compared to Windows

I am facing a performance issue in Linux while fetching data from the Oracle database. My scenario is as follows: 1) I have the backend server which is on UNIX with Oracle database running . The ...