13
votes
3answers
940 views

Does my Oracle DBA need root access?

My Oracle DBA Colleague is requesting root access on our production servers. He is arguing that he need it to perform some operations like rebooting the server and some other tasks. I do not not ...
2
votes
1answer
279 views

What are the best practice for monitoring Oracle's rollback segment?

Occasionally, we run out of rollback segment space causing the query/update to fail. What are the best practices that I can expect from an Oracle DBA to ensure that this is monitored pro-actively and ...
2
votes
1answer
146 views

Oracle Backup Strategy

I have recently inherited a smallish Oracle database running on a SPARC Solaris 10 Server. I have been asked to implement a sensible backup strategy. The database has about 3000 odd tables and is ...
1
vote
1answer
2k views

Can I recover an Oracle database to an instance with a different SID?

I've implemented a backup (and recovery) plan for an Oracle 11gR2 database as follows: Installed the same version of 11gR2 on production and disaster recovery (DR) servers Created identical Oracle ...
0
votes
1answer
547 views

problem in run oracle server please help

I used Oracle 11g, from few days ago I face below error: SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: ...
1
vote
3answers
699 views

How do I find the query parameters for a prepared statement in an oracle .trc file?

I have an oracle query generating a 3137 error, and the trace file contains the query. For example: select x from y where z = :1 I think it would help to isolate the problem if I could determine ...
1
vote
1answer
792 views

Oracle 10.2.0.1 --> 10.2.0.4 patchset errors on Advanced Queuing tables. Serious or not?

We're running Oracle on RHEL 5.4 64-bit. We recently did an upgrade from 10.2.0.1 to 10.2.0.4. Many errors were generated during the upgrade (sample listed below from trace.log) but during ...
0
votes
2answers
2k views

ORA- 01157 / Cant connect to database

this is a follow up from this question. Let me start by saying that i am NOT a DBA, so i'm really really lost with this. A few weeks ago, we lost contact with one of our SID'S. All the other ...
15
votes
5answers
894 views

Is my new Oracle DBA talking sense

When we setup FC LUNs for our MSSQL boxes we rarely have to present them with more than about 8 distinct LUNs of various kinds (Quorum, MSDTC, TempDB, Data, Logs, Backup and a few others). We have a ...
3
votes
8answers
379 views

Should a DBA store and retrieve passwords

Should a DBA record passwords for application logins, or should this be a responsibility of developers/analysts? By application login, I mean the login which an application uses for access to the ...
2
votes
2answers
906 views

How do I setup Red Hat Enterprise Cluster and oracle 9 to support failover?

I am trying to figure out how to use RHEL cluster to have automatic failover of an oracle 9 database from one physical machine to another. Ideally this solution would be fully hardware redundant in ...
4
votes
3answers
27k views

Oracle difference between SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name

Can someone explain to me what's the difference of SID, DB Name, DB Domain, Global Database Name, Service Name, Service Alias and Instance Name in Oracle ? Thanks Michael
13
votes
6answers
20k views

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article ...
1
vote
2answers
588 views

Does Oracle optimise index creation following bulk data load

When doing data warehouse bulk data loads into a table for which I don't require logging, typically my process is to: truncate table drop indexes insert /*+ append */ re-create indexes without ...
6
votes
7answers
3k views

Things every Oracle DBA should know

This could include: Books worth reading; Tools worth having; etc.