Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
989
questions
1
vote
2
answers
41
views
How to configure the location of the Oracle password file?
When I start an Oracle instance with sqlplus the paths to the datafiles are stored in the control files, the control file name is stored in the control_files initialization parameter. The ...
- 7,664
0
votes
0
answers
9
views
Postgresql in Colab using the wrong link
So I am trying to set up Django and PostgreSQL in Google Colab but I ran into an error when trying to test postgres. I created the user, password and the database and it says that my db called "...
- 11
0
votes
1
answer
29
views
Reset root password in MySQL
I am logging in with root user in MySQL, and the server has been hardened, so this parameter is set default-authentication-plugin=caching_sha2_password, and this is currently the only user I have.
...
0
votes
0
answers
11
views
Geting ORA-01017 after copying oracle home directory to different linux server
-- Oracle V 12c
I have two different servers. I have copied the entire oracle directory from one server to another, and now I am using made relevant changes in .bash_profile.
when executing sqlplus, ...
0
votes
0
answers
12
views
MySQL access denied problem - random, sudden password changes?
It looks as if my MySQL password is randomly changing after some time. I lose access - i can't log in with the password. I have to set it up again for it to work, and after about one hour do it again.
...
0
votes
0
answers
26
views
MySQL crashed and process in zombie state
MySQL server crashed and was in a zombie state. Attempted to send kill -s SIGCHLD to the parent process but failed. Killing the parent was not an option since it was the init process and I was forced ...
- 119
-1
votes
0
answers
59
views
ORA-27369: job of type EXECUTABLE failed with exit code: 5 Login executable not setuid-root
I try to run executable job in Oracle 19c and the error occurs:
ORA-27369: job of type EXECUTABLE failed with exit code: 5 Login executable not setuid-root
ORA-06512: at "SYS.DBMS_ISCHED", ...
0
votes
1
answer
55
views
How do i fix "InnoDB Plugin initialization aborted with error Generic Error"
i am running a Nextcloud Server on a Ubuntu 20.04 which was running fine. I wanted to upgrade the Nextcloud Version and make a backup before. This is what i did:
plugged in a external harddrive (/dev/...
Ruben247
0
votes
0
answers
66
views
MS SQL server runs slowly on new Linux server
I am running a relatively small Access application with an SQL server 2019 backend, and have recently updated my ~10+yr old Linux system that is running the server. I was surprised to find that SQL ...
- 1
0
votes
1
answer
257
views
Connecting to MariaDB server: ERROR 2013 (HY000): Lost connection to server at 'handshake: reading initial communication packet', system error: 11
I am trying to connect to an AWS hosted (RDS) MariaDB database (engine version 10.6.14). The database is hosted on a private subnet but it's accessible through a bastion host. I use an SSH tunnel to ...
0
votes
0
answers
36
views
MySQL 5.7 - could not establish connection (every 2 months or so) - how to log / ID issue?
I have a v5.7.42 MySQL server (community) running on Ubuntu 20.04.6 LTS - My issue is about every two months or so , the site will show could not establish connection to database, service mysql status ...
0
votes
0
answers
88
views
I can't create tablespace in Oracle
I have deployed an oracle database running on docker and use navicat to connect to the oracle database. But when I tried to created a tablespace, I failed to make it.
sql : Create tablespace tbs ...
CodeRabbit
0
votes
0
answers
35
views
Mount MariaDB data in a separate directory on RHEL 8?
We are migrating from a CentOS 7 server (physical server) to RHEL 8 (Azure server). This server was setup by someone else, and admittedly I know enough to install/configure LAMP. I am not a sysadmin.
...
0
votes
1
answer
22
views
migrate mysql dbs from old linux drive
I have an intact file system with a nonworkable old installation of linux. All the mysql pieces are there fine, I can see all the data files, but I can't figure out how to access them. I've tried a ...
- 101
0
votes
1
answer
25
views
MSSQL 2019 CU16 on Linux: virtual_address_space_committed_kb vs RSS
I am running SQL Server 2019 CU15 on Linux in kubernetes and trying to investigate why SQL Server pod gets killed by OOMKiller. I see some inconsistency in reporting of memory consumption. SQL Server ...
0
votes
1
answer
226
views
Assigning multiple IP addresses to MongoDB 7.0 on Ubuntu
The Problem
I am trying but failing, in MongoDB 7.0, on Ubuntu, to bind multiple IP addresses to net.bindIp in mongod.conf
What I have tried
I have tried 127.0.0.1,x.x.x.x, 127.0.0.1;x.x.x.x, [127.0.0....
- 1
0
votes
1
answer
30
views
Postgres keeps forgetting my data
I'm fairly new to Postgres, having spent years with MySQL/MariaDB. I have a Postgres 14.9 database for development with two schemas in it. When I lose power, both of the schemas still exist in the ...
- 143
0
votes
0
answers
397
views
PostgreSQL Server Timeout Issue with pgAdmin, pgAdmin Web, and DBeaver
I am using PostgreSQL 15.4 on Ubuntu 22.04. Initially, I used pgAdmin 4 for managing the database. However, I've been facing an issue where pgAdmin stops responding after some time. This issue seems ...
0
votes
2
answers
537
views
Installing DBD:Oracle on RedHat 8.8
I am trying to install DBD:Oracle.
I'm in the following environment:
Red Hat Enterprise Linux release 8.8 (Ootpa)
Perl v5.26.3
Our DBA installed the Oracle 19 client in this location:
/u01/app/oracle/...
- 1
1
vote
0
answers
23
views
Why does mysqld use much more memory than expected?
Running MySQL 8.0.24, I have been recently seeing frequent instances where the RHEL7 OS will kill the mysqld process as the system memory gets all used up. The server has 65 GB of memory, and I think ...
- 11
0
votes
0
answers
15
views
Access MySQL remotely with terminal and PHPMyAdmin
First I must say that it's the first time I'm doing this kind of stuff, I'm a bit confused. I've uploaded a MySQL database to a website I bought few hours ago which I can access through PHPMyAdmin. I'...
- 1
0
votes
0
answers
37
views
MongoDB replication fails around 1900 GB with error-Too many open files
My MongoDB replicaset running in cloud and onprem on version 2.6.12. The replication between the two is failing everytime it reaches around 1900 GB.
I have tried the below steps but the replication ...
0
votes
0
answers
35
views
How to create replica set of mongodb in ubuntu and enable it?
I am using MongoDB community edition in Ubuntu 22.04. How can I make replica set in my local machine and how can I enable it to use in my node js application?
Tanzim Ahmed
0
votes
1
answer
130
views
Cannot restore MySQL into existing DB - get ERROR 1050 (42S01): Table 'blahblah' already exists
I can restore from
mysqldump wordpress-db > mysqldump-wpdb.sql
to new DB fine with
$ sudo mysql wordpress-db001 < mysqldump-wpdb.sql
But if the DB already exists (as they generally do with a ...
- 138
0
votes
1
answer
79
views
How to restore a SQL Server bak file (Enabled FileStream ) to Docker version SQL Server?
I have SQL Server 2014 installed on Windows and enabled the FileStream feature. I backed up the database to a .bak file. Now I want to restore the file to my Docker container of SQL Server 2019. ...
- 1
-1
votes
1
answer
80
views
How to make sqlplus parse stdin?
I have the data in the following form:
10334,99.4,4241
14354,99.5,6018
16807,93.9,2279
22042,97.5,70341
22117,96.4,70335
22138,95.7,70332
23869,94.4,135649
23937,97.5,135642
23982,96.6,135638
24055,95....
0
votes
0
answers
132
views
MySQL CPU 200% - 300% Help me!
Good morning everyone,
I write to you because I'm desperate and I can't find the solution:
I have mysql CPU going over 200-400% causing me to slow down and almost crash the only website hosting the ...
user274959
0
votes
3
answers
286
views
How can I purge MySQL binlogs if MySQL is turned off
I am using Digital Ocean droplets for my WordPress Site. There are more than 60 binlog files in /var/lib/mysql. Most of the solutions say that I should purge them from MySQL. The storage is so full ...
- 101
3
votes
2
answers
2k
views
How can I get a list of locales in PostgreSQL?
I want to change number and currency format using something like:
SET lc_numeric='en_AU.UTF-8'
SET lc_money='en_AU.UTF-8'
I tried a number of formats for, say, Dutch, but nothing works. It appears ...
- 2,759
2
votes
1
answer
624
views
psql \set an environment variable from the existing shell environment
I want to set up a psql variable from an existing shell environment variable that I can use in later psql commands.
I found the \set meta-command, but I'm not able to make it use an existing ...
- 342
0
votes
1
answer
28
views
Does the order in which vms are shutdown impact the postgresql replication environment?
I have the following environment:
A postgres server (rhel8, postgresql v14) as master and another as standby.
I need to do a maintenance task on the infrastructure and for this reason both vms need to ...
- 149
5
votes
1
answer
301
views
MSSQL Server 2022 on Linux: sys.* tables very slow for non-db_owner users
Querying sys-tables, for instance sys.columns, sys.indexes or sys.tables, has become significantly slower on SQL Server 2022 on Linux for users which are not db_owner.
To reproduce, take a SQL Server ...
- 315
2
votes
1
answer
99
views
SQL Server on LInux - OpenRowSet function only has access to files in /var/opt/mssql directory?
I have a file I want to import into an SQL Server 2019 database running on Ubuntu 20.04. The file resides in the /proc directory and I have done a chmod 777 on that file. However, when trying to read ...
0
votes
1
answer
47
views
Unable to use data pump utility in Oracle to import data to another server
I am using this command:
impdp atif/[email protected]:1521/serv1 DIRECTORY=DATA_PUMP_DIR DUMPFILE=mltpltblbkp.dmp LOGFILE=mltpltblbkp.log
to import data from one server to another.
this is my ...
- 54
1
vote
2
answers
61
views
How is cassandra 9042 port used in the context of lsof command?
I am trying to identify who is making connection to cassandra instances in my environment. The machine has ip 172.31.44.23. I ran the command sudo lsof -i -n -P | grep 9042 | grep ESTABLISHED | awk ' ...
1
vote
1
answer
76
views
[[FATAL]] [[DBT-06103]] The port (5,500) is already in use in Docker Container
I'm trying to use Oracle 19c DB Container for my test cases in Jenkins Job but DB Container is intermittently failing with this error
[FATAL] [DBT-06103] The port (5,500) is already in use.
ACTION: ...
1
vote
0
answers
165
views
PostgreSQL data_directory doesn't match value set in postgresql.conf [closed]
I've recently updated from version 14 to 15 and I can't figure out why it's still using the data directory for 14.
I've verified that I'm using version 15.
$ sudo -u postgres psql -V
psql (PostgreSQL) ...
- 111
1
vote
2
answers
588
views
Issue configuring Postgresql for remote connection: 'Job for postgresql.service failed'
I'm trying to configure Postgresql 14.7 for remote connections in a SLES15 environment. I've been following the instructions from Postgres for Zypper installation supplemented with these instructions ...
- 113
0
votes
0
answers
278
views
Mongoexport query using date range on Linux
I'm trying to run mongoexport using this query:
mongoexport --db=database --username=user --password=pass --collection=coll --type=csv --fields=Name --query='{ "Date" : { "$gte" : {...
Fernanda Andretto
0
votes
0
answers
66
views
Linux PostgreSQL backup single schemas + data into individual files
Is there a way to backup only the schemas (plus their relative data) of a PostgreSQL DB individually, into single dedicated files?
I'm on Linux CentOS 7, hopefully there's some way to automate this so ...
0
votes
0
answers
190
views
MSSQL replication snapshot agent fails
I'm using MS SQL server 2019 on Linux. I'm trying to create a transactional replication.
The problem is that when I create a publication, the snapshot agent can not start.
Basically, I'm getting this ...
- 1
1
vote
1
answer
91
views
Oracle ASM for data files - "not recommended" - why not
I've been supporting a lot of Oracle databases (not full-time; I'm a programmer 90% of the time) and I just happened to see in the Oracle 19 Linux Installation document that storing Oracle data files ...
- 1,123
0
votes
1
answer
121
views
mysqld how to only listen on unix socket?
how do i make mysqld not use ip at all, only listening on an unix socket? if i do
mysqld --socket=mysql.sock
it still opens port 3306, and if i do
mysqld --bind-address='' --socket=mysql.sock
it ...
- 103
1
vote
1
answer
2k
views
Cannot connect on psql specifying connection string postgres
On my Ubuntu machine, I have installed postgres 15. I created a new superuser called "test" (with password "test"). Then, I created a database called "test" as well and ...
- 111
0
votes
0
answers
263
views
MSSQL error when creating publication
I'm using one MSSQL server (SQL server 2019 on Linux, to be precise, on Kubernetes) as a distributor and publisher. I tried to configure it as a transactional publication using SSMS.
The problem that ...
- 1
1
vote
1
answer
389
views
PostgreSQL uses huge amount of memory
When executing a query containing WITH and more than a thousand UNION ALL, PostgreSQL version 14 or higher uses all server memory until it enters recovery mode. In tests with version 11, this behavior ...
1
vote
1
answer
235
views
Allow connection to mongo only from my server droplet
Recently I created a server with MongoDB preinstalled on a DigitalOcean droplet following these tutorials
DigitalOcean - Initial server setup
DigitalOcean - How to secure MongoDB on Ubuntu
Medium - ...
- 11
-1
votes
1
answer
911
views
Why MariaDB server is consuming SWAP when there is available memory?
I have a dedicated server for MariaDB 10.8.3 and the features as follows:
248GB free disk space.
innodb_buffer_pool_size = 12286766080
binlog_cache_size=8M
Memory results:
[root@server user]# free -h
...
- 129
0
votes
1
answer
530
views
Mysql Replication Error: Waiting for master to send event
My replica db can't update master update.
When I write on my replica
Show slave status\g
its result:
*************************** 1. row ***************************
Slave_IO_State: ...
furkan aydınlı
1
vote
2
answers
542
views
Apache Cassandra 3.11.2 unable to start Centos 7
I am trying to start Apache Cassandra 3.11.2 on Centos 7 and I get error Exception:
ERROR [main] 2023-02-22 11:19:03,067 NativeLibraryLinux.java:64 - Failed to link the C library against JNA. Native ...
- 23