Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [redhat]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
29 views

How do I change the user running DSE?

The user I'm referring to is the user created by the Datastax DSE package install. I'd like to replace that user with another account. I've found a couple of places where the "Cassandra user"...
mkvdba's user avatar
  • 1
0 votes
0 answers
91 views

What is the purpose for no gpgcheck in the pgdg-redhat-all.repo?

A repository installed from the official PostgreSQL site (/pgdg-redhat-repo-latest.noarch.rpm) has gpgcheck disabled for PostgreSQL 17 Downloads. See below. [pgdg17-updates-testing] name=PostgreSQL 17 ...
Jakub Liška's user avatar
0 votes
0 answers
57 views

Mount MariaDB data in a separate directory on RHEL 8?

We are migrating from a CentOS 7 server (physical server) to RHEL 8 (Azure server). This server was setup by someone else, and admittedly I know enough to install/configure LAMP. I am not a sysadmin. ...
Joel Firestone's user avatar
0 votes
0 answers
573 views

SQL*Net message from client too important

It is not easy to describe my problem but I will try. We noticed a slow processing problem with the database when migrating an application from a current VM named VM1 (RedHat 7.9, Java 8, Tomcat, ...
user avatar
0 votes
1 answer
51 views

Is it recommended changing the file /sys/kernel/mm/transparent_hugepage/enabled for MariaDB node?

Is it recommended changing the file /sys/kernel/mm/transparent_hugepage/enabled from 'always' to 'never' for a MariaDB Galera node?
user3637971's user avatar
1 vote
0 answers
521 views

Why when a Mongodb second secondary node is unreacheable, the cluster is affected?

I have the following MongoDB 4.0.2 cluster with the following information: rs.conf() { IP:192.168.1.26, // Primary, in New York branch priority:10 }, { IP:192.168.1.24, // Second Secondary, in ...
user3637971's user avatar
1 vote
0 answers
115 views

Update MySQL after upgrade RHEL7 - 8 : mysql-community-client-plugins has inferior architecture

I've updated RHEL 7 to RHEL 8 with leapp, but just have problems wirh mysql update: sudo dnf update Error: Problem 1: mysql-community-client-plugins-8.0.30-1.el7.i686 has inferior architecture - ...
user avatar
0 votes
1 answer
107 views

Sysbench - Public key for postgresql-libs-9.2.24-7.el7_9.x86_64.rpm is not installed

I have a mariadb on a redhat server (7.9) and trying to install sysbench for benchmarking with this command: sudo yum -y install sysbench I got this error: Loaded plugins: fusioninventory-agent, ...
TimLer's user avatar
  • 161
0 votes
2 answers
445 views

Silent Installation of Oracle 11gR2 Fails During NETCA setup in Redhat Linux 8

I am trying to install Oracle 11gR2 in Rhel 8. There was a few incidents of missing packages here and there which I managed to fix during the SOFTWARE ONLY installation. But now I am completely stuck ...
the_ruffler's user avatar
2 votes
2 answers
7k views

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 ...
kevin's user avatar
  • 103
0 votes
1 answer
29 views

Mysql v5.1/RHEL6 dump to MariaDB v10.3/RHEL7 restore process

I am moving a number of databases from a MySQL 5.1 RHEL6 server to a MariaDB 10.3 RHEL7 server. Do I need to run mysql_update after doing the dump/restore of each DB, or is that just for system tables ...
user2723901's user avatar
0 votes
1 answer
949 views

MongoDB: F CONTROL [main] Failed global initialization: FileNotOpen: Failed to open "/data1/mongodb/log/mongod.log"

I am trying to install mongodb 3.4 on Redhat 7.9. When I start mongodb systemctl start mongod I get the below error FileNotOpen: Failed to open "/data1/mongodb/log/mongod.log, But when I start ...
Eva's user avatar
  • 101
0 votes
0 answers
74 views

Checkopenport - DB2 / shell script sample

at DB2 startup we will check, whether the db2 port is in use. In the client DB2 setup we have only one instance / server. the port is always 50020 - for all servers. our idea - netstat -tunlp | grep &...
Oliver's user avatar
  • 1
-1 votes
1 answer
106 views

Importing big MySQL Database

I am trying to import a 6GB database on RHEL7. I have been reading for Here are my main settings in my.cnf: Why downvote? You are just making sure nobody else will help who needs help. Please let me ...
staminna's user avatar
0 votes
0 answers
23 views

How do I enable pgadmin4 (PostgreSQL12) to read and write files in directories of other Linux Users on RHEL8/CentOS8 [duplicate]

While trying to export a query result set from PGAdmin4 on PostgreSQL12 to a CSV I am encountering the following error: ERROR: could not open file "/home/linuxusername/Downloads/data.csv" ...
K8sN0v1c3's user avatar
0 votes
1 answer
868 views

Problem installing Oracle 19c to symlinked directory from RPM

I've created destination directory and linked it to default install path: $mkdir /u01/oracle $ln -s /u01/oracle /opt Then I've changed the owner: $sudo chown -R oracle:oinstall /opt/oracle But when ...
ant0nk's user avatar
  • 1
2 votes
1 answer
668 views

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 ...
Anthony's user avatar
  • 21
0 votes
0 answers
792 views

MySQL8.0 Replication Got Stuck "Applying batch of row changes (delete)"

When I configured Master-Slave replication it was working fine but after five weeks it is showing the following error. *************************** 1. row *************************** ...
Irungbon's user avatar
0 votes
1 answer
62 views

SQL Server 2017 on RHEL Linux with IDM for AD authentication

We are using Red Hat IDM to authenticate AD users to SQL Server. Users can login successfully to SQL Server with SSMS and SQL CMD with AD Authentication. But running some elevated commands from SSMS ...
Amit Saxena's user avatar
0 votes
2 answers
359 views

COPY Command spawning multiple processes

I have a lengthy data pipeline that imports a CSV, creates a sequence of dependent views and then exports the results using COPY as a CSV. This process had been working fine, completing in around 30-...
Matt's user avatar
  • 271
2 votes
2 answers
1k views

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 ...
user1111991's user avatar
0 votes
1 answer
264 views

galera cluster with mariadb 10.3.13 is not replicating on RHEL 8.1

I'm installing a galera cluster using mariadb 10.3.13 with two nodes in redhat 8.1 server. I enabled ports 3306, 4567, 4568 y 4444 ports. selinux is disabled. firewall disabled. The first node is ...
user3637971's user avatar
0 votes
1 answer
694 views

Install Oracle Weblogic: Unsupported major.minor version 52.0 [closed]

I tried to install Oracle Weblogic on Redhat Linux 8 using command java -jar fmw_12.2.1.4.0_wls_quick.jar but got an error: Unsupported major.minor version 52.0 Java version java version "1.7....
soulivong's user avatar
2 votes
1 answer
1k views

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 ...
Mikhail Aksenov's user avatar
0 votes
0 answers
45 views

Need Suggesion on PostgreSQL Database Minor upgrade Procedure from 9.5.15 to 9.5.19:

Thanks Alot each and every one. Could you please help us to below points: We are trying to deploy the latest postgres minor version 9.5.19. We have deployed postgres server using yum repository. ...
Siva's user avatar
  • 1
0 votes
1 answer
495 views

Oracle 12c create manual script for automatic startup on RHEL7

I need to create a script to start and shut down a 12c database in rhel7 automatically when the operating system starts and shuts down, it turns out that I have tried the common options with dbstart ...
miguel ramires's user avatar
0 votes
1 answer
37 views

Using MySQL Workbench 8 on RHEL7 gui - When I highlight text in the SQL editor it turns black

I'm assuming this is a config issue in MySQL Workbench or in RHEL. How can I change this to a readable color?
user114226's user avatar
1 vote
1 answer
8k views

Does Oracle 11gR2 is supported on RHEL 8 or Oracle Linux 8? [closed]

Oracle (afaik) did not updated their compatibility matrix yet. Can I run Oracle 11gR2 (which still is in extended suporte) in the new OS?
chesterman's user avatar
0 votes
1 answer
55 views

MySQL eats up all the memory from the RHEL OS

Currently, I have MySQL server installed in the AWS RHEL EC2 instance. The team was running heavy data processing in the DB and we found out that every now and then the DB restarted itself. After ...
Jupyterous's user avatar
1 vote
1 answer
786 views

MongoDB deployment across cloud and On Premises

We are planning to implement MongoDB as a stretch cluster which includes Primary secondary in DC 1, Secondary secondary in DC 2, Arbiter in cloud(DC 3) where DC 1 and DC 2 are on premise servers and ...
vignesh's user avatar
  • 25
0 votes
2 answers
80k views

psql: FATAL: password authentication failed for user "postgres"

I am running postgresql-9.6 on Rhel7. I know that the default/root user doesnt have a password, however i will like to use phpPgAdmin to do my work. the problem is I have edited my pg_hba.conf file to ...
christian Martin's user avatar
2 votes
2 answers
12k views

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 ...
wellwellwell's user avatar
0 votes
0 answers
125 views

external authentication of database users in Db2

For a future project, I am looking into authenticating Db2 database users via LDAP and PAM. However, it seems that LDAP server is deprecated in RedHat: https://access.redhat.com/documentation/en-us/...
Lennart - Slava Ukraini's user avatar
0 votes
1 answer
435 views

MongoDB Ops Manager

I have few questions regarding backup process in MongoDB Ops Manager 1) How backup process works ? 2) According to documentation for production do we need to have 3 dedicated servers for ...
vignesh's user avatar
  • 25
3 votes
1 answer
452 views

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 ...
Carlos Mazzini's user avatar
0 votes
1 answer
513 views

I can't add an extra node to mariadb cluster 10.1

I was installing a test mariadb cluster but I have a problem when I want to add an extra node. Both nodes use Red Hat Enterprise Linux Server release 7.3 (Maipo) These were the following steps: On ...
user3637971's user avatar
1 vote
2 answers
3k views

Cannot reset MySQL default root password after initial installation

I have installed mysql 5.7 on a Red Hat Enterprise Linux 5.5 server and when I tried to run following command after installation it is asking for a password for root@localhost. /usr/bin/...
Chathura Buddhika's user avatar
0 votes
1 answer
72 views

Installing oracle 9i in RHEL5 ... error during the process

Currently I am installing oracle 9i in RHEL5, but I have found that during the installation process at 5% completion it throws this error: Error in writing to file /path of oracle home/ctx/lib32/...
Arnaldo Raxach's user avatar
0 votes
1 answer
110 views

Completeness of Patch Population

I'm performing an audit on Oracle database changes and the database is on a Linux OS. After using the command opatch lsinventory, we learned that this command has not been pulling the complete ...
PlatosSpaghetti's user avatar
2 votes
0 answers
2k views

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 ...
JM Scheiwiler's user avatar
0 votes
1 answer
624 views

Sybase ASE monitoring tool of choice [closed]

I have inherited an Sybase ASE 16 database server and my initial task consist on deploy some Key Performance Indicators to monitor the RDBMS instance performance. I have 3 tools available in the ...
dnaranjor's user avatar
0 votes
1 answer
2k views

Installing Oracle 12c on Red Hat Enterprise Linux 6

When I try to ./runInstaller I get this error message: Source location is incomplete. Make sure you have downloaded and extracted all the relevant archives. I have two database unzip folders, ...
user113448's user avatar
1 vote
1 answer
28k views

ORA-00201: control file version 12.1.0.2.0 incompatible with ORACLE version 11.2.0.0.0

I'm trying to mount my database but sqlplus returned the following error : SQL> startup ORACLE instance started. Total System Global Area 1073741824 bytes Fixed Size 2932632 ...
Couim's user avatar
  • 253
1 vote
2 answers
2k views

Mysql Refuses to Start

On HOST OS RHEL 6.5, I upgraded mysql server from 5.1 to 5.7.9. And when i try to start it refuses and give me these messages in Logs 2016-08-01T07:29:42.939712Z mysqld_safe Starting mysqld daemon ...
OmiPenguin's user avatar
1 vote
1 answer
2k views

Mysql will no longer start after DB import and password change

I'm running Mysql5.6 on RHEL 7. I had managed to get the mysql service up and running, and imported a database into it with no issues. However, after attempting to reset a user's password, the ...
Jance's user avatar
  • 113
0 votes
1 answer
545 views

Reject Specific Database PostgreSQL User Authentication [closed]

Lets say I have two databases: Sales and Inventory And two users: A and B I want user A to be able to do: psql sales B But user A must not be able to do: psql inventory B Right now user A can ...
Everlight's user avatar
  • 101
0 votes
2 answers
3k views

SQL2043N Unable to start a child process or thread

I've seen the message SQL2043N Unable to start a child process or thread occur every once in a while since upgrading to rhel7 and db2 10.5. db2diag.log does not reveal much out of interest, beside: ...
Lennart - Slava Ukraini's user avatar
1 vote
1 answer
336 views

How does a VoltDB cluster determine time sync between nodes

I have a weird painful issue with VoltDB clusters on multiple RHEL7.1 vm (KVM). Time is synced between the VM and their hypervisor with a single local master NTP server - using chrony. Master server ...
Muhammad's user avatar
  • 113
0 votes
3 answers
2k views

Error while installing MySQL on RedHat Linux

I am new to RedHat Linux and am referring to this link for the installation :https://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html I finished the first two steps and ...
Rowana Ravenclaw's user avatar
2 votes
3 answers
32k views

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. ...
Rohit Batta's user avatar