ORACLE DBA INTERVIEW QUESTIONS (L2)

By -

##############ORACLE DBA INTERVIEW QUESTIONS (L2)#####################


How Will you create RAC DB from Standalone DB.

How you create DR DB from scratch.

How will you proceed to migrate your database from FS to ASM.

What is Voting Disk, why its required?

what is the minimum and maximum number of voting disk that you can have for voting disk.

What processes are required in RAC?

What does LNS,RFS process do?

What is load balancing and its type?

How will you perform refresh on RAC Database.

What is  raw disk and ASM .

How do you approach to stop and start services in RAC env.

Why do we need public, private and Virtual IP's?

What is ACFS?

How do you perform switchover and failover?

How to make DB in sync with standby database if its not in sync. what could be the causes?

In case of performance issue, how you approach to resolve it.

How will you record the information of your current session?

How can you use the information collected in trace file from your session?

Why you do Index rebuilding? Which wait event indicates towards it?

How can you find out if your table can be redefined?

What does DBMS_SQL package do?

If you to take export in different FS how would you approach for it?

What is the difference between exp and expdp?

What is use of table_exist_action in impdp and what are the option you can use for it?

How you create Standby database? By duplicate or rman backup?

How do you do recovery of the database?

What type of issues you have faced in RMAN?

How you schedule backup from OEM ?

How backup runs in your env and why you think its planned in optimal way?

To check the execution plan of a SQL which package you use?



What is Marginality w.r.t. database statistics?

What is max extent term in oracle database used for?

What is DB time and DB CPU time? Which will have greater value and why?

How you determine DB CPU time is good in AWR report?

How you approach to identify the root cause of any performance related issue via AWR, basically what approach you use to read it.

In order to tune oracle database running on a Linux machine what parameters you can set or change at OS level.

What is huge pages and why it is used for?

What type of wait events have you seen and how you approach to resolve the issue related to that wait event?

How exp and expdp are different ? why expdp is faster than exp?

What is the term transform is used in data pump?

You are facing that your active data guard is responding slow for reporting related task. How you can find the root cause?

can you generate AWR snapshots on Active data guard?

What is log miner?

What is shmmin and other oracle related kernel parameters are used for?

How you identify that a table is fragmented or not?

Tell me about the indexes related to the partitioned tables.



Thanks & Regards

Nikhil Kumar.

Comments

Post a Comment

Popular posts from this blog

How to set the root password after creating instance on oracle cloud

By -
How to set the root password after creating instance on oracle cloud? since you have created instance on oracle cloud, it requires you private .ppk key file to login from putty you can login on your instance by directly providing that private key. and on Linux/Unix defult user is "opc". since during creation of instance it  will not ask you for  root password. You dont need any password to connect to root. to connect to root type below command as opc user. [opc@sts ~]$ sudo su [root@sts opc]# by this you will login as root. Now change your password [root@sts opc]# passwd Changing password for user root. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@sts opc]# All done. Thanks & Regards Nikhil Kumar.
Read more

TNS-12541 TNS-12560 TNS-00511 TNS:protocol adapter error No listener

By -
Oracle Listener does not start with errors:  TNS-12541: TNS:no listener TNS-12560, TNS-00511, Linux Error: 2: No such file or directory, The listener supports no services euls25002.sgp.st.com:oraSID 51> ps -ef | grep -i tns root       330     2  0 Jul19 ?        00:00:00 [netns] oraSID   17512     1  0 Jul20 ?        00:01:25 /oracleSID/SID/121/bin/tnslsnr LISTENER_SID -inherit oraSID   56223 56131  0 08:02 pts/1    00:00:00 grep --color=auto -i tns euls25002.sgp.st.com:oraSID 52> lsnrctl status LISTENER_SID LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-SEP-2017 08:02:19 Copyright (c) 1991, 2014, Oracle.  All rights reserved. Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD)) TNS-12541: TNS:no listener  TNS-12560: TNS:protocol adapter error   TNS-00511: No listener    Linux Error: 2: No such file or directory ...
Read more

Queryable inventory could not determine the current opatch status.

By -
[oracle@Testing02 OPatch]$ ./datapatch -verbose SQL Patching tool version 12.2.0.1.0 Production on Fri May 15 15:54:19 2020 Copyright (c) 2012, 2019, Oracle.  All rights reserved. Log file for this invocation: /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log Connecting to database...OK Bootstrapping registry and package to current versions...done Queryable inventory could not determine the current opatch status. Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual' and/or check the invocation log /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log for the complete error. Prereq check failed, exiting without installing any patches. Please refer to MOS Note 1609718.1 and/or the invocation log /testing/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29313_2020_05_15_15_54_19/sqlpatch_invocation.log for information on how to resolve the above errors. SQL...
Read more