Database administrator

learn more… | top users | synonyms

0
votes
0answers
15 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
2answers
221 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
0answers
59 views

About shifting my career from Software developer to DBA [closed]

I am a software engineer having 5 years of experience in .Net. I am not enjoying working as developer by doing coding and all developer stuff. So i am planing to become a Oracle DBA. Please advice how ...
0
votes
1answer
395 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 ...
0
votes
0answers
41 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
votes
0answers
20 views

How to prevent database server from lagging when auto back up of data to backup DB is in progress?

We have a windows 2008 r2 server with MSSQL server running on it as our application's database server (we use it 24 hours). It has auto back up every midnight (as it is the time when less users are ...
1
vote
2answers
71 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
57 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
21 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
31 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
42 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
36 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
146 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
40 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
131 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
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
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
35 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
26 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
59 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
12 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
198 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 (DEV/QA/...
1
vote
1answer
44 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
68 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
167 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
82 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
74 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
248 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
121 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 ...
2
votes
2answers
100 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
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
53 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
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
67 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
54 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
49 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
141 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
54 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
62 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
185 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: https://msdn.microsoft....
0
votes
2answers
37 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 ...