Questions tagged [redhat]
The redhat tag has no usage guidance.
58
questions
0
votes
1answer
14 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?
1
vote
1answer
77 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?
0
votes
1answer
18 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 ...
1
vote
1answer
103 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 ...
0
votes
2answers
8k 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 ...
0
votes
1answer
2k 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 ...
0
votes
0answers
86 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/...
0
votes
1answer
98 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 ...
3
votes
1answer
66 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 ...
0
votes
1answer
152 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 ...
1
vote
1answer
724 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/...
0
votes
1answer
51 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/...
0
votes
1answer
48 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 ...
1
vote
0answers
813 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 ...
0
votes
1answer
299 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 ...
0
votes
1answer
1k 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, ...
1
vote
1answer
13k 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 ...
1
vote
2answers
770 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 ...
1
vote
1answer
901 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 ...
0
votes
1answer
239 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 ...
0
votes
2answers
1k 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:
...
1
vote
1answer
166 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 ...
0
votes
3answers
1k 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 ...
2
votes
3answers
20k 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.
...
0
votes
1answer
743 views
RHEL Postgresql 9.4 and PostGIS
I'm a dba new to postgresql. I have Linux RedHat 7 without openshift.
I have to install some DB on 9.4 version with postgis.
My sysadmin has published the following repositories :
RHEL 7 server
...
0
votes
1answer
79 views
Oracle 11g: SQLDeveloper
How would I use the pre-installed SQLDeveloper that comes packaged within Oracle 11g if I am invoking it with a user that has no oracle or admin rights on linux?
Would it be enough just to change ...
0
votes
1answer
160 views
Postgres Installed in Linux (RHEL) and trying to access / connect using pgadmin (Windows)
I've installed and configured postgresql in Linux successfully,
1. postgres user created
2. new db created successfully
3. I'm trying to connect using pgadmin III (Windows)
4. Following details are ...
0
votes
1answer
2k views
what is oracle shiphome?
I am trying to install oracle grid, One of the Oracle installation steps says,
set the variable ORA_SHIPS to the path location where you are going to
extract the 11.2.0.4 shiphomes
Please ...
0
votes
1answer
5k views
Oracle 12c Installation (Grid) on RHEL 7.1 CLSRSC-214: Failed to start 'ohasd' [duplicate]
root.sh script execution failing with following error please advice
./root.sh
Performing root user operation for Oracle 12c
The following environment variables are set as:
ORACLE_OWNER= grid
...
1
vote
3answers
6k views
Problem Installing 11.2.0 on RHEL 7 64 Bit
I have problem in stalling Oracle ASM on RHEL 7, Please advice
[root@localhost grid]# ./root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
...
0
votes
1answer
28 views
MySql DB from Ubuntu to RHEL
I would like to migrate my Mysql databases from Ubuntu to RHEL..what is the best way to proceed? I'm on community edition. I will be moving to entreprise edition of MySql on RHEL.
0
votes
1answer
110 views
How to create oracle user for more than one version
I have server under RHEL 6.3 installed on that server Oracle 11gr2 and 12c, I want to create user lets say Ahmad but I want this user to be sysdba on both servers, for single server I edit ....
1
vote
3answers
2k views
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-...
1
vote
1answer
741 views
Installation of Oracle 9.2.4.0 stalled
I'm installing Oracle 9.2.4.0 (I know, I know...) on Red Hat Enterprise Linux AS release 4 (Nahant Update 8) 64 bits using an Oracle 32 bit installer.
It appears to be stalled or hanged at 17% while "...
1
vote
1answer
1k views
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 ...
0
votes
1answer
516 views
pgbench-tools failed authentication
I'm trying to configure pgbench-tools and went to run it per the README and got this error
-bash-4.2$ ./newset 'Initial Config'
psql: FATAL: Ident authentication failed for user "postgres"
psql: ...
0
votes
1answer
578 views
how to Use old mysql database after reinstall mysql in RHEL 6?
I was getting problem in starting and login mysql server so I backuped /var/lib/mysql folder and reinstalled mysql server. Now I want to use old database files like: ibdata1 and database folder /var/...
0
votes
2answers
5k views
configure client ibm_db2 for php
I am installing a RHEL server with nginx and php that can connect to a db2 database, download and install the "IBM Data Server Client" package, also install the pecl library through:
pecl install ...
2
votes
2answers
2k views
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)
...
1
vote
1answer
2k views
Oracle 11gR2 + RedHat 6.5 cannot start sqlplus
I cannot start sqlplus
I've read everything I found, tried everything and still I am getting "command not found"
I have a user oracle, I did export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
....
0
votes
2answers
110 views
ORACLE Shifting from from one version to another
I have RHEL5 server with Oracle Home actual location is SAN, which is mounted on this server.
Now for few Reasons I have one more Server with RHEL 6 64Bit.
I will map those storage LUNS there.
What ...
1
vote
1answer
53 views
How can I create DB2 objects with Linux SUDOer authority?
All,
I am relatively new to Red hat linux and I have SUDOer authority but unable to create DB2 database or other objects. How can I accomplish this task? Please give examples.
Also, is there any ...
1
vote
1answer
2k 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). ...
3
votes
1answer
3k views
sqlplus is not starting
I have a strange error on a Red Hat machine.
InstantClient is installed in and ORACLE_HOME is set to /opt/oracle/product/112030_cl_64/cl/
The user which installed the client was oracle:oinstall. My ...
0
votes
2answers
53 views
Implementing older version of mySQL on RH9
I'm building a virtual machine running Red Hat Linux 9 (Shrike) and MySQL. This is to virtualize a current production system that needs new hardware. Questions:
Can I copy the existing mysql daemon ...
0
votes
1answer
692 views
Proper drive partitioning in Linux for Oracle
I have a current production physical server running on RHEL and I'm going to be building a new Oracle Linux VM to take it's place. Below is a listing of the existing physical drive partitions.
Can ...
0
votes
2answers
6k views
What is the last Mysql Version supported in REDHAT 6?
Maybe not such a good question ! But my Linux admin is to busy to answer my doubts. SO:
I have all my Mysql servers running on 5.1.69 version(the free one) that comes with RedHat O.S. My users are ...
0
votes
1answer
2k views
Percona MySQL 5.5.33 not reading my.cnf?
At some point Percona MySQL on CentOS 6.4 seems to have stopped reading my.cnf, possibly after MySQL updated to 5.5.33 a few days ago.
Selection from /etc/my.cnf:
[mysqld]
# GENERAL #
user ...
0
votes
1answer
5k views
Target database memory exceed available shared memory
I am trying to install Oracle 12c on a RHEL 6.4 system with 64GB of memory. When I try to enable automatic memory to 48GB, I get the error:
What do I need to change to allow Oracle to use more than ...
1
vote
4answers
2k views
Reading CSV files located on LINUX server and updating the tables in SQL Server Database
I was wondering how do we ingest CSV files located on a Red Hat LINUX server into SQL Server Database Table.
I know we can write a Stored Procedure/Bulk Insert to read the files that are located on ...
