Error in cluvfy checks:
Check: User equivalence for user "oracle"
Node Name Comment
------------------------------------ ------------------------
node1 passed
node2 failed
Result: PRVF-4007 : User equivalence check failed for user "oracle"
Solution:
Check for the ssh trust between nodes.
There should not be any banner after ssh.
check the user equivalence as a oracle user
Tuesday, May 10, 2011
Tuesday, May 3, 2011
Oracle DBA Interview Questions ....
SET 1
1. How did oracle database evolve?
2. What is the sysaux and system tablespace?
3. how to find the free space for undotblspace? Hint----dba_undo_extents?
4. locally managed vs dictionary managed tablespaces?
5. what if redo group is lost? what if redo member is lost?
6. what is snapshot too old error? How recover from it?
7. what is fast_MTTR_target? Hint---mean time to recovery
8. How to get free,used,total tablespace sizes?
9. List out types of backup
10. how to take hot backup?
11. what is undo tablespace?
12. what if control file is lost?
13.what are kernal and os level parameter need to be set prior to installation of oracle?
13. what if backup is going on and if snapshot too old error is occuring
14. what are required export and import parameters?
15. What are mandatory background processes?
Set 2:
1.What happens when we kill smon or pmon?
2.How to recover database if UNDO gets corrupted?
3.What is a fractured block and how to fix it?
4.What is a corrupted block and how to fix it?
5.What are the oracle threads which start when we start the database?
6.How do we check a index is working properly and how do we decide a particular index has to rebuilt?
7.What steps do we need to take if we receive a call that performance has gone
down as a dba?
8.Is it possible to change block size after db creation?
9.If users are not able to connect database or database is down what preliminary steps are to be taken?
10.What does oracle do when we take hot backup where actually modified
blocks are written?
11. On what basis should RAM be determined for a 50gb database?
12.Can we connect a database using listener instead of tnsnames?
13.Normally what are the jobs a DBA has to do on a daily basis?
14. Can we create a physical standby database using hot backup?
15.Is there a limit for concurrent user connections in Oracle?
16.Can we increase user connections by using LISTENER FILE?
1. How did oracle database evolve?
2. What is the sysaux and system tablespace?
3. how to find the free space for undotblspace? Hint----dba_undo_extents?
4. locally managed vs dictionary managed tablespaces?
5. what if redo group is lost? what if redo member is lost?
6. what is snapshot too old error? How recover from it?
7. what is fast_MTTR_target? Hint---mean time to recovery
8. How to get free,used,total tablespace sizes?
9. List out types of backup
10. how to take hot backup?
11. what is undo tablespace?
12. what if control file is lost?
13.what are kernal and os level parameter need to be set prior to installation of oracle?
13. what if backup is going on and if snapshot too old error is occuring
14. what are required export and import parameters?
15. What are mandatory background processes?
Set 2:
1.What happens when we kill smon or pmon?
2.How to recover database if UNDO gets corrupted?
3.What is a fractured block and how to fix it?
4.What is a corrupted block and how to fix it?
5.What are the oracle threads which start when we start the database?
6.How do we check a index is working properly and how do we decide a particular index has to rebuilt?
7.What steps do we need to take if we receive a call that performance has gone
down as a dba?
8.Is it possible to change block size after db creation?
9.If users are not able to connect database or database is down what preliminary steps are to be taken?
10.What does oracle do when we take hot backup where actually modified
blocks are written?
11. On what basis should RAM be determined for a 50gb database?
12.Can we connect a database using listener instead of tnsnames?
13.Normally what are the jobs a DBA has to do on a daily basis?
14. Can we create a physical standby database using hot backup?
15.Is there a limit for concurrent user connections in Oracle?
16.Can we increase user connections by using LISTENER FILE?
Subscribe to:
Posts (Atom)