Database administrator

learn more… | top users | synonyms

0
votes
1answer
26 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
38 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 ...
0
votes
0answers
16 views

Install oracle 12c database preinstallation RPM without yum

Question: Is it possible to install oracle 12c database pre-installation without yum? If so how? What I have found on the internet is to use yum, I cannot use yum because the proxy just does not ...
0
votes
2answers
202 views

How can delete an orphaned temporary table on Mysql Innodb?

I was issuing an Alter table statement and suddenly the server crashed, Now i can not run any alter table to that table because it shows me the error 1050 and it says that a table named #sql1504d ...
0
votes
1answer
302 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 ...
1
vote
0answers
34 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. ...
3
votes
1answer
141 views

How to directly query other user tables

I am trying to learn Oracle database and I am having difficulties on importing a backup file with impdp command. I googled deeply but couldn't find answers to my problems. What have I done until now ...
0
votes
2answers
37 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 ...
2
votes
3answers
113 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 ...
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
16 views

Prerequisite for learning oracle DBA [duplicate]

i need an advice on the needed skills to start an oracle DBA. Thanks
2
votes
2answers
44 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
29 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
18 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
46 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 ...
0
votes
0answers
11 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??? ...
1
vote
1answer
195 views

Junior DBA hopes for advice [closed]

This is the 7th month of my DBA career, and I just graduated as a master, no experience before. My daily work for now is pretty much about backup/restoring databases in different environments ...
1
vote
1answer
42 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
73 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
65 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
32 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
116 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
76 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 ...
-2
votes
1answer
64 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
243 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 ...
2
votes
0answers
103 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 ...
1
vote
2answers
96 views

What are the necessary course requirements to become a DBA? [closed]

Before some of you say it is related to other posts, let me tell you that I am more interested about schooling and getting my Master's degree not necessary learn SQL and such. I just graduated with a ...
2
votes
2answers
2k views

Good book on databases for beginners [duplicate]

Possible Duplicate: Must-read Books for DBA I'm already reading a book on Introduction to SQL (RDMS). But that only teaches SQL and commands and I feel like my knowledge lacks in database ...
-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
16 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
48 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 ...
0
votes
1answer
33 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
58 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 ...
1
vote
0answers
50 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
48 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
108 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
63 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 ...
-1
votes
1answer
51 views

Using BIT datatype to filter a query in the WHERE clause [closed]

I'm building a stored procedure that uses a bit parameter. this bit parameter is used to filter the email column. if @param is 1 - show all clients that has an email. if @param is 0 - show all ...
0
votes
1answer
31 views

Unable to connect to mysql remote

I am struggling to connect MySQL database with my application, I am having the following set up 3 Applications running in cluster mode and trying to connect with same DB. MySQL database running on ...
-1
votes
1answer
50 views

I cannot add a new Server Role “SQL Server 2008 R2”

I want to add a new user-defined Server Role to my SQL Server instance, but the menu doesn't show all options, it only shows this: Instead of this : and I also tried the T-SQL command to create ...
2
votes
1answer
153 views

Running scheduled SSIS pkg with SQL Server 2012 Web Edition

I have a client with SQL Server 2012 Web Edition. I believe it has SQL Server Agent, but I see on the following Microsoft page that many integration services are not supported: ...
0
votes
2answers
34 views

conditional/processing on the dummy data column to create new dummy column

Following is my query. Select [A],[C] ,CASE WHEN [A]>19999 and [A]<30000 THEN '12' ELSE '21' END AS 'dummy1' ,Substring(CAST(C AS varchar(9)),1,4) as YEARDummy ,Substring(CAST(C ...
1
vote
2answers
41 views

How to make a line/string to multiple records

So, I want to create a teacher-degree (1:m) table. I have this example: One professor has 3 degrees. This is the actual string I have(multiple of these actually): B.A, 1983, University of China; ...
0
votes
0answers
9 views

for a dba to understand db easily what kind of document he will be looking for from us [duplicate]

Me as a developer looking forward for a expert db to come an optimize our db as we have slowness issue. SQL Class diagram is enough for him or is there any other document i should prepare for new db ...
1
vote
1answer
70 views

Sql Server Maintenance Plan - Simple Recovery Mode - Adding Shrink Log

I inherited lot of old servers and Databases from other department and now I will be the one who needs to take back ups / do Maintenance stuff with it. I see a lot of databases in simple mode (I ...
0
votes
0answers
24 views

events not getting completely written in binary log file MySQL 5.0.32

referring this question : Records not getting replicate from Mysql 5.5.32 to MySQL 5.6 i found that binary log files which has been created at master database server , i see following surprising ...
1
vote
0answers
42 views

Identify a blocking process in MongoDB

I have a single MongoDB instance is performing quite badly. I noticed that db.currentOP().inprog.length quite often becomes quite big, sometimes even goes up to 100. When I drill down to the actual ...
1
vote
1answer
64 views

MySQL creating a concat_WS delimiter function, one part not working

I have a function that looks like this: CREATE FUNCTION CONCAT_UNTIL( x LONGTEXT, delim CHAR(1), repeatEvery SMALLINT) RETURNS LONGTEXT LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA BEGIN DECLARE ...
4
votes
2answers
201 views

BI and DBA dev , where to start [closed]

I've read a lot about business intelligence development and database development, too. I have tried to work my way around a couple of courses on SQL Server 2008 however I feel kind of lost and I have ...
-1
votes
2answers
85 views

DBA responsibilities: should they include suggesting a database engine for a new project? [closed]

I need your opinion on a subject. I have been working as DBA for a short time and I have been asked by the Project Manager which database engine I recommend for a new critical project. The options ...