Install Oracle
1. Introduction to Oracle Core DBA
2. Primary Responsibilities of Core DBA
3. Configuration Settings
4. Read me file in the installation folder
5. Prerequisites to done before installation
a. Knowing all the seven parts available for Installable Media
6. Basic Installation – Each screen in it (Installation starts here)
7. Advanced Installation – Each screen in it
8. Silent Installation
9. When to use basic installation and when to use advanced installation
10. Uninstall and again install
11. Only client installation
a. Out of seven parts which part is required to do client installation
12. On Windows OS Oracle 11g Server as well as Client installation
a. Try installing on any of the windows machine too(Extra)
13. Auto start oracle service
a. Oracle Service will not start automatically. If the server is rebooted, Oracle database will not come up in a started mode. To make the database also restart automatically we require taking certain steps.
14. Versions in Oracle 11g
a. Theory for versions available for Oracle 11g
15. Editions in Oracle 11g
a. Theory for versions Editions for Oracle 11g
b. Theory Features of Oracle 11g
16. Installation logs for Oracle 11g - Installation and Configuration Log File Locations for e.g. for installation logs go into :
17. When installing the software it ask you whether to create a starter database also. If you opt for yes, dbca binary will come and create a database. Other than the starter database you can create other databases using dbca too - ( There are two ways to create database, 1. Using dbca 2. Manually
• for dbca <ORACLE_HOME>/cfgtoollogs/oui/installActions<timestamp>.log
And
• For oracle Software installation
oraInventory/logs/installActions<timestamp>.log –
18. what is oraInst.loc –what is the use of this file
19. What is make.log file in ORACLE_HOME/install directory
20. Oracle Inventory – Global Inventory and Local Inventory
Patch Application Applying Oracle Database 11g Release 2 (11.2.0.4.0)
Which will upgrade Oracle 11g software installation from 11.2.0.1.0 to 11.2.0.4.0
1. After applying patch for Oracle11g software, we need to upgrade database
Two ways of upgrade
a .Start the database in - startup upgrade
This activity has to be carried for each database. How will you know how many databases are there in the server. Checking as prerequisite.
i. When database is in upgrade mode then run the script in each database to upgrade database - $ORACLE_HOME\RDBMS\ADMIN\ catupgrd.sql
ii. The activity of upgrade – each database to be upgraded
iii. Checking for each database data dictionary view dba_registry- In each database all 17 components to be upgraded with version 11.2.0.4.0 and status column should be valid
iv. The post activity of upgrade, before releasing the server to client
v. We are putting upgrade patch 11.2.0.4.0
b. Use dbua tool to upgrade each database in the software
OPATCH – is a utility patch
opatch is located in ORACLE_HOME/OPATCH/opatch
CPU patch – is cumulative patch set of many opatch together (CPU stands for critical patch update)
Creating Database Manually
1. Planning for Database Creation
2. Scripts to run after database creation – catalog.sql and catproc.sql – run these scripts as sys user (location of these scripts - $ORACLE_HOME/RDBMS/ADMIN – why to run this scripts
Creating Database with DBCA
a. Location of this script - $ORACLE_HOME/sqlplus/admin
why to run this script and why to run this script as system user – not sys user
b. product_user_profile – table in system schema and use of this table
Logical & Physical Structure :
1. Difference between logical structure and physical structure
2. Physically stored files- Data file, redo log file & control files
3. Content of each file
4. Logically understanding and division of space
5. Location of database file
Schema Objects
List the logical objects in a database like table,view,index etc.
After patching
1. utlrp.sql and utlprp.sql
The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in the database. They are typically run after major database changes such as upgrades or patches. They are located in the $ORACLE_HOME/rdbms/admin directory and provide a wrapper on the UTL_RECOMP package. The utlrp.sql script simply calls the utlprp.sql script with a command line parameter of "0". The utlprp.sql accepts a single integer parameter that indicates the level of parallelism as follows.
• 0 - The level of parallelism is derived based on the CPU_COUNT parameter.
• 1 - The recompilation is run serially, one object at a time.
• N - The recompilation is run in parallel with "N" number of threads.
Both scripts must be run as the SYS user, or if with another user with SYSDBA privilege, to work correctly.
2. Checking the registry to be sure about validity of objects
a. Dba_registry – data dictionary
b. select comp_name, status from dba_registry;
Downgrade the patch and again upgrade
a. how will we downgrade the applied patch on the software
b. Which script we will use to downgrade the database
c. How will you have the information of total number of databases in the
installed software which all need to upgrade or downgrade
No comments:
Post a Comment