Basic Oracle tutorial-installing Oracle 11g software and example Solution

Preparations

Install a Virtual Machine (VMware Workstation version 8. x or VMware Server Version 1. x)

Install the Operating System (CentOS 5.x or CentOS 4.x) on the Virtual Machine)

Create an Oracle user and copy the Oracle software to a directory related to the Operating System

Granted correct User Permissions

Suggestion: I hope everyone can have their own laptops and learn more conveniently. The memory should be 4 GB, the minimum is 2 GB, And there is 40 Gb. We recommend 60 GB or more hard disk space.

Preparations

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba, wheel oracle

Passwd oracle

Mkdir-p/orasetup/u01/app/oracle/

Chown-R oracle: oinstall/orasetup/u01/

Chmod-R 770/orasetup/u01/

Environment Variable

Log on with an oracle account and set the corresponding environment variables

[Oracle @ oracle ~] $ Vi. bash_profile

Set environment variables for Oracle, such as ORACLE_HOME, ORACLE_BASE, and ORACLE_SID. ORACLE_BASE is the Oracle main directory, ORACLE_HOME is the Oracle product storage directory, and ORACLE_SID is the Oracle instance id.

[Oracle @ oracle ~] $ Source. bash_profile

Privilege Escalation

Log On with the root account and modify some System Parameters

[Root @ oracle ~] # Vi/etc/profile

[Root @ oracle ~] # Source/etc/profile

Modify Kernel Parameters

[Root @ oracle ~] # Vi/etc/sysctl. conf

Make some simple modifications to kernel parameters, including shared memory segment parameters (SGA), semaphore parameters, maximum number of opened files parameters, network-related parameters, etc.

[Root @ oracle ~] # Sysctl-p

Permissions and restrictions

[Root @ oracle ~] # Vi/etc/security/limits. conf

Nofile: Maximum number of files that an operating system user can open simultaneously

Nproc: Number of processes that a single user can open at the same time

[Root @ oracle ~] # Vi/etc/pam. d/login

Note: For X86 mode, use lib for the class library. For X64 mode, use lib64 for the class library; otherwise, local logon failures may occur.

Suggestion: The rlwrap software is very useful. You can use the up and down arrow keys like the Linux Command Line when using the sqlplus tool. The installation method is very simple (standard binary code installation mode requires installation using the root account ).

Use the root account to compile the/etc/sudoers file and add a line of oracle ALL = (ALL) NOPASSWD: ALL. You can use sudo to operate the root account safely.

1 2 3 4 5 Next Page