Shulou(Shulou.com)06/01 Report--

Today, I will show you what is the procedure for Linux system to connect to Oracle server remotely. The content of the article is good. Now I would like to share it with you. Friends who feel in need can understand it. I hope it will be helpful to you. Let's read it along with the editor's ideas.

I. installation environment

Linux server: CentOS 6.8 64-bit

Oracle server: Oracle11gR2 64-bit

II. System requirements

1. Linux installation Oracle system requirements

2. Modify core parameters of the operating system

Perform the following steps under Root user:

1 modify *) modify the limit of user's SHELL, modify / etc/security/limits.conf file * *

Enter the command: vi / etc/security/limits.conf**, press I to enter edit mode and add the following to the file. **

Oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 press ESC after editing, and type ": wq" to save and exit.

2) modify the / etc/pam.d/login file, enter the command: vi / etc/pam.d/login, press * * I to enter edit mode, and add the following to the file. **

Press ESC after editing session required / lib/security/pam_limits.so session required pam_limits.so, and type ": wq" to save and exit.

3 modify *) modify the linux kernel, modify the / etc/sysctl.conf file, enter the command: vi / etc/sysctl.conf, press I to enter edit mode, and add the following to the file * *

Fs.file-max = 6815744 fs.aio-max-nr = 1048576 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 25032000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 4194304 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 press ESC and type ": wq" to save and exit

4 execute *) * * for the / etc/sysctl.conf changes to take effect immediately, execute the following command. Input: sysctl-p is displayed as follows:

Linux:~ # sysctl-p net.ipv4.icmp_echo_ignore_broadcasts = 1 net.ipv4.conf.all.rp_filter = 1 fs.file-max = 6815744 fs.aio-max-nr = 1048576 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 25032000 100128 net.ipv4.ip_local_port_range = 900065500 net.core.rmem_default = 4194304 net.core.rmem_max = 4194304 net.core. Wmem_default = 262144 net.core.wmem_max = 10485765) Edit / etc/profile Enter the command: vi / etc/profile, press * * I to enter edit mode and add the following to the file. **

If [$USER = "oracle"]; then if [$SHELL = "/ bin/ksh"]; then ulimit-p 16384 ulimit-n 65536 else ulimit-u 16384-n 65536 fi fi after editing, press ESC and type ": wq" to save and exit

Create relevant users and groups, * * as owners of software installation and support groups.

Create user, enter command: groupadd oinstall groupadd dba create Oracle user and password, enter command: useradd-g oinstall-g dba-m oracle passwd oracle and then let you enter password, password entered twice at will, but must be consistent, enter confirm 7 please *) create database software directory and data file storage directory, directory location, according to your own situation, pay attention to disk space. Here I put it under the oracle user, for example: my directory is: / software/oracle is the partition where the previous blog was mounted * *

Enter command: this directory can be customized mkdir / home/oracle/app mkdir / home/oracle/app/oracle mkdir / home/oracle/app/oradata mkdir / home/oracle/app/oracle/ product8) * * change the directory owner to Oracle user, enter the command: this is required, permission problem * *

Chown-R oracle:oinstall / home/oracle/app9) * * configure the environment variables for oracle users. First, you must switch to the newly created oracle user, * *

Enter: * * su-oracle**, and then directly enter: vi .bash _ profile

Press * * I to edit .bash _ profile, enter edit mode, and add the following: * *

Press the ESC key after editing umask 022 export ORACLE_BASE=/home/oracle/app export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=orcl export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib, and type ": wq" to save and exit.

3. Installation process * *

1) when all the operations of the above system are completed, log out of the system and log in as an Oracle user in the graphical interface. First copy the downloaded Oracle installation package to linux, which is recommended with Xmanager or other ftp tools.

Open a terminal and run the unzip command to extract the oracle installation file, such as:

Enter the command: after the unzip linux.x64_11gR2_database_1of2.zip unzip linux.x64_11gR2_database_2of2.zip is decompressed, cd enters its decompressed directory database

Enter command: cd database uses the ls command to view the files contained in the decompressed database, as shown below:

2install *) * * execute the installation, enter the command:. / runInstaller

[when you install to this step, you can see that there are many rpm packages. We can find the missing packages from the CD or ISO where we installed linux, upload them to linux using ftp, and then use rpm-ivh xxx.rpm-nodeps-force to install (with-nodeps-force for mandatory installation, which is used in the case of unsuccessful installation using rpm-ivh xxx.rpm directly) the installation process is slight.

Wait until all the packages are installed, once again in the oracle graphical interface, perform the installation process 2, down during the environmental check process, and pass. ]

In the course of my installation, I did not encounter

After the installation is complete, you will be prompted to execute 2 shell scripts with root permissions. Follow the prompted path to find its location, such as: mine is on / home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh

Open a new terminal with / home/oracle/app/oraInventory/orainstRoot.sh and enter the command:

Build su-root cd / home/oracle/app/oracle/product/11.2.0/dbhome_1 sh root.sh cd / home/oracle/app/oraInventory sh orainstRoot.sh4**. database * *

1) still in the graphical interface of oracle users, oracle users, open a new terminal, directly enter the command dbca will pop up the following interface. We use a custom database here.

Enter the unified password (you can also set the password separately)

The storage location of the database. I use the default here.

Do not specify quick recovery and archiving

Remove modules that are not commonly used (check Oracle Text,Oracle OLAP,Oracle Spatial for GIS SDE)

Memory allocation and specified character set

After a long wait, when you see this interface, you may encounter problems when you complete the installation process of building an oracle library.

You can use sqlplus to verify, open a new command window, enter sqlplus, and then enter the user name and password, you can test.

The above is the whole content of Linux system remote connection Oracle server steps, more and Linux system remote connection Oracle server steps what is the related content can search the previous article or browse the following article to learn ha! I believe the editor will add more knowledge to you. I hope you can support it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.