在centos 7中安装Oracle

爱被打了一巴掌 2022-04-22 12:40 213阅读 0赞

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70]

将安装包放入opt目录下，进行解压  
复制`yum install -y automake autotools-dev binutils bzip2 elfutils expat \ gawk gcc gcc-multilib g++-multilib lib32ncurses5 lib32z1 \ ksh less lib32z1 libaio1 libaio-dev libc6-dev libc6-dev-i386 \ libc6-i386 libelf-dev libltdl-dev libodbcinstq4-1 libodbcinstq4-1:i386 \ libpth-dev libpthread-stubs0-dev libstdc++5 make openssh-server rlwrap \ rpm sysstat unixodbc unixodbc-dev unzip x11-utils zlibc unzip cifs-utils \ libXext.x86_64 glibc.i686`  
到crt下  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 1]  
会进行安装依赖包

完成之后使用  
![在这里插入图片描述][20181105095046601.png]

执行之后会有一个is this ok 输入y 进行更新

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 2]

用户的id是502 用户组的名字是oinstall  
下面的503都是类似的创建组  
![在这里插入图片描述][20181105100559341.png]

输入更改密码  
设置八位密码

切换使用su命令

![在这里插入图片描述][20181105100858250.png]

操作用户：oracle  
操作目录：/home/oracle  
将Oracle 11gR2安装文件上传（可以使用sftp上传）到该操作目录下面，然后顺序解压安装文件到该目录  
放入之后进行查看  
![在这里插入图片描述][20181105101303580.png]

之后进行解压

unzip linux.x64_11gR2_database_1of2.zip
    unzip linux.x64_11gR2_database_2of2.zip

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 3]

修改安全设置  
操作用户：root  
操作文件：/etc/security/limits.conf  
![在这里插入图片描述][20181105101610952.png]  
进入root，因为Oracle没权限

vi /etc/security/limits.conf

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 4]

在文件最后追加如下内容（vi使用方法略）：
    
    oracle              soft      nproc 2047
    oracle              hard    nproc  16384
    oracle              soft      nofile  1024
    oracle              hard    nofile  65536
    oracle              soft    stack  10240

再次进入Oracle中进行修改  
![在这里插入图片描述][20181105102119455.png]

之后执行

![在这里插入图片描述][20181105105601421.png]

mkdir  -p ~/tools/oracle11g

下一步，还是在Oracle操作用户下操作，修改环境变量  
![在这里插入图片描述][20181105105715472.png]

vi ~/.bash_profile

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 5]

export ORACLE_BASE=/home/oracle/tools/oracle11g
    export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
    export ORACLE_SID=orcl
    export ORACLE_UNQNAME=orcl
    export NLS_LANG=.AL32UTF8
    export PATH=${PATH}:${ORACLE_HOME}/bin/:$ORACLE_HOME/lib64;

之后执行`source ~/.bash_profile`，使得配置生效  
![在这里插入图片描述][20181105105851859.png]

以后每次重新登录不需要重新设置，环境变量将自动加载。

关闭防火墙  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 6]

systemctl stop firewalld.service
    
    systemctl disable firewalld.service

完成之后定义安装响应文件

在Oracle操作用户下，进入/home/oracle目录下，

cp /home/oracle/database/response/db_install.rsp .

使用vi编辑器，编辑内容  
![在这里插入图片描述][20181105141324371.png]

vi db_install.rsp

在db\_install.rsp中编辑内容

####################################################################
    ## Copyright(c) Oracle Corporation 1998,2008. All rights reserved.##
    ##                                                                ##
    ## Specify values for the variables listed below to customize    ##
    ## your installation.                                            ##
    ##                                                                ##
    ## Each variable is associated with a comment. The comment        ##
    ## can help to populate the variables with the appropriate        ##
    ## values.   ##
    ##                                                                ##
    ## IMPORTANT NOTE: This file contains plain text passwords and    ##
    ## should be secured to have read permission only by oracle user  ##
    ## or db administrator who owns this installation.                ##
    ##                                                                ##
    ####################################################################
    #------------------------------------------------------------------------------
    # Do not change the following system generated value.
    #------------------------------------------------------------------------------
    oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
    #------------------------------------------------------------------------------
    # Specify the installation option.
    # It can be one of the following:
    # 1. INSTALL_DB_SWONLY
    # 2. INSTALL_DB_AND_CONFIG
    # 3. UPGRADE_DB
    #-------------------------------------------------------------------------------
    oracle.install.option=INSTALL_DB_AND_CONFIG
    #-------------------------------------------------------------------------------
    # Specify the hostname of the system as set during the install. It can be used
    # to force the installation to use an alternative hostname rather than using the
    # first hostname found on the system. (e.g., for systems with multiple hostnames
    # and network interfaces)
    #-------------------------------------------------------------------------------
    ORACLE_HOSTNAME=localhost
    #-------------------------------------------------------------------------------
    # Specify the Unix group to be set for the inventory directory. 
    #-------------------------------------------------------------------------------
    UNIX_GROUP_NAME=oinstall
    #-------------------------------------------------------------------------------
    # Specify the location which holds the inventory files.
    #-------------------------------------------------------------------------------
    INVENTORY_LOCATION=/home/oracle/tools/oraInventory
    #-------------------------------------------------------------------------------
    # Specify the languages in which the components will be installed.           
    #
    # en  : English                  ja  : Japanese                 
    # fr  : French                  ko  : Korean                   
    # ar  : Arabic                  es  : Latin American Spanish   
    # bn  : Bengali                  lv  : Latvian                 
    # pt_BR: Brazilian Portuguese    lt  : Lithuanian               
    # bg  : Bulgarian                ms  : Malay                   
    # fr_CA: Canadian French          es_MX: Mexican Spanish         
    # ca  : Catalan                  no  : Norwegian               
    # hr  : Croatian                pl  : Polish                   
    # cs  : Czech                    pt  : Portuguese               
    # da  : Danish                  ro  : Romanian                 
    # nl  : Dutch                    ru  : Russian                 
    # ar_EG: Egyptian                zh_CN: Simplified Chinese       
    # en_GB: English (Great Britain)  sk  : Slovak                   
    # et  : Estonian                sl  : Slovenian               
    # fi  : Finnish                  es_ES: Spanish                 
    # de  : German                  sv  : Swedish                 
    # el  : Greek                    th  : Thai                     
    # iw  : Hebrew                  zh_TW: Traditional Chinese     
    # hu  : Hungarian                tr  : Turkish                 
    # is  : Icelandic                uk  : Ukrainian               
    # in  : Indonesian              vi  : Vietnamese               
    # it  : Italian                                                 
    #
    # Example : SELECTED_LANGUAGES=en,fr,ja
    #------------------------------------------------------------------------------
    SELECTED_LANGUAGES=en,zh_CN
    #------------------------------------------------------------------------------
    # Specify the complete path of the Oracle Home.
    #------------------------------------------------------------------------------
    ORACLE_HOME=/home/oracle/tools/oracle11g/product/11.2.0/dbhome_1
    #------------------------------------------------------------------------------
    # Specify the complete path of the Oracle Base.
    #------------------------------------------------------------------------------
    ORACLE_BASE=/home/oracle/tools/oracle11g
    #------------------------------------------------------------------------------
    # Specify the installation edition of the component.                       
    #                                                           
    # The value should contain only one of these choices.       
    # EE    : Enterprise Edition                               
    # SE    : Standard Edition                                 
    # SEONE  : Standard Edition One
    # PE    : Personal Edition (WINDOWS ONLY)
    #------------------------------------------------------------------------------
    oracle.install.db.InstallEdition=EE
    #------------------------------------------------------------------------------
    # This variable is used to enable or disable custom install.
    #
    # true  : Components mentioned as part of 'customComponents' property
    #        are considered for install.
    # false : Value for 'customComponents' is not considered.
    #------------------------------------------------------------------------------
    oracle.install.db.isCustomInstall=false
    #------------------------------------------------------------------------------
    # This variable is considered only if 'IsCustomInstall' is set to true.
    #
    # Description: List of Enterprise Edition Options you would like to install.
    #
    #              The following choices are available. You may specify any
    #              combination of these choices.  The components you choose should
    #              be specified in the form "internal-component-name:version"
    #              Below is a list of components you may specify to install.
    #       
    #              oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning
    #              oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining
    #              oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault
    #              oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security
    #              oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing
    #              oracle.oraolap:11.2.0.1.0 - Oracle OLAP
    #------------------------------------------------------------------------------
    oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0
    ###############################################################################
    #                                                                            #
    # PRIVILEGED OPERATING SYSTEM GROUPS                                        #
    # ------------------------------------------                                  #
    # Provide values for the OS groups to which OSDBA and OSOPER privileges      #
    # needs to be granted. If the install is being performed as a member of the  #
    # group "dba", then that will be used unless specified otherwise below.       #
    #                                                                            #
    ###############################################################################
    #------------------------------------------------------------------------------
    # The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
    #------------------------------------------------------------------------------
    oracle.install.db.DBA_GROUP=dba
    #------------------------------------------------------------------------------
    # The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
    #------------------------------------------------------------------------------
    oracle.install.db.OPER_GROUP=oper
    #------------------------------------------------------------------------------
    # Specify the cluster node names selected during the installation.
    #------------------------------------------------------------------------------
    oracle.install.db.CLUSTER_NODES=
    #------------------------------------------------------------------------------
    # Specify the type of database to create.
    # It can be one of the following:
    # - GENERAL_PURPOSE/TRANSACTION_PROCESSING         
    # - DATA_WAREHOUSE                               
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
    #------------------------------------------------------------------------------
    # Specify the Starter Database Global Database Name.
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.globalDBName=orcl
    #------------------------------------------------------------------------------
    # Specify the Starter Database SID.
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.SID=orcl
    #------------------------------------------------------------------------------
    # Specify the Starter Database character set.
    #                                             
    # It can be one of the following:
    # AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,
    # EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,
    # BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,
    # AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,
    # IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,
    # KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,
    # ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.characterSet=AL32UTF8
    #------------------------------------------------------------------------------
    # This variable should be set to true if Automatic Memory Management
    # in Database is desired.
    # If Automatic Memory Management is not desired, and memory allocation
    # is to be done manually, then set it to false.
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.memoryOption=true
    #------------------------------------------------------------------------------
    # Specify the total memory allocation for the database. Value(in MB) should be
    # at least 256 MB, and should not exceed the total physical memory available
    # on the system.
    # Example: oracle.install.db.config.starterdb.memoryLimit=512
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.memoryLimit=512
    #------------------------------------------------------------------------------
    # This variable controls whether to load Example Schemas onto the starter
    # database or not.
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.installExampleSchemas=false
    #------------------------------------------------------------------------------
    # This variable includes enabling audit settings, configuring password profiles
    # and revoking some grants to public. These settings are provided by default.
    # These settings may also be disabled.   
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.enableSecuritySettings=true
    ###############################################################################
    #                                                                            #
    # Passwords can be supplied for the following four schemas in the       #
    # starter database:            #
    #  SYS                                                                      #
    #  SYSTEM                                                                    #
    #  SYSMAN (used by Enterprise Manager)                                      #
    #  DBSNMP (used by Enterprise Manager)                                      #
    #                                                                            #
    # Same password can be used for all accounts (not recommended)       #
    # or different passwords for each account can be provided (recommended)      #
    #                                                                            #
    ###############################################################################
    #------------------------------------------------------------------------------
    # This variable holds the password that is to be used for all schemas in the
    # starter database.
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.password.ALL=Oracle#123456
    #-------------------------------------------------------------------------------
    # Specify the SYS password for the starter database.
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.password.SYS=
    #-------------------------------------------------------------------------------
    # Specify the SYSTEM password for the starter database.
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.password.SYSTEM=
    #-------------------------------------------------------------------------------
    # Specify the SYSMAN password for the starter database.
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.password.SYSMAN=
    #-------------------------------------------------------------------------------
    # Specify the DBSNMP password for the starter database.
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.password.DBSNMP=
    #-------------------------------------------------------------------------------
    # Specify the management option to be selected for the starter database.
    # It can be one of the following:
    # 1. GRID_CONTROL
    # 2. DB_CONTROL
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.control=DB_CONTROL
    #-------------------------------------------------------------------------------
    # Specify the Management Service to use if Grid Control is selected to manage
    # the database.     
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
    #-------------------------------------------------------------------------------
    # This variable indicates whether to receive email notification for critical
    # alerts when using DB control. 
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false
    #-------------------------------------------------------------------------------
    # Specify the email address to which the notifications are to be sent.
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.dbcontrol.emailAddress=test@163.com
    #-------------------------------------------------------------------------------
    # Specify the SMTP server used for email notifications.
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.dbcontrol.SMTPServer=
    ###############################################################################
    #                                                                            #
    # SPECIFY BACKUP AND RECOVERY OPTIONS                                      #
    # ------------------------------------                               #
    # Out-of-box backup and recovery options for the database can be mentioned    #
    # using the entries below.       #
    #                                                                            #
    ###############################################################################
    #------------------------------------------------------------------------------
    # This variable is to be set to false if automated backup is not required. Else
    # this can be set to true.
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.automatedBackup.enable=false
    #------------------------------------------------------------------------------
    # Regardless of the type of storage that is chosen for backup and recovery, if
    # automated backups are enabled, a job will be scheduled to run daily at
    # 2:00 AM to backup the database. This job will run as the operating system
    # user that is specified in this variable.
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.automatedBackup.osuid=
    #-------------------------------------------------------------------------------
    # Regardless of the type of storage that is chosen for backup and recovery, if
    # automated backups are enabled, a job will be scheduled to run daily at
    # 2:00 AM to backup the database. This job will run as the operating system user
    # specified by the above entry. The following entry stores the password for the
    # above operating system user.
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.automatedBackup.ospwd=
    #-------------------------------------------------------------------------------
    # Specify the type of storage to use for the database.
    # It can be one of the following:
    # - FILE_SYSTEM_STORAGE
    # - ASM_STORAGE
    #------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
    #-------------------------------------------------------------------------------
    # Specify the database file location which is a directory for datafiles, control
    # files, redo logs.       
    #
    # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/home/oracle/tools/oracle11g/oradata
    #-------------------------------------------------------------------------------
    # Specify the backup and recovery location.
    #
    # Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM
    #-------------------------------------------------------------------------------
    oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=/home/oracle/tools/oracle11g/fast_recovery_area
    #-------------------------------------------------------------------------------
    # Specify the existing ASM disk groups to be used for storage.
    #
    # Applicable only when oracle.install.db.config.starterdb.storage=ASM
    #-------------------------------------------------------------------------------
    oracle.install.db.config.asm.diskGroup=
    #-------------------------------------------------------------------------------
    # Specify the password for ASMSNMP user of the ASM instance.                 
    #
    # Applicable only when oracle.install.db.config.starterdb.storage=ASM_SYSTEM
    #-------------------------------------------------------------------------------
    oracle.install.db.config.asm.ASMSNMPPassword=
    #------------------------------------------------------------------------------
    # Specify the My Oracle Support Account Username.
    #
    #  Example  : MYORACLESUPPORT_USERNAME=metalink
    #------------------------------------------------------------------------------
    MYORACLESUPPORT_USERNAME=
    #------------------------------------------------------------------------------
    # Specify the My Oracle Support Account Username password.
    #
    # Example    : MYORACLESUPPORT_PASSWORD=password
    #------------------------------------------------------------------------------
    MYORACLESUPPORT_PASSWORD=
    #------------------------------------------------------------------------------
    # Specify whether to enable the user to set the password for
    # My Oracle Support credentials. The value can be either true or false.
    # If left blank it will be assumed to be false.
    #
    # Example    : SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
    #------------------------------------------------------------------------------
    SECURITY_UPDATES_VIA_MYORACLESUPPORT=
    #------------------------------------------------------------------------------
    # Specify whether user wants to give any proxy details for connection.
    # The value can be either true or false. If left blank it will be assumed
    # to be false.
    #
    # Example    : DECLINE_SECURITY_UPDATES=false
    #------------------------------------------------------------------------------
    DECLINE_SECURITY_UPDATES=true
    #------------------------------------------------------------------------------
    # Specify the Proxy server name. Length should be greater than zero.
    #
    # Example    : PROXY_HOST=proxy.domain.com
    #------------------------------------------------------------------------------
    PROXY_HOST=
    #------------------------------------------------------------------------------
    # Specify the proxy port number. Should be Numeric and atleast 2 chars.
    #
    # Example    : PROXY_PORT=25
    #------------------------------------------------------------------------------
    PROXY_PORT=
    #------------------------------------------------------------------------------
    # Specify the proxy user name. Leave PROXY_USER and PROXY_PWD
    # blank if your proxy server requires no authentication.
    #
    # Example    : PROXY_USER=username
    #------------------------------------------------------------------------------
    PROXY_USER=
    #------------------------------------------------------------------------------
    # Specify the proxy password. Leave PROXY_USER and PROXY_PWD 
    # blank if your proxy server requires no authentication.
    #
    # Example    : PROXY_PWD=password
    #------------------------------------------------------------------------------
    PROXY_PWD=

其中有一个设置oracle数据库的密码设置为  
![在这里插入图片描述][20181105141459430.png]

也可以再次打开fx，可以事先写好db\_install.rsp，将文件存入oracle用户的oracle目录下

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 7]

之后执行静默安装，oracle 11gr2

![在这里插入图片描述][20181105115446449.png]

./runInstaller -silent -ignoreSysPrereqs -responseFile /home/oracle/db_install.rsp

记得是oracle用户下，使用su oracle 进入oracle 之后，使用 cd ~ 进入 home/oracle/下，在使用cd database进入/home/oracle/database

之后在当前目录下执行，`./runInstaller -silent -ignoreSysPrereqs -responseFile /home/oracle/db_install.rsp`

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 8]

当执行之后，会出现一个日志文件。  
再次打开一个crt，使用su oracle 更改用户，然后使用cd 进入相对应日志文件的目录下，`cd /home/oracle/tools/oraInventory/logs`执行输入tail -1000f 加入日志文件名 `tail -1000f installActions2018-11-05_11-22-43AM.log`

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 9]

之后就可以在另外一个crt看到安装日志文件，会安装比较慢，有耐心的等待，但在旧的crt中看到successful的时候，就代表服务已经成功  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 10]

之后再进行安装oracleclient  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 11]

对于解压安装win64\_11gR2\_client推荐博文[安装oracleclient图文步骤][oracleclient]

解压PLSQL  
![在这里插入图片描述][20181105144448575.png]  
点击plsqldev1204，进行安装

安装完之后进行配置，使用之前安装的plsqldev1204其中有个安装路径带有app的路径，按照我截图的图片找到相对应的文件，（自己选择的目录），每个人目录不一样，只要找到`tnsnames.ora`这个文件就可以了  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 12]

配置文件内容  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 13]

之后进入crt进行配置，如果重启了服务器重启过，环境变量要重新source一下。执行以下命令使其生效：

source /home/oracle/.bash_profile

如果在下次连接时候，进入sqlplus模式的时候，未找到指令，则就要在执行一次source  
然后连接，在Oracle用户下进行操作`su oracle`必须进入oracle用户下进入sqlplus模式，不然会被权限限制  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 14]

进入sqlplus模式

sqlplus  /nolog

使用管理员权限输入

connect /as sysdba

启动服务

startup

启动服务之后，使用quit退出sqlplus模式  
开启监听

lsnrctl

执行之后编辑命令

start

\*\*注意：\*\*也可以在sqlplus模式下使用下面命令关闭服务

Shutdown

开启监听  
退出sqlplus模式  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 15]  
如果在下次需要进行开启的时候，则需要进行配置环境重新`srouce`一下

可以使用`ps -ef | grep oracle`查看oracle进程

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 16]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70]: /images/20220422/a2d3e7c0602e49df8cea0239b2af5a08.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 1]: /images/20220422/199fd9ee7fb046fca0fd21ef8ba44c9c.png
[20181105095046601.png]: /images/20220422/e4401caa66a7408792cde73cc7c7a54b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 2]: /images/20220422/6c0c09a15e4c44c18884b0800751175f.png
[20181105100559341.png]: /images/20220422/403bdb9cbb8247fd8054ccd3c0c39f84.png
[20181105100858250.png]: /images/20220422/c494e0a834394e4fa0598e33ec5c2a28.png
[20181105101303580.png]: /images/20220422/141caaebc9364daabf34ffbcc4b0a078.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 3]: /images/20220422/be57d1d8d7164eb28070af5e10a54df8.png
[20181105101610952.png]: /images/20220422/fce70d5b2d9a4f7e8040ff9a5bfe89cf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 4]: /images/20220422/606d1ed810774f5587afa0121a841191.png
[20181105102119455.png]: /images/20220422/11f104ab58254df98246bf8ac48613a9.png
[20181105105601421.png]: /images/20220422/2c67cd3e539d4362b3265cb818c04b19.png
[20181105105715472.png]: /images/20220422/a3e5db0b7e23411ba38ead77173c0c1d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 5]: /images/20220422/8454010ddacb4f4c8c3090772bab5777.png
[20181105105851859.png]: /images/20220422/1f705a1752df434984120c89bb6d7792.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 6]: /images/20220422/4356543db00f4294b0eaf1ff9f9008aa.png
[20181105141324371.png]: /images/20220422/ea0ca9f8ff514535866a028b311976f1.png
[20181105141459430.png]: /images/20220422/46a488f0680d44c18afd72f08ff0e219.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 7]: /images/20220422/1ac0f663cc4f48b888caac17689233c5.png
[20181105115446449.png]: /images/20220422/a9d64195de714a2c9950b96f05190af3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 8]: /images/20220422/4912ca1f747d40f5be54707a2ba75742.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 9]: /images/20220422/902ee99d5e774d7dbf2b13b0801faf87.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 10]: /images/20220422/39800f3d135f480d8841740d0796a67e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 11]: /images/20220422/363a1458a3684fdea6db821924873a37.png
[oracleclient]: https://blog.csdn.net/lanchengxiaoxiao/article/details/39251947?tdsourcetag=s_pctim_aiomsg
[20181105144448575.png]: /images/20220422/666ad03f9c654ed695806032b5c4ce7f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 12]: /images/20220422/a7db631d6c074b1e9831ee27229e6895.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 13]: /images/20220422/5991e91833e84e16bad0b0d4be2a1403.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 14]: /images/20220422/6dc37332a3a04c6482b55023c235a5af.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 15]: /images/20220422/b5466a75f2e0440aba00cf0e190a09cc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjk3OTg0MA_size_16_color_FFFFFF_t_70 16]: /images/20220422/9fa6a023e67c4a5680c2f833d8ba7956.png