Oracle environment variable setting method in Windows sharing _oracle

environment variable settings for Oracle in Window server

1. Right-click "My Computer"-> Select "Properties"-> Select "Advanced"-> Click "Environment Variables"
2. Select the "Path" line, click Edit, add a semicolon ":" In the last face of the variable value text box in "path", and then add the directory path to the Sqlplus file after the semicolon, such as "C:\Program files\oracle\product\ 10.2.0\db_1\bin ", and then click" OK "button.
3, if you do not find the "Oracle_home" and "Oracle_sid" variables in the variables column under the System Variables list box, you need to do the following, otherwise you don't need to do this.
4, in the "System variable" click on the "New" button, "variable name" in the "Oracle_home", the variable value of the installation directory of ORACLE path, such as "C:\Program files\oracle\product\10.2.0\db_1", Then click the "OK" button.
5, in the "System variables" click on the "New" button, in the "variable name" input "Oracle_sid", the variable value of the database to enter the instance name, and then click "OK" button.

installation directory for oracle_home:oracle database software
Oracle_sid:oracle the instance name of the database
Oracle database Instance Name: The identity used to communicate with the operating system, that is, the exchange between the database and the operating system is represented by the database instance name.