Here are the steps:
Mount/MNT/centos-7-x86_64-dvd-1708. ISO: mount/MNT/centos-7-x86_64-dvd-1708 Mount -t ios9660-o loop/MNT/centos-7-x86_64-dvd-1708. Iso /oraclehome (L not 1) CD /etc/yum.repos. D/enter this file rm-f * delete all the files in the directory Vim yum.repo edit the contents of the file, the suffix-cannot be changed [without this file automatically created] [oraclehome] specify name=oraclehome name BaseURL =file:/// OracleHome location GPGCheck =0 Skips source checking
2. Install the RPM package: yum install -y binutils* yum install -y compat-libcap1* yum install -y ksh* yum install -y libaio-devel* yum install -y compat-libstdc* yum install -y elfutils-libelf* yum install -y gcc* yum install -y glibc* yum install -y libaio* yum install -y libgcc* yum install -y libstdc* yum install -y make* yum install -y sysstat* yum install -y libXp* yum Install -y glibc-kernheaders if the installation environment is Intranet and some packages are missing. Go online and download the offline package. Specific operation reference: https://blog.csdn.net/wdw984/… https://www.cnblogs.com/lgx21… https://www.cnblogs.com/fanji… https://blog.csdn.net/qq_1648…
Users and groups to create the database installed with details: https://www.runoob.com/linux/… Using the root user, do the following: Create the oinstall group
# groupadd -g 5000 oinstall
Create the dba group
# groupadd -g 501 dba
Create Oracle user
#useradd -g oinstall -G dba oracle
Passwd oracle (example: 11111111) : passwd oracle
The database name and the database instance name are first determined. For a single-instance (non-RAC) environment, the two are generally the same.
Assuming the database (instance) is named PowerDES, using Oracle User, edit /home/oracle/.bash_profile and add the following
#added by timman for oracle export ORACLE_BASE=/home/oracle/app/oracle export ORACLE_HOME = / home/oracle/app/oracle/product / 12.2.0 / dbhome_1 export ORACLE_SID = former export PATH = $ORACLE_HOME/bin: $PATH
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/lib:$ORACLE_HOME/lib
export CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/jlib:$ORACLE_HOME/network/lib
export LANG=en_US.gbk
export NLS_LANG=american_america.ZHS16GBK
export EDITOR=vi
ORACLE_BASE database base directory (profile) ORACLE_HOME database installation path TMP the temporary file directory ORACLE_TERM install Oracle terminal type LD_LIBRARY_PATH temporary library file path of the path Source /home/oracle/.bash_profile Source /home/oracle/.bash_profile Source /home/oracle/.bash_profile 3.3 Create a file system (or install directory) and change the corresponding permissions -p to make sure the directory name exists. If it does not exist, create one. [root@powerlong4 oracle]# mkdir -p /home/oracle/app/oracle [root@powerlong4 oracle]# mkdir -p / home/oracle/app/oraInventory (product list) [root @ powerlong4 oracle] # chown -r oracle: oinstall/home/oracle/app [root@powerlong4 oracle]# chmod -R 775 /home/oracle/app/oracle
4.1 Check the Free -m partition
# dd if=/dev/zero of=/usr/swapfree BS =1024 count=2048000
Swapon /usr/swapfree # To stop using the newly created swap file, simply execute swapoff / TMP /swapfree. If the swap file is no longer in use, you can delete it. Swapon-s # Check swap
Reference: https://blog.csdn.net/weixin_… / MNT /database: / MNT /database: / MNT /database: / MNT /database Chmod-r 777 / MNT /database/ [oracle@powerlong4 database]$./runInstaller Reference: https://blog.csdn.net/weixin_…
After the installation, Using the root user run/home/oracle/app/oraInventory/orainstRoot sh/home/oracle/app/oracle/product / 12.2.0 / dbhome_1 / root. Sh these two files After running the above two files, start installing the listeners. Run netca hostname Settings under Oracle user: ‘localhost’, ‘install dbca create database container do not restore area’, ‘archive do not install’. According to the company project configuration 5500 the do not install remote program. According to company requirements bigdata – kvm03. Siat. Cn and modify/home/oracle/app/oracle/product / 12.2.0 / dbhome_1 / NETWORK/ADMIN/listener. Ora Change host to native IP. Ora: SID_LIST_LISTENER = (SID_LIST = (SID_DESC =
(GLOBAL_DBNAME = former) (ORACLE_HOME = / home/oracle/app/oracle/product / 12.2.0 / dbhome_1) (SID_NAME = former)))
SU-oracle Sqlplus/as sysdba Startup Exit Isnrctl start Exit su-oracle Sqlplus/as sysdba Startup Exit Isnrctl start Exit
SU-Oracle SQLPLUS/AS SYSDBA Shutdown immediate Exit ISNRCTL stop Exit
Possible errors during installation: Hard limit: Maxinum open file descriptors(maxinum open file descriptors) require at least 65536, The actual value is 65535.) Ulimit-a can see that the open files are 65535. In the root user to modify the/etc/security/limits the conf configuration file. Vim/etc/security/limits. Conf at the last increase the following content: (Write as large an error message as you need, Oracle Soft nproc 2047 Oracle Hard nproc 16384 Oracle Soft nofile 65536 Oracle Hard nofile 65536 Oracle Soft nofile 65536 Modify the /etc/pam.d/login startup file at root. To make the/etc/security/limits file configuration to take effect, must make sure that the boot file/etc/PAM. Included in the d/login/lib64 / security/pam_limits. So, if not to join: /etc/pam.d/login: /etc/pam.d Session required /lib64/security/pam_limits. So log in to the Oracle user and run ulimit-a to find out that the open files value has been changed to 65536. complete
Answer: https://blog.csdn.net/andygua… https://blog.csdn.net/weixin_… https://blog.csdn.net/andygua…
Dbstart restart server LSNRCTL stop LSNRCTL start start listener LSNRCTL status view exit
Su – switch oracle oracle user virtual machine communication network: https://www.cnblogs.com/wishw… Disable Selinux systemctl to stop firewalld. Service #– disable firewalld. Service #– disable firewall to start systemctl Status firewalld.service # Alter user identified by password; ADMIN_123 LISTENER name: LISTENER NAME: ORCL DATABASE NAME: ORCL SID: ORCL