Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [redhat]

85 questions
14
votes
2 answers

innodb_flush_method=O_DIRECT vs O_DSYNC performance impact on ext3 with LVM disk partition

In one of my production environments, we have two instances running on a RedHat cluster, with one production instance associated with the cluster. We have 125G main memory with 24G InnoDB buffer pool occupied by instance1 & 12G occupied by…
Gopinath Karangula
  • 933
  • 2
  • 10
  • 21
4
votes
1 answer

changing Virtual IP interface names on RAC nodes - how to reconfigure

We are adding an extra interface on our nodes and we are going to bond these so the VIP interface will change from eth5 to bond3. Can someone point on documentation on what to do to reconfigure the interface name in a RAC? Or simply give a procedure…
Nicolas de Fontenay
  • 1,875
  • 2
  • 18
  • 37
3
votes
2 answers

db2_install do not have write permission on the directory or file

This is the error I encountered (I ran the db2_install and everything else as root,): DBI1288E The execution of the program /home/DB_SERVER/ibm/db2/v10.5 failed. This program failed because you do not have write permission on the …
Tiana987642
  • 131
  • 1
  • 3
3
votes
2 answers

Is there a recommended way to update a database schema when updating and app's RPMs?

I have a pretty standard server layout: 2 Application servers running Tomcat on Redhat. 2 Database servers running Postgres on Redhat. One database is a master and replicates to the slave. I'd like to automatically upgrade the scheme when I update…
alex.collins
  • 203
  • 2
  • 4
3
votes
2 answers

psql (PostgreSQL client) tool install on RHEL

I would like to install just the PostgreSQL client tool (psql) on RHEL on a container to connect to an Azure database for PostgreSQL server. Can you please point me step by step instructions on how to do the same?. I do not want to install the…
kevin
  • 133
  • 1
  • 3
  • 10
3
votes
1 answer

Is there a version history for the Postgres upgrades made in the installation?

I'm trying to determine when the last Postgres upgrade was made. I know my current version (through "show server_version" command, and other ways too). But I wasn't able to find a history of the last upgrades and the respective dates. Is there such…
Carlos Mazzini
  • 45
  • 4
2
votes
2 answers

Issue when connecting to open shift via mysql workbench on Mac

I am trying to connect to open shift with mysql workbench on an iMac. A colleague has shown me his setup on Windows which looks exactly as follows (other than the usernames / passwords changing) However I keep running in to the following error and…
Biscuit128
  • 121
  • 4
2
votes
1 answer

Configuring Postgres 9.2 streaming replication with Redhat Clustering Suite for High Availability

I'm in the process of configuring PostgreSQL 9.2 streaming replication with Redhat Clustering Suite for high availability. I have 1 master and 1 hot standby configured to replicate the data from master to standby using streaming replication. Now I…
Prem
  • 121
  • 3
2
votes
1 answer

SQL Server for Linux 2019 - Windows Authentication not working

Hoping to pick the brains of those more knowledgeable than me. I've been trying to set up a SQL Server 2019 instance on Linux; specifically on AWS using AMI amzn2-x86_64-SQL_2019_Standard-2019.11.12 I've followed the steps to connect the instance…
Anthony
  • 21
  • 1
2
votes
2 answers

Less obvious "The table 'mytable' is full" error

Error in mysqld.log: 2020-02-02T01:17:32.133974Z 3069 [ERROR] /usr/sbin/mysqld: The table 'IS_DUT_IFID' is full None of the many threads I've found about this error have helped me to resolve this issue. Here's what I've checked or tried so…
user1111991
  • 23
  • 4
2
votes
1 answer

Postgres systemd service unit is in activating (start)

I'm experiencing Postgres service in activating state after incorrect server shutdown. The Postgres seems fine: connections are available and DB is running. [root@postgres-02 ~]# systemctl status postgresql -l ● postgresql.service - PostgreSQL…
Mikhail Aksenov
  • 430
  • 1
  • 7
  • 19
2
votes
2 answers

Can't start mysqld service after changing datadir

I have an AWS EC2 instance with RHEL 7 on which I installed mysql-5.5 on xvda. Its datadir is under /var/lib/mysql (as is the default). I am importing dumps from a database on version 5.5.29 and the currently installed version is 5.5.60 A larger…
wellwellwell
  • 49
  • 1
  • 2
  • 7
2
votes
0 answers

Start/stop postgresql with pg_ctl or service without root access on RHEL6

We plan to use postgresql on RHEL 6. DBAs won't have root access but they will need to start/stop the databases. They'll be able to do so with pg_ctl as postgres. However databases should also start automatically when the server reboots and so we…
JM Scheiwiler
  • 21
  • 3
2
votes
3 answers

How to identify how many instances of Oracle are installed on Linux environment

Last day, I was at one training for Oracle installation and service start & shutdown. There I came to know about some Linux commands to start and shutdown an Oracle instance on a Linux machine. To identify the instance running : The command below…
Rohit Batta
  • 123
  • 1
  • 1
  • 5
1
vote
3 answers

Is using ASM a pre-requisite for RAC?

I am about to build our first RAC development environment, and as I'm new to RAC and have not used ASM I wanted to keep things as simple as possible. I was under the impression that ASM is a pre-requisite of RAC, but reading I've done recently…
davegreen100
  • 572
  • 4
  • 12
  • 25
1
2 3 4 5 6