How to install Oracle11g on CentOS 7 system (steps)
- PHPzOriginal
- 2023-04-19 14:15:065106browse
Oracle11g is a powerful relational database management system that can manage and store large amounts of data. Installing Oracle11g on the server can improve the server's data management and processing capabilities, and also facilitate remote management and data sharing.
The following are the steps to install Oracle11g on the CentOS 7 operating system:
Step 1: Download the Oracle11g installation file
First, you need to download Oracle11g for the server from the Oracle official website Installation files. It should be noted that you need to download the installation file of the Linux version suitable for the server, usually in zip or tar format.
Step 2: Install service packs and dependent libraries
Before downloading the Oracle11g installation file, you need to install some necessary service packs and dependent libraries to ensure that Oracle11g can be installed and run smoothly.
In the CentOS 7 operating system, you can use the following command to install the service pack and dependent libraries:
yum install -y binutils yum install -y compat-libstdc++-33 yum install -y compat-libstdc++-33.i686 yum install -y gcc yum install -y gcc-c++ yum install -y glibc yum install -y glibc.i686 yum install -y glibc-devel yum install -y glibc-devel.i686 yum install -y ksh yum install -y libgcc yum install -y libgcc.i686 yum install -y libstdc++ yum install -y libstdc++.i686 yum install -y libstdc++-devel yum install -y libstdc++-devel.i686 yum install -y libaio yum install -y libaio.i686 yum install -y libaio-devel yum install -y libaio-devel.i686 yum install -y libXext yum install -y libXext.i686 yum install -y libXtst yum install -y libXtst.i686 yum install -y libX11 yum install -y libX11.i686 yum install -y libXau yum install -y libXau.i686 yum install -y libxcb yum install -y libxcb.i686 yum install -y libXi yum install -y libXi.i686 yum install -y make yum install -y sysstat
Step 3: Create a new user
Before installing Oracle11g, you need to create A new user to install and run Oracle11g.
You can use the following command to create a new user:
groupadd oinstall groupadd dba useradd -g oinstall -G dba oracle
Step 4: Set system parameters
In order to ensure that Oracle11g can be installed and run normally, some system parameters need to be modified.
System parameters can be set using the following command:
vi /etc/sysctl.conf
Add the following lines to the open file:
fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586 fs.aio-max-nr = 1048576
Save and exit the file.
Then use the following command to make the modified system parameters take effect immediately:
sysctl -p
Step 5: Create directories
Before installing Oracle11g, you need to create some directories for storing Oracle11g configuration files, data files and log files.
You can use the following command to create a directory:
mkdir /u01 mkdir /u01/app mkdir /u01/app/oracle mkdir /u01/app/oraInventory chown -R oracle:oinstall /u01 chmod -R 775 /u01
Step 6: Edit environment variables
You need to edit the environment variables of the oracle user and add the path to Oracle11g.
Environment variables can be edited using the following command:
vi /home/oracle/.bash_profile
Add the following lines to the opened file:
export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 export ORACLE_SID=orcl export PATH=$PATH:$ORACLE_HOME/bin
Save and exit the file.
Then use the following command to make the modified environment variables take effect immediately:
source /home/oracle/.bash_profile
Step 7: Decompress the Oracle11g installation file
Extract the downloaded Oracle11g installation file to /u01/app /oracle directory.
You can use the following command to decompress the installation file:
unzip linux.x64_11gR2_database.zip -d /u01/app/oracle/
Step 8: Run the installation program
Log in as the oracle user and enter the /u01/app/oracle/database directory.
Then run the ./runInstaller command to start the Oracle11g installation program.
The installation program will sequentially perform client check, installation type selection, Oracle11g unique identifier (SID) setting, Oracle11g storage type setting, Oracle11g installation option setting and final installation.
When executing the ./runInstaller command, you need to pay attention to the following points:
- You must use the root user to execute the ./runInstaller command, otherwise a Permission denied error will be prompted.
- When selecting the installation type, select Typical to install using the default options.
- In the storage type settings of Oracle11g, select File System to use the file system for storage.
- In the installation option settings, select "Install and configure Oracle Database" and "Create Database".
The installation process may take some time, please wait patiently.
Step 9: Create Oracle11g database
After the Oracle11g installation is completed, you need to create a new Oracle11g database.
You can use the following command to create a database:
dbca
In the opened Oracle11g Database Configuration Assistant, follow the wizard and specify the database name, database storage location, administrator account and password and other information.
When creating a database, you need to pay attention to the following points:
- Use File System as the storage type.
- In the Administrator tab, specify the administrator account and password.
- In the Character Sets tab, use the AL32UTF8 character set.
- In the Storage tab, set the Database File Size of the Sizing tab to 1024MB.
Step 10: Verify Oracle11g installation
After the Oracle11g database is created, you can verify whether the installation and configuration of Oracle11g are correct.
You can use the following command to log in to the Oracle11g database:
sqlplus / as sysdba
After successfully logging in, you can execute some simple SQL statements to verify the installation and configuration of Oracle11g.
For example, you can use the following SQL statement to view the currently connected Oracle11g database version:
SELECT * FROM v$version;
If the returned result contains the version number of Oracle11g, it means that Oracle11g is installed and configured successfully.
Summary
Oracle11g is a very powerful and commonly used database management tool that can be used for server data management and processing. To install Oracle11g on the CentOS 7 operating system, you need to set some system parameters and install dependent libraries. Then you can use the Oracle11g installer for installation and configuration. After the installation is complete, you need to create a new Oracle11g database, and verify whether Oracle11g is installed and configured correctly.
The above is the detailed content of How to install Oracle11g on CentOS 7 system (steps). For more information, please follow other related articles on the PHP Chinese website!