The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

1
vote
2answers
51 views

Dedicated SQL instance vs multiple database same server instance

Looking for best practice advice for a sprawling network. I inherited a bunch of SQL servers. The practice has been to just stand up a new VM instance any time a database was needed or add a new SQL ...
-4
votes
0answers
32 views

what prerequisite are required to become a DBA?not overview but to the depth of course [duplicate]

what prerequisite are required to become a DBA?not overview but to the depth of course if any online link is there to learn or course to become DBA then let me know
0
votes
2answers
240 views

Replace a specific part of a string using MySql

I have many Strings in the database Like <iframe src="https://www.youtube.com/embed/-qTiYA1WiY8&index=8&list=PLPNcLSfYNC3Dw535smncyHRCBRmdf1Bti" frameborder="0" ...
1
vote
1answer
3k views

Not receiving archivelogs from production to remote side

I have a scenario in which we have Designed data guard. Where we have 2 standby sides. One standby is located locally and 2nd standby is located on remote side. The distance between local and remote ...
0
votes
1answer
490 views

RapidMiner Not Connecting To SQL Server Database Connection

I recently installed RapidMiner and tried connecting the application to my MS SQL database connection via the Manage Database Connections feature. I have followed video tutorials on integrating SQL ...
3
votes
3answers
38 views

Call to default values (MySQL) in a procedure

For the sake of an experiment, we're working with the following procedure (same DB, multiple tables): delimiter // CREATE PROCEDURE mysql.insertTables (_first_name varchar(30), _last_name ...
1
vote
1answer
38 views

Importing Oracle12c database

i am using Oracle 12c in debian Jessie i want to import an old database exported with expdp on oracle 12c when i try to launch the commande 'impdp' i got those errors : 'ORA-39002: invalid operation' ...
1
vote
1answer
215 views

Can we restore backup for standby from external hard drive with differnet drive labels

I am using windows server 2003 and Oracle database 10g R2 and i have taken the backup using RMAN of my primary database in Drive label E. The size of backup is 1.5TB. In my standby database i don't ...
1
vote
2answers
81 views

How can I remove 'Using temporary ' and speed up my query

Hi I was working for hours to speed up this query using indexes, but its useless.. im tyring to optimize by eliminating 'Using temporary' and using only indexes. I wonder if there is another ...
0
votes
0answers
42 views

Error ORA-12547: TNS:lost contact

I installed Oracle12c Database in my server i run SQLPLUS with the command 'sqlplus /nolog' and when i type 'conn sys /as sysdba' i got this error ORA-12547: TNS:lost contact Can you help me ...
3
votes
1answer
9k views

How to run DB Admin Tool (GUI) in IBM DB2 Express-C?

I had installed IBM DB2 Express-C in Windows but I can't find any shortcut to launch the Administration Tools (GUI). When installing, I had selected "Administration Tool" option (I had checked twice ...
0
votes
0answers
16 views

Diagnosing why postgresql query is going in a seemingly endless processing loop

I maintain a social forum built with Django and postgresql 9.3.10. There's a maintenance query I run via psql, to clean up my postgresql table. It goes like this: begin; DELETE FROM links_seen WHERE ...
3
votes
1answer
142 views

How to directly query other user tables

I am trying to learn Oracle database and I am having difficulties on importing a backup file with impdp command. I googled deeply but couldn't find answers to my problems. What have I done until now ...
2
votes
1answer
23 views

Count of range on datetime in MySql

I want to group table entries for each userId only if they are consecutive entries in the table. I have a table like this. id userId transactionTime 1 1 2016-04-13 22:15:44 2 1 ...
-1
votes
1answer
17 views

SQL Server MIRRORING - FAIL ON SECONDARY

I have a problem in the SQL Server Mirroring. Current system: Server: S1 (Principal) & S2 (Secondary) Databases: D1 (2.5TB) & D2 (20GB) Situation 1: without witness 1. D1 & D2 were ...
0
votes
0answers
10 views

don't understand atquery command script [migrated]

I'm using a big-data database. in one of it's tutorial it has recommended me to use below bash scripts if order to running queries: #!/bin/sh # this will launch the real atquery program with the ...
0
votes
0answers
55 views

RDS MySQL memory usage question

I have an instance of RDS of MySQL 5.7.10 I am on a package: db.t2.micro which grants me 1vCPU and 1Gib of memory. I am using Monitoring window to monitor the CPU/Memory usage. I do not understand ...
3
votes
2answers
141 views

Best fill factor for GUID clustering key

We have a database that uses GUIDs for most of their columns in a data (non sequential). Does anyone have any best recommendations for fill factors on a GUID database in an hgih insert/update ...
0
votes
0answers
13 views

Remedying psycopg2:OperationalError in postgresql 9.3.10 database

I have a Django app + postgresql 9.3 DB, hosted on Ubuntu VM. Recently my VM ran out of disk space, resulting in no space left on device errors showing up in my logs. I cleared the space on the device ...
0
votes
1answer
39 views

I'm a beginner, studying Data modelling as part of my course. I'm having trouble understanding Normalisation. How can i improve?

It was difficult to frame the title given the word limit, so apologies for that. Currently I'm studying DBA and Data modelling as a part of my ICT Apprenticeship course in a Web Development team. I'm ...
4
votes
2answers
16k views

Table is marked as crashed and should be repaired

I have MySQL and Nagios installed Linux PC (Centos5.5) I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table) The data fetching working properly (confirmed ...
0
votes
1answer
72 views

Error launching sqlplus

I try to run sqlplus on my server with the command sqlplus /as sysdba and I got this error sqlplus: error while loading shared libraries: ...
0
votes
1answer
35 views

Table/database design question

Suppose you have these fields to keep track of in records: (first_name, last_name, state_id, stateid_status, day, month, year, id_status, id, criminal_status, charge, plea, sentence, create_time, ...
0
votes
1answer
23 views

Check is there is an Empty Column Value

Let's say we have a Table in MySQL Database called TAB1 that Contains two Columns col1 : col2 . the question is : is there a way to check is any of these Columns Contain a Null or Empty Value? for the ...
6
votes
1answer
1k views

What to do when handed a server the first time?

I'm a new SQL Server DBA in a new company. Just recently, they have handed me access to the server. There are about 50 OLTP databases with different sizes, some ranging 250MB and the biggest database ...
0
votes
1answer
16 views

Install MongoDB on Debian

I tried to install MongoDB using this command: apt-get install mongodb=3.0.1 But the version 3.0.1 was not found. How can I install it?
1
vote
0answers
40 views

How can I partition records vertically across machines?

I recently asked two questions: (1) how to store and connect partial records in two or more machines, with the record halves correctly associated, and (2) how to determine the increase in time/space ...
2
votes
2answers
44 views

Is an Oracle 10g instance dependent on the windows account authentication?

I have created an Oracle 10g (10.2.0.4) instance on a Windows 2003 Server with a domain user xxx having domain administrator level privileges. Now I wish to change xxx's password. Will it impact the ...
0
votes
1answer
23 views

mySQL Event Help - Update colum value for each row every 15 minutes

Okay so if I have a login database: id | email | pass | attempts ---------------------------- 1 | "" | "" | 4 2 | "" | "" | 2 Attempts marks the number of attempts made at logging ...
-4
votes
1answer
28 views

SQL Server Table Creation Help [closed]

I'm a newbie, taking University course on DBA with Microsoft SQL Server and trying to write my first manual create table table but I keep getting errors in query or in using SQL Fiddle My attempt is ...
0
votes
1answer
40 views

Oracle 11G, Move indexes from one datafile to another

I have an Oracle 11G DB installed on Windows Server 2008 SP2 64bit OS. Below is some data files usage statistics: As you can see, there are two files: index01.dbf and index02.dbf belong to the same ...
-1
votes
2answers
42 views

Good learning source for learning normalization [closed]

Can anyone recommend a good learning source to learn about database normalization from scratch please? I referred to many youtube videos but they weren't fit to me.
6
votes
2answers
5k views

efficient way to poll database?

I have a Linux CentOS server hosting an Oracle 11.2 database, which communicates with an application server, which communicates with a client (a Flex application). I'll try to describe the pseudo-code ...
1
vote
1answer
106 views

MongoDB allocates chunks only to Primary when sharding is enabled

I'm setting up an instance of MongoDB with 3 shards. I've setup everything seemingly correctly by following the docs and comparing my config with that of a friend who has a similar setup but with a ...
0
votes
1answer
32 views

Should my database be on the same server as my web server?

We are about to add user login and management to a high traffic website. I am wondering if I should put the postgres database on the same server or put it in a different node in the internal ...
1
vote
4answers
59 views

User privileges error on server maria db Create trigger Drop trigger

User privileges error on server maria db User : user1 DB : db1 Error 15:00:46 DROP TRIGGER IF EXISTS audit_trigger Error Code: 1419. You do not have the SUPER privilege and binary logging ...
9
votes
2answers
1k views

MS SQL Server Cumulative Updates - Best Practices

I'm trying to get an idea of what recommended best practices are for the SQL Server Cumulative Updates. Currently, we run on the idea of "do nothing unless an issue fixed by the CU is one we ...
1
vote
2answers
32 views

Insufficient disk space in Filegroup

One of my jobs is failing and it shows below message. Error: Could not allocate a new page for database 'Reporting' because of insufficient disk space in Filegroup ‘PRIMARY’. Create the necessary ...
0
votes
0answers
64 views

Database as it is raw content

recently I asked my hosting company to give the backup of my database . I asked them to create a new database and import backup to that database. But they reply cannot dump database ...
0
votes
2answers
43 views

could not allocate a new page for database [closed]

Could not allocate a new page for database 'bteexamination' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding ...
0
votes
1answer
27 views

How can I set maxIdleTimeMS by command line or mongo-shell?

So, I have deployed my PHP application (using Laravel). However , I've noticed a high connection number in connection pool. I would like to know how could I to set the maxIdleTimeMS parameter through ...
0
votes
0answers
17 views

3023 : File serialization issue with transaction log backups

I am trying to take a transaction log backup on one of the AO replica servers. It throws an error saying that backup operations must be serialized. I googled this and found that only one backup should ...
1
vote
0answers
303 views

Records not getting replicate from Mysql 5.5.32 to MySQL 5.6

I have a MySQL 5.5.32 server (community edition) on one Linux server which is master. I have a MySQL 5.6 server (community edition) on another Linux server which is slave. I have installed various ...
0
votes
2answers
56 views

MySQL Backup Strategy

We are running the backup from the replication server and it is working good, since we are not facing any other issues, some information for better understanding our strategy: Backup Type: Full ...
0
votes
1answer
33 views

To use tpc-h benchmark its really necessary create primary and foreign keys?

Im doing some tests with tpc-h benchmark. And Im with a doubt, and I didnt find any answer. The tpch-h benchmark simulates a data warehouse environment. And the most important here are the queries ...
0
votes
2answers
51 views

Practical Aspects of Making Changes to Databases [closed]

I am setting up my first database and have gone through the standard process of studying the business logic, figuring out the entities, associated fields and dependencies. This is the ...
0
votes
1answer
130 views

Huge database… queries too slow. How to improve performance? [closed]

I'm currently managing a MySQL database with 30 million rows(many more to come). The entire database is 280GB. The server has 4GB of RAM and 3.2Ghz 4 core processor. The largest column stores an array ...
0
votes
1answer
44 views

MySQL ADD KEY meaning

This code below is creating a primary key on table User, but Im not understanding the second ADD KEY (C_NATIONKEY), do you know what is doing? Its something about foreign keys? ALTER TABLE USER ADD ...
0
votes
1answer
71 views

Starting MySQL… ERROR! The server quit without updating PID file (/var/lib/mysql/SI-CloudDB-003.pid)

I have changed mysql (5.6.29 linux centos 6.6 final) port from 3306 to 3310 and getting below error and its work fine with 3306. Starting MySQL... ERROR! The server quit without updating PID file ...
0
votes
1answer
81 views

ORA-29913 and ORA-30653 error selecting an external table

I created an external table using a .tbl file and now Im trying to select all rows from that table, using: select * from users_load; But Im getting this error: ORA-29913: error in executing ...