Stack Exchange Network

Stack Exchange network consists of 174 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.

-2
votes
0answers
16 views

Connection to SQL Db from Linux server [on hold]

How can we establish connection from a Linux machine to a SQL DB to execute a batch script
0
votes
4answers
53 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
59 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
25 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
12 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
23 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
37 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
19 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
31 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
65 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
22 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
14 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
20 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
92 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
31 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
101 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
19 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 ...
0
votes
1answer
35 views

Why could pgloader fail with 'undocumented reason' while migrating large MySQL database to PostgreSQL?

The database I would like to import is approximately 55GB in binary format, about 36 GB exported by mysqldump. But as we know even the postgres compatible mysqldump is not 100% compatible, so I'm ...
0
votes
1answer
31 views

Problem with pdb Oracle 12c

I use pre-built Oracle 12c r2 when I tried to sign up as sqlplus / as sysdba I got a ORA-01017 which I solved with unset TWO_TASK Since then, I can not sign in to the user I created Because I'm in ...
0
votes
1answer
53 views

I have an error before I connect to the user Oracle 12c [closed]

After that, I log in normally. I tried it sqlplus as sysdba error is the same Why this error occurs I'm a beginner [oracle@localhost ~]$ sqlplus "/as sysdba" SQL*Plus: Release 12.2.0.1.0 ...
-1
votes
0answers
38 views

log rotate error in /var/log/messeges

i have a server with CentOS 6 as Os and DB2(10.5.0.5) database. i saw that our monitoring agents get connection but they dont close it. then i checked /var/log/messeges and saw this error: Nov 18 ...
3
votes
1answer
201 views

What ports does SQL Server use on Linux?

What ports does SQL Server use on Linux? I want to be sure I'm forwarding the ports required when I run it in a container.
0
votes
1answer
23 views

Master slave replication with different mysql version is on both slave and master

Currently, we have MySQL master-slave replication. Both master and slave servers have Mysql 5.5 Currently I need to add one more Master server having version 5.7. Is it possible to add Multiple ...
4
votes
1answer
66 views

Why is my database restore being aborted?

I'm trying to restore a SQL Server 2016 database into a SQL Server 2017 docker instance (microsoft/mssql-server-linux:latest). The process seems to be: Create docker container: docker run -e ‘...
2
votes
1answer
1k views

psql: FATAL: role “postgres” does not exist

Running PostgreSQL server on Void Linux. After installing ran initdb as OS user 'postgres': [user@host]$ sudo -u postgres -i $ initdb -D '/var/lib/postgresql/data' Received output: creating ...
0
votes
1answer
33 views

Moving Oracle / Oracle datafiles to different file system on Linux

We have Oracle installed on /root, which is now running out of space due to increasing data in Oracle database. On the same machine we have another file system with free space. I want to know the ...
0
votes
1answer
144 views

How to execute sqlplus by root using sudo in linux?

Scenario: *oracle xe11g r2 is installed( and runs properly when logged in as oracle). *logged in as user, root *added root to groups oinstall and dba as follows: #useradd -G oinstall root #useradd -...
0
votes
1answer
122 views

how to install mssql on to ubuntu

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1' : file not found. pugazhl@pugazhl-LIFEBOOK-LH532:~$ # sqlcmd -S ...
8
votes
2answers
657 views

Can one of Windows failover cluster nodes run on Linux?

As SQL Server is available for Linux can I configure Clustering on Linux nodes? I mean mixed with Windows - some nodes are on Linux, others on Windows in the same cluster?
0
votes
1answer
20 views

Analyze general log

Motivation : understand the highest CPU\usage\long_query of historic queries running on production. example :10 minute ago on server x graph showed high CPU usage. I thougth for next steps : ...
0
votes
1answer
420 views

Failed to start MySQL Community Server

A lot of stuff stopped working on my server because the sda3 partition became full. After fixing that issue, I cannot start the mysql service: root@abcd:~# sudo service mysql start Job for mysql....
0
votes
1answer
66 views

Can't launch multiple instances of MySQL in Linux

I'm in real trouble here. First, thank you to all of you that will take the time to read my post. So, I've followed tones and tone of tutorial to create multiple MySQL instances. On the paper, it's ...
0
votes
1answer
210 views

MySQL CPU usage 128%?

I backed up my site using an all in one WordPress migration plugin from shared hosting and restored on VPS hosting server. Everything worked fine except for 1 MySQL task eating up whole CPU usage.. I ...
0
votes
1answer
61 views

Migrating Oracle 10g on Solaris Sparc to Linux RHEL 5 VM

if i will rate my oracle expertise i would give it 3/10. i just started learning oracle, solaris and linux 2months ago and was given this task to migrate. yes our oracle version is quite old and might ...
0
votes
1answer
49 views

mysql - 35GB binlog files are cached in OS cache

I have a mysql database with 5.6. Binary logs are enabled and it has 5 slaves. GTID mode enabled. Maximum binlog file size is 1GB. sync_binlog = 0 When I check the free -gh total ...
2
votes
2answers
128 views

How do I install SQL-Server Tools if I can't use curl?

Attempting to install mssql-tools, I get $ sudo apt-get install mssql-tools Reading package lists... Done Building dependency tree... 50% Building dependency tree Reading state information......
0
votes
0answers
77 views

SQL Server logs “blob data”, viewable with journalctl

What does it mean when I run journalctl -u mssql-server.service and it says B blob data, Sep 06 17:34:44 x230 systemd[1]: Stopping Microsoft SQL Server Database Engine... Sep 06 17:34:44 x230 ...
0
votes
1answer
198 views

Listing the Microsoft SQL Server configuration with the values set by mssql-conf?

The utility mssql-conf in /opt/mssql/bin/mssql-conf has the setting list which tells you possible keys, $ sudo ./mssql-conf list control.alternatewritethrough Enable optimized write ...
1
vote
1answer
47 views

Postgresql installation, avoid creating “postgres” user

I have a constraint, that I can use only one user on a SUSE Linux Enterprise Server 11. Now, I need to install PostgreSQL 9.4. Is it possible to somehow avoid the automatic creation of "postgres" ...
1
vote
1answer
43 views

It's possible to recover a deleted pg_hba.conf linux postgresql file?

If anyone delete the pg_hba.conf file, and don't run "pg_ctl reload", the configuration of the deleted file is still working. With that in mind, could someone put in a new file that info wherever it ...
1
vote
0answers
26 views

What kind of hashing should I do? [closed]

I installed the following simplechan bulletin board but md5 was used to hash passwords for administrators of this bulletin board. According to the examination I found out that md5 is very weak. So, I ...
0
votes
1answer
26 views

PostgreSQL on ephemeral storage

Is there any safe way to use ephemeral storage (deleted on halt) for postgresql cluster?
2
votes
1answer
96 views

Mysql not started after some crash [closed]

I don't know what exactly happen, but I can't start mysql over lamp controller. In console I can do it, but mysql is not started in fact. Here is my login file. Can some experienced look at it? 2018-...
2
votes
0answers
50 views

SQL Server 2017 Failover Cluster on RHEL Linux

I am trying to create Failover Cluster on SQL Server 2017 on RHEL 7.3 Linux, following this document from Microsoft: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-shared-disk-cluster-...
1
vote
2answers
59 views

Should a privileged port (<1024) be used to deploy Postgresql in production?

I've never found a recommendation to run Postgresql on a privileged port in production. What type of port should be used in production regarding security and best practices?
-1
votes
2answers
49 views

MySQL on Windows or Linux [closed]

I am new to the Database region while have to migrate the company's database from AWS RDS to AWS EC2 and subscribe MySQL Enterprise edition. What I am confused now is which OS should I choose, ...
0
votes
1answer
167 views

Oracle - Archivelog files , can we delete them?

We have RHEL 7.2 machine where Oracle is installed. Recently this machine ran out of space and we figured out that most of the space is going into "/home/oracle/ORA12C/fast_recovery_area//archivelog" ...
0
votes
1answer
161 views

Cannot start sql server in antergos linux: Unit mssql-server.service has a bad unit file setting

I can no longer start sql-server on antergos linux. This is what I tried so far (following this link): $ sudo systemctl status mssql-server.service ● mssql-server.service Loaded: bad-setting (...
1
vote
1answer
363 views

Missing mysqld.sock file on linux server

I have this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") Anyone know what is wrong? It seems it isn't ...
0
votes
1answer
28 views

One SQL Server RDS instance plus one Ubuntu instance cost money on my initial free trial year [closed]

Why do I get charged when I only have one micro instance running as Ubuntu and another one a RDS. Does the extra RDS count as a separate instance? My RDS is Microsoft SQL Server exchange which should ...