Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [containers]

31 questions
3
votes
1 answer

Non-CDB database vs Single tenant CDB

I am looking at the prospect of upgrading from oracle 11G to 12C, and I am looking at the cdb vs non-cdb models, and I am having a hard time seeing the benefit of using CDB, without multitenant licensing. For the most part when I look for…
Patrick
  • 698
  • 3
  • 9
  • 23
2
votes
2 answers

InnoDB: Cannot close file ./tablefile.ibd because of 1 pending operations

MariaDB Version: '10.5.13-9 I am facing multiple unsuccessful data migration(Copy) attempts from my old legacy data environment to my DBaaS Container Environment. Performing this data migration using mysqldump with pipe to restore in my Container…
Gopinath Karangula
  • 933
  • 2
  • 10
  • 21
2
votes
1 answer

Postgresql RAM optimization for containers and kubernetes

I wondered how to optimize the RAM usage of my PostgreSQL database deployed in Kubernetes. Particularly I'm interested in configuring the shared_buffers and effective_cache_size values. Typically the recommendation stated by various sources is to…
Jacob
  • 123
  • 1
  • 5
2
votes
0 answers

MySQL multi-master group replication on kubernetes

We are trying to setup MySQL multi-master group replication (GR) on kubernetes Group replication configuring instances. GR is starting on one pod after all the configurations. However the second node goes to RECOVERING state when GR is started…
Raghavendra V
  • 21
  • 3
2
votes
0 answers

Where should I put my system databases in WindowsCore container

We're looking into migrating our SQL Server environment to use containers. I've successfully built a WindowsCore image with SQL Server installed. The instance is accessible with the data files using volumes so that they persist. My question is where…
Nabil Becker
  • 441
  • 2
  • 6
2
votes
0 answers

How to run SQL Server Developer Edition within a windows docker container?

I'm hoping to be able to use features like publisher replication within the developer sku for SQL Server 2016. I have unsuccessfully adapted a dockerfile for it from the official docker repo from Microsoft, the text is from an old checkin where the…
Alexandar Narayan
  • 43
  • 5
1
vote
1 answer

Using docker containers to execute pg_upgrade

using pg_upgrade when you have installed both the 'old' version and the 'new' version on a system is quite straightforward. I tried to find a way using pg_upgrade with docker containers. This is a little bit more complicated because you need the…
D M
  • 445
  • 5
  • 10
1
vote
0 answers

ORA-27046: file size is not a multiple of logical block size

I have oracle19c container, running by docker-compose: version: '3.7' services: oracle: image: container-registry.oracle.com/database/enterprise:19.3.0.0 container_name: oracle19c ports: - 1521:1521 volumes: -…
MiH
  • 125
  • 3
1
vote
1 answer

DBMS in a container/cluster vs data corruption

I am fairly new to db administrations as well as containerization/kubernetes concepts. I see every here and then containerized/clustering solutions for i.e. running PostgreSQL (i.e. here. This conflicts with info I get during my training where it is…
vrms
  • 269
  • 1
  • 4
  • 12
1
vote
1 answer

SSIS failure flow error. The decision after a sequence container failure does not proceed with the correct flow

I have an SSIS sequence container that extracts data from individual source database tables into a Stage layer. However, I need to know when a given calculation crashes in order for the given error to be written to the configuration table, which is…
Valachor
  • 11
  • 1
1
vote
1 answer

Active Directory authentication with SQL Server on Linux containers

I have a problem and hope someone can help me. I have SQL Server as docker container. I want our developers able to login in SSMS (SQL Server Management Studio) using their Active Directory users. I followed this procedures which was Microsoft Doc…
Mehran Dehghan
  • 11
  • 2
1
vote
1 answer

How to get a list of current Oracle CDBs on server

If I have a server with one or more CDBs, what command can I run on the server in order to obtain a list where each item uniquely identifies one of the CDBs? (a "CDB" is an Oracle Container Database) Note 1: I realize that it is rare to have more…
mareoraft
  • 111
  • 3
1
vote
0 answers

How to connect mongodb from aws ec2 ubuntu docker containers?

I have tried mongosqld --addr localhost:3002 --mongo-uri xxxxx.com:27017 But it is throwing the following error: unable to load MongoDB information: failed to create admin session for loading server cluster information: unable to execute command:…
Tushar Kale
  • 11
  • 2
1
vote
2 answers

How to connect to root with Oracle Developer VM

I have the Oracle Database App Development VM (12c) and am trying to create a new container. Specifically: conn / as sysdba create pluggable database pdborcl admin user system identified by oracle…
Druckles
  • 113
  • 5
1
vote
1 answer

Unable to connect to pluggable database in Oracle 12c

I have oracle database Oracle Database 12c Enterprise Edition 12.2.0.1.0, and I created a pluggable database named DEVDB to use it in web application development, I created it using the Database Configuration Assistant, during the creation process I…
rainman
  • 205
  • 1
  • 4
  • 13
1
2 3