Questions tagged [linux]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
4 views

Postgres 10 -> 13 - version mismatch after running pg_upgrade

I used the following commands to migrate from Postgres 10.3 to 13.4, on Ubuntu 18.04: 1. pg_dumpall -p 5432 > backup.sql 2. wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | ...
0
votes
0answers
7 views

How to check if a new Oracle PDB has been replicated successfully to the standby side?

How can I check if a newly plugged in 19c PDB on the primary has been replicated successfully (automatically) to the DataGuarded standby side?
-1
votes
1answer
82 views

Why SQL Server docker image uses high CPU all the time, and how to fix it?

Using this docker-compose.yml I have created a container: version: "3.9" services: database: image: mcr.microsoft.com/mssql/server user: root restart: always ...
0
votes
1answer
4 views

logical replication. How do I change the subscriber to new master?

I'm migrating Linux distros and need to migrate the Postgres 11 to new master. I can do a streaming replication and have little to no downtime or do a dump. That I got down. My problem is how do I ...
0
votes
1answer
38 views

Rebuilding an Oracle 19c Standby Database after plugging in a new PDB

I have an Oracle 19c Dataguarded physical standby DB setup running on Linux 7. The container DB had one PDB but I've now just plugged a new PDB into the primary. What do I need to do to get this new ...
0
votes
0answers
13 views

Pgpool-II on Ubuntu - older Pgpool version is OK?

I took a long time setting up the Pgpool-II high availability on my postgres 13 cluster on Ubuntu machines. I kept following this example, while converting the CentOS tutorial to Ubuntu equivalent. I ...
2
votes
1answer
52 views

How do I identify the users on Oracle database who uses OS authentication?

I'm trying to audit the privileged users on Oracle Db and see there are users for whom the last login column appears to be blank, however, I'm aware that those user accounts are used for certain ...
0
votes
1answer
22 views

Oracle database startup leads to errors

Used the Oracle Linux Server 8.2 and its terminal shows below errors. ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination ...
1
vote
0answers
37 views

Tracking Read/Write latency for SQL server on linux

Hello i want to track SQL server read/write latency for the SQL servers i monitor running on linux host. I checked and found disk related metrics would not work here for linux if fetched from sys....
0
votes
1answer
51 views

RAM overflow in MYSQL

I have a server with a database in MYSQL 5.7.34 MySQL Community Server (GPL) on weekends has a very high tractability so it has been responding very slowly, I saw the logs and it gave me the following ...
0
votes
1answer
20 views

Postgresql log uploading service on Ubuntu Linux

I am trying to create a systemctl service to collect + upload logs for Postgresql 12 on Ubuntu Linux. However, I am expert at none of the two. While I have set up the server modifying /etc/postgresql/...
2
votes
1answer
39 views

Backup MSSQL database to local machine on Linux command line

What is the mssql-cli (or other tool options?) equivalent of this? mysqldump --host servername dbname > dbname.sql As far as I can tell, logging-in to the SQL Server with mssql-cli and running ...
0
votes
1answer
21 views

Wordpress crash on slow queries related to wp_term and wp_term_taxonomy

I have a WordPress blog with around 90K articles. The problem is I get frequent crashes on the server and browsing is slow due to some slow queries on the website. I am suspecting the problem is with ...
0
votes
1answer
36 views

Deleting hundreds milion of rows in single MySQL query

we have a project with a huge MySQL table (MySQL version 5.7.35-0 on Ubuntu 18.04.1 using InnoDB) table. By Huge I mean approximately 100M of rows 300GB. I want to do some pruning there. This can be ...
0
votes
1answer
74 views

Restore MySQL MariaDB Database from local files (without sql dump)?

first of all - I already read several other threads like Restoring MySQL database from physical files, but I'm unsure wether this will work for me since I'm running MariaDB and not MyISAM. Let me ...
0
votes
1answer
24 views

MySql Important Linux System Configuration [closed]

Last month I'm trying to find a "formula" for optimal Linux system configuration for MySql installation. But I didn't find anything related in those fields: Should I disable swapping ? ...
1
vote
1answer
72 views

SQL Server in a Linux Docker Container: Maximum size recommendation

Total docker noob here. Please forgive me for the lengthy post. We are currently use SQL Server 2019 on Windows for our database. In an effort to "dockerize" the applications and database in ...
0
votes
0answers
19 views

debain execute msyql_install_db failed. mysqld: Got error 'Can't create file' when trying to use aria control file

Question I want to run a mysql server standalone. When I try to initialize a new mysql data directory by run msyql_install_db --defaults-file=my.conf --user=mysql, It said that I have no enough ...
1
vote
1answer
20 views

Mysql 8 which linux / Unix Distro would have better performance (2021 topic) [closed]

I want to setup a mysql 8 with MyRocks engine and BUILD from source with my custom parameters. Is there any recommendation on which linux / unix distro would have better performances ? CentOS stream ...
3
votes
2answers
120 views

Importing a 16 GB MySQL file silently fails

I've looked at a lot answers here MySQL any way to import a huge (32 GB) sql dump faster? and on Server Fault but haven't found a solution to not being able to import a 16 GB MySQL file completely; it ...
0
votes
3answers
73 views

JDBC oracle listener random port

I have an issue with our listener trying to assign random ports to JDBC connections. We have a 19c oracle db running on a RHEL server with two ports opened 1523 and 1524. When application tries to ...
0
votes
0answers
49 views

Is it neccesary to shutdown the oracle database before uninstalling

I have a requirement of deleting/uninstalling a installed oracle 11g database on a Linux machine and I follow the below steps to uninstall the database. Kill all processes runs with user oracle. ...
0
votes
1answer
115 views

How to configure Oracle19c to use case-insensitive passwords?

How can I make Oracle19c accept case-insensitive passwords? That is, I want "mypAsswOrd" password to serve as "MyPaSsWoRd" or "MyPassword".
1
vote
2answers
56 views

DB2 Linux authentication fails

I have DB2 Express-C v10.5 instance configured to authenticate against LDAP. The LDAP sever is going to be shutdown and I should configure the same DB2 instance to use Linux authentication. I copied ...
1
vote
2answers
83 views

GRANT command not working on MySQL 8.0.25

I'm attempting to grant a user privileges within a database, and I'm receiving the error #1410 - You are not allowed to create a user with GRANT I'm executing the following: GRANT ALL PRIVILEGES ON `...
0
votes
1answer
49 views

PostgreSQL + how to clean pg_xlog log without damage the PostgreSQL service

we are using postgresql for ambari DB , in our linux server - rhel 7.2 postgres -V postgres (PostgreSQL) 9.2.13 we noticed that pg_xlog folder consuming 198g , and its gives /var to get 100% size so ...
0
votes
2answers
39 views

How to set user-based .psql_history in linux?

If use postgres in linux, it has a postgres user. So when use psql from this user, it will generate a .psql_history file under this user - /home/postgres/.psql_history. When set many users on the ...
0
votes
0answers
30 views

Cannot change MySQL tmpdir, error on MySQL Restart

This morning I attempted to Optimize a large database (3gb+, 10m rows+). My /tmp folder filled as it was only 600mb. Now my table is corrupt and inaccessible until I repair the table. I've read that I ...
1
vote
1answer
44 views

Oracle Linux 6.10 - Changing the Oracle user's ID & GID

OS: Oracle Linux 6.10 DB vers: 12cR1 I will backup and restore from NFS shared disk for a preprod server. However, the ID and GID of the oracle user on the production server (shared disk on ...
0
votes
0answers
15 views

How to configure non-mysql user for datadir in MySql/MariaDB?

Using it for testing purposes and the NFS datadir will be accessed by two or more non-concurrent independent mariadb-servers. So far, mariadb only permits if its this way: chown -R mysql:mysql /data/...
0
votes
1answer
460 views

psql: warning: extra command-line argument "postgres.dolphin.com" ignored

when I using this command to copy table video from database dolphin to database acientbay in Fedora 32, shows error like this: /usr/share/postgresql-13/bin/pg_dump -v -t video -h postgres.dolphin.com -...
0
votes
1answer
69 views

Oracle 11g TDE wallet autologin

I have setup Oracle TDE for my 11.2.0.4 database. I created the wallet. I created the autologin wallet and everything looked good. {ORACLE_HOME}/bin/orapki wallet create -wallet cwallet.sso -...
0
votes
1answer
19 views

Oracle 11g Encryption

Can somebody please tell me how to encrypt an existing tablespace in 11g? The wallet has been setup and the sqlnet.ora points to it. SQL> select STATUS FROM V$ENCRYPTION_WALLET; STATUS -----------...
0
votes
1answer
101 views

How to create SQL Server backup from Windows Server to Linux Client with SQLCMD?

I've got sqlcmd installed on an Ubuntu LTS instance and I'm able to connect successfully to Windows SQL Server and do queries and such. sqlcmd -S 192.168.0.100 -U SA -P secret I need to be able to ...
1
vote
1answer
313 views

Column count of mysql.proc is wrong

Im attempting to deal with a corrupted database with little success, when I try to alter this table I am giving the error Column count of mysql.proc is wrong Looking up this error online gives me ...
0
votes
1answer
33 views

Mysql 8 tables size

We have a problem with an unreasonably large table size on the server, for example: Yesterday, a table with partitions was created, data began to be written to a specific partition. mysql> show ...
-1
votes
1answer
34 views

Why do I get this error on setting up an administrator user on Griddb?

I am trying to set up an administrator user on gridDB by the following command: gs_passwd admin and I got this error: A00105: GS_HOME, GS_LOG environment variable not set So what should I do?
1
vote
0answers
18 views

TDE error when attempting to encrypt a datafile

I'm encountering error ORA-28374: typed master key not found in wallet when attempting to run alter database datafile '+DATA/testdb/datafile/users.2514.1233355332' encrypt; against an 11g database ...
0
votes
1answer
30 views

How do I know my Oracle database is correctly configured and running?

I've installed a fresh Oracle 19.3 on Linux CentOS 8.3. I used the install steps (manual install) from this official Oracle guide. I tried to start the DB using the standard script: [oracle@localhost ...
0
votes
0answers
113 views

Why root user cant write to sqlite?

I have a sqlite data base with the full permissions: -rwxrwxrwx 1 ibse ibse 21504 кві 15 16:26 mydb.dat* When I try to insert into it from the root user, the error attempt to write a readonly ...
0
votes
1answer
99 views

Reset Root Password MySQL on Ubuntu

I know there are tons of posts about this on here but nothing seems to work. I have tried every command I could find it will not work. I just recently setup mysql on Ubuntu (SQL version is 8.0.23-...
0
votes
1answer
112 views

'Could not fsync file' while running VACUUM FULL on a table

I'm getting an error for around half of my tables in Postgres while trying to run VACUUM FULL. For example, I have a table named 'qwerty', and when i try to vacuum it i get the following error: ERROR:...
0
votes
1answer
12 views

Database not showing

I create a database in the terminal linux ubuntu,gave it all privileges,created the table,inserted the rows.When I open phpmyadmin the database isn't showing how do I connect them? I did use mysql -u ...
0
votes
0answers
38 views

Can I safely delete /var/log/messages-20210328 which is 383M under / directory ? OS version:Oracle Linux Server 6.7. db version Oracle 11g

the content of file is displayed using # cat /var/log/messages-20210328 Output: Mar 21 04:31:11 testdb snmpd[17566]: Connection from UDP: [*.*.*.274]:61775->[*.*.*.*] Mar 21 04:31:11 testdb snmpd[...
0
votes
1answer
80 views

mysqld_pre_systemd fails when starting MySQL on Fedora

I installed MySQL using dnf (I'm on fedora) and from the officials rpm on the website. Both had the same problem : I have an error when I do systemctl start mysqld.service. So I checked systemctl ...
0
votes
0answers
38 views

SQL Server 2019 on Ubuntu Throwing security.crypto.symkey errors

I'm repeatedly seeing the following error, seemingly for every connection to SQL: 04/06/2021 16:39:25.890647613 Error [security.crypto.symkey] <0000004241/0x00000c34> Setting Variable Length ...
-1
votes
1answer
99 views

Linux PostgreSQL mount data from external ntfs disk [closed]

I have similar problem as here: Postgres tablespace on mounted usb I want to have access to my DB on external hard drive from Raspbian and Windows 10. Not simultaneously. I just want cross-platform DB ...
0
votes
2answers
1k views

mysql: [ERROR] unknown variable 'default-authentication-plugin=mysql_native_password' [closed]

When I installed MySQL 8.0, I selected sha256 password authentication method instead of legacy, When I tried to return to native password authentication it shows an error message: mysql: [ERROR] ...
0
votes
1answer
48 views

sqlcmd is running but database shown no running query

We are facing this weird issue on our Azure setup. The database is SQLServer and client is CentOS. We fire queries using sqlcmd. Sometimes it happens that you see the sqlcmd running, but there is no ...
0
votes
1answer
73 views

postgresql + how to recover the wals files

we have postgresql version 9.x on rhel machine , postgresql is the DB of the ambari server some of the files under folder - /var/lib/pgsql/data/pg_xlog was deleted by mistake from total 487 files only ...

1
2 3 4 5
19