Questions tagged [database-administration]

Questions about how to install, configure or tune the configuration of any database package.

Filter by
Sorted by
Tagged with
1
vote
3answers
463 views

How to downgrade MS SQL Server 2019 Enterprise (evaluation) to Standard (purchased)?

SQL Server 2019 was installed in evaluation edition. When entering the activation code for a purchased copy of Standard edition I received the following message: I entered the activation code that is ...
0
votes
1answer
38 views

Physical to Virtual Migration using Disk2vhd utility

We are currently in plan of migrating physical to virtual servers for both DB & App servers. Currently we are with SQL Server 2014 AOAG System. Databases are FileStream enabled. Currently we have ...
0
votes
0answers
28 views

Plesk: encrypt/hide specific database from other admins

Is it possible to hide or encrypt a specific database (or its contents) from other users with same privileges in Plesk linux?
0
votes
0answers
108 views

Oracle limitation for Materialized View on a remote Table (via DB Link) having a nullable CLOB column

I recently ran into a problem with Oracle whereby I have a materialized view which maps 1:1 to a target table in a remote database over a db link. The target table has multiple columns, one of which ...
0
votes
0answers
71 views

Cassandra Bootstrapping

I initially created a new cassandra (ver 3.11) cluster with three nodes and one seed on some ubuntu servers. Since their was no data, I set auto_bootstrap to FALSE in the cassandra.yaml files for all ...
0
votes
1answer
51 views

MDSplus configuration: How to Change the Start Shot Number in an MDSplus tree?

When creating a new MDSplus tree, it's possible (or perhaps even required) to specify the smallest shot number for which data can be stored in the tree. Shot numbers are just index values identifying ...
1
vote
1answer
72 views

Database Reverse engineering wizard Fails

I am using Visio 2019, trying to reverse engineer a Azure SQL server. I have successfully created multiple User data sources to use in the wizard using both our DB-admin user and my admin azure ...
0
votes
0answers
21 views

Making a second back end database in Access when the first gets full

I will start this by saying that I am a mechanical engineer, and I am in no way familiar with Microsoft Access, I don't even know the right terminology to describe the small amount of knowledge I do ...
0
votes
1answer
89 views

SQL Server file is in Is_media_read_only mode and can't apply TDE as a result

We have a database that we restored to a server and have been read/writing to that database for quite some time. We are now trying to apply TDE to that database and it will not allow us because it ...
0
votes
0answers
43 views

How to fix corrupted user from Keycloak database

We have keycloak, and there seem to be one "corrupted user" in database. If queries are made against this user -> Keycloak crushes with Null Pointer Exception whenever request for this user is made. ...
0
votes
0answers
7 views

Intraday Return calculations

We are setting up a new SQL server Database that will contain fund performance data for a new Database. During the day we will receive new positions for intraday fund returns and need to trigger the ...
0
votes
0answers
29 views

SQL Deadlock Troubleshooting and Statistics

One of my company's SQL database generates a lot of deadlocks per day recently (someday >100) I'm trying to troubleshoot the causes of these deadlocks, i noticed that many deadlocks occur at the same ...
0
votes
1answer
239 views

MariaDB slave replication stopped after slave upgrade to 10.1.41

After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay logs from master which is on 10.1.40. Slaves which got automatically updated to 10.1....
0
votes
1answer
25 views

Link two fields in one table to one field in a second table, and create qry in Access

I am not sure if this is possible to do in Access; I have been googling forums and have not found a solution yet that works... Essentially there are a list of patients who provide multiple blood ...
0
votes
1answer
131 views

MS Access form doesn't reflect recent data updates in Split Database's FrontEnd Forms

I have a front end and a backend to my access database. The VBA code, forms, queries etc are on the frontend and tables on the backend. The backend is on a server, about 5 different users are using ...
1
vote
1answer
929 views

PostgreSQL getting error during pg_restore using pgadmin pg_restore: [archiver (db)] could not execute query: ERROR: role does not exist

I am trying to restore a database from one schema to another schema in PostgreSQL using pgadmin backup and restore utility. The backup is successful for the database A but when I try to do the restore ...
0
votes
0answers
47 views

Can you store encrypted passwords in ConnectWise Manage or will they always be plain text?

Title pretty much says it all. I need to store passwords for devices and configurations but I want them to be stored securely and encrypted. Can this be done with ConnectWise Manage?
1
vote
0answers
61 views

How to connect to a PostgreSQL database?

I have a website written in Python / Django, and it is functioning well on a CentOS server (I wasn't one who set it up though). Now I want to set this website up locally on my Mac OS X or Linux system ...
0
votes
0answers
11 views

Connecting MsSql to Oracle Database

Trying to connect mssql to oracle database through linked server . Need to know the process to connect so that we can connect t
0
votes
1answer
54 views

postgresql does no restart after changing postgres.conf or pg_hba.conf. This incident happened while i was trying to setup the postgresql BDR

I am not able to login to postgresql after restarting postgresql DB after configuring pg_hba.conf and postgresql.conf file. The snapshot of the error is attached for referral postgresql.conf / pg_hba....
0
votes
1answer
155 views

Removing cluster node from always on cluster

I have an alwaysOn configuration for SqlServer 2012 that is installed in two node windows cluster. We had a disk failure on the second node, and there is no way to recover it, so I should run a new ...
0
votes
1answer
388 views

PostgreSQL 10 does not start after something

I'm handling a strange problem with one installation of PostgreSQL 10.4. One of the databases instances of PostgreSQL have stopped working after 7 months without issues. When this guy saw that the ...
1
vote
0answers
45 views

Talend ETL tutorial [closed]

I need a good tutorial on how to use Talend ETL tool to automatically apply ETL process once new files are added to the directory. eg. (using file watcher). Any useful tutorial on talend is also ...
1
vote
1answer
39 views

What kind of tables would I need for the following person database made in MS Access 2003?

It's a database about actors and movies. I want fill it with their age too, so I can answer the queries: at what age they made their last movie. what is the average age when they made their movies? ...
2
votes
1answer
193 views

Database server for web browser [closed]

What is the most used database server for web browsers such as Chrome, Firefox, Opera, or Safari? Maybe I don't understand web browsers, but I am assuming they must have a database server the same way ...
0
votes
0answers
18 views

Is there a way to Store a Query in View/Procedures?

I wrote an Oracle query and I run it manually from SQL Plus or SQL Developer. It has 2 parameters; start and end date/time. Is there a way to store this query in a view or procedures and run it ...
0
votes
0answers
33 views

Why is the database tab not functional in Crystal Reports 9?

I have a particular report that I can run, it prompts for an Oracle username and password and then generates the report. The Database tab is not fully available. I cannot select Database Expert or set ...
0
votes
1answer
88 views

Automatic update of cells on a second tab when they are merely a copy of the previous tab

I have 2 tabs in excel, part of the information on tab one is to be copied into tab 2. It works ok until I insert a new row into the tab 1 spreadsheet. That change to the cells does not reflect in the ...
1
vote
0answers
56 views

Data security in server at home

I am a beginner linux user, and am planning on provisionally opening a game server on a machine I have at home. In addition to the possible DDoS attacks that may occur on this server (the server will ...
2
votes
1answer
2k views

MySQL: creating a user that can connect from multiple hosts

I'm using MySQL and I need to create an account that can connect from either the localhost or from another server, i.e. 10.1.1.1. So I am doing: CREATE USER 'bob'@'localhost' IDENTIFIED BY '...
2
votes
1answer
209 views

Simulating file corruption on Linux programmatically? (for DB durability testing)

Basically, I want to fwrite() n bytes and have < n bytes be written on the actual disk, or whatever other inconsistency artifacts could arise (like sectors being written out-of-order). I know I ...
0
votes
1answer
1k views

What is the difference between DELTA & TOTAL columns in dba_hist_sqlstat Oracle?

I am using the following query to measure the performance improvement between two views SELECT PARSING_SCHEMA_NAME, SQL_TEXT, OPTIMIZER_COST, FETCHES_TOTAL, FETCHES_DELTA, ...
0
votes
0answers
262 views

Odoo 10 stock transfer under wrong company

The Scenario I am running Odoo 10 Community on a postgresql 9.4 database. I have multiple companies setup, including a parent company and two child companies. A PO was setup incorrectly in the ...
3
votes
4answers
767 views

Why is Hadoop not a Data Warehouse?

What are functional reasons why Hadoop cannot be a Data Warehouse On several sites one can see statements that a Hadoop cluster is not a replacement of a traditional data warehouse. However, I can't ...
0
votes
0answers
50 views

What are the steps involved to share the credentials with multiple applications?

I have 2 scenarios here. app1 and app2 both belong to the same domain app1 and app2 both do not belong to the same domain. For both scenarios, I require the responsibilities of frontend and backend ...
2
votes
2answers
3k views

Horrendous decrease in MySQL Performance after upgrade to Ubuntu 16.04 MySQL 5.7.12

I have a development server that I recently upgraded from 14.04 to 16.04. I have a database 'algebra', which hosts data for my website algebra.com. It is a Q&A website that has Questions and ...
2
votes
2answers
350 views

Which wildcards can I use for a Microsoft Access form asking for month and year?

I made an Access Database that includes dates. I have a Report connected to a query that, when opened, prompts the user for a month in numbers (1-12) in order to produce the report for that months. ...
0
votes
1answer
815 views

how to find out session id of executing ssis package through SP_target

I am executing a ssis Package which contains only one data flow task. Simply SELECT statement in source and Table in destination. I want to find out session id of this running Package in SP_TARGET. I ...
0
votes
1answer
148 views

Back end already in use

We are using an Access Database divided in front end and back end (in a shared folder). I distributed copies of the front end to every user. All users have the shared folder and subfolders added to ...
1
vote
0answers
48 views

Is there any way(e.g. software etc.) where data can be matched visually

I have two columns in excel(see N.B.) that contain as below Column1 Column2 ------- -------- USA India Serbia United States of America Bharat China ...
1
vote
2answers
8k views

Postgres restoring replication, timeline conflict

I have a postgres database (version 9.4) with streaming replication (master, slave configuration). Lets call master db A and slave db B. The server running A failed and we had to do a switchover, ...
0
votes
1answer
230 views

How to give DBA Rights to Domain User Account

How can we give rights / permission to domain managed user account, to manage SQL Databases, typically a DBA Rights? I am on Windows OS.
0
votes
1answer
35 views

SQL 2014 adds null transaction log entries every time a custom service wakes up to look at the database.

SQL2014 on Server2012 (12.0.2000) versus SQL2008R2 (10.50.6000) on Server 2008R2. In SQL2014 but not in SQL2008 .... Both examples add the noted entries to the transaction log once a second (every ...
0
votes
1answer
266 views

Find riak node's listening HTTP and Protobuf port

I recently followed and scripted the Riak 5 minute install, successfully getting 4 nodes running on a Ubuntu 14.04 VM. Currently the nodes are running and are joined / clustered successfully. ...
0
votes
1answer
156 views

MySQL Cluster ndb_restore fails with no error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
-1
votes
1answer
4k views

OSX: Postgresql port 5432 is closed. How to open?

Mac OS X Yosemite (10.10.2) Postgresql 9.4.1 (installed with Homebrew) Snort 2.9.7.0 (installed with Homebrew) I can't connect to psql - port 5432 seem to be closed: $ psql postgres psql: could ...
0
votes
1answer
668 views

Postgresql: can't rename the database

PostgreSQL 9.4.1 (installed with homebrew) I want to rename a database. I'm doing this: $ psql postgres postgres=# ALTER DATABASE snot RENAME TO snortdb postgres-# \l ...
1
vote
2answers
2k views

Is there a tool to put a phone number into E.164 format?

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example: (123)456-7890 fred ...
1
vote
0answers
625 views

check_oracle_health with OPS$Nagios account

I can login to my database via sqlplus with the OPS$ account, but i cannt seem to get it to work in with the nagios check_oracle_health. Im testing from the command line. nagios@servername:/usr/local/...
0
votes
1answer
44 views

Reads vs Writes

Consider a Database which is being constantly accessed (read,write,update,deletions etc) , for instance the Database for some particular airlines. I can understand simultaneous writes/updates can ...