Linux_x64 install Oracle11g (full version), linux_x64oracle11g
1. Modify core operating system parameters
Perform the following steps under the Root user:
1) modify the user's SHELL restrictions and modify the/etc/security/limits. conf file
Enter the command vi/etc/security/limits. conf, press the I key to enter the editing mode, and add the following content to the file.
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
After editing, pressEscKey, enter": Wq"Save disk and exit
2) modify the/etc/pam. d/login file, enter the command vi/etc/pam. d/login, press the I key to enter the editing mode, and add the following content to the file.
Session required/lib/security/pam_limits.so
Session required pam_limits.so
After editing, Press EscKey, enter ": wq"Save disk and exit
3) modify the Linux kernel, modify the/etc/sysctl. conf file, enter the command vi/etc/sysctl. conf, press the I key to enter the editing mode, and add the following content to the file.
Fs. file-max = 6815744
Fs. aio-max-nr = 1048576
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
Kernel. sem = 250 32000 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
After editing, pressEscKey, enter": Wq"Save disk and exit
4) to make the/etc/sysctl. conf change take effect immediately, run the following command. Input: sysctl-p:
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 = 250 32000 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
5) edit/etc/profile, enter the command vi/etc/profile, press the I key to enter the editing mode, and add the following content 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, pressEscKey, enter": Wq"Save disk and exit
6) Create related users and groups as owners of software installation and support groups.
Create an Oracle user and password, and enter the following command:
Useradd-g oinstall-g dba-m oracle
Passwd oracle
The password will be entered twice, but the password must be consistent. Press enter to confirm.
7) Create a database software directory, a data file storage directory, and a directory location based on your needs. Pay attention to the disk space. Here I will put it under the oracle user, for example:
Enter the following command:
Mkdir/home/oracle/app
Mkdir/home/oracle/app/oracle
Mkdir/home/oracle/app/oradata
Mkdir/home/oracle/app/oracle/product
8)Change the directory ownerOracleAll users. Enter the following command:
Chown-R oracle: oinstall/home/oracle/app
9)Configure oracleFirst, switch to the newly created oracleUser,
Input: su-oracle, and then directly enter: vi. bash_profile
Press I to edit. bash_profile, enter the editing mode, and add the following content:
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
After editing, pressEscKey, enter": Wq"Save disk and exit
Ii. Installation Process
1)After all the operations required by the above system are completed, log out of the system and useOracleUser login. First, downloadOracleCopy the installation packageLinuxMedium, useSSHOthersFtpTool copy.
Open a terminal and runUnzipCommand DecompressionOracleInstallation files, such:
Enter the following command:
Unzip linux.x64_11gR2_database_1of2.zip
Unzip linux.x64_11gr2_database5of2.zip
After decompression, the cd enters the decompressed directory database.
Enter the following command:
Cd database
Run the ls command to view the files contained in the decompressed database, for example:
2)Run the following command to install the SDK:./RunInstaller
Install this step. We can see that there are many rpm packages not available. We can install linux from the CD or ISO (or D: \ linux_oracle11g_Package) find the missing package, upload it to linux using ftp, and then use rpm-ivh xxx. rpm -- nodeps-force is used for installation (add -- nodeps -- force indicates forced installation, and rpm-ivh xxx is used directly. when all the packages are installed properly, run the installation process 2 in the oracle graphical interface again. During the Environment check, it is passed.
During installation, 86% may encounter errors such as errors (error in invoking target 'mkldflags ntcontab. o nnfgt. o' of makefile.
Upload and install image rhel-server-6.1-x86_64-dvd.iso,
Then mount the image file, such as/mnt
# Mount-o loop rhel-server-6.1-x86_64-dvd.iso/mnt
# Cd/mnt/Packages
# Rpm-ivh glibc-common-2.12-1.25.el6.x86_64.rpm
# Rpm-ivh kernel-headers-2.6.32-131.0.15.el6.x86_64.rpm
# Rpm-ivh libgcc-4.4.5-6.el6.x86_64.rpm
# Rpm-ivh glibc-2.12-1.25.el6.x86_64.rpm
# Rpm-ivh libgomp-4.4.5-6.el6.x86_64.rpm
# Rpm-ivh nscd-2.12-1.25.el6.x86_64.rpm
# Rpm-ivh glibc-headers-2.12-1.25.el6.x86_64.rpm
# Rpm-ivh glibc-devel-2.12-1.25.el6.x86_64.rpm
# Rpm-ivh mpfr-2.4.1-6.el6.x86_64.rpm
# Rpm-ivh ppl-0.10.2-11.el6.x86_64.rpm
# Rpm-ivh cloog-ppl-0.15.7-1.2.el6.x86_64.rpm
# Rpm-ivh cpp-4.4.5-6.el6.x86_64.rpm
# Rpm-ivh gcc-4.4.5-6.el6.x86_64.rpm
Note: The gcc installation sequence is correct.
**************************************** **
# Rpm-ivh libstdc ++-4.4.5-6. el6.x86 _ 64.rpm
# Rpm-ivh libstdc ++ devel-4.4.5-6.el6.x86_64.rpm
# Rpm-ivh gcc-c ++-4.4.5-6. el6.x86 _ 64.rpm
Note: The above is the installation of gcc-c ++
The error is solved according to this method.
After the installation is complete, the system prompts you to use the root permission to execute two shell scripts. Locate the location according to the prompted path, for example, in/home/oracle/app/oracle/product/11.2.0/dbhome_1/root. sh.
And/home/oracle/oraInventory/orainstRoot. sh to open a new terminal, enter the command:
Su-root
Cd/home/oracle/app/oracle/product/11.2.0/dbhome_1
Sh root. sh
Cd/home/oracle/oraInventory
Sh orainstRoot. sh
Iii. database creation
1) in oracle user graphical interface (GUI), a new terminal is opened. The following interface is displayed when you directly enter the command dbca. Here we use a custom database.
After a long wait, when you see this interface, the oracle database creation is complete.
4. Configure listeners and Local Network Services
1) open a new terminal in the oracle user graphical interface (GUI) of the oracle user. Enter the command netca to bring up the following interface.
2) create a listening service (Act as an oracle Server and connect other oracle clients to the local oracle Server)
3) configure the local network service name (Act as the oracle client and connect to other oracle servers)
Enter the database instance name of the connected oracle Server
Enter the IP address of the oracle server
Select YES to test
Click change Login and enter a user name and password (oracle and the password) of the connected oracle Server. Then, click OK.
If the test is successful, check whether the network is smooth, whether the connected oracle Server is started, and whether the listener is started)
Name your local network service name
In this way, the installation and configuration of the oracle server are basically complete.
Note:
1. Storage path of Linux oracle Database listener. ora
Cd/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener. ora
2. Storage path of Linux oracle Database tnsnames. ora
Cd/home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames. ora
3. ORACLE startup listener
(1) switch to oracle Installation user (generally oracle)
Su-oracle
(2) Start the listener
Lsnrctl start
(3) Stop the listener
Lsnrctl stop
4. Start oracle testing:
[Oracle @ oracle ~] $ Sqlplus/nolog
SQL * Plus: Release 11.2.0.1.0 Production on Fri Jul 27 02:12:12 2012
Copyright (c) 1982,200 9, Oracle. All rights reserved.
SQL> quit
Another method for testing: Find a windows platform computer and telnet the IP address of the oracle host to 1521. If the connection is successful, a black screen will pop up and the cursor will flash.
5. open port 1521 in Linux to allow network connection to Oracle Listener
Symptoms:
(1) TCP/IP connection is successful. You can use the ping command to test.
(2) Oracle Listener is enabled on the server.
Lsnrctl status view listener status
Lsnrctl start Oracle listener
(3) Client errors are usually: ORA-12170: TNS: Connection timeout
At this time, we can basically say that the server has not opened port 1521 (assuming you use the default settings)
Solution:
(1) assume that you have configured a firewall in a LAN environment. You can disable the Linux firewall.
Sudo service iptables stop
(2) EDIT iptables and open port 1521:
Sudo vi/etc/sysconfig/iptables
-A input-p tcp-m state -- state NEW-m tcp -- dport 1521-j ACCEPT
: Wq
Restart Firewall
Sudo service iptables restart
Save the configuration so that the configuration is valid after linux is restarted.
Sudo service iptables save
View firewall rules:
Sudo iptables-L-n
6. Create oracle user tablespace in linux
Creates a new account on an existing database instance to access some new tables.
The procedure is as follows:
(1) log on to linux and Log On As an oracle user (if logged on as a root user, use the su-oracle command to switch to an oracle user)
(2) Open sqlplus in sysdba mode. The command is as follows: sqlplus "/as sysdba"
(3) Check the location where the user tablespace is normally placed: execute the following SQL statement:
Select name from v $ datafile
(4) create a user tablespace:
Create tablespace policydb DATAFILE '/home/oracle/app/oradata/orcl/scsdb. dbf' SIZE 200 m autoextend on extent management local segment space management auto;
(5) create a user and specify the password and the user tablespace created above
Create user scs identified by scs default tablespace policydb;
(6) grant permissions
Grant connect, resource to scs;
Grant unlimited tablespace to scs;
Grant create database link to scs;
Grant select any sequence, create materialized view to scs;
-- After the above operations, we can use scs/scs to log on to the specified instance and create our own table.
Where does the RPM package required to install Oracle11g on Linux need to go?
The Oracle installer does not provide rpm. If it is a related support software package, it should be available on the Linux CD. For more information, see the installation instructions for Oracle on Linux.
In linux, can I use commands on the oracle11g installation interface?
Install it silently on your Baidu oracle.