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
votes
1answer
49 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
57 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
31 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
44 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
15 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
12 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
39 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
22 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
15 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
29 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
28 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
115 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
78 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
63 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
38 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
44 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
42 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
80 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
127 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
61 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
16 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
26 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
44 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
50 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
36 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
110 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
26 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
16 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
21 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
306 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
39 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
143 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
26 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
51 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
34 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
60 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 ...
3
votes
1answer
223 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
28 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
71 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
4k 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
36 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
421 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
156 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
672 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
23 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 : ...
1
vote
1answer
979 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
99 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
300 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
82 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
62 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 ...