Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Linux non-graphical interface to install Oracle Database     - To install and use Docker under linux (Server)

- Ten linux version of the system (Linux)

- Linux crontab (Linux)

- Linux host dual LAN transceiver package ARP problem (Linux)

- How to merge two pictures in Cacti (Linux)

- How to make a U disk to install Ubuntu (Linux)

- Features and prevention methods elaborate network security grayware (Linux)

- Add local search to your Android app (Programming)

- Merge sort Java implementation (Programming)

- Linux file time Comments ctime mtime atime (Linux)

- Ubuntu install Tonido private cloud services (Server)

- Java and C / C ++ data conversion when network communication (Programming)

- Oracle VirtualBox Problem Solving Case (Linux)

- MongoDB 3.2 to upgrade from 3.0.7 (Database)

- Talking about the implementation and the JVM garbage collection mechanism (Programming)

- Zabbix installation under Linux (Server)

- Use OpenSSL carried BASE64 encoding and decoding (Linux)

- Struts2 interceptor simulation (Programming)

- Ubuntu 15.04 / CentOS 7.0 to set custom boot (Linux)

- FFmpeg compiled with only H264 decoding library (Programming)

 
         
  Linux non-graphical interface to install Oracle Database
     
  Add Date : 2018-11-21      
         
         
         
  Comment:

A graphical interface is not open Linux OS, how to install Oracle software and databases, as is a large step 2

Cloning software
Building a database manually
First, cloning software

1, the basic configuration

1.1) system package installation

yum -y install binutils compat-libstdc ++ - 33 compat-libstdc ++ - 33.i686 elfutils-libelf elfutils-libelf-devel gcc gcc-c ++ glibc glibc.i686 glibc-common glibc-devel glibc-devel.i686 glibc-headers ksh libaio libaio .i686 libaio-devel libaio-devel.i686 libgcc libgcc.i686 libstdc ++ libstdc ++ i686 libstdc ++ -. devel make sysstat unixODBC unixODBC-devel

1.2) user-created

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
1.3) configuration file

    1.3.1) environment variables

              vi ~ oracle / .bash_profile

              export ORACLE_BASE = / data / app / oracle

              export ORACLE_HOME = $ ORACLE_BASE / product / 11.2.0.4 / db_1

              export ORACLE_SID = test # up to 8 characters; link oracle operating system and the associated instance; ORACLE_HOME + ORACLE_SID ==> hash ==> shared memory segment

              export PATH = $ PATH: $ HOME / bin: $ ORACLE_HOME / bin # the command after the installation of oracle appended to the execution search path

              export LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / lib: / usr / lib # dynamic library location

      export nls_lang = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" # client character set

              # Load a configuration: oracle user logs off or log back on source .bash_profile

    1.3.2) Host

          echo "10.240.1.7 Database-backup" >> / etc / hosts # error ORA-00000 while avoiding being given startup noumount: normal, successful completion

    1.3.3) software directory

          mkdir -p /data/app/oracle/product/11.2.0.4/db_1

            chown -R oracle: oinstall / data / app

      1.3.4) resource constraints

            1.3.4,1) vim /etc/sysctl.conf added to the file at the bottom of

                    kernel.shmall = 2097152

                    #Total Amount of shared memory available (bytes or pages); number of pages; 2097152 * 4096/1024/1024/1024 = 8G; if memory than 8G, this parameter must be modified

                    kernel.shmmax = 2147483648

                    # To> = half Maximum size of physical memory of shared memory segment (bytes); recommendations> = sga_max_size (oracle application memory size);

                    # Single program memory segment maximum number; 4G, then divided into two mem_seg1 mem_seg2, affecting the efficiency;

                    kernel.shmmni = 4096

                    # Maximum number of shared memory segments system-wide; page size;

                  kernel.sem = SEMMSL SEMMNS SEMOPM SEMMNI

                                          The maximum signal of the target object sets each signal number; SEMMSL Maximum number of semaphores per set

                                          SEMMNS Maximum number of semaphores system-wide; the maximum number of objects in the system-wide signal; SEMMNS = SEMMSL * SEMMNI

                                          The maximum number of operations of each signal object supports SEMOPM

                                          SEMMNI Maximum number of semaphore identifiers; set system-wide maximum number of semaphore object

                  fs.file-max # system allowed the maximum number of file handles

                  IPv4 port range net.ipv4.ip_local_port_range # application that can be used

                  net.core.rmem_default # socket receive buffer size defaults

                  net.core.rmem_max # maximum socket receive buffer size

                  net.core.wmem_default # socket send buffer size defaults

                  Net.core.wmem_max # maximum socket send buffer size

                  # Note: OS32bit, oracle application up to 1.7G; should be installed 64bitOS

                  # Sysctl -p parameter to load

1.3.4, 2) /etc/security/limits.conf oracle on linux operating limit

                        [Root @ dba ~] # grep -v '^ #' /etc/security/limits.conf

                      oracle soft nproc 2047 #oracle open proc amount on linux

                      oracle hard nproc 16384

                      oracle soft nofile 1024 #oracle number of open file on linux

                      oracle hard nofile 65536

                      [Root @ dba ~] # grep 'limit' /etc/pam.d/system-auth

                      session required pam_limits.so

            1.3.4,3) turn off the firewall, SELINUX

                        iptables -F

                        Change / etc / selinux / config file -> SELINUX = disabled

2 cloned ORACLE_HOME

        2.1) Copy

        scp db_1 oracle@10.240.1.7: /data/app/oracle/product/11.2.0.4/db_1/

      2.2) Executive clone.pl clone script to change the configuration parameters (ORACLE_SID, ORACLE_HOME)

      $ Cd /data/app/oracle/product/11.2.0.4/db_1/clone/bin

              $ Ls
                  clone.pl prepare_clone.pl
              $ Perl clone.pl ORACLE_SID = test ORACLE_BASE = / data / app / oracle ORACLE_HOME = / data / app / oracle / product / 11.2.0.4 / db_1 / ORACLE_HOME_NAME = OraDb11g_home1

                    ....... Finally following message said cloning success ...


                    The following configuration scripts need to be executed as the "root" user.

                    /data/app/oracle/product/11.2.0.4/db_1/root.sh

                    To execute the configuration scripts:

                    1. Open a terminal window

                    2. Log in as "root"

                    3. Run the scripts

                              The cloning of OraDb11g_home1 was successful.
                              ...................

 Second, building a database manually

1, the configuration parameter file (a simple test environment parameters, if demand can be added)

        [Oracle @ Database-backup dbs] $ cat inittest.ora
        db_name = test
        db_files = 80
        db_file_multiblock_read_count = 8
        log_checkpoint_interval = 10000
        processes = 50
        parallel_max_servers = 5
        log_buffer = 32768
        max_dump_file_size = 10240 # limit trace file size to 5 Meg each
        global_names = TRUE
        #control_files = (ora_control1, ora_control2)
        sga_max_size = 300M
        sga_target = 300M
        * .local_listener = '(ADDRESS_LIST = (Address = (Protocol = tcp) (Host = 10.240.1.7) (Port = 1521)))' # avoid starting a database error (ORA-00119ORA-00130 local_listener configuration is invalid)
        [Oracle @ Database-backup dbs] $

2, start the database to nomount

        SQL> startup nomount
          ORACLE instance started.

          Total System Global Area 313159680 bytes
          Fixed Size 2252824 bytes
          Variable Size 104861672 bytes
          Database Buffers 201326592 bytes
          Redo Buffers 4718592 bytes
        SQL>

3, create a database, to the open state
SQL> CREATE DATABASE test
      USER SYS IDENTIFIED BY change_on_install

      USER SYSTEM IDENTIFIED BY manager

      LOGFILE GROUP 1 ( '/data/app/dbf/redo01.log') SIZE 100M,

              GROUP 2 ( '/data/app/dbf/redo02.log') SIZE 100 M,

              GROUP 3 ( '/data/app/dbf/redo03.log') SIZE 100 M

      MAXLOGFILES 5

      MAXLOGMEMBERS 5

      MAXLOGHISTORY 1

      MAXDATAFILES 100

      MAXINSTANCES 1

      CHARACTER SET GBK

      NATIONAL CHARACTER SET AL16UTF16

      DATAFILE '/data/app/dbf/system01.dbf' SIZE 325M REUSE

      EXTENT MANAGEMENT LOCAL

      SYSAUX DATAFILE '/data/app/dbf/sysaux01.dbf' SIZE 325 M REUSE

      DEFAULT TABLESPACE users datafile '/data/app/dbf/users.dbf' size 50m

      DEFAULT TEMPORARY TABLESPACE tempts1

          TEMPFILE '/data/app/dbf/temp01.dbf'

          SIZE 20 M REUSE

      UNDO TABLESPACE undotbs

          DATAFILE '/data/app/dbf/undotbs01.dbf'

          SIZE 200 M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

        Database created.

              SQL>

4. Verify that the database state

        SQL> select status from v $ instance;

        STATUS
        ------------
        OPEN

        SQL>

5, the DBF settings automatically extended later to avoid the execution of the script to load the data dictionary table / pack / user space shortage when scott

          alter database datafile 1 autoextend on;
          alter database datafile 2 autoextend on;
          alter database datafile 3 autoextend on;
          alter database datafile 4 autoextend on;

6. Create a data dictionary / pack / scott user

          Data dictionary views: @ / rdbms / admin / catalog.sql?

          System package / stored procedure:? @ / Rdbms / admin / catproc.sql

          Users PROFILE table:? @ / Rdbms / admin / pupbld.sql

          Test user scott: @ / rdbms / admin / scott.sql?

Above has been completed and the software installed oracle database.

Organize and improve the problem

1, ***** sqlplus / as sysdba prompted not libclntsh.so.11.1 files found

          [Oracle @ Database-backup ~] $ sqlplus / as sysdba
          sqlplus: error while loading shared libraries: libclntsh.so.11.1: can not open shared object file: No such file or directory

          [Oracle @ Database-backup lib] $ ls libclntsh.so *
          libclntsh.so libclntsh.so.10.1 -> Only 10.1 cp -rp complete copy of the joint property, may be normal if libclntsh.so.11.1 file permissions problem.
          [Oracle @ Database-backup lib] $ cp -rp libclntsh.so.10.1 libclntsh.so.11.1
          [Oracle @ Database-backup lib] $ sqlplus / as sysdba

          ... Normal.

2, for the sys password

          orapwd file = orapwtest password = test

 3, ORA-00904: "wm_concat": invalid identifier
        Create a user script execution WMSYS
        SQL> @? / Rdbms / admin / owmctab.plb
        SQL> @? / Rdbms / admin / owmaggrs.plb
        SQL> @? / Rdbms / admin / owmaggrb.plb
     
         
         
         
  More:      
 
- MongoDB Study Notes (1) - Install MongoDB on Windows systems (Database)
- To install PostgreSQL 9.4 (Database)
- a virtual machine created migrated to host RHEL6.4 on Ubuntu 14.04 (Linux)
- Linux install Samba file sharing server (Server)
- Oracle set the timer task JOB scheduler to execute stored procedures or PL / SQL code block (Database)
- shell script: a key to install LAMP, LNMP script (Server)
- Source encountered problems and solutions when installing SaltStack (Server)
- Vi (Vim) keyboard map and its basic commands (Linux)
- MongoDB3.0.6 wiredtiger MMAPv1 (Database)
- The best tools and techniques to find data on a Unix system (Linux)
- The most commonly used Linux commands (Linux)
- Linux Network Programming - raw socket programming (Programming)
- Ubuntu install video playback software SMPlayer 14.9.0.7042 (Linux)
- How to manage and use Logical Volume Management LVM in Ubuntu (Linux)
- Ubuntu terminal command - see the port occupied and off (Linux)
- Linux, modify / etc / profile file (Linux)
- Qt for file splitting and fusion gadgets (Programming)
- Linux environment variable configuration and save places (Linux)
- Quota for Vsftpd do use disk quotas (Server)
- Various sorting algorithms implemented in Python (Programming)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.