Installation of oracle 11g under Debian 8

Keywords: Oracle SQL Database sqlplus

oracle has never supported Debian systems. How did the leader have to put it on debian, so he started.

1. Create directories and users:

/usr/sbin/groupadd -g 501 oinstall && /usr/sbin/groupadd -g 502 dba && /usr/sbin/groupadd -g  503 oper && /usr/sbin/useradd -g oinstall -G dba,oper -d /home/oracle/ -s /bin/bash oracle

mkdir -p /data/ora11g/product/11.2.0.4/db_1 && mkdir -p /home/oracle && chown -R oracle:oinstall /data/ora11g && chmod -R 775 /data/ora11g && chown -R oracle:oinstall /home/oracle

2. Installing dependency packages

Here we need to configure the source vi/etc/apt/sources.list.
Common commands:

apt-cache pkgnames | grep  libXp | more
apt-cache searche xxxx

Install dependency packages: (try to check all, and then don't know what strange errors will be reported)

apt-get install gcc g++ glibc-* libaio*  libstdc++6 libstdc++-4.9-dev make binutils openjdk-7-jdk libc6 libc6-dev libstdc++6 libstdc++5 rpm gawk alien ksh  lesstif2 libmotif3 libaio1 linux-headers-*common elfutils libaio-dev sysstat unixodbc-bin unixodbc-dev pdksh

3. Modify configuration files
The machine configuration here is 48 cores and 120G memory, so some parameters should not be copied.

vi /etc/sysctl.conf
As for how to change the parameters here, you can refer to my other articles.
http://blog.csdn.net/hkyw000/article/details/53486940)

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 16515072
kernel.shmmax = 67645734912
kernel.shmmni = 4096
kernel.sem = 5010 641280 5010 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586

Systcl-p to make it effective

vi /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Vi/etc/pam.d/login Finally add:

session required pam_limits.so

Finally, check the firewall iptables-F to clear all rules.

4. Unzip files

unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip
unzip p13390677_112040_Linux-x86-64_3of7.zip

5. Start silent installation
The parameters of these rsp template files can be changed by yourself, not to mention much.

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

6. When the dbca library is built after completion, the error is reported and two library files are missing
njni11,libclntsh.so.11.1

UnsatisfiedLinkError exception loading native library: njni11 
Java.lang.UnsatisfiedLinkError: /data/ora11g/product/11.2.0/dbhome_1/lib/libnjni11.so: /data/ora11g/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: undefined symbol: nnfyboot

The modification is to copy the inventory/Scripts/ext/lib/libclntsh.so.11.1 in the home directory to the $ORACLE_HOME/lib folder.

7. After that, dbca ran normally but started to report that TNS was disconnected. After subsequent installation monitoring, sqlplus / as SYSDBA
Login is not good either. The lsnrctl command does not respond. I've taken an extreme approach here by putting rsync on the debian machine for all the files on the $ORACLE_HOME/bin database machine running normally on the linux system of other machines. Then there's a reaction... In fact, many strange and weird places can not be solved according to the normal way of thinking.

8. Two standard listener.ora and tnsnames.ora files are pasted here.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.19)(PORT = 1521))
    )
  )
ADR_BASE_LISTENER = /data/ora11g
DIAG_ADR_ENABLED_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = test)
      (ORACLE_HOME = /data/ora11g/product/11.2.0.4/db_1)
      (SID_NAME = test)
    )
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /data/ora11g/product/11.2.0.4/db_1)
     (PROGRAM = extproc)
    )
  )
TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.19)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
)

9. Afterwards, in view of other errors, we decided to build the database manually.
There is no need to mend the catalogue, because it was almost built in the beginning.
First create the password file

orapwd file=orapwSID password=oracle entries=5

Then copy an initXXX.ora file from a good machine and start the database in pfile to nomount state.

Library building script:

create database test CONTROLFILE REUSE 
   MAXINSTANCES 8 
   MAXDATAFILES 3000
   MAXLOGHISTORY 1024
   MAXLOGFILES 64
   MAXLOGMEMBERS 4
   character set AL32UTF8 national character set AL16UTF16
   logfile 
   group 1 ('/data/ora11g/oradata/test/redo01.log') size 1g reuse,
   group 2 ('/data/ora11g/oradata/test/redo02.log') size 1g reuse,
   group 3 ('/data/ora11g/oradata/test/redo03.log') size 1g reuse,
   group 4 ('/data/ora11g/oradata/test/redo04.log') size 1g reuse,
   group 5 ('/data/ora11g/oradata/test/redo05.log') size 1g reuse,
   group 6 ('/data/ora11g/oradata/test/redo06.log') size 1g reuse,
   group 7 ('/data/ora11g/oradata/test/redo07.log') size 1g reuse,
   group 8 ('/data/ora11g/oradata/test/redo08.log') size 1g reuse,
   group 9 ('/data/ora11g/oradata/test/redo09.log') size 1g reuse
datafile '/data/ora11g/oradata/test/system01.dbf' size 1g reuse extent management local
sysaux datafile '/data/ora11g/oradata/test/sysaux01.dbf' size 20g
default temporary tablespace temp tempfile '/data/ora11g/oradata/test/temp01.dbf' size 5g reuse
undo tablespace undotbs1 datafile '/data/ora11g/oradata/test/undotbs01.dbf' size 30g reuse
USER SYS IDENTIFIED BY "ora11g" USER SYSTEM IDENTIFIED BY "ora11g";

After the completion of the library, a script should be run. What users are the main users to run it?

spool /home/oracle/record.log
@?/rdbms/admin/catalog.sql ;      (Must run, build data dictionary view)
@?/rdbms/admin/catproc.sql ;      (Build Stored Procedure Package
@?/rdbms/admin/catblock.sql ;     (Several Views Related to Lock Building)
@?/rdbms/admin/catoctk.sql ;      (Building Password Toolkit dbms_crypto_toolkit)
@?/rdbms/admin/owminst.plb ;      (Build workspace management related objects, such as dmbs_wm)
spool off

You can then check the log to see if there are unacceptable errors.

connect system/oracle
@?/sqlplus/admin/pupbld.sql
@?/sqlplus/admin/help/hlpbld.sql helpus.sql
connect /as sysdba
CREATE TABLESPACE USERS LOGGING DATAFILE '/data/ora11g/oradata/test/user01.dbf' SIZE 30g EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER DATABASE DEFAULT TABLESPACE USERS;

Finally, restart the database, open the archive in mount mode, and end.

Posted by Typer999 on Tue, 09 Jul 2019 16:14:56 -0700