Linux安装oracle

Dear 丶 2022-07-24 06:10 137阅读 0赞

--root执行
    groupadd -g 1010 oinstall
    groupadd -g 1020 dba
    useradd -g oinstall -g dba  -m oracle
    passwd oracle
    
    --root执行----
    修改database的所有者 
    找到oracle11g的解压目录执行
     chown -R oracle:dba database
    
    --root执行
    mkdir  -p /home/oracle/app
    mkdir  -p /home/oracle/app/oracle
    mkdir  -p /home/oracle/app/oradata
    mkdir  -p /home/oracle/app/oracle/product
    
    --root执行
    vi /etc/security/limits.conf
    oracle soft nproc 2047
    oracle hard nproc 16384
    oracle soft nofile 1024
    oracle hard nofile 65536
    
    --root执行
    vi /etc/pam.d/login
    #session required /lib/security/pam_limits.so
    session required pam_limits.so
    
    --root执行
    vi /etc/sysctl.conf
    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
    
    --root执行
    sysctl -p
    
    --root执行 可以不执行
     vi .bash_profile
    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
    
    --oracle执行  进入到/home/oracle目录下面执行
     vi .bash_profile
    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
    
    
    --root执行
    vi /etc/profile
    if [ $USER = "oracle" ]; then
    	if [ $SHELL = "/bin/ksh" ]; then
    		ulimit -p 16384
    		ulimit -n 65536
    	else
    		ulimit -u 16384 -n 65536
    	fi
    fi
    
    reboot 系统 
    重启后以oracle登录
    执行安装，输入命令：./runInstaller
    
    global database name orcl 
    username：sys/system/scott
    password ctllin
    
    Enterprise Manager Database Control URL - (orcl) :
    https://localhost:1158/em
    
    /home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh
     执行root.sh输入 /home/oracle/app/oracle/product/11.2.0/dbhome_1
    /home/oracle/oraInventory/orainstRoot.sh
    RedHat 开放防火墙端口
    1. cd到/sbin目录，执行命令:
    iptables -I INPUT -p tcp --dport 1158 -j ACCEPT
    iptables -I INPUT -p tcp --dport 1521 -j ACCEPT
    2.service iptables save
    3.service iptables restart
    
    
    在oracle用户的图形界面oracle用户中，新开启一个终端，直接输入命令dbca会进入数据库图形界面
    在oracle用户的图形界面oracle用户中，新开启一个终端，直接输入命令netmgr会进入监听配置图形界面
    local->Service Nameing->(for exapmle orcl)orcl  Connetction Type:Dedicated Server
    
    
    lsnrctl start 
    sqlplus /nolog
    startup     #shutdown immediate
    conn as sysdba;
    Enter user-name: system
    Enter password:ctllin
    alter user scott account unlock;
    alter system register;
    alter user scott identified by ctllin;
    
    listener.ora 增加上
    SID_LIST_LISTENER=
      (SID_LIST=
          (SID_DESC=
                          #BEQUEATH CONFIG
             (GLOBAL_DBNAME=orcl)
             (SID_NAME=orcl)
             (ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)
                          #PRESPAWN CONFIG
            (PRESPAWN_MAX=20)
            (PRESPAWN_LIST=
              (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
            )
           )
          )	
    tnsnames.ora增加上 可以不配置
    LISTENER_ORCL =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.42.19)(PORT = 1521))
    
    
    scott/ctllin@192.168.42.19/orcl
    scott/ctllin@192.168.42.19:orcl
    scott/ctllin@127.0.0.1:orcl
    scott/ctllin@127.0.0.1/ORCL
    
    ORA-00845: MEMORY_TARGET not supported on this system
    虚拟机装好后调小了内存，如果报此错误可以恢复内存大小
    
    listener.ora
    # listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.42.19)(PORT = 1521))
        )
      )
    
    ADR_BASE_LISTENER = /home/oracle/app
    
    SID_LIST_LISTENER=
      (SID_LIST=
          (SID_DESC=
                          #BEQUEATH CONFIG
             (GLOBAL_DBNAME=orcl)
             (SID_NAME=orcl)
             (ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)
                          #PRESPAWN CONFIG
            (PRESPAWN_MAX=20)
            (PRESPAWN_LIST=
              (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
            )
           )
          )	
    
    tnsnames.ora
    # listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.42.19)(PORT = 1521))
        )
      )
    
    ADR_BASE_LISTENER = /home/oracle/app
    
    SID_LIST_LISTENER=
      (SID_LIST=
          (SID_DESC=
                          #BEQUEATH CONFIG
             (GLOBAL_DBNAME=orcl)
             (SID_NAME=orcl)
             (ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)
                          #PRESPAWN CONFIG
            (PRESPAWN_MAX=20)
            (PRESPAWN_LIST=
              (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
            )
           )
          )	
    
    
    create public database link orcldblink connect to scott IDENTIFIED BY ctllin
    using '(DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.42.19)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = orcl)
    )
    )';
    
    drop public database link orcldblink;
    
    select * from tablename@dblinkname