Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
989
questions
0
votes
1
answer
387
views
SQL Server Ubuntu server - failure: remote connection from Win 7
Our analytical lab (chemistry) has an information management system (LIMS) that uses a Microsoft SQL Server database. Technicians interact with the system through a Windows form application that is ...
- 11
1
vote
1
answer
386
views
Can we create SQL Server Aliases in Linux clients?
Can we create "Server Aliases" in Linux clients (webservers etc.) so that you can change connections without touching the application's DB URL string?
The official documentation seems to ...
- 849
0
votes
0
answers
3k
views
MySql, Starting XA crash recovery [closed]
Mysql server crashed on my ec2 server, Sometimes it works without problems and sometimes it crashes suddenly, which causes bugs in my project.
My Server Details
Ubuntu 20.04.1 LTS
1 GB Ram
This is ...
0
votes
1
answer
136
views
What parameters should be modified after upgrading RAM memory in Oracle server
I have a linux server (rhel4) with oracle 9i (9.2.0.8) to which we have recently upgraded the RAM memory from 4G to 16G. I would like to know what server parameters I should modify and even more what ...
- 149
0
votes
1
answer
5k
views
How many parallel workers can I have on Postgres?
I working on a server with Ubuntu, 320 GB SSD, 6 cores and 16GB Ram, but Postgres is having issues some queries that take very long time to run, and with parallel queries, that are increasing the ...
0
votes
0
answers
13
views
Sharing MySQL data folder between Windows and Linux [duplicate]
I have dual boot laptop with Windows 7 and Linux. I've been working for a long time on Windows programming in php / Apache / MySql. I share NTFS partition with Linux which is mounted using ntfs-3g, it ...
2
votes
1
answer
2k
views
I have 600% high CPU usage mysqld
I have an insane usage of cpu mysqld +600% here is the file my cnf
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an ...
Alfredo
1
vote
2
answers
83
views
Deleting Duplicates - mariaDB
I have a mariaDB database containing details about user devices (sort of an 'allowed device' list for VPN access). Back when the project started, there was no restriction on what devices were allowed ...
- 23
1
vote
1
answer
8k
views
Can we enable tls 1.0 on MSSQL Server 2019 on database level? if yes then how?
i am running sql server 2019 on Linux box and trying to connect using a Windows server 2016 client, how can we enable TLS 1.0 for SQL Server 2019 on the Database/instance level.
TIA.
Rafay Pervaiz
0
votes
1
answer
417
views
MySQL in Ubuntu Linux - I cannot connect to the server
I am new in MySQL. I installed Workbench and server. When i try to connect to the database server i receive a message: Your connection attempt failed for user 'root' to the MySQL server. Ann AppArmor ...
keanu
2
votes
1
answer
139
views
MySQL Client can Connect but Replication Slave Can't
We have an odd issue we've never come across. We have roughly 14 pairs of master/slaves all running MySQL 5.6.35 without issue. We are trying to add a slave to a slave (which we have two other ...
- 133
2
votes
0
answers
12k
views
InnoDB Failing to start / MySQL not loading plugins
I installed MariaDB on my system (Debian 9), however, upon running sudo service mysql start, I get these errors:
Sep 22 12:32:37 bremea mariadbd[30151]: 2020-09-22 12:32:37 0 [Note] /usr/sbin/mariadbd ...
- 21
1
vote
1
answer
2k
views
Oracle - Delete dmp files from ASM diskgroup
I want to delete my export files daily from ASM diskgroup with a crontab job. I want to prepare a script for it.
ASMCMD> ls
exp1.dmp
exp2.dmp
exp3.dmp
exp4.dmp
ASMCMD> pwd
+DATA/EXP
How can I ...
- 55
1
vote
3
answers
2k
views
MariaDB master to master replication auto increment is not sequential
I have two master to master MariaDB server replication with the below settings:
server A with 192.168.1.100:
------------------------------
bind-address = 0.0.0.0
server-id = 1
log-...
- 13
-1
votes
2
answers
1k
views
How can Postgresql use more of the total RAM?
I'm trying to undertstand how Postgresql's (v9.1) memory usage relate to the overall Linux memory.
When I look at htop, I see that the system is using about 60GB out of a total of 256GB RAM. That ...
0
votes
1
answer
472
views
Sql server cpu usage is 140%
I run Sql server instance and a dot.net core app on the same server for a while and today is the first time I came across with this issue, my website doesn't get data from the server and it gets this ...
- 1
1
vote
0
answers
171
views
oracle sqlcl and sqlplus - seperate login.sql on linux
I feel I'm probably missing something obvious here, but I can't see an easy way to have a separate login.sql for sqlplus and sqlcl
This is problematic for me as the errors thrown up by sqlplus for the ...
- 135
0
votes
1
answer
635
views
Why is Postgres service failing?
I'm setting up a ManageIQ appliance for development. When I updated the 'v2_key' encryption key to be same as production, my db connection croaked. Initially I got these errors:
Aug 31 13:26:59 miq-...
- 103
0
votes
1
answer
619
views
How to install HANA DB on Oracle Linux 7?
I want to know how to install SAP HANA DB 2.0 on Oracle Linux 7 including downloading, installing and the first connection establishing to the system from network. I've spent a few hours to find out ...
- 275
2
votes
1
answer
11k
views
Retrieve or reset the password for PostgreSQL on Linux
I have installed Postgres on my Linux system. I forgot the admin password I want to reset the password. How can I do that?
kumkum kumkum
2
votes
1
answer
7k
views
My Mariadb fails and shuts down after running with a timeout
My Mariadb version is
$ mysql -V
mysql Ver 15.1 Distrib 10.3.23-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
My machine is a ubuntu server:
$ uname -a
Linux mypc 5.4.0-42-generic #46-...
- 43
0
votes
1
answer
208
views
RMAN Backups - Can more than one media management software solution be used?
Does anyone know if it's possible for two different backup utilities to be used to backup the same Oracle database? Both utilities would use RMAN.
So, for example, take an Oracle 11g standby DB with a ...
- 51
-1
votes
2
answers
517
views
How to create a same user in different PDB while it exists in other PDBs?
I have a list of 100 PDBs in the CDB, say the account_user exists in 50 PDBs and to create the same account_user in other 50 PDBs instead of logging into each PDB and creating user, is there a way to ...
1
vote
1
answer
364
views
Using SQL*Plus to connect to remote DB from local server, how do I export a backup to my local server?
I am trying to have my entire remote DB backup made to my local server.
Running the following command from my local server: expdp \"user/user@ip as SYSDBA\" full=Y directory=/backup/backup/ ...
- 13
0
votes
2
answers
808
views
A Remote GUI for PostgreSQL [closed]
I've installed PostgreSQL 12 server onto an Ubuntu 20.04 server, but I want to access it using a GUI from my Kubuntu 20.04 laptop. I'd be interested to know any options for GUI administration.
I have ...
- 133
4
votes
1
answer
5k
views
Is there a way to automatically upgrade DBeaver?
I am trying to update DBeaver Community Edition 7.0.3 to (currently) newest 7.1.0 edition on Fedora 30. When I start DBeaver a "Version Update" window pops up with buttons as options to Upgrade and ...
- 232
0
votes
1
answer
87
views
RMAN Disk Backups
I have to run RMAN full backups of my 11g Oracle DB to disk. As part of that process the backups will all be changed to have a backup tag of 'UNAVAILABLE'. This is because the filesystem location of ...
- 51
0
votes
1
answer
703
views
Not able to access Oracle manager online. Port 5500 is closed [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
1
answer
6k
views
[[FATAL]] [[DBT-06103]] The port (5,500) is already in use [duplicate]
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-...
1
vote
2
answers
911
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 ...
2
votes
1
answer
203
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 ...
- 21
0
votes
0
answers
101
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. ...
- 181
1
vote
1
answer
312
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 ...
- 113
0
votes
0
answers
2k
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 ...
- 101
10
votes
2
answers
1k
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 ...
- 323
0
votes
1
answer
17
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
0
answers
5k
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 ...
Julie
2
votes
1
answer
1k
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....
1
vote
0
answers
1k
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 ...
- 11
0
votes
1
answer
486
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
1
vote
2
answers
2k
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
- 11
0
votes
1
answer
2k
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 ...
- 3
0
votes
0
answers
276
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 ...
- 1
0
votes
1
answer
93
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 ...
Divik Shrivastava
2
votes
1
answer
600
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
...
- 21
0
votes
0
answers
733
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 ***************************
...
- 1
4
votes
1
answer
806
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 ...
- 143
0
votes
1
answer
2k
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 ...
- 1,910
0
votes
1
answer
58
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
2
answers
1k
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
H.Burak