Install and configure the Oracle10g client on Linux

To access Oracle on Linux, you need to install a client. I have referenced a lot of information on the Internet, but there will always be half a card. According to your actual operations, I wrote the following operation manual,

To access Oracle on Linux, you need to install a client. I have referenced a lot of information on the Internet, but there will always be half a card. According to your actual operations, I wrote the following operation manual,

To access Oracle on Linux, you need to install a client. I have referenced a lot of information on the Internet, but there will always be half a card. According to your actual operations, I wrote the following operation manual, hoping to help my friends who installed the oracle client on linux. My Linux is RedHat Enterprise Linux AS4.

I. Check the system
1. Check the operating system version. For detailed system requirements, see the installation manual.
Cat/etc/issue
2. Check the Linux kernel version. For more information, see the installation manual.
Uname-r
3. Check whether the software installation package is installed and the version is correct. The syntax is: rpm-q package_name For example: rpm-q make. If it has been installed, the version number is displayed. Otherwise, the system prompts that the software has not been installed. Record the package that is not installed or the version is too low, find it in the installation CD of Linux, or search and download it online.
After all packages are installed, run the rpm command again.
Note: Some packages require system installation disks during installation.
The specific software package is as follows:
Make-3.79.1
Gcc-3.2.3-34-the system comes with the GCC compiler, but requires manual Installation
Glibc-2.3.2-95.20
Glibc-devel-2.3.2-95.20
Compat-db-4.0.14-5
Compat-gcc-7.3-2.96.128
Compat-gcc-c ++-7.3-2.96.128
Compat-libstdc ++-7.3-2.96.128
Compat-libstdc ++ devel-7.3-2.96.128
Openmotif21-2.1.30-8
Setarch-1.3-1
Gnome-libs-1.4.1.2.90-34.1 (32 bits)
Libaio-0.3.96-3
Libaio-devel-0.3.96-3

2. Create a user name and group name
/Usr/sbin/groupadd oinstall
/Usr/sbin/useradd-m-g oinstall oracle
-- Check the user ID
Id oracle
-- Set the password of an oracle user
Passwd oracle

3. Create an oracle installation directory and Set User Permissions
Mkdir-p/u01/app/oracle
Chown-R oracleinstall/u01/app/oracle
Chmod-R 775/u01/app/oracle-authorization. system users using the oracle client must have read permission on this directory.
Note:/u01/app/oracle is the recommended installation directory name in the Standard installation manual. You can use another directory name.

4. Install the Oracle client
To install the main directory, use the created/u01/app/oracle file. When you are prompted to run the script, log on to the terminal as the root user and run the two scripts. (Enter su in the terminal to log on as the root user)

5. log out of the system and use the root user to log on.
1. Edit the configuration file
Vi. bash_profile
Check whether the correct ORACLE_HOME and PATH are set in the file. If no, continue to the next step.
2. Add the following statement to the existing file:
Umask 022
Export ORACLE_HOME =/u01/app/oracle
Export PATH = $ ORACLE_HOME/bin: $ PATH
Note: after entering the editing page, press I to edit it. Press ESC and enter wq to save and exit.

6. log out of the system and log on to oracle. Repeat Step 5.

VII. Configure the oracle client

1. Enter cd/u01/app/oracle/bin in the terminal to enter this directory, and then enter ls to view the files under this directory.
2. Enter./netmgr to open net manager and configure the oracle server to be accessed.
3. After closing the net manager, enter./sqlplus. Enter hdny @ 225 in the username field (225 is an ORACLE_SID configured in the previous step ). Check whether the connection is successful.
8. If other Linux users need to use the oracle client, perform Step 5. And use the root user to authorize the oracle installation directory.