Database administrator

learn more… | top users | synonyms

0
votes
2answers
31 views

How to find out to which roles tables belong?

I was wondering if there is a way to find out what roles 2 tables reside? I have 2 tables and I want to find out to which role they belong? Is there a way to find out? Thanks
0
votes
1answer
30 views

stored procedure logic,data flow visualization tool [on hold]

I have a very poorly written stored procedure with cursors, if else etc. Is there any toll available to visualise the logic and data flow? Thanks
1
vote
0answers
17 views

How to Move a whole partition to another tabel on another database?

Database: Oracle 12c I want to take single partition, or a set of partitions, disconnect it from a Table, or set of tables on DB1 and move it to another table on another database. I would like to ...
1
vote
1answer
18 views

db2 convert regular table to partitioned using online table move

I am converting my regular table to partitioned table using timestamp column. However, the below code fails with sql error 2103 reason code 6. Please note that there are no referential(or foreign key ...
1
vote
1answer
63 views

Replication Subscribers and AlwaysOn Availability Groups (SQL Server)

I have AlwaysOn Availability Groups configured with Replication Subscribers, and is currently running successfully with one publisher using the command below. -- commands to execute at the publisher,...
0
votes
0answers
15 views

ERROR 2002 (HY000) … mysql.sock

Mysql Version :: 5.0.51b OS Version :: CentOS 6.4 Error : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (2) I got this error in live ...
0
votes
2answers
42 views

SQL Server Storage for multiple data files

Recently, our company wants to add 4TB on the drive size for SQL Server. We have two drives now which have different size and data files. In order to make sure our SQL Server has the best performance, ...
0
votes
1answer
25 views

Call to sysmail_delete_mailitems_sp keeps deadlocking

I run SQL Server 2012. I have a maintenance job that runs every night. At the end of the maintenance, I do some cleanup and call this: Begin try Exec msdb.dbo.sysmail_delete_log_sp @logged_before = '...
1
vote
2answers
68 views

Change database loaction

I have installed new MS SQL Web Edition on C Drive and I have also another D drive on server. Now I want to change database location, like when we make new database it should be make on D drive. Can ...
0
votes
0answers
22 views

Mongo DB services went down while creating indexes in >300GB Mongo database instance

While creating index for a collection in Mongo DB instance.Mongo DB services went down with below error. kindly help on how to overcome the same.For smaller database instances it went fine. Command ...
0
votes
0answers
38 views

Shrink .ldf file issue

These are the timing of some jobs on SQL-Server: rebuild indexing at 10.30 am (all timing in IST) reorg indexing at 11 am full backup at 12.30 pm transaction backup every 2 hours truncate log ...
1
vote
1answer
38 views

what is oracle universal installer in oracle database products

I am new to oracle database products. I am planning to install oracle 11g express edition in my PC,it looks like a standard installer.But in many of the oracle database installation tutorial mentions ...
0
votes
1answer
45 views

Restore of database failed .bak file SQL Server 2008

I have faced following error during restoring database: TITLE: Microsoft SQL Server Management Studio Restore failed for Server (Microsoft.SqlServer.SmoExtended) ADDITIONAL INFORMATION: ...
1
vote
1answer
59 views

Why can not user set current schema to SYS?

See the example bellow. User is created with dba (but not sysdba) privs. He's allows to access v$session (which is public synonym to view in schema SYS, having different name). When executing alter ...
0
votes
1answer
25 views

Cannot create a database connection SQL Developer

I will try to explain the current situation in the best possible way. Well, I got a VM with SQL Developer already installed but could not run properly. After some reasearch, I solve the problem ...
0
votes
0answers
42 views

How Can I move data among the datafiles

I have almost 1 tb of database which have 4 datafiles in primary file group that have data unevenly A-data file has 300 gigs B- has 430 gigs c- has 200 gigs D- has 12 gigs what should I do in order to ...
1
vote
2answers
80 views

Large Database backup approx 2 TB and restore with limited disk space

I am working on DB migration from server A to server B. Server A:- DB size - 2 TB - Sql 2008R2 - Multiple Data files stored in diff drives. Server B:- Disk space:- 999 GB - Sql 2014 Enterprise ...
1
vote
1answer
74 views

How to restore database with ib_log0, ib_log1 and ibdata1 files in MySQL

We have a Mysql5.5 running on Windows server 2008 from past 4 years. Recently we have moved ib* files to new locations because of space constraint in c drive. When we started the Mysql it created ...
0
votes
0answers
30 views

PostgreSQL Redhat Cluster Implementation(Active-Passive) With Streaming Replication setup For DR failover

We have a scenario Where Customer is looking For Cluster kind of solution with DR failover Setup. I am Planning to suggest the attached Architecture with customer. Few Clarification as per ...
0
votes
1answer
33 views

Database Log 3 times Data File [duplicate]

I have a set of database on full recovery model, my backup schedule looks like this: 1 Weekly Full Backup 1 Daily Log Backup Full backups are about 10GB, log backups are about 500mb per day. What ...
0
votes
1answer
46 views

How to delete duplicate records in my database? [duplicate]

I joined about 12 databases into 1 db and in each database I have some duplicate records. How can I delete all duplicate records in my joined database? For example, I want to delete duplicate ...
1
vote
0answers
39 views

Postgresql with just index storage

I have a PostgreSQL table with a key (bigint) and a value (double). The table has tens of billions of rows. I have a single btree on the (key,value) for aid lookups by key. The table is never updated. ...
0
votes
2answers
43 views

How do i find out the most active database?

How do i find out the most active database? I mean to say I have 10 DBs and some transactions keep on happening on these DBs. I want to know which is less used or which DB has less no of ...
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
0answers
17 views

Prerequisite for learning oracle DBA [duplicate]

i need an advice on the needed skills to start an oracle DBA. Thanks
2
votes
2answers
46 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
0answers
47 views

postgres vacuuming query: value of datfrozenxid increased after vacuuming

I checked the datfrozenxid values, and performed "vacuumdb --analyze -a", Normally postgres, template1 values are very high and they return to around 1,000,000,000 after vacuum. But I found something ...
1
vote
1answer
32 views

Teradata 15 : Failure 5619 Role nesting exceeded single-level

I am using Teradata 15. In Active Directory, We have a policy to assign a universal group, which has people, to a local group, where permissions are assigned. So I create two Teradata roles to mimic ...
0
votes
0answers
13 views

dba_tab_partitions we have all columns except MAXVALUE column

i want to cross check all partitions were created properly or not according to the timestamp, TO_DATE(' 2013-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', is there any way to cross check partitions??? ...
0
votes
0answers
74 views

Error 1129: Host '' blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

When I run a python code which connects to mysql, I see this error; "Error 1129: Host '' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'". Here is what I have ...
2
votes
3answers
143 views

Oracle 11gR2: ORA-01102: cannot mount database in EXCLUSIVE mode

I am running Oracle 11gR2 on an AIX box. I did a rename database and change DB ID using NID. I can restart db in a nomount mode, but I can not mount it by the following error. ORA-01102: cannot ...
1
vote
1answer
48 views

special setup to create views in Oracle in default schema

When creating views in Oracle, do you need special setup for a given user if the view and table in which the view is reading from are in two different schemas? The user creating the view has dba ...
0
votes
1answer
74 views

Advice For A New Senior DBA [closed]

I'm finally taking the plunge and moving up from Junior DBA at a large organisation to Senior DBA at a smaller place running SQL Server. It's going to take some time for me to get a good picture of ...
0
votes
1answer
73 views

Migrating database from oracle 11.2.0.03 to 11.2.0.04. [closed]

I have been assigned task of migrating our oracle database from 11.2.0.03 to 11.2.0.04 version. Being new to oracle, I have list down all activities I need to carry out to make it successful. I will ...
0
votes
1answer
35 views

Possible aproach for MySQL replication

This might be a duplicate questions asked before. But I need to understand a possible approach for my ENV running innodb engine. Is it possible to upgrade a Master MySQL Server to 5.5 to 5.6 and ...
0
votes
0answers
216 views

Teradata 15: install TTU 15, The installation of Shared ICU-32 bit appears to have failed

I downloaded Teradata Tools and Utilities (TTU 15) from Teradata support site. After I uninstalled the TTU 15, now I cannot install it again! I am using Windows 7 Enterprise version. Here is my ...
0
votes
0answers
94 views

create table in a different schema

I am trying to create a table on a different schema without using "create any table" privilege. I have an application user/schema. TABLESPACE_NAME USEDMB MAXMB ----------------...
1
vote
1answer
464 views

Slave not getting replicated SERVER_UUID error

Unable to start replication Master-Slave, I have searched a lot for this but unable to get the Server-UUID of both the server. Do we have any solution for this. Scenario: I have created new slave ...
-2
votes
1answer
83 views

I have created a zip file using 7z for backup but its taking time to open [closed]

I have created a zip file using 7z for backup but its taking time to open. Any possibility of making fast. Please suggest me.
13
votes
1answer
251 views

Metrics to prove or disprove the need for additional DBA's?

We currently have 2 DBA’s, me and one other guy and we both feel the need for an additional resource (or two). I have had the conversation with my direct manager on this topic a couple different times,...
2
votes
0answers
172 views

Is there a recommended for the database-to-DBA ratio? [closed]

We are now in a process of justifying the hiring of more staff for our DBA team. We have about 246 database instances. Not all of them are Oracle instances, some of them are PostgreSQL databases in ...
-3
votes
0answers
39 views

Procedure taking so much time [closed]

Can anyone help me out. This is first time im working on performance tuning can anyone help me out. If want i can paste the proc also.
0
votes
0answers
17 views

AlwaysOn Availability Groups with Different subnets

Am Successfully configured the Always On with different sub nets. but I have one small glitch here every time am manually flushed out the DNS (command prompt ipconfig /flushdns) while fail over is ...
0
votes
1answer
34 views

trimming leading characters

I'm in oracle and I have a table 'parts' in which have a field 'Description', which contains description for a part. my query is: SELECT DESCRIPTION FROM PART WHERE PAR_ID=123 AND DESCRIPTION ...
0
votes
1answer
73 views

Restoring ORACLE 11gR2 database with Flash Recovery Area Only

I was succeded in making backup using RMAN in Archivelog mode in my host server and this is the screenshot when i list the backup, and the next step, i copy content from Flash Recovery Area folder ...
0
votes
1answer
66 views

How to reset slave without over write of master dump in mysql

My master having position is File Position mysql-bin.000046 430674598 I lost my data dir of mysql on master after that I have backup of slave which restored in master.Now Both ...
1
vote
0answers
57 views

A call to a package procedure fails after upgrade to PSU24

We have just upgraded an Oracle Database 11.1.0.7 from PSU6 to PSU24. We have set a AFTER SERVER ERROR trigger to track application errors a while ago and checked its history table. Summary We see ...
-7
votes
1answer
50 views

Need Immediate Help To Develope T-SQL

Hi DBAs, I want to Develop a T-SQL For Fetch data from following Table. But Condition is : I want to select only those data which status has all three status. suppose for id 1 : It has Only two ...
0
votes
0answers
167 views

Teradata how to create a sysdba super user

I am relatively new to Teradata. I was told by my Teradata consultant to create a super user or a role for DBAs to use, in stead of using DBC. I tried the following syntax, but kept getting errors: ...
0
votes
2answers
65 views

Missing rows in Visual DBA, exist when queried specifically

Greetings fellow DB Admins, I have an interesting issue on which Google has failed me. Background: I am working with medical records managed with Ingres SQL. The other day I wrote a simple query in ...