javascript
Brief description  about Online courses   join in Online courses
View varun  yada 's Profile

What is Oracle Home? ANd What is Oracle Base? Please explain in detail.

What is Oracle Home? ANd What is Oracle Base?
Please explain in detail.
Asked by varun yada | Jul 20, 2012 |  Reply now
Replies (5)
View Swapnil Jagtap Jagtap 's Profile
The Oracle Universal Installer supports the installation of several active Oracle homes on the same host. An Oracle home is a directory into which all Oracle software is installed. This is pointed to by an environment variable. The Oracle home consists of the following:

Directory location where the products are installed

Corresponding system path setup

Program groups associated with the products installed in the home (where applicable)

Services running from the home
Oct 17, 2018
View divya tripathi 's Profile
ORACLE_BASE and ORACLE_HOME are directory locations defined by the Oracle Flexible Architecture.
ORACLE_HOME- This is the directory which contains all software (directories) that need to be available on server to create and maintain Oracle database.
ORACLE_HOME corresponds to the environment in which Oracle Database products run. This environment includes the location of installed product files, the PATH variable pointing to the binary files of installed products, registry entries, net service names, and program groups.
ORACLE_BASE- It is the root of the Oracle Database directory tree. If you install an OFA-compliant database using Oracle Universal Installer defaults, then ORACLE_BASE is X:oracleproduct10.2.0 where X is any hard drive.
For Better Understanding please Go through with link mentioned below-
http://www.cetpainfotech.com/technology/oracle-dba-Training
Oct 16, 2018
View Swapnil Jagtap Jagtap 's Profile
stands for structured query language and is meant for manipulating, communicating data stored in RDBMS databases. There are lots of domains spread across SQL and has various concepts and theories. To initiate career in SQL one must master all the SQL concepts.

There are lots of jobs in the market with respect to SQL and there are lots of demands in this field. This field will always be in demand and be beneficial for you. There are lots of professionals who are interested in this field.

Qualifications To Boost Your Career In SQL
Depending on the client needs and job type, the careers in SQL job needs and selection criteria would differ:

The SQL professionals would need to have a bachelor’s or a Master’s degree in computer science or computer information systems (CIS) or IT in the future.

Database Administrator Certification, Database Developer, Database Architect, Database Designer will give lots of value to the education.

PL/SQL and ETL Tools must be learned as an added information which has lots of demands in the market today.

Career Path in SQL
SQL is the third most famous database server that is present today and there are lots of SQL professionals that work with SQL database server on a daily basis.

Business Intelligence professionals, Data Science, SQL Server Database administration, and Development are few of the SQL career paths.

Among other career prospects, DBA has a very excellent demand today. There are lots of DBA career paths like Production DBA, Development DBA, and Infrastructure DBA.

Job Positions or Application Areas:
1. Database Administrator (DBA) – Maintains SQL Server databases

2. Database Developer– Design and implementation of databases.

3. Database testers – Validation of database for right data loaded.

4. Data Scientist– Deals with analyzing, predicting and mining data to drive the business ahead.

5. ETL Developer – Extraction and transformation of data from databases.

6. Data Application Interface Developer– Works with various programming languages like C#, Asp Dot Net etc.

7. BI Application Developer– This job is in completed demand in the market and it deals with reporting, data transformation, data warehousing for analyzing various data cubes and marts.

8. BI Administrator– ETL jobs are executed, published and monitored and contrasted with SQL database for backend Validation.

9. Big Data Expert – Deals with various tools of big data like Spark, Hadoop, Hive etc.

10. Cloud database Expert– There are lots of cloud databases like GCC, AWS, Microsoft Azure that requires SQL professionals.

11. Database Migration Engineer– Meant for database migration or data migration from various sources in SQL server.

12. Data Analyst – creates key performance indicators to analyze the data.

13. BI Reporting Engineer– Executes business reports and metrics with the help of various BI tools like Tableau, Microstrategy, Panorama Necto Business Intelligence solutions in SQL databases reporting concept.

14. BI Solution Architect (SME) – Solutions for a business problem is offered by data analysis from lots of sources like SQL.

15. NoSQL DBA- There are lots no SQL databases like MongoDB but SQL Skills are quite applicable to work with NoSQL administration.

16. Big Data Architect– In the current world scenario data is everything and is very huge in volume, velocity therefore big data architect offers solutions to handle data in large numbers.

Oct 12, 2018
View Arun Kumar Das 's Profile
Difference between Oracle base and Oracle home
ORACLE_BASE is the root directory for oracle.
ORACLE_HOME located beneath ORACLE_BASE is where the oracle products reside.

ORACLE_BASE specifies the directory at the top of the Oracle software and administrative file structure.
The value recommended for an OFA configuration
For example: /u01/app/oracle.
If you are not using an OFA-compliant system, you do not have to set ORACLE_BASE, but it is highly recommended that you do set it.

ORACLE_HOME specifies the directory containing the Oracle software for a given release.
The Optimal Flexible Architecture recommended value is:
$ORACLE_BASE/product/release.
For example:
/u01/app/oracle/product/8.1.7.
Jul 26, 2012
View Arun Kumar Das 's Profile
Difference between Oracle base and Oracle home
ORACLE_BASE is the root directory for oracle.
ORACLE_HOME located beneath ORACLE_BASE is where the oracle products reside.

ORACLE_BASE specifies the directory at the top of the Oracle software and administrative file structure.
The value recommended for an OFA configuration
For example: /u01/app/oracle.
If you are not using an OFA-compliant system, you do not have to set ORACLE_BASE, but it is highly recommended that you do set it.

ORACLE_HOME specifies the directory containing the Oracle software for a given release.
The Optimal Flexible Architecture recommended value is:
$ORACLE_BASE/product/release.
For example:
/u01/app/oracle/product/8.1.7.
Jul 26, 2012