Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
993
questions
8
votes
2
answers
11k
views
Easy Postgresql master/slave replication with automatic failover on Linux?
I need a reliable SQL DB for our application and have been looking at Postgresql's streaming replication support. It seems that it's not hard to setup master/slave replication and you can use the ...
- 471
3
votes
2
answers
19k
views
Encoding problems with sqlplus, Linux
I use sqlplus and all non-Latin characters appear as '?' when I run select queries. When I run insert or update queries with non-Latin characters I get question marks on a web page.
select * from ...
- 155
108
votes
6
answers
178k
views
Safest way to perform mysqldump on a live system with active reads and writes?
I'm not sure if this is true but I remember reading if you run the following command in linux
mysqldump -u username -p database_name > backup_db.sql
while reads and writes are being made to a ...
- 1,215
5
votes
2
answers
12k
views
Tool for Reverse Engineering of PostgreSQL Database on Linux (Ubuntu) [closed]
Please suggest a tool to reverse engineer a PostgreSQL DB into an entity-relationship-diagram (ERD) or equivalent ??
Ideally, I'm looking for a simple ERD or UML class diagram in a format that is ...
- 1,155
8
votes
5
answers
39k
views
Scriptable command line access to SQL-Server from linux [closed]
Does anyone know of a ready made1 command line tool that would allow me to connect from a linux client to a sql-server?
I want to be able to run arbitrary queries, but most of the time I want to be ...
- 1,452
2
votes
2
answers
2k
views
How to write a shell script to check the mysql database backup status. [closed]
I have mysql production databases running in main server(Linux) and from this server every night the backup is taken into local server.
Now i want to find a shell script to check if all the databases ...
2
votes
1
answer
2k
views
Oracle, error while exporting schema
I'm using a command:
$ exp userid=apex_public_user/apex_public_user OWNER=apex_public_user DIRECT=Y CONSISTENT=Y FILE=/home/oracle/apex_public_user.dmp
and getting following output:
Export: Release ...
- 155
3
votes
2
answers
2k
views
Replication with only update and insert
I have set up my replication but I want to delete some outdated data from my master tables. Is it possible that say if I have 10 records at master and I delete 5 of them but I want those 10 records to ...
- 131
5
votes
1
answer
2k
views
Oracle Database Enterprise Users & Roles with Microsoft Active Directory?
We have a legacy application and we have full access to source code and platform running it, so virtually any change can be implemented if required.
The application is a Java Swing heavy-weight GUI (...
- 51
1
vote
1
answer
2k
views
Oracle Client vs Oracle Instant Client on Linux!
to have the following setup on a Linux box:
SQLPlus
client library (oci.dll)!!!!
ORACLE_HOME is set for users
is Oracle Instant Client enough or I need to have the Oracle Client installed on the box....
- 357
14
votes
5
answers
63k
views
Cannot output MySQL data to file
I am trying to output the data from an MySQL table to a file but getting permission errors:
$ pwd
/home/dotancohen
$ mkdir in
$ chmod 777 in/
$ mysql -ugs -p
mysql> USE someDatabase;
mysql> ...
- 1,075
33
votes
7
answers
47k
views
Does innodb_file_per_table affect mysql performance?
There are many articles exaggerating (IMHO) the need for innodb_file_per_table. I understand that with innodb_file_per_table there should be better control over individual tables, like being able to ...
- 4,491
6
votes
2
answers
35k
views
MySQL case sensitive table names on Linux
Moving a MySQL database from Windows to Linux I have the problem that on Linux the names of the tables are case sensitive. This is a problem, because the Java application that I am developing can't ...
6
votes
1
answer
21k
views
How to grant access for multiple tables to a user in MySQL DB?
I have mysql db named "greats" with four tables as below
+---------------------+
| Tables_in_greatstat |
+---------------------+
| log |
| sitedet1 |
| siteindex ...
- 493
2
votes
2
answers
1k
views
MySQL performance on Mac vs Linux
I know that MySQL is tested more on Linux (Oracle has it's own linux distribution and you canot have LAMP wit MySQL (meaning MySQL has always focused more on Linux)
My intuition says that MySQL has a ...
- 1,757
1
vote
1
answer
1k
views
Tutorial for installing and setting up 'streaming replication' with PostgreSQL on Windows XP
Please refer to the diagram in the link below. While looking at my goals.
https://i.stack.imgur.com/GkVWb.png
GOAL:
Get PostgreSQL 9.1 running on 3 terminals on the 'on site' location.
'on site'...
- 153
2
votes
1
answer
4k
views
Installing Oracle XE 11gR2 on Fedora 15 - linux group permission deadlock
During installation of Oracle XE 11gR2 on Fedora 15, I am presented with:
The install cannot proceed because ORACLE_BASE directory (/u01/app/oracle) is not owned by "dba" group. You must change ...
- 21
5
votes
2
answers
23k
views
How to set a specific directory location for individual MySQL database?
Is it possible to set each database in MySQL to use a separate datadir?
I'm running a userdir development (sandbox) server and would like to put the MySQL data files for the database(s) for that user ...
- 185
3
votes
1
answer
1k
views
oracle 11g seems to die every 2 days, how can i debug what's happening?
I installed oracle 11g on ubuntu 11.10, but it seems that every couple of days I'll get to work and the database isn't running but the listener is.
To fix it, all I have to do is login and start it ...
nick humphrey
1
vote
1
answer
15k
views
How to set up tns listeners for Multiple Oracle Installations on One machine
So I have two oracle installations on a development/testing machine (10g and 11g, respectively).
The platform is RHEL4.
Now I need to have both these oracle up and have tns listeners for them ...
BeyondSora
3
votes
2
answers
8k
views
Oracle 11gR2 expdp table converted to CSV from Linux
With Oracle expdp, I can export the tables I want with
expdp INCLUDE=TABLE:table1,table2,table3
I need a way to convert this into CSV on a linux machine. I've seen Windows tools but don't know how ...
- 31
19
votes
4
answers
71k
views
Taking MySQL dump from another machine
I have a MySQL db on Machine A and I want to access the mysqldump from machine B.
Both machines are running on Linux and I also have the credentials of both, but I can't access the mysqldump. What ...
- 337
5
votes
3
answers
4k
views
MySQL general log
Is there away to have MySQL dump its log to a remote MySQL server?
I would like to audit MySQL connections but I don't want the server to store all the information local on its own hardware.
- 53
11
votes
2
answers
15k
views
View Postgresql Memory Usage
I'm running Postgresql on a Ubuntu server and need to be able to monitor its memory usage. Currently I have scripts running in a one-minute cron job that monitor/log various statistics and need to ...
- 213
3
votes
2
answers
28k
views
Oracle11.2g post-installation problem on Oracle Linux kernel
After installation of Oracle 11.2g in silent mode on the Oracle Linux kernel, I have the following error:
[u01/app/oracle/product/11/bin] $ sqlplus
sqlplus error while loading shared libraries: ...
- 31
3
votes
1
answer
5k
views
I have lots of free memory. How do I use it to increase performance?
I am running Litespeed (with suExec, PHP SAPI), MySQL, DirectAdmin, named on a VPS with a 16-core Xeon CPU and 2GB RAM.
Currently, only 300 MB out of 2048 are used. It might sound a stupid, but how ...
develroot
2
votes
1
answer
2k
views
MySQL Tuner OPTIMIZE and Defragmentation
I have just started using mysqltuner to help keep my mysql server fast and healthy. However, I am having a little trouble optimizing my tables. When I execute mysqltuner, it all works fine and returns ...
- 123
5
votes
5
answers
20k
views
MySQL said "InnoDB: Initializing buffer pool, size = 128.0M", does it mean it is using 128MB RAM?
I am just using a very few InnoDB tables (e.g. less than 1MB), but during MySQL startup, it said
InnoDB: Initializing buffer pool, size = 128.0M
Does it mean even I am using in such a small size, ...
- 249
14
votes
3
answers
12k
views
How to convert mysql to postgresql? [closed]
I am desperately looking for a conversion tool to convert a big mysql database to postgresql. I need the tool/script to be:
Free
Works under Linux
Simple to use and not buggy
You actually tried and ...
- 141
3
votes
2
answers
8k
views
Mysql consumes a lot of memory
Here is my situation.
I have an ubuntu server monitored by nagios.
recently nagios sends alarms regarding the memory consumption on the server. I logged into the server and executed the top command ...
- 31
3
votes
1
answer
2k
views
Any Idea how to migrate from PostgresSQL 8.4 to PostgresSQL 9.1.1 in opensuse12.1
I had a crashed opensuse 11.3 that's why I installed opensuse 12.1..
after I installed (via yast) and edited /etc/passwd
I do this:
rcpostgresql start
and this shows on the /var/log/messeges
~ # ...
- 305
5
votes
1
answer
223
views
Will I need more system resources to run DB2 instead of MySQL?
I need to convert my web application from MySQL to run on DB2. I need to know in advance whether I will need a high spec server to ensure the web application performs at the same speed as it does now ...
- 163
3
votes
2
answers
5k
views
MySQL Replication Troubleshooting
Here's what I did. On the master, change /etc/my.cnf:
[mysqld]
server-id=1
log-bin=mysql-bin
innodb_flush_log_at_trx_commit=1
sync_binlog=1
Save and restart mysql, then log in.
>GRANT ...
user168185
0
votes
1
answer
794
views
Any disadvantage to using oraToolkit for installing oracle
I am going to install oracle 11gR2 on a redhat enterprise 5.6 machine. Is there any disadvantage to using oraToolkit? For example, could it cause any problem or difficulty for future complimentary ...
- 101
9
votes
4
answers
29k
views
Oracle returns an error ORA-01031: insufficient privileges
Oracle returns an error "ORA-01031: insufficient privileges"
When I run sqlplus / as sysdba but sqlplus sys/oracle123 as sysdba doesn't, why?
Oracle version: Oracle Database 10g Enterprise Edition ...
- 91
2
votes
1
answer
6k
views
How to find out CPU utilization per Oracle Database on Linux?
For capacity planning on existing RedHat servers hosting Oracle Databases, I was asked how to find out the CPU utilization per database.
Thought it would be as simple as
ps -eo pcpu,comm |grep -i ...
- 21
1
vote
2
answers
884
views
Oracle XE Fedora 15 Installation problem
I got a problem installing Oracle XE on Fedora 15. Hope you can help me.
I used this tutorial(that worked great for F14) but didn't got lucky with F15.
The problem is that during installation goes ok,...
- 115
6
votes
3
answers
7k
views
Add Oracle Label Security to an existing Oracle installation
We are using Amazon EC2 to host some Oracle database instances while we are evaluating and prototyping some software. We are using the AMIs provided by Oracle - specifically, Oracle Database 11g ...
- 161
5
votes
1
answer
3k
views
Unable to create a tablespace, unusual error
I'm having difficulty creating tablespaces with Oracle 11gR2 on a fiber attached disk array. Permissions are correct and there is ample space available. I can create tablespaces on other mounts that ...
- 171
14
votes
9
answers
26k
views
What tools are there for data masking? (MySQL, Linux) [closed]
I'm looking for (ideally free, open-source) data masking tools. Do any such exist?
Note: this related question deals with tools for generating test data, but in this question I'm more interested in ...
- 477
8
votes
1
answer
1k
views
How can a datapump export have its resource usage limited on linux?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
- 23.8k
20
votes
4
answers
91k
views
Can I change the SID of an Oracle database?
The Server is Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
Is there an easy & quick way to change the SIDs of the test databases on the server?
Dropping & recreating of ...
- 12.2k
7
votes
5
answers
910
views
Improving SQL Server performance on VMware under Linux
I have a Linux server in a small company (3 users) acting as a domain server and running two VMs under VMware: one has SQL Server 2000 on it and one has SQL Server 2005, in each case running on Win2k....
Brad Richards