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

learn more… | top users | synonyms

3
votes
2answers
3k 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 ...
0
votes
1answer
617 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 ...
6
votes
3answers
10k 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 ...
2
votes
1answer
1k 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 ...
1
vote
2answers
827 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 ...
6
votes
3answers
3k 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 ...
3
votes
1answer
1k 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 ...
6
votes
7answers
6k views

What tools are there for data masking? (MySQL, Linux)

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 ...
4
votes
2answers
1k views

What's a free client for Oracle 8 on Linux / Ubuntu?

I need to connect to a legacy Oracle 8 database. Oracle SQL Developer would be my tool of choice, but the current version doesn't support Oracle 8 anymore. I tried Squirrel too, but the connection ...
8
votes
1answer
416 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 ...
15
votes
3answers
24k 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 ...
4
votes
5answers
410 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 ...