How To Set Oracle_home And Oracle_sid In Windows

In my previous article i have given the detailed description of multiple queries related to oracle. In this article i would like to throw light on – How to set oracle_home path? I volition explain multiple steps for setting upwardly the oracle_home path.We often employ the oracle_home in item. In this mail service i would like to cover the following topics in detail.

1. What is mean past ORACLE_HOME and What is Purpose of it?
2. How to check the ORACLE_HOME setting
3. How to gear up ORACLE_HOME path
4. How to modify setting of oracle domicile or how to delete or change oracle home

Purpose of ORACLE_HOME:

1. ORACLE_HOME is a directory name which will come up at the fourth dimension of Oracle software installation.
2. The specified directory path of ORACLE_HOME directory is been stored in an surround variable.
3. The path of the ORACLE_HOME directory is stored the installation path of oracle. Case : For windows information technology could exist C:\ or C:\Software or nether D:\.
4. File Structure under oracle home : The structure of files in ORACLE_HOME is fixed. Example : The location of sqlplus.exe is always ORACLE_HOME/bin and Tnsnames.ora path will be ORACLE_HOME\network\admin.
5. The ORACLE_HOME file will always used to ensure the correct oracle version is accessed running against the database.
6. When information technology is important : Information technology is very critical when yous are using multiple versions of oracle on aforementioned windows server. ORACLE_HOME file is also of import for installing the patches of oracle.

How to set oracle_home path? :

One time you install the Oracle.We require to check ORACLE_HOME file is fix or non. We crave to set the ORACLE_HOME .

How to set oracle_home path? – Windows Server

There are and then many questions in heed that what is verbal path of ORACLE_HOME file.We require to check whether the ORACLE_HOME is fix or non.

c:\>echo %ORACLE_HOME%

C:\oraclexe\app\oracle\product\xi.i.0.6\server

If the path is given below (The version proper noun may be different). If ORACLE_HOME is not set and so y'all require to set the ORACLE_HOME.

C :\> repeat %ORACLE_HOME%%ORACLE_HOME

How to set oracle_home path?

We require to gear up the ORACLE_HOME for Windows server ,

C:\>set up ORACLE_HOME=C:\oraclexe\app\oracle\product\xi.1.0.half dozen\server

C:\>repeat %ORACLE_HOME%C:\oraclexe\app\oracle\production\11.1.0.6\server

C:\>

How to check and gear up Surroundings variable path?

Stride 1 : Get to the Control Panel –> System –> Advanced

Step 2 :We require to create on button named "Environs Variables". There are 2 set of variables – kickoff is User and other is Organization variables.The user variables are the variables which are visible to anyone who has logged in to the arrangement. The organisation variables are visible to any other person who uses the system.

Step 3:Depending on the visibility y'all crave to create ORACLE_HOME variable past clicking on New push.

Step 4 : We crave to prepare the ORACLE_HOME directory value and Save it.

Step 5: We crave to verify it with new command line session,

1. Go to Command Console -> System -> Advanced.
2. Click on push "Surround Variables". This volition open a window with ii sets of variables – User and Arrangement. User variables are visible to your login but, while system variables are visible to anyone else who uses the system.
3. Cull "New" to create ORACLE_HOME variable every bit either User or Organisation variable, depending on how you lot desire its visibility.
4. Set its value to the Oracle directory.
5. Click OK to save.
6. Verify through anew control line session that the value has been set correctly.

How to set oracle_home path? – Unix or Linux Server

You tin can besides check and fix the ORACLE_HOME path on unix or linux server. The first step is to cheque the ORACLE_HOME.

Command to employ :

env | grep ORACLE_HOME

If the path is not set then you lot will get the following error.

SQL> @%ORACLE_HOME%\RDBMS\ADMIN\SCOTT.sqlSP2-0310: unable to open file "%ORACLE_HOME%\RDBMS\ADMIN\SCOTT.sql"

If you get above error so y'all crave to set the ORACLE_HOME using following Steps.

Step 1 : Open the linux/unix operating system command prompt.

Step two : Use following commands to set the ORACLE_HOME and ORACLE_SID are set properly.

Command 1 : (bash or ksh)export ORACLE_SID=orcl

Command two :csh or tcsh)setenv ORACLE_SID orclYou tin can set these with the scriptscoraenv (for the C shell) andoraenv (for other shells). These scripts are typically located in the/usr/local/bin directory.

Pace 3 : Cheque and Ensure that the ORACLE_HOME/BIN directory in environment variable path.

Stride 4 : Command to use,

export ORACLE_HOME=/app/oracle/product/11.ane.0.six/server

How to alter setting of ORACLE_HOME?

There is need to edit or delete the ORACLE_HOME. These kind of situation occurs when there is demand to install multiple oracle installations. Y'all crave to follow the same steps and only you need to click on Edit or Delete button accordingly in Windows.

In Linux organization also you can also edit profile file for your default shell in home directory. Instance : /domicile/oracle , so that these environs variables are set every time you log in every bit that user.

I hope you get articulate idea near – How to ready oracle_home path? in particular .If you like this article or if you have any issues with the same kindly comment in comments section.

Source: https://www.complexsql.com/how-to-set-oracle_home-path/

Share this post