Oracle environment variable settings

Oracle environment variable settings

Oracle architecture read 7 Comments 0 font size: Large LargeMedium MediumSmall Small

Oracle uses a large number of operating system environment variables when managing its own software. an environment variable is the value assigned to a name in the operating system. the software can use the name to call the variable value. if the environment variable settings are incorrect, Oracle commands such as "sqlplus" may not be found in Oracle because $ oracle_sid may be faulty.

Oracle software uses many environment variables. Three of the most important ones are ORACLE_HOME, oracle_base, and oracle_sid.oracle_home, which specify the location of the Oracle execution program you want to run. several versions of Oracle software may be installed on a computer. Most Oracle programs query ORACLE_HOME to determine which version of the software to run. oracle_base defines the basic directory for installing database management files. oracle_sid defines the name of the local Oracle database on which you want to work.

1. Su Oracle and press enter to switch to the Oracle user;

2. CD and press enter to return to the Oracle user directory;

3. VI. bash_profile, press enter to edit the file, press I to enter the insert status, and add the following lines at the end:

Export oracle_sid = orcl

Export ORACLE_HOME =/home/Oracle/product/10 ...... (the part is modified according to your actual path)

Export Path = $ path: $ ORACLE_HOME/bin

Press ESC to exit VI editing. Enter WQ and press enter to save the disk.

4. log out of all oracle users and log on to Oracle.

The following documents briefly describe how to view Oracle environment variables in Linux

Example:

[Oracle @ q1test01 ~] $ ENV | grep-e ora-e TNS-e LD

Oldpwd =/home/Oracle

LD_LIBRARY_PATH =/Oracle/product/9.2/lib:/usr/local/lib

Oracle_sid = orcl

Oracle_base =/Oracle

Oracle_term = xterm

Ld_assume_kernel = 2.4.1

Ora_nls33 =/Oracle/product/9.2/ocommon/NLS/admin/Data

ORACLE_HOME =/Oracle/product/9.2

Bytes ----------------------------------------------------------------------------------------------------------------------

Oracle 10g ORA-12154: TNS: cocould not resolve the connect identifier specified problem solved!

Today, from last week, I finally got rid of my problem! I'm proud of it.
Oracle 10g Database is installed on my computer. After configuring the variables, use PL/SQL to operate everything. after installing Oracle 10g client again, the problem arises, with PL/SQL login repeatedly prompt: ORA-12154: TNS: cocould not resolve the connect identifier specified
For beginners, I repeatedly find the problem in "net manager" in "configuration and porting Tools" under "oracle-oradb10g_home3. consult experts, and do not summon the cause of the problem. I was depressed and decided to solve the problem.
I made a lot of repeated data queries and self-check, and the inspiration came out after work. I suddenly realized that my "environment variable" had been ignored.
After opening it, I found that my current environment variable is set as follows:
Path = E:/oraclient_2; E:/Oracle/oradata/bin; E:/Oracle/bin; E:/program files/Java/jdk1.5.0 _ 04/bin; E: /tomcat5028/bin; % SystemRoot %/system32; % SystemRoot %/system32/WBEM
The problem occurs. I should make it as follows:
Path = E:/Oracle; E:/Oracle/oradata/bin; E:/Oracle/bin; E:/program files/Java/jdk1.5.0 _ 04/bin; E: /tomcat5028/bin; % SystemRoot %/system32; % SystemRoot %/system32/WBEM

OK !!! The problem was solved at the last moment !!! Good.