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

learn more… | top users | synonyms

1
vote
1answer
288 views

Oracle silent install on Redhat Linux (The Global database name was left blank.)

I am installing Oracle 11g in silent mode using the response file that is in the database/response directory. It is three response files in that directory(i.e. dbca.rsp, db_install.rsp and netca.rsp). ...
1
vote
0answers
204 views

How to set selinux permission for non-standard mysql bin log path?

By default, mysql bin log works in folder /var/log/mysql. but moving to any other share such /mylogs/mysql gives permission error. Below is the exact message: usr/sbin/mysqld: File ...
0
votes
2answers
80 views

Reset of root password not working?

Our previous DBA left and didn't note the root password down, and I've been pressganged into doing part of his job until we can hire someone. So I create a file : /root/mysql.password Inside that ...
1
vote
0answers
59 views

Does using noatime on modern Linux make sense?

Starting from version 2.6.30 (which was released 5 years ago), Linux has the option relatime enabled by default. It means updates of file access time are very infrequent and prudent. But I still see ...
0
votes
0answers
137 views

Huge load on CPU because of mysql process [closed]

I am getting a huge load on my linux servers because of this query. CPU is on 500% load & this query is causing load. /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql ...
0
votes
0answers
118 views

MySQL gets slow in Linux server

I'm using a jdbc connection to connect a vaadin application to a MySQL database. It works fine, but after a couple of uses it gets really slow, and even freezes the application to a point I have to ...
2
votes
3answers
2k views

Counting postgres open connections without SQL query or connecting to postgres itself

For a monitoring script I need to count the number of open connections to a postgres database. This is done easily enough by opening up a client connection and running a count on the pg_stat_activity ...
0
votes
1answer
69 views

Please tell me my data isn't gone… lie to me even

In a moment of ignorance I setup my webserver to auto backup all data to another machine. not a problem except I just mearly cp -R /var/lib/mysql so all I ended up getting was hundreds and hundreds ...
0
votes
0answers
621 views

sqlldr: command not found

I have a script which has this command 'sqlldr' which gives me the error sqlldr: command not found when I run this script. I googled and found that people say that this command should be there in my ...
2
votes
1answer
715 views

Mysql error 28 no space left on the device

I keep running in to the same problem with mysql with error code 28 which means there is not enough space left on the device. Now the weird part is that there is enough space, here are some tips i ...
0
votes
1answer
103 views

Poor SQL performance with raid10

Maybe I'll try my luck here. Server Fault site was quite hostile for non-professional server user. I recently bought HP ProLiant ML310e Gen8 v2 server with 8G's RAM and 4 HP 1TB 6G 7.2k rpm SATA ...
2
votes
1answer
468 views

Can I execute an external process via MySQL on table change?

When using triggers, if an update is done to a table then a trigger is executed. This is very convenient. But what I would need is to execute an external script. Is it possible to configure MySQL ...
0
votes
0answers
265 views

Postgres Backup on linux server [closed]

I am trying to take backup of postgres from InstallAnyWhere which is installer for linux and windows machine. I am calling pg_dump from Java process builder as command line below cmdLine: ...
4
votes
2answers
2k views

mysql multi threading for a single query

I have big db of size 8GB and having 9 million contacts in this db. When we try to retrieve all contacts, it takes nearly 1 or 2 hour (in some cases result in timeout) to retreive all contacts for the ...
0
votes
2answers
433 views

PostgreSQL - pgAdmin error creating a server

I have the latest versions of PostgreSQL and its GUI-frontend, pgAdmin, installed. When I try to register a new server a fatal error appears when pgAdmin tries to connect to the newly created server - ...
0
votes
2answers
73 views

Why its failed on linux server?

I tried to mark disk and got Fail!!! [root@oradbserver3 Server]# /etc/init.d/oracleasm createdisk DISK1 /dev/sda2 Marking disk "DISK1" as an ASM disk: [FAILED]
0
votes
1answer
258 views

web interface port for oracle 11g

I am running a fresh Oracle 11g installation created on lunix redhat 5, but I forget the web interface port, I have already tried this https:// localhost:5500/em/ but did'nt work. any help will be ...
0
votes
1answer
129 views

Kerne module for Oracle 11gR2 RAC on Linux

As per Oracle, it requires three Linux packages to run ASMLib: oracleasm - kernel module oracleasmlib-2.0 - ASMLib libraries oracleasm-support-2.0 - Admin for ASMLib This library versions are OS ...
0
votes
0answers
34 views

How do I save file data to my newly mounted SSD in mysql innodb continually?

I've recently mounted a new SSD since my disk's empty space had less than 10% (mysql unbuntu linux) and this is what I did in my.cnf file to save data to my new path: innodb_buffer_pool_size=2G ...
0
votes
1answer
343 views

MySQL Service is not starting on linux

I am having a problem with my database it does not want to start :( the server is running on linux centos 6.2 it was working until I emptied the logs I don't know if this have anything to do with ...
1
vote
0answers
207 views

InnoDB: error: space object of table

131212 10:35:18 InnoDB: error: space object of table 'main/wp_m_membership_levels', InnoDB: space id 119 did not exist in memory. Retrying an open. 131212 10:35:18 InnoDB: error: space object of ...
0
votes
1answer
21 views

Change MySQL 4.1 Windos to MySQL 4.1 Linux- Problem with the key Sensitive in query

I need help to resulucion this problem. change the server MySQL 4.1 run on Windows to MySQL 4.1 run on Linux(debian). This all working, but same query not return the correct data because key ...
1
vote
1answer
439 views

Grant postgres superuser to linux account

On my development (Ubuntu linux) laptop I have a postgres OS account, which owns the Postgres installation. When I want to perform any postgres activities, create/drop databases etc, I must first su ...
0
votes
2answers
2k views

MySQL on Windows or GNU/Linux?

I've just read this article: http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server.html There it says that MySQL on Windows is a good choice. (or is what I've understood) In ...
0
votes
1answer
1k views

MySQL - Server collation utf8_unicode_ci vs table collation utf8_bin: compatibility and performance

I'm not sure whether this belongs to SE DBA, but it sounds more logical ... Our MySQL 5.5.32 on Ubuntu 12.04 64 uses utf8_unicode_ci for the Server collation and some tables, like phpBB3, uses ...
0
votes
1answer
396 views

TCP sockets bottleneck with InnoDB/Debian?

We have a big mysql performance issue on a production environment with 18 "front" servers sending mysql queries to a unique mysql server. We are using Redis on each front server for a number of ...
3
votes
3answers
8k views

Oracle client throwing ORA-12541: TNS:no listener

when i was trying to connect my remote server as- sqlplus SYSTEM/oracle@192.168.0.171:1521/kannel it shows me this error- SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 15 15:36:52 2013 ...
1
vote
3answers
141 views

Best practice to query administrative views for instance level elements

I want to query a monitor element at instance level (for example the memory used for the instance) via a query like this: SELECT MEMBER, MAX_MEMBER_MEM, CURRENT_MEMBER_MEM, PEAK_MEMBER_MEM FROM ...
0
votes
1answer
69 views

Are databases only growing in size?

Databases use the file system to store the data. As far as I know it is not possible to delete a record from a random access file. So does that mean that when we do a DELETE FROM TABLE the size of the ...
0
votes
0answers
288 views

Oracle Installation issue on Oracle Linux 6.4

I am trying to install Oracle 11g(11.2.0.1.0) on Oracle Linux 6.4(Remote Server). I get the following error(s) when Database Configuration Assistant is running ORA-01092: ORACLE instance terminated ...
0
votes
0answers
31 views

mysqldump: Got error: 0: when retrieving data from server

I get a the error in the header when the server tries to replicate itself after the backup completes. I have looked at error indexes, but failed to see an explanation for the error code 0. I was ...
0
votes
2answers
274 views

Importing MySQL database using Linux Terminal

I have an existing database, named dlti.sql I want to transfer it to a Linux-based server. I tried using this code, however I get no response: mysql -u root -p Desktop < dlti.sql The .sql file ...
0
votes
1answer
76 views

How can I run a PostgreSQL outside the standard directories on Linux, ie outside /var/run/postgresql etc?

I need to be able to run PostgreSQL databases outside the standard installation directories, ie run the existing postgres or pg_ctl process pointing to the alternative ports, configuration and data ...
1
vote
1answer
112 views

command line tool on linux to convert oracle sql into db2 sql

IBM has a GUI based tool to convert Oracle SQL into DB2 SQL. Is there a command line tool (preferably on linux) that does the same thing? The reason being, we want to do this work as part of a ...
1
vote
1answer
91 views

creating 2 database at the same time in db2

Do you know whether it is safe to have in one shell user db2inst1 creating a database A and having another shell the same user creating at the same time database B? create database A # shell 1 ...
0
votes
1answer
555 views

configure: error: SQLite3 library not found

I'm getting the below configure error while doing the install the Zabbix reporting tool on Linux. i have tried both Versions(zabbix-2.0.9,zabbix-1.8.17), but getting same issue. Log: checking for ...
0
votes
0answers
82 views

ORACLE_HOME is not available

I install Oracle 11GR2 on Cenots 5.9 . i edited bash_profile to correct values for ORACLE_HOME and ORACLE_BASE and etc . But when i want to run SqlPlus , " command not found " is shown . but when i ...
0
votes
2answers
2k views

Entering command 'sqlplus' results in 'sqlplus: command not found'

I've recently installed Fedora 19 on an older PC, to serve as a test server of sorts. After a lot of hiccups, I was able to install Oracle 10g XE. Because I'm using Linux - which I, admittedly, have ...
0
votes
1answer
601 views

Install Oracle 11gR2 driver for Node.js 0.10.20

I want to connect Oracle 11gR2 and Node.js 0.10.20. I use this package but I don't understand this part of installation process. Can you explain it to me? # Replace /opt/instantclient_11_2/ with ...
0
votes
0answers
66 views

How do I debug an Oracle Linux Diskspace Issue?

I have about 429GB Diskspace allocated to this VM. I see that only 179GB is being used. Now when I try to add a 128GB file I get an I/O error saying I do not have any space left. I need to be able ...
0
votes
2answers
240 views

Backup Oracle DB using TSM server version 6.3.0

I'm new to Oracle and TSM server. I installed Oracle11gR2 and TSM server version 6.3.0 (linux Centos 6.4 OS). I did the configuration and everything works fine. so far I arrive to run the following ...
1
vote
3answers
808 views

Issues installing MySQL server on Ubuntu 13.04

I'm currently trying to install a MySQL server on my Ubuntu 13.04 machine. The problem is, when I try to install it, I get error messages indicating that not all packages could be downloaded. When I ...
0
votes
1answer
122 views

MongoDB cloneCollection between CentOS servers times out at 2 hours

I'm trying to clone a MongoDB collection from CentOS server A to CentOS server B. Both are running 2.4.6. The copy works great until exaxctly 2 hours, at which point I get a 9001 socket exception: ...
0
votes
2answers
1k views

Mysql Server Login and Permission Deny Error

I have a problem with MySQL server. After upgrading MySQL server from 5.3 to 5.4, I am not able to log-in using my MySQL root password (Yes, I am able to log-in without password!). Also not able to ...
0
votes
1answer
1k views

Installing Oracle 11gR2 on Oracle Linux 6 - error possibly related to database (unique) name

Installing 11gR2 on Oracle Linux 6.4. System is a desktop used by one developer. It's on DHCP. Hostname is similar to ip-t3400-1547.mydomain.local Please note I have no issues installing this ...
0
votes
0answers
168 views

After RAM upgrade on 32-bit Oracle server, ORA-04031: unable to allocate x bytes of shared memory

We are in the process of upgrading our Oracle database server at work, from SUSE Linux Enterprise Server 10.4 / Oracle 10g / 4GB RAM (Intel 32-bit) to Scientific Linux 6.4 / Oracle 12c / 8GB RAM ...
3
votes
2answers
5k views

db2 database alias not listed via list database directory but still unable to create that database

I am trying to create a database by logging on to the linux server on which the db2 server is installed, as the instance owner db2 => list database directory System Database Directory Number ...
0
votes
1answer
244 views

db2 SQL0930N error on linux - not enough space to process this statement

This is another newbie question on db2, related to space. How to I start diagnosing and then solving what the problem is so that users can connect to this database? This error is displayed when both ...
-3
votes
1answer
62 views

How can I move one table from one database to other database [closed]

I want to move one table in one database to other database using mysql dump on linux terminal How can I go about it ?
1
vote
1answer
852 views

SQL1641N error on linux while running db2start using db2 express c on linux (LUW) but the file system is not mounted using nosuid

I am trying to install and start db2 on my linux machine using the following script: #!/usr/bin/env bash MKDIR=/bin/mkdir RM=/bin/rm TAR=/bin/tar ...