The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

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
27 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
60 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
77 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
218 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
101 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] ...
1
vote
2answers
54 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
59 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
169 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
73 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
297 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
886 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 ...
0
votes
0answers
145 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
87 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
2answers
240 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
185 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
191 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
390 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
102 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
146 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
403 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
3k 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
3k 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
150 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
236 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
61 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 ...
3
votes
3answers
198 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
264 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
736 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
32 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
241 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
105 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
48 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
23k 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
38 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
170 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
67 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
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
17 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 ...
0
votes
0answers
74 views

Error: 17806, Severity: 20, State: 14

I have frequent access error log like below: Error: 17806, Severity: 20, State: 14. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated ...
0
votes
0answers
173 views

Cant connect to local teradata database in VMware image

Login credentials for VM linux: root/root database: dbc/dbc The image`ve been downloaded from here. (this version TDExpress15.00.02.08_Sles11_40GB.7z) I successfully launched VM image, but failed ...
0
votes
0answers
86 views

Get Event name during it's execution

We want to maintain event's logging within the MySQL DB so I want to get event's name during its own execution. Is there any way to get event name in its own execution? For example below are the ...
0
votes
2answers
397 views

Need Help maintaining multiple databases for a multi-tenant application?

i need some information about multiple databases for a multi-tenant application ? I am working on a project in which we are maintaining separate database for every company? The Companies Database ...
0
votes
0answers
153 views

Interpreting AWR report(top queries)

Could someone help me to understand a part of awr report? Below I'm pasting the top sql statements. I see there was a (very) huge number of executions of the first query. I see it was called from web ...
0
votes
1answer
54 views

I have a database design for an E-commerce website. Need to know how to display related product for each specific product

For example: A customer is viewing a product on the website, say a laptop. There's a section on the left where i need to display products from the database that are associated with this particular ...
0
votes
0answers
9 views

Pentaho getfilename error

I am try to send 20 mail with attachments using pentahi DI, Jobs are like below Get File Names--->Add constants--->Mail But some mails are not send with below error, Thay say files are not ...
4
votes
1answer
67 views

Problem when add administrator for Analysis Server ( SQL Server 2008 R2 )

I'm trying to add a user as an administrator in Analysis Server, doing this: 1 - Connect - Analysis Server - Right click on the Instance - Properties - Security - ADD : This number was already ...
0
votes
0answers
28 views

SQL TDE Key Format

I'm trying to find the Key Format that SQL TDE uses. Is it PKCS? If so, what #? I haven't been able to identify this based on research done on MS website. And, there is no mention of key format during ...
2
votes
1answer
840 views

Can I do VACUUM FULL to pg_largeobject table?

I have two tables (table1, table2) in a Postgres 9.1 database. Both having oid type. Each table 1 million records. And pg_largeobject table size is around 40GB. I have removed 0.9 million records from ...