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

learn more… | top users | synonyms

2
votes
3answers
185 views

External authentication using Oracle Standard

I want to authenticate my client connections externally, using a custom external application. Is this possible using Oracle Standard 11g? If so, how? (our custom external application will not have ...
0
votes
1answer
144 views

Mysql can't write to filesystem

I need to output some queries as csv files. The directory is in the webroot and I want it to be writable by apache too, so I'm trying to add mysql to the www-data group (on Ubuntu). I thought this ...
1
vote
1answer
124 views

temp table (#sql-7a87_230c32.ibd along with its .frm) still exists on slave

I executed some alter statements on my master server, which have been successfully executed on master (now there is no temp table on master) and all alter also have been replicated on slave server ...
0
votes
0answers
33 views

compare time difference between current time with last data timestamp

I have a data server recording data every second. i need to setup a cron job that that runs a script that can give a reply if the now() is 24 hours more than the last data recorded. So that I can ...
0
votes
0answers
22 views

10.2.0.5 RAC instance running on Linux-64 recieved KEWRRFC: Remote Flush slave Failed, return code: 2

Last Friday one of two instances in our 10.2.0.5 RAC cluster was non-responsive after logging the following messages. We ended up rebooting the node and it came up successfully. While I will likely ...
0
votes
0answers
50 views

Mysql DB recovery

Mistakenly I have deleted "ibdata1" file in mysql server. Now my database is not working. All the tables are corrupted. But still I have "ib_logfile0" and "ib_logfile1" files.Also I have a recent ...
0
votes
1answer
73 views

How to call the unix Sendmail from oracle

I know that is possible to send mails using the oracle-db by UTL_SMTP, and there are several examples of such usage everywhere. My question is: Can I call the GNU/Unix/Linux Sendmail to perform a ...
0
votes
0answers
54 views

Mysql database recovery in linux

Is there anyway to get back database if I deleted database. Is mysql creates temp file which contain temporary data from database and whether I can recover from that Edited: cp my.cnf my.cnf41 mv ...
0
votes
0answers
72 views

MYSQL backup options using mysqldump and mysqlbackup

I'm currently using mysqldump to backup mysql database. I heard that mysqlbackup offers a much much better performance. Unfortunately it requires MySQL enterprise version which is pricy. A few ...
-1
votes
1answer
104 views

Mysql Queries cause high load in server

I have problem in the database ,here is phpmyadmin status queries --------------------+ ...
1
vote
1answer
852 views

MySQL Workbench Cannot start SSH tunnel manager

I don't know why this error is happening when I try to connect by MySQL Workbench. Cannot start SSH tunnel manager. I'm using slackware 14.1 and installed all dependencies. I already installed the ...
1
vote
0answers
269 views

PostgreSQL refuses to listen on IP [closed]

This was a case of PEBKAC. By default, the listen_addresses line in postgres.conf is commented out. I failed to notice this and remove the comment. I'm trying to get a PostgreSQL 9.3 server up and ...
0
votes
4answers
87 views

Move MySQL database to another server

I need to move 20 Gb MySQL database from on Debian server to another. The problem is that there is no way to create its backup since there are almost no free HDD space on the source server. What would ...
-1
votes
1answer
140 views

Lost connection to mysql?

We're receiving the following error on every 1 hour. Lost connection to MySQL server at 'reading initial communication packet', system error: 115 "Operation now in progress" Any clue ?
1
vote
3answers
191 views

MySQL: How to avoid case sensitivity in SQL queries when migrate from Windows to Linux?

I have migrated my Database from Windows to Linux server. In many places, query has been written without focusing their cases (uppercase / lowercase). So, these queries are not getting executed and ...
3
votes
1answer
312 views

high background flush avg mongodb

similar question: High Global Lock % on Mongodb Overview We have a production setup replica set in v2.4.8 mongodb running on five 4-core, 28gb RAM VMs with standard azure datadisk HDDs running on ...
1
vote
1answer
187 views

InnoDB engine is not loading after tuning parameters

After installing MySQL-5.1.73, I placed default my-huge.cnf into /etc/my.cnf and started the mysql service. It was running without any issue. Now, I tunned some parameters in /etc/my.cnf file. Below ...
0
votes
0answers
36 views

Switching from Windows to LINUX server with lower configuration

As of now, My application is running on dedicated windows DB server which configuration is below: RAM 8.00 GB Processor Intel(R) Xeon(R) CPU X5460 @3.16GHz, OS Windows Server ...
0
votes
1answer
199 views

Difference between [mysql] and [mysqld] in MySQL configuration file

There are multiple sections in MySQL configuration file: [mysql] [mysqld] [myisamchk] [mysqld_safe] [mysqlhotcopy] [mysqldump] [client] I found that same variables with different values have ...
0
votes
1answer
201 views

How to create and start a PDB for RCU in Oracle 12c

So I've made a fresh install on a virtual machine based on OEL 6.5 x64. All my installs are in /opt/apps I installed a Oracle Database 12c, with the Desktop Version selected (not server), UNICODE ...
1
vote
1answer
91 views

Mongodb replica sets: why does my master server occupy more disk space than my slave?

I have two servers on my replica set. Let's call it the master and the slave, for the purpose of this discussion. The master was the original one, and the slave was replicated from that master. At ...
1
vote
1answer
67 views

What does this mean - ~/.my.cnf

When I run $ mysqld --verbose --help | less I got information like Default options are read from the following files in the given order: /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf As per my ...
1
vote
1answer
20 views

Unable to start mysql

I am using Oracle LINUX5. I installed MySQL 5.1.73 community edition through RPM command and it was working. Now, I stop mysql by running below command: $ mysqladmin -u root -ptmpassword shutdown I ...
0
votes
1answer
272 views

Report Builder cannot publish to report server

This is currently in a cloud lab environment. We're not allowed to join any AD domains. We have a linux server (RHEL 6) running MySQL 5.3 and a Windows SQL Server 2012 on Win 2k8 R2. Our laptop is ...
0
votes
0answers
502 views

MySQL - Out of memory: Kill process 3046 (mysqld)

We run a MySQL (v5.6.17) dump backup every 4 hours, and today noticed: Apr 19 20:09:30 mysql1 kernel: Out of memory: Kill process 3046 (mysqld) score 970 or sacrifice child Apr 19 20:09:30 mysql1 ...
1
vote
1answer
382 views

MongoDB on Raspberry Pi --dbpath not setting

I installed MongoDB using this tutorial. I have tried to set --dbpath in /etc/mongodb.conf like this: dbpath=/path/that/iwant #where to log logpath=/var/log/mongodb/mongodb.log logappend=true ...
-2
votes
1answer
98 views

MySQL ran out of space, now won't start

So the partition MySQL was mounted on ran out of space. As a quick fix, I decided to move mysql's data directory to /home/minecraft/mysql/. I then changed the datadir in the config to the correcy ...
1
vote
4answers
1k views

PostgreSQL 9.3 on Ubuntu Server 12.04 v.s. MS SQL Server 2008 R2 on Windows 7 Ultima

I have searched many articles in Google about the performance of PostgreSQL vs MS SQL 2008 R2 and found that many of those articles say the performance of PostgreSQL is better than that of MSSQL 2008 ...
0
votes
1answer
618 views

Unable to Start PostgreSQL. kernel's SHMMAX parameter exceeded you limit

When I am trying to start my PostgreSQL I get the following error in the Postgresql.log file: FATAL: could not create shared memory segment: Invalid argument DETAIL: Failed system call was ...
1
vote
1answer
48 views

Which version of linux OS has support for MongoDB installation?

I would like to learn how to install MongoDB in my Windows machine. Currently I have a Windows 8 64 bit OS laptop and I installed MongoDB 64 version for Windows. My question is: which version of ...
0
votes
2answers
133 views

Make Oracle backup files available for duplicate

I have a Red Hat Enterprise Linux server with Oracle 10.2.0.5 and a database on it (SID is TNATEST). I have a remote CentOS server with Oracle 10.2.0.5 on it that I want to duplicate TNATEST to. The ...
0
votes
2answers
88 views

MySQL - prevent OS cache for query

On high load production server I have many sql selects which are unique or re-use will be in hours. I use SQL_NO_CACHE but this queries are still cached with OS cache. Server have 64G ram and used ram ...
0
votes
0answers
84 views

Can I set a lower_case_table_names value for a specific database?

I'm running a MySQL 5.5 on Linux (Debian 7) with several databases. I need to import a database originally maintained in Windows MySQL using sqldump. My issue is that this database is used by a ...
1
vote
2answers
391 views

Why Can't I find my databases from Mysql on linux?

I'm new to linux. I cannot get a list of my databases by typing SHOW DATABASES on the MySQL shell. Though this MySQL program is aware of the MySQL datadir because it is listed when I type SHOW ...
1
vote
1answer
377 views

Postgres memory usage too low

I have a 400GB Postgres 9.3.4 DB running on Fedora20, and a few indices per table. I have upped shared buffers to 4GB (the system has 16GB available), set shm in the kernel and set the ...
0
votes
1answer
380 views

Using environment variables in data pump query

I have been trying to use data pump (expdp and impdp) in order to retrieve some data from a database to import it into another. I am using the expdp using the table and the query parameters in order ...
0
votes
0answers
47 views

MySQL/MariaDB CLI limits max password?

I've got strange problem - my MariaDB instance CLI (Linux) does enforce limit on how long password can be. For example, setting password like this UPDATE mysql.user SET ...
0
votes
0answers
60 views

mysqlcheck -o --all-databases does not finish

I have a problem with my MySQL Databaseserver. I have many tables and there is quite some traffic going on there (around 4 connections per second). Since the phpMyAdmin advised me to do a OPTIMIZE ...
3
votes
2answers
735 views

Does a MyISAM table locks if I copy it while MySQL is running? (READ DISCLAIMER)

DISCLAIMER: I'm very aware this is not supposed to be done, but time consistency between tables aren't a concert here and Im trying whatever pops in my mind right now to have alternatives for ...
0
votes
2answers
138 views

Can CPU cores be separated for MySQL?

Is it possible to separate CPU cores in Mysql? I understand it is possible for Memory as we can tune it in innodb_buffer_pool_size or innodb_additional_mem_pool_size. How about CPU cores in ...
1
vote
2answers
428 views

Linux command to kill all MySQL sessions from a specific User?

How can i kill all sessions from a user in mysql using a linux command line command? I have a user that is using all on my database connections and insted of killing one by one i want to make a ...
2
votes
3answers
330 views

Move Complete ORACLE from one system to another

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. Entire ORACLE HOME ( bin , control files, data files everything on oracle) is on 2nd ...
0
votes
0answers
78 views

MariaDB : Larger innodb_buffer_pool_size causing SQL updates to be slower

Has anyone here encountered such scenario before where and update statement took longer time to run when innodb_buffer_pool_size is bigger. I've run a few tests using the same statements on around ...
0
votes
3answers
209 views

How to use Oracle Installation Prerequisites on Redhat Linux 6.5?

Today I get error below when install Oracle 11gR2 on Redhat Linux 6.5. I follow instruction in this link: http://public-yum.oracle.com/ After I call this command: # yum install ...
1
vote
1answer
257 views

Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux

I'm trying to create extension under postgresql 9.1 (Linux): CREATE EXTENSION pg_trgm; but got error: ERROR: could not open extension control file "/usr/share/pgsql/extension/pg_trgm.control": No ...
0
votes
1answer
215 views

I'm trying to run an oracle database in virtual box under oracle linux

I'm trying to run a oracle DB in VirtualBox and access it from my host mac OSX , i am using port forwarding to access my guest, I can telnet my guest on the port, however when i try to connect from ...
0
votes
2answers
73 views

MySQL: Moving Database from Windows to Linux

I have a Windows based dedicated server have below configuration: Windows edition: Windows Server 2008 R2 Standard Service Pack 1 Processor: Intel(R) Xeon(R) CPU X5460 @3.16GHZ 3.16 GHZ (2 ...
0
votes
0answers
119 views

Postgresql on Slackware 14.1 (64-bit) Cluster Error

I am attempting to install Postgresql Database on Slackware 14.1. However i am getting an error: Problem running post-install step. Installation may not complete correctly The database cluster ...
1
vote
1answer
129 views

Heartbeat Options with MySQL and Possibilities

I would like to understand if the following scenarios are possible in Heartbeat in Linux. Setup: Two Database Servers running Mysql in Active/Passive mode in replication mode having Heartbeat setup ...
0
votes
2answers
66 views

ORACLE Shifting from from one version to another

I have RHEL5 server with Oracle Home actual location is SAN, which is mounted on this server. Now for few Reasons I have one more Server with RHEL 6 64Bit. I will map those storage LUNS there. What ...