The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

0
votes
1answer
589 views

Where to install Oracle client software on SharePoint 2010 Server

We have our ASP.net web application hosted on a SharePoint Server 2010. Our application uses oracle database to save and retrieve data.For our application to work on SharePoint server we need to ...
0
votes
1answer
474 views

Security Concerns of SQL Server Express for Web e-Voting web application

I am building a database driven web application. The web application is basically an E-Voting website, where users can register and vote on things that concern their community ... etc. The database ...
0
votes
1answer
3k views

Plugin 'FEDERATED' is disabled

Im trying to start Mysql using easyPHP : the response is an alert window to a log file. The main error is <-- Plugin 'FEDERATED' is disabled -->. Through my research on internet i found that the ...
0
votes
1answer
493 views

replication breaks after upgrading master

I have a set up of replication with master 5.1.30 and slave 5.5.16 and the replication is working good Now i have upgraded mysql master to 5.1.47 As far as i know we have to turn off the log bin ...
0
votes
2answers
4k views

Secure Linked Server - Non privledged user possible? Registry corruption?

Is it possible to use a non privledged Windows domain account to impersonate itself in a linked server? And why would it be unable to read the registry for available network protocols? Overview: ...
0
votes
1answer
3k views

TSQL query for viewing start/end of all SQL Agent jobs yesterday

See this related query: What's a good tool for visualizing SQL Agent jobs? I'm not after a visual tool however, since I am looking to build my own visualisation. This is my starting point, but ...
0
votes
1answer
108 views

Is Index Used for This Query

If so, which one? How do we know? I have 3 indexes in a query. Actually only the first 2 should be useful { "v": NumberInt(1), "key": { "LongitudeLatitude": "2d", "Prominent"▼: ...
0
votes
1answer
4k views

What is going wrong with postgresql initdb? Why is the `UTF-8` encoding not getting enforced?

I am using PostgreSQL 9.1. Trying to enforce UTF8 encoding as default. This is what I am doing. service postgresql initdb -E 'UTF-8' \ --lc-collate='en_US.UTF-8' \ ...
0
votes
1answer
789 views

Unable to restore database in Oracle 10g

I created a database backup using the expdp command in Oracle 10g. The backup appears to be created successfully. However, while restoring using impdp command I get the following error message. ...
0
votes
1answer
630 views

What are commonly used database types? [closed]

There are a lot of database types. Can you list a list of the top classification of databases commonly found in schools and offices? Any help is appreciated. Hope to see compressed and summarized type ...
0
votes
0answers
26 views

Managing large database tables, large tables VS seperate databases

In my project I have a system where users sign up and perform daily tasks. Note that I am not a database expert, none the less I am trying to solve a potential issue that may arise. A problem has a ...
0
votes
0answers
16 views

DBCC DBINFO and linked servers [on hold]

I have 2 servers A, B. A has a linked server connection to B. B has a stored procedure that runs DBCC DBINFO WITH TABLERESULTS for a database name passed into it. From server A I can execute the ...
0
votes
0answers
19 views

How to access a SQL Server database from other computer connected to the different workgroup? [on hold]

I want to access my database from my office network to home net work (not in teamviewer). Cqn you kindly help me on this?
0
votes
1answer
16 views

File share Witness or Disk Witness

I have 2 SQLServers at production site Windows Server Failover Cluster and 1 SqlServer at DR site. I will add the DR node to existing windows cluster and configure AOAG. So for this should I go for ...
0
votes
0answers
9 views

What's the point of Doctrine2 ArrayCollections in OneToMany assotiations? [migrated]

I'm new on Doctrine2 and I'm trying to understand what's the goal of having an ArrayCollection on the inverse side of a OneToMany assotiation. Let's say I have two entities, User and Comment, that ...
0
votes
0answers
14 views

error while creating user with a default tablespace

I am new to Oracle 12 and I don't know how to work with Container Databases (CDB) and Pluggable Databases (PDB). In Oracle Database 12c I created a database with the dbca and I created a tablespace ...
0
votes
2answers
40 views

ORACLE12 - Connect Via SqlPlus

I have a local installation of Oracle Before i can connect directly via SqlPlus but now when i try to connect i have this error : ERROR: ORA-01034: ORACLE not available ORA-27101: shared ...
0
votes
0answers
48 views

FATAL INS-32012 Unable to create directory - Oracle 12c client installation

I am installing oracle client as Administrator in my Linux machine as a silent mode, I faced issue like this [FATAL] [INS-32012] Unable to create directory: /u01/app/12.1.0.2/admclient64. I don't ...
0
votes
1answer
37 views

Database convert character_set_server latin1 to utf8

I am writing about a problem on the character encoding that i have on my site with Magento. In practice, the special characters do not take utf8 and gives me the classic non-coded characters: Ã. ...
0
votes
0answers
34 views

Oracle database in maintenance mode without patch

I could not enable maintenance mode in oracle database without patch Also I don't have patch(Since I don't have Support Identifier). @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE SP2-0310: unable to ...
0
votes
0answers
22 views

SQL Server Job does not execute when scheduled, but does execute manually, how do I get it to run as scheduled? [duplicate]

I am running SQL Server 2014 SP 1 CU 5. The job did work in the past. The schedule is enabled. The account it is running under is an ADS account which has sysadmin rights and has delete rights to the ...
0
votes
0answers
26 views

Cannot Start MongoDB

I cannot start MongoDB on Debian(Jessie 8.4 Stable). I generated the keyfile and added the path to the key file to the configuration and uncommented the "auth=true" but when I try to start the service ...
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 ...
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 ...
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 ...
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
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 ...
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?
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
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 ...
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
41 views

Array as a column vs lookup table

Hi I have two tables that has one to many relationship. Table 1 Users: ------------- | id | name | ------------- | 01 | John | ------------- | 02 | Harry | ...
0
votes
0answers
28 views

Problem seeing Table Diagrams after Downloading SQL Server 2014. Default Status? [duplicate]

I recently downloaded and installed SQL Server 2014, and I am having trouble even viewing the table diagrams (i.e., the database ERD). Just curious: What kind of access level is necessary in order ...
0
votes
0answers
17 views

MS Access - Extract Data from Proprietary mdb file

my friend has this "software" that manages financial records, with a lot of user data per record. This "software" is really an access file. To launch it, you use msaccess.exe program.mdb, and it ...
0
votes
1answer
38 views

Relationship between data independence and database schema

What is the relationship between data independence and database schema? I know both of them separately. But I don't know how to explain the relationship of these two.
0
votes
0answers
25 views

search pgadmin for column

I'm a front end dev and this is my first time doing serious database work. I have json sent to the client that looks like this: prop[0].event.history = 'foo'; //can also be 'bar' I wanted to ...
0
votes
0answers
6 views

What are the advantages of Packet Inspection and SHOW FULL PROCESSLIST over PERFORMANCE_SCHEMA?

We have several MySQL Servers (v 5.1) scattered across different geo locations. We are considering upgrading to the latest MySQL version as we heard a lot of good things about PERFORMANCE_SCHEMA ...
0
votes
1answer
25 views

Unstructured to Structured Data

This is highly a research based question about converting the unstructured textual data to structured data. Are there any systems or tools perform automated process of converting the unstructured data ...
0
votes
0answers
70 views

Create File,secondary FileGroup then move a table and restore database with 'Primary'

I created a secondary FileGroup, added a File, moved a table there, and then restored the database with 'Primary'; however, the table name is still there and when I use a select statement I get an ...
0
votes
0answers
11 views

How can i delete or clear log files in sql? [duplicate]

I would like to clear the space occupied by log files how to do that in an sql server
0
votes
0answers
59 views

Phpmyadmin not displaying table data

I have a table named "log", which basically stores error log for my php application. My application has database running on rds, and recently i had to delete logs from this table, so i downloaded a ...
0
votes
1answer
45 views

Query other database's INFORMATION_SCHEMA tables

I have a shared database that stores procedures for all the other databases on the same server. This helps maintain one instance of a procedure rather than copying it across all databases. As long as ...
0
votes
1answer
241 views

pgbouncer 1.7 with TLS/SSL client and server connections

With settings borrowed from a similar server running Postgres 9.4.1 & pgbouncer 1.6.1, I have multiple users connecting to the database through pgbouncer on port 6543. I also have a second server ...
0
votes
0answers
14 views

Manage clone of Production MongoDB on UAT env

I have mongodb (v2.4.9) replication setup on AWS ec2. I have one primary and 2 secondary for Production environment. The db size is around 80 GB and i am maintaining a snapshot of primary db server ...
0
votes
0answers
31 views

How to clean up transaction logs in production database [duplicate]

My stored procedure when executed on server machine takes nearly 1hr but when executed in my local it takes 1 minute. So when I check the log file, its size was near to 65 GB. Guess these logs are ...
0
votes
0answers
109 views

how to recover everything from ibdata in mysql

I lost all my databases files after my hard disk was broken, In a way or another I got ibdata files the size for the file is 4GB.After replacing log files and files and type innodb_force_recovery=6 in ...
0
votes
1answer
51 views

what is the consequence of setting enableQueryTimeouts to FALSE?

MySQL Connector-J has a property enableQueryTimeouts which is TRUE by default. However, in the documentation it is mentioned as : When enabled, query timeouts set via Statement.setQueryTimeout() ...
0
votes
0answers
459 views

Oracle Error ORA-15042 when trying to mount a diskgroup

everybody. I am having some troubles mounting my DATA diskgroup. I am getting this error: Mounting Disk Group DATA failed with the following message: ORA-15032: not all alterations performed ...
0
votes
1answer
60 views

Movement of Standby database from one location to another location

Looking for help on below mentioned process We are planning to move the standby database from Location A to Location B. I need your help to move this database using lift and drop method, by ...
0
votes
1answer
22 views

Cannot access mysql in ec2 instance

mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I installed mysql server on a ec2 instance and started it. Seems like it started , but when I ...