Monday , September 25 2017
Home / Oracle DBA Interview Questions / ORACLE INSTALLATION INTERVIEW QUESTIONS

ORACLE INSTALLATION INTERVIEW QUESTIONS

INSTALLATION INTERVIEW QUESTIONS

 

  1. Explain the steps of installing oracle 10g on a linux machine

    1. Refer to the installation guide in class notes

  1. What is the purpose of adding oinstall and dba groups?

    1. oinstall – to provide the user to install any oracle software

    2. dba – allows to administer the database

  1. Is it compulsory that we need to give group names as oinstall and dba? Or can we give any other name?

    1. We can give any name, but those are oracle standards

  1. What are kernel parameters and why to set them?

    1. They will define the memory allocation from physical memory to Oracle database

  1. What is the difference in installing 10g and 11g on linux?

    1. 11g allows to set kernel parameter later whereas in 10g we need to do it before

  1. What is Oracle inventory?

    1. It is a location which provides the oracle product information which are installed on a particular host

  1. Why to run orainstRoot.sh and root.sh scripts at the end of installation?

    1. orainstRoot.sh will change the permissions for oraInventory and root.sh will create oratab file

  1. When I am trying SQLPLUS, its throwing command not found error. How you will handle it?

    1. We need to set oracle bin directory in PATH environment variable

  1. Where you will set environment variables in linux? Why to set them?

    1. We need to set in .bash_profile file. Setting them will help in easy access to commands

  1. How you will set environment variables in windows?

    1. We can set in advanced tab in mycomputer properties

  1. When trying to connect to the database, I am getting “net service name is incorrectly specified” error. What is the reason?

    1. ORACLE_SID is not set

  1. How to check how many databases are up and running at OS level?

    1. ps –ef | grep smon. Even though this is the generic command that is used, this is not the perfect answer as it will give output even if instance is started. So the correct answer would be ps –ef | grep oracle. In the output, we need to see for processes which says LOCAL=NO which means someone connected to the database from remote machine

  1. How to check the version and bit version of oracle software?

    1. SQL> select * from v$version;

  1. How to check how many databases are existing on the server?

    1. Using oratab file. But this may not give perfect answer if manually created databases are not updated

  1. How many databases can we create on a single server?

    1. Unlimited until cpu and memory configuration are supported

  1. How many databases are there in your environment and categorize them?

    1. Tell any value between 70 to 100. Out of that say 35 are prod and rest are dev and test

  1. What is the highest size of the databases you are maintaining?

    1. Tell any value between 400 to 700 GB

  1. How many servers are there in your project? Which platforms you are comfortable to work in?

    1. Tell any value between 30 to 50. Platforms are all unix and windows flavours

  1. Can we change the block size after database creation?

    1. No, we cannot

  2. What are the 3 important steps after database created manually?

    1. Executing catalog.sql script

    2. Updating oratab file

    3. Executing catproc.sql script

  1. How to see background process at DB level?

    1. SQL> select program from v$session;

  1. How to start the database if pfile is not in default location?

    1. SQL> startup pfile=’location of pfile’

  1. I am creating a database manually and while executing script, I am getting “ORACLE INSTANCE TERMINATED, DISCONNECTION FORCED” error. What went wrong and how you will troubleshoot?

    1. This is due to UNDO tablespace name mismatch between create database script and pfile. Once fixed, problem will be resolved

  1. What is the difference between ORACLE_BASE and ORACLE_HOME?

    1. ORACLE_BASE is the location where we can install oracle software and ORACLE_HOME is the database home location

    1. How to automate database startup during linux bootupbshut and dbstart scripts

      25.What is your strategy to delete old traces?

    1. We will delete them every 3 months except alert log. We will take backup of alertlog and will trim the file

      26.How to check RAM size at OS level?

    1. We can user free or top command

      27.How to check the size of a single directory?

    1. du –sk*
    1. It is used to know the IO and memory statistics

  1. 28.While starting the database, I am getting “END OF FILE ON COMMUNICATION CHANNEL” error. You are the only user connected to the database. What could be the reason for this?

    1. If a particular mount point is full, in that case we will get that error
  1. 29.What are different types of SCN available?

    1. We have TOP, START, STOP, BLOCK SCN etc
  1. 30.How many types of checkpoints are there?
    1. We have nearly 10 checkpoints which helps in making data permanent in different stages of transaction
  1. 31.What is the use of oratab file?
    1. To identify how many databases existing on a server
  1. 32.How do you check if oracle installed on a server?

    1. By checking orainventory location
  1. 33.If I have 5 databases on a server, how to find which version they are?
    1. By checking oratab file
Read More:
ORACLE EXPORT & IMPORT
about ORACLE UTILITIES ( SQL * Loader )
Oracle Materialized Views

Comments

comments

Check Also

ORACLE BACKUP and RECOVERY INTERVIEW QUESTIONS

BACKUP & RECOVERY INTERVIEW QUESTIONS 1.What is the difference between cold and hot backup? a.COLD …

Leave a Reply

Your email address will not be published. Required fields are marked *