The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

9
votes
3answers
5k views

Database Administrator vs Database Architect?

In terms of job responsibilities and activities, what is the difference between a Database Administrator (DBA) and a Database Architect?
0
votes
1answer
39 views

Database access: what should I do here?

I'll explain my situation here, I hope I'm posting this on the correct site, otherwise I'm sorry and I'll move this to somewhere else. I've built a Java program in order to control sales, inventory, ...
0
votes
2answers
39 views

How can I handle delayed records a month or older on a table clustered on time?

I have a two part question really for anyone working with data warehousing where they have large fact tables. Question 1 Lets say you have a table that has 500 million or more records in it that is ...
44
votes
12answers
5k views

How could DBAs be more 'programmer friendly'?

The answers and comments on the dba.se version and programmers.se version of the question "What are the arguments against or for putting application logic in the database layer?" are very revealing ...
1
vote
2answers
2k views

What is meant by DDBB?

Today we got a term DDBB. I am not sure whether it refer normal database or database driver in certain programming language. Google search did not help me much in this. And I am sure it is not 'Dirty ...
0
votes
0answers
18 views

Wordpress DB's and fixing corruption

I'm usually over in the Wordpress stack exchange but I thought this would be more pertinent in this community. Recently I took down a site I spent a few years developing it's content and closed the ...
0
votes
0answers
25 views

Does extending datafiles affect performance

We have an Oracle 10.2.0.3.0 on Windows 2003 Server which is scheduled for upgrade within the next six months. One tablespace is about 2TB in size with over 250 data files. Some of these were ...
1
vote
1answer
22 views

Mongo database error in resource allocation

pthread_create failed: errno:11 Resource temporarily unavailable maximum number of open files 64000 maximum number of processes 64000 It is taking 50seconds to complete query. How to allocate ...
1
vote
0answers
64 views

Prdouction Database went into restoring mode

Yesterday one of my production database went into restoring mode,but fortunately i recovered it using below query USE MASTER EXEC SP_CONFIGURE 'Allow updates',1 RECONFIGURE WITH OVERRIDE GO EXEC ...
1
vote
2answers
86 views

How can I make an automatic copy of a MySQL database to another MySQL database on the same server?

I have two MySQL databases called LIVE and REPORTS on the same server. I want to copy the LIVE database and all its contents into the REPORTS database everyday at a specific time frame between 1 am ...
2
votes
1answer
94 views

Two Databases on same server handle date differently

I have two databases on the same server, one is a backup of the other from a few weeks ago. I have a third party application that has started misbehaving. It logs the LastLoginDate of a particular ...
5
votes
2answers
3k views

Update Statement takes forever to complete [closed]

I have table around 1250000 records, and 80 columns Table Structure CREATE TABLE [dbo].[Table] ( [Column1] [int] IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL, [Column2] [int] NULL, [Column3] [int] ...
0
votes
2answers
91 views

Unable to start Oracle database

We have a oracle database, one data file(users table space) of the instance got corrupt and another data file(containing application data) was deleted due to some issue. The database is in ARCHIVELOG ...
1
vote
2answers
50 views

Connect Two MYSQL Databases

I have two servers. Eg. server A and server B. I want to select data from server A and insert into server B using MYSQL. How to make it? I can access server A's database remotely from server B but i ...
2
votes
2answers
52 views

How to optimize performance of backup process? Servers go down during backup

The context - So I am an intern (So I'll appreciate a more noob friendly response) and we have several websites on a server of which we do a backup daily, at midnight. We use MongoDB and there's a ...
0
votes
0answers
76 views

Merging time series in influxdb 0.9.x

I have a system which demands monitoring its metrics. In order to do that I use grafana + influxdb. The version of influxdb I currently use is 0.9.x. I want to be able to calculate some statistics. ...
1
vote
0answers
55 views

SQLPlus TNS:protocol adapter error

i have two Oracle 12c instances. currently both are shutdown. when I try to connect with sqlplus / as sysdba it says tns protocol adapter error contents of tnsnames.ora are DB12102 = (DESCRIPTION = ...
16
votes
2answers
280 views

Why is it taking longer to create an index after column size increases?

Our vendor changed column widths on almost every column in the entire database. The database is around 7TB, 9000+ tables. We are trying to create an index on a table that has 5.5billion rows. Before ...
0
votes
3answers
766 views

SQL Server: unable to copy database

I'm trying to create a dev database so I don't create triggers and such on the production database. I use the right click -> Taks -> Copy, followed the wizard and the process starts. After maybe a ...
1
vote
1answer
75 views

Unable to apply patch in Oracle Grid Home

I need to set up a RAC environment using two nodes. Details of each server are: OS : Windows Server 2012 R2 64bit ( certified by Oracle ) RAC: Oracle Grid 11.2.0.4 While installing the Grid ...
0
votes
0answers
67 views

Oracle RAC Database software installation failing after successful Grid installation

2 node installation. Grid successfully installed. RAC DB software installation fails on node 2. Logs below: ****Oracle Services For Microsoft Transaction Server failed**** Node 1 (installation ...
0
votes
0answers
66 views

Database design recommendation for a workflow-enabled ticketing application

I am working on a ticketing application; tickets are created and they need to be resolved. A ticket needs to go through many steps (in this case 4 steps). Not just a single user in my application can ...
1
vote
0answers
62 views

Sql Server Reporting Services will not connect to sql server 2008r2 using SQL server Connection

I have set up a new SQL Server 2014 default instance. In my Sql Server 2014 Configuration manager I see my 32 and 64 bit SQL Native Client 11.0 configurations and all protocols, pipes, tcp/ip,shared ...
1
vote
2answers
134 views

How to change dbid in oracle to specific value?

I want to change dbid of oracle 11g database. Current dbid = 2241883xxx And want to set dbid = 1380515xxx
0
votes
1answer
128 views

Mongo error : Could not lock auth data update lock. on root user

i have a mongodb on 2.6.9. my connected user is root: mongo --username myadmin --password thepassword --port 27018 --host 127.0.0.1 admin MongoDB shell version: 2.6.9 connecting to: ...
2
votes
1answer
137 views

SQL*Loader-926, ORA-04031 unable to allocate x bytes of shared memory

A customer received this error while importing serveral files. The import routine (VB.NET) is using SQL*Loader (Release 11.2.0.3.0) via Process on each table separately (64 in total) and is called ...
1
vote
1answer
315 views

Accuracy of mysqldbcompare vs other tools like pt-table-checksum

I was curious to hear what everyone's experiences are with using mysqldbcompare vs pt-table-checksum( from Percona Toolkit ) to find the differences between two MySQL databases. I have heard that ...
0
votes
0answers
78 views

Login failed for user xxx because the account is currently locked out

Sometimes, my database user is locked out for no reason, and seconds after then unlocked, I was trying to found a reason around www, but I just found a manner to correct the intermitent error each ...
-1
votes
1answer
91 views

Database Schema for Maintaining Phone Contacts of users

I was building an Application where I need to sync user's phone contacts. Now since a phone contact in user's phonebook have N different fields, such as name, contact, work contact, email, email2, ...
-4
votes
1answer
238 views

How do I create multiple users with one login to have access to single database [closed]

What is the benefit of creating a login for users? If a login grants the principal entry into the server, I want to grant this login to three users: db-writer db-reader ddl-admin each with ...
5
votes
2answers
2k views

Transaction log is full due to 'CHECKPOINT' for DB in simple recovery model

For one of our DB's on SQL server 2012 RTM, We could not perform almost any troubleshooting step as the error says: " Transaction log is full due to 'CHECKPOINT" This being a dev database, its ...
1
vote
1answer
1k views

Oracle - ORA-01654: unable to extend index in tablespace

I referred to the below related question, but it was not helpful in my case: ORA-01654: unable to extend index <name of the index> by 128 in tablespace <name of the Index tablespace> I ...
0
votes
1answer
138 views

How to solve “Servlet error” when using database control in Oracle 12c?

When I want to use Oracle 12c GUI, I receive an error as written below: Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in ...
4
votes
1answer
231 views

Re-designing a Database cost and advice [closed]

The web application I am working with has a huge Database that is a real mess, no foreign keys, no constraints, no indexes, no optimization, no normalization, nothing. Until now, the logic has been: ...
0
votes
0answers
46 views

Batch Processing in Talend open studio for data integration

I am using TOS for data integration to transfer a data between mysql and postgres. Its transferring data between small tables successfully. But a table has 3GB data. while trying to transfer data its ...
0
votes
1answer
93 views

Time out while connecting to the database. Current time out value is 30 seconds

I am installing a repository creation utility on a windows 8 x64 bit system and getting the following error: Time out while connecting to the database. Current time out value is 30 seconds When ...
3
votes
3answers
146 views

database corruption

The database is corrupted and there is no recent backup, Error from DBCC CHECKDB Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type ...
1
vote
2answers
188 views

Connecting to a new RDS instance from an EC2 instance

I'm trying to use MediaWiki and WP to connect to two MySQL databases. The databases are working properly and so are the forms but when I try to establish a connection to the database with MediaWiki ...
15
votes
2answers
717 views

How to Drop Table with Non-Printable Character on its name

I have a legacy table with a name containing non-printable characters (CHAR(31), to be specific). The non-printable character is beside a underscore, and I've discovered that the shortcut ...
0
votes
0answers
29 views

How to work with a master database and multiple terminals

We have a main database in postgres used to assemble updates using flyway and modified from a single terminal. Now we want to know what the best way to work with multiple terminals making changes to ...
4
votes
1answer
198 views

Star join query optimization - Change partitioning, use columnstore?

I am trying to know the best possible way to improve performance of a query given to me by my client. It contains a few tables which are joined and one of table is called dwh.fac_sale_detail which ...
1
vote
1answer
78 views

Permissions for sys.database_mirroring in SQL Server

I need to assign permission to use sys.database_mirroring and of course I want to give the minimum amount of privilege. When I looked at microsofts homepage it says: To see the row for a database ...
0
votes
1answer
36 views

How to Set up SSRS Web Services to run under another port than 80?

What steps do I have to pace to run Web Service URL and, Report Manager URL, under another port rather than 80? (DBMS is SQL Server 2008R2 and OS is WIn Server 2008R2).
4
votes
2answers
21k views

How to backup IBM DB2 Database online?

I tried to backup the IBM DB2 (LUW) Database using this command: ./db2 backup database DBEMP to /home/user1/db2bkup But I got this message: SQL1035N The database is currently in use. ...
0
votes
0answers
36 views

How to improve the slow performance with Insert operations in SQL Server 2005?

Suddenly our server started to have a bad performance, after trace the error, I identified that the inserts are the problem, this seems a know bug: https://support.microsoft.com/en-us/kb/940545 (The ...
0
votes
1answer
153 views

SQL Server 2012 Enterprise: Copy Databases to New SQL Server, Same Domain, Users, Etc

Am having trouble with what seemingly should be an easy process. I'm a SQL Server n00b, so please be gentle and very explanatory with your answers. Currently, I have a SQL Server 2012 cluster ...
0
votes
1answer
45 views

Need to maintain transational consistency of the data across both servers, need to achieve these goals without manual intervention

I got this question about MS SQL Server 2012 administration, two production servers in the same data center. You need to ensure that database remains available if a catastrophic server failure or a ...
1
vote
0answers
202 views

Records not getting replicate from Mysql 5.5.32 to MySQL 5.6

1. I have a MySQL 5.5.32 server (community edition) on one Linux server which is master. 2. I have a MySQL 5.6 server (community edition ) on another Linux server which is ...
1
vote
3answers
1k views

List all tables from all user databases

sys.tables lists all user tables from a single database, But it doesn't have their schema name. If I know existing databases when creating the code, I can use USE to browse all databases, query ...
0
votes
0answers
13 views

Redshift schema access permissions not applied to new tables [duplicate]

I've granted privileges to a group in Redshift: GRANT USAGE ON SCHEMA public TO GROUP read_clients; GRANT SELECT ON ALL TABLES IN SCHEMA public TO GROUP read_clients; However when I create a new ...