Questions tagged [linux]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
21 views

ORA-00904: “GET_JAVA_PROPERTY”: invalid identifier - 11gR2

In Oracle DB 11.2.0.4, linux 6.7 single instance select get_java_property('java.version') from dual; SQL> show user USER is "SYS" SQL> select get_java_property('java.version') from dual; ...
0
votes
1answer
23 views

T-SQL is not working on DBeaver on Linux

I am trying to run a basic T-SQL script DECLARE @temptable TABLE( abilityTypeId BIGINT NOT NULL, companyId BIGINT NOT NULL ); INSERT INTO @temptable(abilityTypeId, companyId) ...
0
votes
0answers
14 views

Mysql memory_global_total is smaller than memory usage in top

When I try top in my ubuntu the result top - 16:03:09 up 16 days, 21:24, 2 users, load average: 3.53, 2.72, 3.46 Tasks: 395 total, 1 running, 282 sleeping, 0 stopped, 0 zombie %Cpu(s): 10.0 ...
0
votes
1answer
34 views

Is it possible to change the SQL Server errorlog file number on Linux?

Everything is in the title. We can change the number of errorlog files using the registry on Windows, does anybody know if it is possible on Linux? I see no mssql-conf option for this. Thanks
0
votes
0answers
49 views

SQL Server on Linux

While running "sudo /opt/mssql/bin/mssql-conf setup" to configure sql server i keep getting the error "sudo: Please use single character options". I am running the above command as root user.
0
votes
0answers
21 views

Corrupted InnoDB still won't start even after removing corrupted tables

My MySQL server stopped working randomly and upon checking log files I found this: 190622 23:45:10 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer ...
0
votes
1answer
23 views

Backing up and restoring all databases in MySQL on linux

I plan to dump all databases on one computer and restore them on another using the following 2 commands:- mysqldump -u username -p --all-databases > dump.sql mysql -u username -p < dump.sql ...
0
votes
1answer
25 views

Mysql, linux, autocompletion

I need autocompletion for mysql console in Linux. I found this solution. Add this to .my.cnf. file in home folder. [mysql] auto-rehash But it doesn't work, for ubuntu 19.04 and mysql 14.14. And ...
0
votes
0answers
12 views

How to change root password of mysql community server in fedora 30

okay so i have changed to custom password as per the password policy but i want to set a short password say, 4 letter password only as a root password for mysql but i am unable to do it, i am using ...
8
votes
1answer
69 views

initdata: No memory for kernel buffers

I recently upgraded my SQL Server 2017 Developer Edition on RedHat Enterprise Linux 7.6 to SQL Server 2019 CTP 3.0. The mssql-server service will no longer start. /var/opt/mssql/log/errorlog shows ...
0
votes
1answer
33 views

SQL Server Linux Disable Remote Connections

What is the best way to disable remote connections on a SQL Server Install on Linux (CentOS 7)? I.E. force SSH Tunneling to connect over localhost. I typically block ports explicitly with IPTables/...
0
votes
0answers
110 views

How to install PLV8 in PostgreSQL 11 in Ubuntu 16?

I am trying to install PLV8 extension (JavaScript Procedural Language for PostgreSQL) in my PostgreSQL 11 Ubuntu Server 16 and having a hard time. The PostgreSQL 11 was installed using PostgreSQL's ...
0
votes
0answers
18 views

MySQL(5.7.23) starting automatically with skip-grant-tables

I recently installed MySQL 5.7.23 and started mysql service later ran mysql_secure_installation but while changing the password ran into any issue where it says that i cannot change the password as ...
1
vote
0answers
31 views

MongoDB Fails due to permission error even though its setup

Attempting to start my MongoDB server using service mongod start fails for the reason: exception in initAndListen: IllegalOperation: Attempted to create a lock file on a read-only directory: /var/lib/...
1
vote
0answers
24 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 ...
3
votes
1answer
82 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
49 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
73 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
33 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
51 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
77 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
53 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
23 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
31 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
273 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
86 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
69 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
77 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
24 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
23 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
166 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
256 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
195 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
234 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
47 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
242 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 ...
1
vote
1answer
161 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
19 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
38 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
154 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
627 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
95 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
108 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
104 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
95 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
56 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
159 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 ...
1
vote
3answers
531 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 ...