Questions tagged [linux]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
8 views

Not able to access Oracle manager online. Port 5500 is closed

I am using Oracle 18c XE on CentOS 7. The database installed successfully but not able to bring it online to my hostname. what I did is: Added port 5500 in firewall: firewall-cmd --permanent --add-...
0
votes
1answer
18 views

[[FATAL]] [[DBT-06103]] The port (5,500) is already in use

I am trying to install oracle 18c XE on CentOS 7. I have opened the ports: firewall-cmd --permanent --add-port=1521/tcp firewall-cmd --permanent --add-port=1630/tcp firewall-cmd --permanent --add-...
0
votes
0answers
6 views

Mismatch of postgresql versions

I installed rh-postgresql12 in my server. These are the steps I used to install and enable it and its dependencies : Installation : yum -y install rh-postgresql12 rh-postgresql12-postgresql rh-...
0
votes
0answers
9 views

Connecting to mysql db server from a remote server to a local machine

As per my understanding, there are two main things to check before connecting to a remote mysql db server. 1. Bind address. 2. Grant privileges. I was able to connect to a remote mysql db server ...
1
vote
2answers
33 views

Alternative to SQL Server Management Studio and Azure Data Studio to initially change my password

Background I'm having to connect to a customer's Microsoft SQL Server. I generally don't need to do much in databases besides your average SQL, so using the database features in IntelliJ IDEA have so ...
1
vote
0answers
20 views

mssql suddenly cannot access physical file

SQL server 2019 on Centos 7 x86_64. It was running fine for quite long time, then got broken. I was not doing anything special, neither update or restart or whatever. At some point the database went ...
0
votes
1answer
19 views

Methods for tracking processing time for long running ADD INDEX call in MySQL

I've set off index creation on a very large table in MySQL and while I expected it to take a long time, I'm 5 days in and wondering if there's any way to debug potential issues or simply let it run. ...
1
vote
1answer
24 views

What is the correct way to define and query a 3NF Associative entity

A subset of my database contains the tables contacts, networks and networkContacts which is my associative entity. I have defined it using a composite primary key composed of the primary keys of the ...
0
votes
0answers
29 views

DB query failed: SQLSTATE[HY000] [2002] No such file or directory

Bit of background as this may be important to this error. I have a VPS and I use the Plesk control panel, I recently upgraded my VPS, which caused my partition storage to be full, this was the first ...
0
votes
0answers
10 views

How to update MariaDB Timezone data

I know I can install timezone data to MariaDB by mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql MySQL document of the DB should be restarted. Is there any method not to? After ...
8
votes
1answer
306 views

Is it possible to restore a SQL Server Linux Backup on SQL Server Windows

I am running SQL Server in docker on a mac. I have taken a SQL Server backup from windows and restored it in the mac SQL Server docker instance. Now I want to take a backup from the SQL Server docker ...
0
votes
0answers
10 views

sudo systemctl start mysql hangs linux ubuntu

I'm having a very difficult time with a mysql error where I am way out of my depth and would appreciate any help. I am using a linux ubuntu server where I am trying to start a previously working mysql ...
0
votes
0answers
11 views

MASTER-MASTER repliation

MySql in master A ceate user after using replicate-do-db filter on Master A, that user is not showing on Master B by this query-------select User from mysql.user; how to completely access both ...
0
votes
0answers
2 views

Cannot see text after exiting mongodb connection

This is probably linux OS question... But if I press CTRL+C after connection try to mongodb, I cannot see text inserted afterwards [userName@serverName ~]$ mongo admin --host localhost --port ...
0
votes
0answers
87 views

psql: could not connect to server: No such file or directory, allowing communication over TCP/IP, ubuntu 18.04

I was installing postgres on Ubuntu 18.04 the command line I used for installation is: sudo apt-get install postgresql postgresql-contrib since I have entered this command line a couple of times, I ...
1
vote
1answer
65 views

SQL2019 CU4 PWAIT_EXTENSIBILITY_CLEANUP_TASK

I'm running SQL2019 CU4 Linux and seeing a high number of PWAIT_EXTENSIBILITY_CLEANUP_TASK. Can anyone share their insight on what this wait type means and how we can reduce it? Select * from sys....
0
votes
0answers
24 views

Postgres Replication - WAL sender throw connection reset by peer

Good morning everyone, I hope containment is going well for you. For my part, I use this time to set up a Postgres 11 cluster on my servers, but I have some problems. Can you help me? I've got ...
0
votes
1answer
26 views

For SSL renewal procedure in Db2 LUW , DO i need to create CSR request for each instance residing in same server?

I am trying to renew my SSL certs . Stuck here if we need to have create a Certificate Signing Request for each instance residing on the same server and send it to CA who will provide us the ...
1
vote
2answers
23 views

deleted the /var/log/mysql folder

Due to a mistake i deleted the log folder for mysql. Is there a way to generate the folder and the error logs? I'm using MariaDB 10.3 on Debian 9 Stretch
0
votes
1answer
24 views

SQL Server Linux(Ubuntu) Connection Options

In general SQL Server Connection Protocols allows three different connection protocols: TCP/IP Named Pipes Shared Memory in linux by default installation we can connect to the SQL Server ...
0
votes
0answers
37 views

Maximum concurrent users on linux server

I have a dedicated server with these info: 128G RAM 6 cores/12 threads CPU, 3.4GHz 512 SSD storage WHM/Cpanel latest Apache/MySQL Centos 7.x I have a single website on this server which have heavy ...
0
votes
1answer
20 views

How to remotely run commands for a DB2 instance, preferably using ibm_db?

My objective is to see the size of Audit Buffer size, normally I would use below command on my Db2 instance db2 get database manager configuration | grep AUDIT_BUF_SZ But now I need to do it ...
0
votes
0answers
24 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 *************************** ...
3
votes
0answers
126 views

MSSQL Ubuntu Unexpected call to legacy ABI

We recently had a Ubuntu 16.04 server loose power. After restarting the server I noticed that MSSQL Server was no longer running due to a an error Unexpected call to legacy ABI. After researching for ...
0
votes
1answer
20 views

Shell script - psql run multiple statements from a variable one by one in one transaction

Im preparing a shell script to generate analyze command and all the commands will go to a variable. echo $analyze_query analyze tbl1; analyze tbl2; analyze tbl3; Now I want to run one by one, and ...
0
votes
0answers
6 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 ...
1
vote
2answers
55 views

What is the recommended my.cnf settings for 32 GB Server

I am just moving my website to a new server and ı want to know what is the recommended settings for 32 GB server? Mysql tunning for my old server (16 GB) https://pastecode.xyz/view/577e824e
0
votes
2answers
33 views

RMAN incremental restore

Can you anyone tell me if it's possible to restore an 11g Oracle database using media management software like Net Backup or Commvault incrementally? I need to perform a restore of a DB into a new ...
3
votes
1answer
70 views

Should I disable filesytem journaling for MS SQL Server (Linux/Windows)

For a PostgreSQL server installation on Linux, it is beneficial to disable filesystem journaling. Tip: Because WAL restores database file contents after a crash, journaled filesystems are not ...
0
votes
1answer
24 views

Benchmarking set up over HDD+SSD combination? [closed]

I have a Linux system set up (Arch) on an HDD. I have been trying to benchmark some of my queries and found some disk IO bottleneck, and thus opted to move the entire PostgreSQL database from the HDD ...
0
votes
2answers
91 views

Lock table size issue when deleting on MySQL

I'm attempting to delete errant records from a table based on certain dates and running into the following error: mysql> delete from myTable where dataDate in ('2011-07-12'); ERROR 1206 (HY000): ...
0
votes
2answers
37 views

Mysql - Replication of multiple database

I'm trying to do a redudancy with Mysql. I'm making master-master. I'm very happy because it works with one database. When I add something in a table, it's added on the table of the second server. The ...
0
votes
0answers
52 views

Loading 260GB worth of CSV into MySQL in Linux

I'm bulk loading a few thousand CSVs totaling ~260GB and ~4.5 billion rows to MySQL using mysqlimport calls on each CSV executed within a bash script. The MySQL installation and the data itself are ...
0
votes
1answer
29 views

MySQL using up all RAM and SWAP in group replication settings

I am using MySQL 8.0.18 in a group replication (multi-master) infrastructure. There are currently 4 master servers connected to each other and everything seems to be working fine but over the course ...
0
votes
1answer
19 views

ssl with postgresql 12

I tried following the docs for the same. It says postgres.conf will have service.crt for ssl_cert_file, but it has /etc/ssl/certs/ssl-cert-snakeoil.pem and now I can't proceed with it. Any insight ...
0
votes
0answers
57 views

Setup certification for SQL Server running on Debian

I have successfully setup an instance of a SQL Server 2017 instance on the latest Debian release, and a domain that points to that server, and I have gotten the respective certificates by using ...
0
votes
1answer
106 views

Oracle 12cR2 - Problem When Creating Database Using DBCA

OS: Oracle Linux 7.7 Users: root, grid, oracle, userwithmyname Installed softwares: grid infrastructure with asm in grid user, Oracle 12cR2 in oracle user I created a database in my grid user. It ...
0
votes
1answer
88 views

Unable to attach SQL Server database with shared folder in docker on Linux

The problem I'm having is that my SQL Server 2017 Linux container is not able to read my database files. I guess it has something to do with permissions and I'm sure I've overlooked something but I ...
1
vote
1answer
34 views

Backup and restore for PostgreSQL + why number of backups increased while we limit the recovery window of 7 days

We are using the barman for PostgreSQL backup and restore on rhel 7.2 machines In the barman configuration file - /etc/barman.conf we set the following retention_policy_mode = auto retention_policy ...
0
votes
0answers
15 views

trying to configure Impala driver with Squirrel SQL

I am trying to configure the Impala driver for Squirrel SQL on Debian 10. I downloaded the Cloudera JDBC driver from here: https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-4.html and I ...
0
votes
1answer
86 views

MySQL ERROR 1064 (42000) insert via bash script (RHEL)

MySQL Server: 8.0.16 Commercial OS: RHEL 7.5 I have written a simple script, to insert certain information into a database table. Following is my script # cat ~mysqldba/bin/connections.sh #!/...
0
votes
1answer
24 views

Using Management Studio on Linux [closed]

Is it possible to use Management Studio in Linux? I want to connect to my SQL Server instances with an IDE. How can i do that?
0
votes
2answers
205 views

linux mysql case insensitive lower_case_table_names=1 make server cannot be started

I use mysql in linux ubuntu an I want to set lower_case_table_names = 1 in /etc/mysql/my.cnf file. But after I inserted the variable, the mysql server cannot be started. o Is there any way to set ...
2
votes
1answer
56 views

How to migrate SQL Server 2014 to SQL Server 2019 on Linux using AG [closed]

I would like to migrate SQL Server 2014 on Windows to SQL Server 2019 on Linux using while running AG. Is there an option to Add the SQL Server 2019 to the same AG and once the time comes gracefully ...
1
vote
0answers
430 views

InnoDB: Error: Table “mysql”.“mysql.transaction_registry” not found after upgrade to mariadb 10.3

I've upgraded the mariadb to 10.3 packages on my Debian 10, however something went wrong and I ended in the same issue which is mentioned several times Cannot open table mysql/innodb_index_stats [...
1
vote
1answer
101 views

Restoring a MS SQL Server database on Linux

I am running Manjaro Linux and I am trying to restore a Microsoft SQL Server database from a .bak file. I am trying to follow the official documentation, but it doesn't seem to work! ➜ ~ sudo ...
0
votes
0answers
81 views

Restore database with .idb .frm and logfiles

I recently had an error with my SD card inside my RaspberryPi4. (I'm very inexperienced with databases as well.) So this means that I have to restore my database. What I did was copying all the files ...
0
votes
1answer
36 views

Running the .sql script in Linux to get the postgresql database table and functions

I am using Red hat Centos 7. When I use this command to run the .sql script to get postgres database table and fucntion: $sudo psql -U postgres -d tsdb -W -f /.sqlscript/location It asks for postgres ...
0
votes
1answer
104 views

Oracle 12c installation : reference data is not available for Release “12.1” on the operating system distribution "Linux4.12.14-94.41-default

We are trying to install Oracle 12c in Suse Linux 12.4. As soon as we start the installation, it fails saying [INS-13001] Environment does not meet minimum requirements When we checked the log, we ...
0
votes
0answers
21 views

No logs generate in audit.log file with audit plugin in MySQL in Linux?

No logs generate in audit.log file, even though: SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'audit%'; gives: | PLUGIN_NAME | PLUGIN_STATUS | +----------...

1
2 3 4 5
16