The discipline of Operational and Architectural Management of Database Systems.
2
votes
2answers
116 views
Database structure for a system with multisite
The system I'm working is structured as below. Given that I'm planning to use Joomla as the base.
a(www.a.com),b(www.b.com),c(www.c.com) are search portals which allows user to to search for ...
2
votes
1answer
78 views
How to get dependencies order
I have a Database Called Total and I have about 40 tables in it.I am trying to move the tables in the database into a different server So I have prepared all the create table scripts but the problem ...
2
votes
2answers
130 views
How to compare the database of a backup from another environment
Has anyone had any luck with taking a backup (approx 30 tables) from an Oracle database's live environment, then loading a test environment with this backup and doing a comparison between the test ...
2
votes
2answers
69 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. ...
2
votes
2answers
1k views
Difference between Row based and statement based replication in Mysql?
What is the Actual difference between Row based and Statement based replication I actually looking in terms of replication effect's on slave.
If I am using Row based replication then whats is the ...
2
votes
2answers
1k views
Generate sample data for an Oracle database [closed]
Good morning,
What free [or trial] software can I use to generate sample data for an Oracle database?
I've been trying with various tools, but none work.
Thanks for all suggestions,
Alec Taylor
2
votes
1answer
402 views
Are there any good database management applications for JDBC/Java databases?
I am working with an Apache Derby/JavaDB database via JDBC. Before have I been working with MySQL and used phpMyAdmin as a good Database Management tool.
Is there any good desktop application for ...
2
votes
3answers
35 views
Oracle error : Shutdown immediate error
echo $ORACLE_SID
YBRD
conn sys/hello as sysdba
SQL>shutdown immediate
Then I was waiting for it to shutdown for a couple of minutes. It didn't, so I closed my window.
Then I again logged in and ...
2
votes
3answers
145 views
Merging tables with a 1 to 1 relationship in a database
Is it a good idea to merge two tables that have a 1..1 relationship together?
I have inherited a database with too many tables linked together in a 1..1 relationship. I'd like to evaluate the ...
2
votes
2answers
7k views
How to create Sql Server login for a domain account?
All,
I have Sql Server 2008 installed on a server (let's say Server1) in a Domain (let's say AD). I also have a domain account called AD\Sql1. This is not an Admin account on the Domain (AD), but I ...
2
votes
1answer
443 views
Problem with Czech collation Czech_CI_AI in MS SQL Server 2008 R2
I have the following issue with accent insensitive search in Czech language. My database is set to Czech_CI_AI collation. For some diacritics system works correctly (ie. I), but for some does not (ie. ...
2
votes
2answers
380 views
How to compare performances of two databases
There are two database servers and I want to compare their performances.
Both have Windows operating system and and Oracle (10.2.0.4 and 11.0.2) database.
Both are OLAP databases with 15-20 users ...
2
votes
3answers
355 views
Tool to monitor database data
I would like to tool that when record data changed inside all tables. so later i would get a report like
table user
added record - 3,user3..
deleted record - 2,user2..
2
votes
1answer
82 views
Forums about getting SQL Server 2000 Administration help?
What I'm trying to accomplish is that I need to migrate the SQL Server 2000 installation into a SQL Server 2008 installation, and I would like to say that I am afraid that after this operation I will ...
2
votes
1answer
490 views
Recover database until cancel without prompt?
The statement:
RECOVER DATABASE UNTIL CANCEL
prompts once to select the archive log file. Is there a way to pre specify the value so as to be able to use it in a script without prompt?
I have ...
2
votes
2answers
487 views
Why database diagrams are not working when domain account is attached to database owner?
I was trying to use Database diagrams is SQL Server and got following error:
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first ...
2
votes
1answer
173 views
Active Directory domain being shutdown— Do I have to update my DBO accounts?
I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
2
votes
3answers
209 views
MySQL - Master/Slave Replication with different server specs
I have a Master/Slave replication (using MySql 5.1 / InnoDB).
Currently both my master & slave are running on the same type of server (32 GB RAM, 2 x Intel Xeon 5520 Quad Core 2.26 GHz (8 cores)) ...
2
votes
2answers
532 views
Cannot login to Oracle11g with System username
I just installed Oracle 11g into my machine.
I was about to shut down a database instance, and Oracle asked me for username and password, I provided the credentials I used to login into the web ...
2
votes
2answers
61 views
Data Backup and Restoring the same if requried in SQL SERVER 2008
In Multi-tenancy , Shared Database Shared Schema.
How to take Tenant level backup and restored the tenant data when required? Can any one guide me or point me to the right direction.
Thanks!!!
NB: ...
2
votes
2answers
2k views
getting error installing oracle 11gR2: cannot access node
I'm installing Oracle 11.2 on dedicated hosted server (centOS 5.5). I've gone through the Oracle Quick Installation guide diligently. I believe I've set everything up correctly, although I'm not a DBA ...
2
votes
2answers
687 views
Unknown Db file format - best way to find out?
A client has given me the data he wants visualised in my project - but I don't know what DB format it's in. He's pretty unclear, also..
I have access to the table structures, but don't know how to ...
2
votes
1answer
40 views
How to restore IBM DB2 database from AIX to Windows?
I had made backup from remote IBM DB2 server in AIX using this command:
./db2 backup database DBEMP to /home/dbemp/backup
Then I grab the backup file using FTP Client from my Windows.
I run this ...
2
votes
4answers
71 views
What is the best permissions to set for only creating and managing own databases?
I want to create a login for a new user who could only create and manage their own databases. Other databases on the server should be read-only to that user. What would be a good set of ...
2
votes
3answers
1k views
Unable to start SQL Server Instance 2008 R2 - DB file corrupt
I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is
" The log scan number passed to log scan in database ‘master’ is not valid. This ...
2
votes
1answer
720 views
What is the best database design for multi-language data?
I am designing a multi-language database for a piece of software with the following features:
data used in every country differs from other countries
data used in every country will be in 2 ...
2
votes
2answers
980 views
Disabling Checking of Schema On Function/Stored Procedure Creation
I'm trying to automate the process that executes changes to the SQL Server 2008 R2 database. The process I put in place drops and recreates my stored procedures and functions, as well as run scripts ...
2
votes
2answers
1k views
Why can the SA account no longer access the master database?
I'm somewhat stuck. We have a database server which was set up and configured by a third party. It's for a third party product so unfortunately we're stuck with the way they've configured it.
Their ...
2
votes
1answer
235 views
How to recover SA account password without restoring it?
I forgot my SA password and resetting the password is out of the question because internal applications are using it and will will affect them. I also don't have an option to change the SA credentials ...
2
votes
1answer
861 views
How to upgrade MySQL to a New version..?
I have installed mysql using the package management system.I am using ubuntu machine.
After that i have very well configured the server for InnoDB and other server related parameters.
I am using the ...
2
votes
1answer
375 views
BACKUP and RESTORE MySQL Database
I have very specific question.
I have seen the instructions on how to backup and restore mysql database using SSH but they barely explain the process when backing up on one server and restoring on ...
2
votes
1answer
700 views
MySQL : “FLUSH TABLES WITH READ LOCK” started automatically
I would like to understand how this happened. I was running a query that would take a long time, but should not lock up any table. However, my dbs were practically down - it seems like it was being ...
2
votes
1answer
278 views
Why is 'Allow Snapshot Isolation' set to TRUE on the master and msdb databases?
Why is the database property Allow Snapshot Isolation set to TRUE on the master and msdb databases, but FALSE on other system databases? The default option for this property is also FALSE when ...
2
votes
1answer
83 views
How can I rename a table, but also all FK etc. references to that table?
I would like to e.g. rename my Applicant table to ApplicantProfile, as applicant is an abstract entity that has a profile. The profile is not the applicant.
Simply renaming the table is hopelessly ...
2
votes
2answers
290 views
Standby controlfile error
I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby ...
2
votes
1answer
271 views
When dedicated server process model should be used instead of shared process model?
It looks like Oracle shared server process model is better than dedicated server process model. In a shared server configuration, client user processes connect to a dispatcher and it can support ...
2
votes
1answer
189 views
Assertion failure from InnoDB while restoring using Innobackupex
I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes:
We recently upgraded our production DBs ...
2
votes
1answer
2k views
Is it possible to do a datapump import with a different user than did the export?
I have one db dump below is the log file for that dump
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** ...
2
votes
2answers
233 views
Help with Vehicle Service database
I am using the Desktop Vehicle Maintenance template in access, but i am trying to cater it towards our farms needs.
We will be keeping track of the service's done on Trucks, Tractors, Equipment, etc.
...
2
votes
1answer
81 views
database connection time expired issue
I have a server machine and four client machine for database connectivity.
I installed sqlexpress 2008 in server and one machine and all remaining systems, they have connected the database through ...
2
votes
1answer
169 views
User Rights - Database Security
I am having following scenarios and i am having some issues and some questions.
We have a DB Server on which we have some databases in these 2(two databases) are for my users.
Now i have created 2 ...
2
votes
2answers
846 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 ...
2
votes
1answer
279 views
PostgreSQL archive_command on Windows
What is the best method for WAL log transfer on Windows?
I have two servers with Windows Server 2008, PostgreSQL 9.0 64bit.
Servers do not have any shared SAN disk, they are on different hosts, ...
2
votes
1answer
534 views
Error restoring SQL differential database files
Occasionally I'm having problems restoring DB differentials. I'm getting the error "the differential backup cannot be restored because the database has not been restored to correct earlier state." ...
2
votes
1answer
485 views
Pgpool-II: sequences advanced by 1 after PITR recovery
I have tested pgpool-II 3.0.1 and pgpool 3.0.4, PostgreSQL 8.4
In both cases I'm getting the same result: after online recovery on primary and target nodes all 'serial' values got "+1". Other nodes ...
2
votes
1answer
37 views
SQL Server database schema (and likely, some data changes) - how to auto-distribute over many database instances
Our development involves a SQL Server database (also might be Oracle or Postgres later) and we would sometimes make database schema changes or some other interventions in database.
What solutions ...
2
votes
0answers
58 views
How to execute a non-table-locking update operation on PostgreSQL? [closed]
Looking for a good way to update the value on a column for all the rows in a database (not huge, but big enough - about 10M records), without locking the whole table, so operations can continue while ...
2
votes
0answers
72 views
How to properly configure pgBouncer transaction level pooling?
What is a good way to determine the number of available transaction connections when using pgBouncer to pool database connections? Also, how should I determine the number of max_connections and ...
2
votes
0answers
111 views
Create Oracle ASM Disks Without Installing Oracle
I have been asked to setup workstations (VMs) for an instructor's Oracle 11g R2 Workshop. I am finding the documentation that was downloaded from the Oracle Academy site extremely underwhelming. I am ...
2
votes
1answer
197 views
How to grant permission for am administrator account in SQL Server 2012? [closed]
I installed SQL Server 2012 on my laptop. I am trying to run a script to create a simple database.
SQL Server version: 11.0.3128
SSMS starting parameters:
server type: database engine
server name: ...
