Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [linux]

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

1
vote
0answers
18 views

Asynchronous availability groups not synchronizing on SQL Server on Ubuntu

I installed SQL Server 2017 on Ubuntu and setup an availability group with cluster type = "None". I set the "Availability" Mode to "Synchronous commit" and tested it. It works fine. All transactions ...
1
vote
0answers
24 views

Cannot systemctl start/stop mssql. mssql-server stuck in script upgrade mode. Cannot login either

I'm having trouble getting my mssql-server back online. Apparently it got stuck between an upgrade and a bad database restore, and now it is stuck, and I nothing I've tried has helped to unstuck it. ...
1
vote
1answer
40 views

SQL Server Management Studio Doesn't do “Full” Backup

Very new to SQL Server. I'm trying to bring a backup from one our clients Windows 2012 Server Install to our Linux Install. We have the site working perfectly on Linux, but can't seem to do an ...
1
vote
1answer
23 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
0answers
31 views

drop_cache effects on database

I have several machines with: databse: db2 10.5 OS: CentOS 6.9 on some of machines cached memory is high and i need to run this command to free some memory: echo 3 > /proc/sys/vm/drop_caches ...
0
votes
1answer
44 views

Master Master replication rows not sync properly

I have a wordpress website that run on 3 machines Machine1 | Machine 2 {nginx+lsyncd+mysql} visitor > cloudflare > haproxy ------ ...
1
vote
2answers
61 views

Possible make mysql faster

Process 3 Million rows data for every 5 minutes. Data flow: LoadData from network to tmp table. Do some kind of group up and save to ~10 different table. Max 7 session running for saving data to ...
0
votes
2answers
45 views

Error 5123 when creating a database with my SQL Server on Linux

I followed the steps of this MS Guide and I managed to run a localdb and create a Testdb with this script: CREATE DATABASE Test ON (NAME='Test_DAT', FILENAME='/home/dlag/Documentos/Proyectos/...
0
votes
1answer
22 views

Using AMMM or Huge Pages for Oracle 11g R2 Database

I'm running an Oracle production 11gR2 database which has around 65Gb of data, running with a 4Gb SGA & 40Mb PGA using ASMM. Now, I have a memory increase up to 32Gb. I'm planning to increase ...
0
votes
0answers
29 views

SQL Server 2019 Developer Edition on Ubuntu 18.05 Linux seems to only use one processor

I set up this db on an old server that has Ubuntu 18.04 in order to test some new features of SQL Server 2019. First time running SQL Server on Linux. I am running an intense query and happened to ...
4
votes
1answer
169 views

best way to run sql server management studio on linux

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker. I want to use sql server management studio to manage the server. SO far now, I have a windows 7 enterprise with with ...
0
votes
2answers
72 views

Issue migrating from SQL Server 2008 R2 to SQL Server 2017 Standard (on Linux)

I am currently trying to carry out a database migration from SQL Server 2008 to SQL Server 2017 (Linux) using the DMA tool. I get the all green after running the assessment, however I get hit with ...
1
vote
1answer
61 views

Linux SQL Standard Edition being killed by OOM killer

We have launched Linux with SQL Server standard edition for production environment, but the memory restriction feature in SQL Server is not working properly. The server has a total of 32 GB of RAM. ...
0
votes
2answers
65 views

MySQL performance tuning related connection

I am running openstack cloud and it use mysql database which is MariaDB 10.1.30 I am sometime seeing connection reset from multiple clients, to trying to find out what is going on in database, I am ...
0
votes
0answers
20 views

SSL certificate is not sent to MySql Server while connecting from MySql C connector

I am writing a C program to communicate to MySql server (running on linux) as root, for whom REQUIRE SSL is set. In this program I am using following function call (from libmysqlclient.so) to set SSL ...
0
votes
0answers
21 views

mysql pointing to 0:-1 partition

We have a Galera cluster on 3 nodes. On one of the nodes with SAN storage we experienced slowness in the cluster. iotop in the node with SAN storage shows that mysqld pointing to 00000...:-1 ...
2
votes
1answer
164 views

How to lock a MSSQL (2017 Linux) account after N unsuccessful login attempts

I have to configure account lock after N unsuccessful login attempts on MSSQL 2017 Linux. That is standalone server and is not in AD. I couln'd find any valuable information so far unfortunately. ...
-1
votes
1answer
151 views

Restore database - Operating system error 5(Access is denied.) on Linux

I try to restore SQL Server 2017 Express database using sqlcmd tool on Ubuntu 16 Server. My SQL command is: RESTORE DATABASE [xxxxx] FROM DISK = N'/home/xxxxxx/DBBackups/xxxx.bak' WITH NORECOVERY, ...
1
vote
1answer
134 views

ORA-48108 / ORA-48140 / ORA-48187 - diagnostic_dest value error(s) - init files / control files

This is all testing / training - none of this is related to a production env Using ORACLE DB 12c + UNIX/LINUX 64-bit on an VM. . Hi Guys! I am running in the below error(s) and seem unable to ...
0
votes
1answer
32 views

Would installing 32 bit packages on the existing 64-bit VM be an option to run Oracle 9.2?

I inherited an old old 9i DB that now needs recovery. It is unstable (disk corruption and performance problems). I have a backup. In the interest of time - I have 64-bit VMs all over the place, but ...
0
votes
2answers
103 views

Special Character in password

I'm Trying to connect to a remote DB using Sqlplus, but the password contains a special character (!). The SID is working fine, but Sqlplus is complaining about it when I use the ! in the password /...
0
votes
0answers
16 views

Connection lockup on syntax error Postgresql 9.5 on Ubuntu 16.04 server

I have postgresql 9.5 running on my server with mostly default configuration. Whenever I'm connected to the server through localhost or 127.0.0.1 postgres fails to return the error, be it a simple ...
0
votes
0answers
34 views

MariaDB Galera journalctl

I've noticed something weird. I have 3 nodes galera cluster, installed using mariadb. I'm pretty sure that I did all three nodes installations exactly the same. All three nodes display their --...
1
vote
1answer
128 views

How to format the output of SQL queries on SQLCMD for SQL Server 2017 on RHEL Linux 7.3?

I have installed SQL Server 2017 on RHEL Linux 7.3, and using SQLCMD utility for querying the SQL Server. When I try to query for example: 'SELECT * FROM SYS.DATABASES'. I get output like the ...
0
votes
0answers
104 views

max_stack_depth not changed even stack changed in limits.conf

The attempt of making changes to max_stack_depth using select set_config('max_stack_depth', '512MB', false); because of the error shown in postgresql log: DETAIL: "max_stack_depth" must not exceed ...
0
votes
0answers
17 views

Tables missing from MySQL database after removing then restoring the mysql data direcory

I Carried out the following operations. make mysqldump of testdb # Stop service /etc/init.d/mysql stop # Create copy of directory cd /var/lib cp -R mysql mysql.backup # Delete datafile on disk rm -...
-1
votes
1answer
36 views

DB2 reporting incorrect filesystem full error? [closed]

DB2 V10.5, RHEL 7.5 We had an issue when DB2 was stuck not being able to write log files to disk because of disk full error just that there was more than enough free disk space on the filesystem ...
0
votes
0answers
94 views

SELECT … INTO OUTFILE “Read-only file system” error

I'm using MariaDB 10.3.12 on CentOS 7, using the MariaDB-server RPM package from MariaDB's yum repository. I'm trying to do a simple SELECT ... INTO OUTFILE into a different directory than /var/lib/...
1
vote
1answer
334 views

Error Code: 1728. Cannot load from mysql.db. The table is probably corrupted

Whenever I try to do a DB query with a particular DB user (myuser) I get the following error: Access denied for user 'myuser'@'localhost' to database 'mydatabase' [1044] I decided to check the ...
2
votes
0answers
88 views

2 SQL 2019 Servers with High Availability Linux with a shared Linux SQL Express 2019 Witness

Is it possible to have two SQL Always on High Availability servers in datacentre A replicating to two servers in datacentre B with one Witness using Express with two availability groups (one for each ...
1
vote
1answer
84 views

Unlock user shell script for Oracle

We have so many user ID locks from the front-end users. We need to provide a shell script to the user which they can run on OS level and unlock the ID themselves when the DBA is not present. The sys ...
2
votes
0answers
66 views

SQL Server stored procedure not throwing certain kind of error

I noticed an issue in my app recently where an database insert that occurred in a stored procedure was failing, but no exception was getting thrown. The insert failed because a column that doesn't ...
3
votes
1answer
74 views

When I run mssql-cli, I get “No module named mssqlcli”

I just installed mssql-cli with pip, pip3 install mssql-cli Then I try to run mssql-cli and I get $ mssql-cli /usr/bin/python: No module named mssqlcli
1
vote
0answers
48 views

Impdp (Oracle 12c) on Ubuntu 16.04

I am trying to import a dump into Oracle 12c by using the below command: impdp SROUSER/<password> directory=dump_dir dumpfile=SROUSER.dmp logfile=dp.log full=yes Which is resulting in the ...
0
votes
4answers
131 views

Group Replication plugin crashes MySQL 8.0

Problem description: INSTALL PLUGIN group_replication SONAME 'group_replication.so'; results in ERROR 2013 (HY000): Lost connection to MySQL server during query Specs: MySQL version: 8.0.13 ...
0
votes
3answers
331 views

How to set listener.ora and tnsnames.ora for oracle instances

I set listener.ora and tnsnames.ora, but I do not know if it is well set up. When I call the lsnrctl status command, I get instances rcadb and proddb unknown. I'm a beginner in Oracle, I installed ...
0
votes
0answers
112 views

How to enable remote debugging of Stored Procs with MSSQL Linux Docker container?

I'm running the latest SQL Server docker container from DockerHub in a Linux environment. Port 1433 is forwarded from my container, and everything is working fine. However, when I have tried to ...
0
votes
0answers
21 views

Mysql no longer working and cannot reinstall

I am on ubuntu 16.04 and my mysql connection to local database suddenly stopped working one day, I then tried various things to fix it, but then came to trying to completely remove and reinstall it ...
2
votes
2answers
27 views

PostgreSQL prevents HDD from spin-down

I am using my router with OpenWRT as a small server. To experiment a little with more advanced database administration in my programming projects I set up psql on it. The.server uses my HDD, which is ...
0
votes
1answer
46 views

How to restrict mySQL queries to not affect server and take it down?

There are times that some heavy queries increase server load and after sometime both CPU and Memory reaches 100%. This is my.cnf configuration file: [mysqld] expire_logs_days= 2 pid-file = /...
1
vote
2answers
112 views

How to generate a dynamic file name for a mysqldump on Linux?

I want to schedule my MySql backs to happen on an hourly basis, but the problem is I want to customize the name of the file that is outputs but not to sure how to? This is the command I am using now ...
0
votes
1answer
37 views

Help understanding the password file

I have one database and password file Now I'm creating a new database, do I need to create another password file or not? I'm a beginner in Oracle, maybe a bit stupid question. Thanks in advance
1
vote
2answers
151 views

What happens when sga and pga reach limits?

I have the following doubt, I have a server with Oracle 9i and another with Oracle 12c, in both cases I have the doubt that happens when Oracle reaches the limit imposed by the defined memory ...
0
votes
1answer
39 views

How to active mariadb log?

I want active log file in mariadb for check last query used in php, i find mysql config in internet like as blow: general_log_file = /var/log/mysql/mysql.log general_log = 1 or ...
0
votes
0answers
27 views

How can I connect the mysql enterprise monitor to its repository database with a socket?

By default the Oracle-MySQL-Monitor MEM (used to monitor MySQL Enterprise Instances) connects to its own repository database through localhost. Since we want to reduce the bindings of that database ...
0
votes
0answers
23 views

Does clearing cache in at os level affect oracle running database?

I have 32 gb of ram for running Oracle 12c database. Now I am facing memory issue at OSlevel. Here are the details of free -h: [oracle@sa1 df_size]$ free -h total used free ...
1
vote
1answer
597 views

Unable to join secondary replica to the availability group by SQL Server error 47106

We were trying to create availability group with 3 synchronous replicas, where we couldn't give the names specified in /etc/hosts as node specifiers in the create availability group in the primary ...
1
vote
1answer
52 views

Import Windows MySQL dump on a Debian Linux server

I created a test database on a Windows computer with MySQL 5.7 and filled it with many data records. Now I created a database dump with mysqldump and wanted to import it on my server (Debian Jessie, ...
2
votes
1answer
213 views

SQL Server 2019 CTP 2.1 on Ubuntu fails after powering off

I've installed Microsoft SQL Server 2019 (CTP2.1) - 15.0.1100.94 (X64) on my VirtualBox Ubuntu 16.04.5 LTS. Everything seemed to work properly until I've powered off the machine. Since then SQL Server ...
1
vote
1answer
35 views

Moving mysql database to new partition with different partition “type”

Sorry, Possibly a dumb question, but something which needs clarification. Currently mysql is stored on sda which is around 1TB. Now our DB has outgrown that, almost !!. So trying to create new ...