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

learn more… | top users | synonyms

0
votes
1answer
13 views

Getting error while running dbca command as oracle user on linux, please help me on this

could someone please help me on the below error to get ride of it: [oracle@localhost ~]$ dbca UnsatisfiedLinkError exception loading native library: njni11 java.lang.UnsatisfiedLinkError: ...
0
votes
1answer
33 views

MySQL: How to clean MySQL from RHEL5?

I have installed MySQL 5.1.73 community edition through RPM. It was working fine. I uninstalled this version by using yum remove mysql-server command. I wanted to upgrade MySQL from 5.1.73 to 5.6.19 ...
0
votes
1answer
46 views

Dedicated mysql server slow response

I have server in Kimsufi with 2gb RAM but my server is very slow , with simple hosting in ovh it responds quickly ... With pingdom.com test i have for server: 10 sec and simple hosting: 2sec is ...
0
votes
2answers
31 views

BASH: DBCA: command not found

When I use dbca command as Oracle 11g user I have the following error message: BASH: DBCA: command not found and when I checked the bash profile I found the following: # .bash_profile # Get ...
0
votes
1answer
25 views

MySQL 5.1: change datadir variable value in my.cnf

Below is my system configuration: OS: RHEL5 MySQL: 5.1.73 Default datadir=/var/lib/mysql/ But, the above directory has space crunch. So, I decided to change the path. I found /u000 directory has ...
0
votes
1answer
19 views

Unable to create Central Inventory

I am Traying to install Oracle 11g on my Linux a have alrady config the varible and X-host but can,t able to Create Central Inventory my Central Inventory location is : /u01/app/u0 ** and ...
1
vote
1answer
44 views

Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server

I installed 11g on Centos VM on my mac.I have everything up and working on server.I have included following command I ran on cenos. $lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production ...
0
votes
0answers
10 views

Can it Possible to do Mysql Active - Active Replication between Redaht linux 6.4X and Ubuntu 12X?

I have small doubt regarding Mysql Active-Active Replication. Can it Possible to do Mysql Master-Master (Active-Active) replication in Mysql between Redhat Linux and Ubuntu? Thanks & regards, ...
0
votes
1answer
45 views

Issue working with Postgres on Windows

I am running PostgreSQL 9.3 on my machine. I have PhpPgAdmin running on a cloud, using which I exported the database I am supposed to be working on, selecting "Structure and Data" and "Download". ...
1
vote
1answer
19 views

SQLite and Write Ahead Logging: why so large files

I have been doing some operations on SQLite databases recently. The other day I ran a command to DELETE a bunch of rows from a 1GB database file and the WAL file got over 8GBs at which point it ...
0
votes
1answer
28 views

SQL2542N - No match for a database image file was found based on the source database alias

I'm trying to restore a DB from a Linux system to a Windows. I'm working with DB2 9.7.7. I want to create a new DB with the restored DB. The DB file has this name: ...
1
vote
1answer
55 views

Master-Master Replication Duplicate Key

I have set two servers master-master replication mysql , i manage to set successfully but the problem is the duplicate key i got MASTER 1 Configuration /etc/my.cnf [mysqld] server-id=1 bind-address ...
2
votes
3answers
116 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
36 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
37 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
25 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
19 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
26 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
39 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
1answer
29 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
31 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
41 views

Mysql Queries cause high load in server

I have problem in the database ,here is phpmyadmin status queries --------------------+ ...
1
vote
1answer
264 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
72 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
71 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
35 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
2answers
52 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 ...
2
votes
1answer
84 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
80 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
24 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
48 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
87 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
38 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
47 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
18 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
61 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
78 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 ...
0
votes
1answer
127 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
54 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 ...
0
votes
4answers
552 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
202 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
24 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
1answer
76 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
1answer
52 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
38 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
105 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 ...
0
votes
1answer
127 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
129 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
26 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
31 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 ...