We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [linux]

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

Filter by
Sorted by
Tagged with
-1
votes
1answer
21 views

RMAN log file with date and name in Oracle 11gR2 in Linux

I have a script and I want to create my log file with datetime and with unique name. It's my script: ....... ....... rman target/ LOG='/u01/backup/logs/rman.log' <<EOF ....... ....... ....... ...
0
votes
1answer
24 views

Using of delete obsolete in Oracle 11gR2 RMAN on Linux

I'm using crontab for automatic backup (full backup). It works 2 times in a day (8 AM and 23 PM). In my script I use delete obsolete but I have a question. I want to delete old backups without last 2 ...
0
votes
0answers
29 views

How to install Postgres 12 on Amazon Linux 2? [on hold]

I'm finding it really difficult to install Postgres 12 on Amazon Linux 2. AWS strongly encourages you to use their own version of Linux. It's optimized for use in their environment. Ok, fine with me. ...
0
votes
1answer
24 views

How do I figure out how Postgres was installed on my Linux system?

I'm using Postges 9.6 on Ubuntu Linux 16. I'm trying to figure out how the Postgres server was installed so I can figure out a command to start and stop it. It evidently isn't installed as a Linux ...
1
vote
2answers
39 views

How to force oracle accept insufficient swap size?

I want to install Oracle 12c on Oracle Linux 6.10 with 5.7803GB swap size. But one of prerequisites checked failed: INFO: ********************************************* INFO: Swap Size: This is a ...
1
vote
1answer
19 views

Dockerized Sysbench could not connect to Mysql

I'm trying to follow this tutorial. It does not give Mysql version requirements. So I'd tried to use Mysql 8.0.18 Community Server to connect to using those commands. I've created what have been ...
0
votes
0answers
49 views

Cannot start postgres service

I have postgres on my pc and I work with it every day. But today when I tried to connect to postgres, I did not manage to do it. I decide to start it by typing systemctl start postgresql@10-main, by ...
0
votes
1answer
31 views

db2 expired password but cannot reset

Has anybody encountered this problem with a db2 server? I'm running a development database and connecting to the database gives me a password expired error. Trying to reset it will give me an invalid ...
2
votes
0answers
31 views

Solution for the deletion of old Database Backups for Linux SQL Server 2017 after Backups created with Ola Hallengren scripts?

I have a problem when I want to delete older backups, I've created with Ola Halengreen scripts. USE Maintenance EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASES', @Directory ='/mssql/backup/'...
-1
votes
1answer
9 views

Impact of changing swappiness

On one of my aws ec2 m4.10xlarge instance running Ubuntu 16.04 LTS with 160 GB memory, I want to change the swappiness from the default 60 to 10. Does changing this at runtime using sysctl -w vm....
5
votes
1answer
112 views

Permissions issue in Docker SQL Server 2017 while restoring certificate

Docker SQL Server 2017 container @latest. Using master database. The error I am facing is the following: [S00019][15208] The certificate, asymmetric key, or private key file is not valid or does not ...
0
votes
1answer
24 views

How to find out unused port on Linux server

We are trying to use port 5444 for our new PostgreSQL instance and we are not sure whether 5444 is used or unused. Could you please help us to find the answers to the below questions. We want to ...
1
vote
1answer
28 views

MariaDB Parallel Replication Drifting at random times

I have recently been thrown in the deep-end to manage our Database servers since our DBA left. The current set-up is Mariadb (mariadb Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu), InnoDB (...
3
votes
2answers
1k views

Exception; Collection does not have UUID in KVCatalog

I have installed Mongodb 4.2 through this guide] and when running sudo service mongod start|restart It does not start the server and I have the log below in mongod.log file. Exception in ...
-3
votes
2answers
61 views

Need a shell script that can run a oracle query and produce output in .csv format

Can you please help- need a shell script that will have a oracle query inside it and produce a .csv format output in specific location, that script should be a scheduled in a cron job which runs, the ...
0
votes
0answers
12 views

SQL Server - Change AuditLevel on Linux hosted instance

just wondering if it's possible to change the AuditLevel on SQL Server 15.0.1800.32 (2019) hosted on Linux to "Failed logins only". Currently it's set to audit failed and successful logins and I ...
0
votes
0answers
30 views

ORACLE timed Datapump on Linux? (No crontab)

what is the best way to create a timed Datapump Dump of a PDB on a Linux System? No Crontab. And how do I implement it?
0
votes
0answers
18 views

Unable to connect with MongoDB when giving mongod command in Cli

I'm trying to install mongoDb on centos VM and followed few sites like https://linuxize.com/post/how-to-install-mongodb-on-centos-7/ , https://www.digitalocean.com/community/tutorials/how-to-install-...
0
votes
0answers
49 views

PostgreSQL + pg_xlog folder with very old files and how to purge pg_xlog files

Under folder - /var/lib/pgsql/DB/pg_xlog We have very old files as the following: -rw------- 1 postgres postgres 56 May 31 2018 00000002.history -rw------- 1 postgres postgres 331 Oct 14 ...
0
votes
3answers
46 views

Postgres Initial Setup and User Login

Full disclosure, new to postgres and new to linux. I am having trouble understanding the user management side of postgresql. I installed on a Ubuntu 19.04 based os using sudo apt update sudo apt ...
0
votes
0answers
27 views

mssql + sssd Ubuntu cannot login via AD group

I've got mssql 14.0.3192.2-2 setup unter Ubuntu; I have joined my machine to AD as described here. The Windows login via SSMS and sqlcmd works if I add invididual AD users, but not if I add groups. ...
0
votes
1answer
86 views

How to install mysql/mariadb on NIXOS?

I installed mariadb via configuration.nix. For the installation I made the following entries in my configurastions.nix. services.mysql.enable = true; services.mysql.package = pkgs.mariadb; ...
0
votes
0answers
97 views

One database on my MS SQL Server wont start OS error: 5(Access is denied.)

I am running MS-SQL server for Linux. There are several databases on this machine, but one of them refuses to start up. The error log shows: 2019-07-30 16:29:36.76 spid19s SQL Server is now ready ...
0
votes
0answers
517 views

Error Code: 1129 Host 'xxx.xxx.xx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

For the past few days, I am getting this error every morning when I tried to connect to the MySQL database using the MySQL workbench and also through some applications. So, every day I log onto the ...
1
vote
2answers
240 views

How to get a new pid file of Mysql and restart Mysql Successfully?

Due to lost of pid file of my server, I can't stop mysql using normal commands like service mysql stop which will show ERROR! MySQL server PID file could not be found! So I try to stop all mysql ...
0
votes
1answer
64 views

LOAD_FILE() works on SELECT, but returns NULL on insert

I'm having troubles using the LOAD_FILE() function in my environment. I'm trying to add a file to a BLOB field but whenever I try to insert or update this field with LOAD_FILE(), this field is being ...
0
votes
0answers
109 views

sudo systemctl restart mssql-server hangs

When installing Red Hat Enterprise Linux Server release 7.6 (VM) minimal install, I followed these steps for MS SQL installation: sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages....
0
votes
0answers
13 views

IO scheduler for Oracle RAC on Linux

All the documentation I have seen says that Oracle recommends the deadline scheduler. This seems very counter-intuitive when using a mini-SAN (with persistent write caching) - in such a scenario, and ...
1
vote
2answers
41 views

Virtual Environment for learning [closed]

I am a new DBA and my friend told me the best way to learn about becoming a DBA is to setup your own server (virtually or physically). I don't have a spare machine laying around so I will need to set ...
2
votes
1answer
263 views

How to install pgcrypto?

While trying to answer Create integer id columns from existing string columns (integer coding?) it turned out that I needed my own version of postgres to play with. I already had a decent postgres ...
1
vote
1answer
55 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
81 views

T-SQL is not working on DBeaver on Linux [closed]

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
25 views

Mysql memory_global_total is smaller than memory usage in top [duplicate]

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 ...
1
vote
2answers
50 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
51 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
88 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
27 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
28 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
28 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
90 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 ...
1
vote
1answer
125 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
395 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 ...
1
vote
0answers
76 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
32 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
307 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
56 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
840 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
43 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
63 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
107 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 ...