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

learn more… | top users | synonyms

2
votes
2answers
351 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
48 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
41 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
452 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
399 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
11 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
38 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
59 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
432 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
132 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
91 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
50 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
169 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
52 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
525 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
57 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
245 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
687 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
889 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
23 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
36 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
92 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
80 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
99 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
115 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
70 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
985 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
154 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
125 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
378 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
692 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
83 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
161 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
99 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 ...
3
votes
1answer
231 views

How can filesystem storage (for blobs, images, etc.) be integrated with (traditional) database storage (e.g. MySQL/Postgres)?

If I use my database for relational data and opt to store large binary blobs in the filesystem, how can I integrate the two? How does this process work? I know that the database will need to store a ...
1
vote
0answers
24 views

MaxDB - Strange behaviour when selecting from a CLOB-Row

I am using "sqlcli" for Linux to write the output of the following query into a file: select clob_field from table (...) in SAPGui (original user input) the contents are displayed as: First ...
2
votes
2answers
317 views

Oracle Database 12c: TNS:permission Denied (CentOS)

(This post has a similar title to another post but the underlying cause and solution are totally different.) Problem: I can't login to sqlplus as sysdba but the listener seems to start [John@...
1
vote
1answer
188 views

Read insert statements from text file

Good day All, I have a 1000 text files that each contain 1000 insert into statements. What is the most efficient way to read and execute each insert statement into a MySQL DB table? Thanks for any ...
0
votes
0answers
21 views

Need to Sync Oracle DB table data with mysql [duplicate]

I have a table with some data in oracle which i want to sync with mysql table once in a day, like a cron job. Is there any tool available which i can use as a cron job in Linux?. Thanks,
0
votes
0answers
76 views

Error while deleting a foreign key

I can't delete foreign key in MySQL, I get this error message: ERROR 1025 (HY000): Error on rename of './database/table_name' to './hp/#sql2-4b1-26' (errno: 152) My system is Ubuntu 14.4 lts
1
vote
1answer
35 views

How to detect MySQL slave writes?

In a MySQL master-slave replication architecture, how do you detect if there have been (erroneously, since this should never happen!) direct writes on the slave? For now, I'm running this command on ...
1
vote
2answers
1k views

ORACLE_HOME / ORACLE_SID variable - why do we need to export them ?

I am not sure if this is a bash / shell question or oracle question. I am on linux and oracle 11g. I have always export my ORACLE_HOME and ORACLE_SID variable and e.g. using invoking sqlplus is no ...
0
votes
0answers
108 views

How to generate “Too many connections” error using mysql cli over ssh

I have a script which queries for blocks of data, one after another, from a remote MySQL database via ssh and mysql cli and pipes the result output to stdin of a local executable. Loosely scripted, ...