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

learn more… | top users | synonyms

0
votes
1answer
10 views

How do i prevent executing os command in oracle 11g

I have Oracle 11g installed on a linux serveur and i'm looking for a way to prevent sysdba from executing system command through oracle(Using java for example).
0
votes
1answer
18 views

How to fix “TNS:listener does not currently know of SID given in connect descriptor” with DBVisualizer on Linux?

I am trying to connect with Oracle database from a server having Oracle client installed (RHEL Linux Environment). I installed DB Visualizer on client machine. But getting listner error on hitting ...
0
votes
1answer
13 views

Will 'sleeping' connections open files other than the socket in MySQL?

Recently, in our MySQL replication setup, the replication slave crashed due to 'too many open files' error. We brought it backup, but trying to figure out what caused the unexpected hike in the number ...
2
votes
1answer
46 views

Problems restoring backup from base backup + WAL with WAL-E

I'm trying to do nightly restores of the main database on a separate node. I want to do weekly full restores and nightly restores by consuming the latest WAL files. On the master I have wal_level = ...
0
votes
1answer
13 views

Setting MySQLDump to keep running in the background after session times out

I'm tryng to set up a new Slave DB by copying another Slave DB. Normally I would simply use MySQLDump to dump the Slave and create a .sql file, then import that into the new database. However, as our ...
0
votes
1answer
26 views

MySQL does not generating PID file

I upgraded my OS from redhat 2.6.3 to 2.6.5 after that when I restarted my MySQL server but it not started, error message is "150320 11:53:17 [ERROR] Error message file ...
0
votes
1answer
20 views

What limits the number of connections?

As per https://devcenter.heroku.com/articles/heroku-postgres-legacy-plans the connection limit is 500 As per https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server "Generally, PostgreSQL on ...
0
votes
1answer
26 views

Server has antivirus. Do I need to enable external locking on MySQL?

From MySQL docs: If you only read tables with other programs, external locking is not required Assuming the bytes of MySQL files does not match viruses, the antivirus will not change the ...
0
votes
1answer
16 views

In mongodb, is “sh.getBalancerState() is false” the same as “sh.isBanlancerRunning is false”?

During upgrading config servers to use WiredTIger, I stopped balancer using sh.setBalancerState(false), and then I run sh.getBalancerState(). The output is false. Does this mean the balancer is not ...
0
votes
2answers
25 views

MongoDb Upgrade from 2.6 to 3.0 Issue [closed]

For some reasons I cannot install MongoDb 3.0 version. What am I missing?
-2
votes
1answer
51 views

any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server [closed]

i am planning to decide to use mysql5.6 on a window server 2012 or a linux server. Can someone gives me some general advises between the two?
0
votes
0answers
16 views

Index creation issue with MySql and Linux

MySQL Server database is installed on RHEL5.5 and db version is 5.6.20 Community Server. In MySQL database we have a table and it has 11,144 records. I am altering the table and adding index to it. ...
0
votes
0answers
40 views

upgrading posgresql 9.0 to 9.4 with pg_upgrade on CentOS 6.6

I'm trying to upgrade a postgres v9.0 database to v9.4 with pg_upgrade on CentOS 6.6, but I keep hitting a wall. I am calling pg_upgrade thru a shell script as postgres, first exporting the needed ...
0
votes
0answers
31 views

PgBouncer optimal settings for a high OLTP workload [on hold]

Hope you are all well. I am trying to figure out how to best optimize our pgbouncer settings. I need to be able to set it so as to allow quick disconnects after a transaction finishes. Whats ocurring ...
0
votes
0answers
26 views

Please help: kerberos authentication setup on postgresql

Requirement: Backend working with RHEL and postgresql and front-end working with windows,.net. please consider how the authentication method must be done. our main idea will be to have the ...
0
votes
2answers
25 views

mysql does not start: error 13 on bin file (permissions are set correctly)

I just renamed the hostname and rebooted the server and now mysql 5.6 wont start. (debian 7 + dotdeb) 150312 20:40:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql.mnt ...
1
vote
1answer
11 views

Requests to local CouchDB have 40ms latency

Requests to a CouchDB instance on the same machine have about 40ms latency when HTTP keepalive is used by the client, about 0-1ms latency when the client does not use keepalive. What causes this ...
0
votes
0answers
9 views

Getting warning ignoring option '--databases' due to invalid value 'testdatabase' in mysql while importing data

i am getting warning ignoring option '--databases' due to invalid value 'testdatabase' in mysql while importing sql data into a database.Its working fine when I do it on my local machine but same is ...
0
votes
1answer
17 views

Mongodb: Couldn't find mech GSSAPI

I am trying to understand how mongodb works with kerberos. To do that I have configured a kerberos server, just only for local. This is the configuration of my realm: this is the content of krb5.conf ...
0
votes
1answer
50 views

ORA-04031: unable to allocate 32 bytes of shared memory

I want to flush shared pool because of error like ORA-04031: unable to allocate 32 bytes of shared memory So I want to flush shared pool using alter system flush shared_pool; Connected as ...
1
vote
1answer
72 views

How much memory are used by perticular session during run time in MySQL 5.1 community version? [closed]

Is it possible to find out how much memory is used by particular session?A user was asked me how much memory is utilized by particular session running in MySQLl 5.1 community version server. Kindly ...
2
votes
0answers
29 views

How to reinstall a legacy DB2 Server 7.x for Linux?

We have to move our legacy database dump to a new Linux installation. I know DB2 7.x is out of support for over a decade, but is there a way to obtain a DB2 7.x Server installation media for Linux? ...
1
vote
0answers
29 views

Pass a URI as a pgAdmin parameter

I can connect to Heroku with psql passing a URI: $ psql postgres://user:password@ec2-54-243-xxx-xxx.compute-1.amazonaws.com:5432/d7xkxididkdi I want to do the same with pgAdmin: $ pgadmin3 -qc ...
0
votes
0answers
8 views

Metadata database on top of flat files

I have a bunch (millions) of flat files. I do sort them into subdirectories, but that doesn't really help searches. Is there some database software that could be fed metadata information and would ...
0
votes
0answers
26 views

Install specific older version of postgresql centos

I need to rebuild a production system with same version of installed packages. It's a Centos 5.11 and it was using this repo http://yum.pgsqlrpms.org/reporpms/8.3/pgdg-centos-8.3-6.noarch.rpm to ...
0
votes
0answers
122 views

MySQL workbench: Cannot Connect to Database Server (ssh)

General pointers would be appreciated -- it's likely I'm misunderstanding the mechanisms involved in a remote connection through ssh. I can use ssh to connect remotely, and then, through the CLI, ...
0
votes
1answer
12 views

Check mysql domain that is using resources

I have a webserver hosting about 300 websites and sometimes my CPU usage gets close to 100% and when I use "top" in my CENTOS to check who is using all CPU, I discover it's mysql. I would like then to ...
1
vote
1answer
47 views

Can I reduce MySQL memory usage, or do I need to add more RAM?

I have a VPS with 2.25GB of RAM. MySQL is using 1.4GB with only four users on my site right now. It seems to use this amount even when no users are online. The available memory of my server regularly ...
0
votes
0answers
22 views

password based ssh authentication with MySQL Workbench

I know that it's possible to configure SSH to use keys only, and to disable password based authentication. That being said, can I do the following from MySQL Workbench? I've tried more than a few ...
1
vote
1answer
57 views

ONLINE BACKUP is not performed from the CRON Job on LINUX server (manually it works)

I made a script which executes successfully online backup when it is run manually by the instance owner. Script is the following (two lines originally). #!/bin/bash /opt/ibm/db2/V9.7/bin/db2 ...
0
votes
1answer
72 views

Spool in Shell script not working for me

#!/bin/sh echo "Started at" `date +%Y/%m/%d" "%H:%M:%S` sqlplus -s ${ORA_LOGIN_SYSADM} <<EOF 2>&1 > /dev/null SET SERVEROUTPUT ON SET FEED OFF spool ech.txt create BEGIN ...
1
vote
1answer
70 views

How to start Sybase server

I have installed Sybase(Developer's Edition for ASE 16.0) on a linux machine. I have executed the setup.bin file, and installed it using GUI. After this, I tried connecting to the localhost server, by ...
4
votes
2answers
250 views

TNS-12541 Error

I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check ...
0
votes
1answer
194 views

How to set ADR Base directory correctly on OracleDB on Linux?

Installed Oracle Database on Linux based OS. Listener is ok. But Oracle is not. (I changed all angular brackets to vertical, because parser not shows angular brackets) ORA-48108: invalid value ...
0
votes
1answer
101 views

Cannot start MySQL service on linux RHEL when pointing datadir to mounted ecryptfs folder

I moved the data directory for MySQL to an ecryptfs encrypted folder. When I run service mysqld start as root, the service will not start. [Warning] Can't create test file ...
0
votes
2answers
556 views

mysql.sock not found on CentOS 7 machine

I am getting the following error when I try to log into mysql from the CentOS 7 terminal of the machine where mysql is installed: ERROR 2002 (HY000): Can't connect to local MySQL server through ...
0
votes
0answers
53 views

MongoDB mongoexport $or query returns zero records

I have the following cmd in bash termial mongoexport --db fscrap --collection Wall -q "{\$or : [{'insert_time' : {\$gte : new Date(1393624800000)} },{'comments.comment_time' : {\$gte : new ...
1
vote
3answers
99 views

Linux kernel parameters for oracle

I wonder what are the optimal Linux kernel parameters for oracle 11g db on 64-bit system. I didn't find any detailed, good or full recommendations or best practices for this issue. Just found one ...
1
vote
1answer
98 views

remove password requirement for user postgres

I understand that, upon installation, PostgreSQL has no password for its db root user (postgres): postgres=# select usename, passwd is null from pg_shadow; usename | ?column? ----------+---------- ...
0
votes
1answer
65 views

Similar hardware, Same DBconfiguration and Database but different status variables result between Windows and Linux server [closed]

I have two database servers - one is Windows - 2008 and another is RHEL5 with similar hardware configuration. Both OS are 64 bit. MySQL 5.1.58 community edition is installed on Windows servers while ...
0
votes
1answer
62 views

Mysqldump without slow query

Situation: I currently monitor an instance of MySQL for slow queries. We have a mysql user dedicated to backups which performs a mysqldump, but the mysqldump gets logged as a slow query. Question: ...
1
vote
2answers
2k views

Oracle Database 12c on Oracle Linux 7 - autostart, enabling connection as sysdba

I've installed 12c on Oracle Linux 7 for my development work, as per document Oracle Database Installation Guide 12c Release 1 for Linux (E41491-10). My previous experience with administering Oracle ...
0
votes
3answers
122 views

Upgrading Oracle from 11.1.0.6 to 11.2.0.2 on Linux Red Hat

I am trying to upgrade the Oracle db from 11.1.0.6 to 11.2.0.4 in Red Hat Linux 5.3. The current database is installed on location. I checked the path using command cat /etc/oratab ...
0
votes
1answer
120 views

PostgreSQL data directory/files portability

I have lost my PostgreSQL 9.1 installation on my Ubuntu machine by update to Ubuntu 14.10. Now I have no (reasonably easy) way to export the data from my PostgreSQL 9.1 database. Is it possible to ...
1
vote
2answers
1k views

Hyperthreading & MySQL InnoDB Thread Concurrency Performance

I have a dedicated DB Server with the following specs" Ubuntu 12.04 LTS Server Intel(R) Xeon(R) CPU X5670 @ 2.93GHz 12 Cores MySQL 5.5.29 64 GB RAM RAID10 We are currently doing Hyperthreading ...
1
vote
1answer
1k views

MySQL slave stuck at 'System lock' most of the time, high CPU usage

Let me describe what we are facing now: We have a MySQL Master-Slave, Row Based Replication setup and at the moment, the slave is stuck with a perpetual System Lock. The Master is an active server ...
0
votes
1answer
208 views

ODBC SQL Server driver on Linux/nginx

Writing here because really can't figure out what to do. I have a site located at ftp server. And now it moves to a new server based on Linux/nginx. And everything is fine except SQL Server ODBC ...
0
votes
1answer
86 views

How to configure my.cnf in 5.6.17?

On production server(linux machine mysql 5.6.17), I tried to find my.cnf to change the system variables, but my.cnf was not in /etc/my.cnf location. It was in usr/ directory. Also that file contains ...
0
votes
1answer
268 views

can't execute opatch even I'm in the oinstall group with -rwx--x---

I'm in $ORACLE_HOME/OPatch directory and i type opatch then it response: -bash: opatch: command not found if i do ./opatch then it response: /bin/sh: ./opatch: Permission denied opatch ls -l shows ...
0
votes
1answer
40 views

How to connect to Oracle database on VM1 from host with 11gClient

I have a VM running Oracle Linux 6.5, I loaded Oracle server x64bit and created a database. The database functions fine and the listener is up and running for the database. I want to connect to the ...