Weitere Installationen

#Ins Stammverzeichnis navigieren
cd /tools/oracle

#Falls die Datei .profile fählt, sie erstellen
#und mit dem untenstehenden Skript (setzt Variablen für das Environnement / Startbildschirm) füllen
touch .profile
nano .profile

##############################################################################
#
#
# FILE:    .profile for oracle user on server machines
#
# AUTHOR:  TRIVADIS AG, M. Wunderli, D. Wapenaar, 28-May-1999
#
# CHANGES: 2004-07-22 / p6230 / CSS adaption

umask 022

typeset BE_OH
BE_OH=~oracle  # [ -f ~oracle/...] will not work
if [ "$BE_HOME" = "" ]; then
  if [ -f "$HOME/.BE_HOME" ]; then
  . "$HOME/.BE_HOME"
  elif [ -f "${BE_OH}/.BE_HOME" ]; then
  . "${BE_OH}/.BE_HOME"
  fi
fi

tty >/dev/null 2>&1
pTty=$?

xtitle () {
    if [ "$TERM" = "xterm" -o "$TERM" = "xterm-color" ]; then
        $BE_ECHO "\033]0;$*\007\c"
    fi
}

unalias go >/dev/null 2>&1
# if you define "go" as a function, uncomment the "go" alias in basenv.conf!!!

go () {
       ssh -X -A -l oracle $*
       xtitle "`hostname`:$LOGNAME"
}

godb () {
       DBHOST=`${CUSTOM_BASE}/bin/get_db_srv.ksh -d $*`
       if [ "${DBHOST}" != "" ]; then
          ssh -X -A -l oracle ${DBHOST}
          xtitle "`hostname`:$LOGNAME"
       else
          echo "Could not find host for database ... \n"
       fi
}


#=================================================================

echo " "
echo "     #####     #####     #####"
echo "   ###   ##  ###   ##  ###   ##"
echo "  ###        ##        ##"
echo "  ###         #####     #####"
echo "  ###           ####      ####"
echo "  ###              ##        ##"
echo "   ###   ##  ##   ###  ##   ###"
echo "     #####    #####     #####"
echo " "
echo " >>> WELCOME TO ORACLE ACCOUNT"
echo " "

set -A SavedArg -- $* 2>/dev/null #ksh?
if [ $? -eq 0 ] ; then
  . ${BE_HOME}/bin/basenv.ksh
else  #bash
  . ${BE_HOME}/bin/basenv.bash
fi

# if [ ${pTty} -eq 0 ]; then
#
#     xtitle `hostname`:$LOGNAME
#     stty erase ^h
#     ${BE_HOME}/bin/oraup.ksh
#
# fi


if [ ${pTty} -eq 0 ]; then

    xtitle `hostname`:$LOGNAME
    stty erase ^?
    stty erase
    if [ ! -z ${BE_MYSQL} ]; then
       ${BE_HOME}/bin/mysqlup.ksh
    else
       ${BE_HOME}/bin/oraup.ksh
    fi
fi


#================================================================= EOF
export VISUAL=vi
set -o vi
# this alias connects to system with password for using db links
alias st="sq @st"
# this sets the history file to "history_{computer_you_logged_in_from}
if [ ${SUDO_USER} ]
then
  export HISTFILE=~/.histdir/history_${SUDO_USER}
else
  export HISTFILE=~/.histdir/history_$(who am i | sed -e 's/^.*(//' | sed 's/\.css.*$//')
fi
# remove escaping of $ in tab completion
#shopt -s direxpand 

vio
rdbms1970grid:/tools/oracle/product/19.7.0_grid:D
rdbms1970:/tools/oracle/product/19.7.0:D

mkdir /tools/oracle/product/19.7.0_grid
cd /tools/oracle/product/19.7.0_grid
unzip /tools/oracle/mnt/Unbreakable_Oracle_Linux/oracle/orasrc/db1930_linux_x86_64/LINUX.X64_193000_grid_home.zip

#Environnement auf OEL7.8 setzen
export CV_ASSUME_DISTID=OEL7.8

Gewünschte Session anwählen

X11-Forwarding aktivieren

#Xming starten (auf dem PC)
Start Xming

#Überprüfen, ob eine Display-Variable gesetzt wurde
echo $DISPLAY

/tools/oracle/product/19.7.0_grid/gridSetup.sh -skipPrereqs

root@lnx55111
/tools/oracle/oraInventory/orainstRoot.sh

oracle@lnx55111
cd /tools/oracle/local/dba/lib
cp -Rp 1210_tvdperl-Linux-x86-64-02.12.00-05.30.02 1900_tvdperl-Linux-x86-64-02.12.00-05.30.02

. basenv.ksh
rdbms1970grid

$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tools/oracle/mnt/Unbreakable_Oracle_Linux/oracle/patches/p30899722_linux64/30899722_1970_x8664/30899722/30869156
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tools/oracle/mnt/Unbreakable_Oracle_Linux/oracle/patches/p30899722_linux64/30899722_1970_x8664/30899722/30894985
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tools/oracle/mnt/Unbreakable_Oracle_Linux/oracle/patches/p30899722_linux64/30899722_1970_x8664/30899722/30869304
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tools/oracle/mnt/Unbreakable_Oracle_Linux/oracle/patches/p30899722_linux64/30899722_1970_x8664/30899722/30898856

root@lnx55111
/tools/oracle/product/19.7.0_grid/root.sh

lsblk

cd /usr/lib/udev/rules.d

vi 98-oracleasm.rules
# cat 98-oracleasm.rules
# 2012.02.06 Persistent SYMLINK as of DM Name!!!
# see also: udevadm info --query=all --name=/dev/dm-XXX
# Temporary Rule, because TMS with FW 5.4.1 shows 4k physical_block_size, that it doesn't work with asmlib...
# ByPass them with asm_diskstring=...
#

# KERNEL!="sdb*", GOTO="asm_end"
ACTION=="remove", GOTO="asm_end"
# ENV{DM_TABLE_STATE}!="LIVE", GOTO="asm_end"

ENV{DEVNAME}=="/dev/sdb2", ENV{PARTN}=="2", OWNER="oracle", GROUP="dba", MODE="640", SYMLINK+="oraclenolib/LDRM01_LUN001"
ENV{DEVNAME}=="/dev/sdb3", ENV{PARTN}=="3", OWNER="oracle", GROUP="dba", MODE="640", SYMLINK+="oraclenolib/LDRM01_LUN002"
ENV{DEVNAME}=="/dev/sdb4", ENV{PARTN}=="4", OWNER="oracle", GROUP="dba", MODE="640", SYMLINK+="oraclenolib/LDRM01_LUN003"
ENV{DEVNAME}=="/dev/sdb5", ENV{PARTN}=="5", OWNER="oracle", GROUP="dba", MODE="640", SYMLINK+="oraclenolib/LDRM01_LUN004"

LABEL="asm_end"
EOF

udevadm control --reload-rules
udevadm trigger

/tools/oracle/product/19.7.0_grid/perl/bin/perl -I/tools/oracle/product/19.7.0_grid/perl/lib -I/tools/oracle/product/19.7.0_grid/crs/install /tools/oracle/product/19.7.0_grid/crs/install/roothas.pl

#Oracle asmca starten, um die einzelnen Disk Groups zu konfigurieren
oracle@lnx55111
asmca

#Dieser Pfad zeigt auf die korrekten installierten Disken
path to: /dev/oraclenolib

#Wichtig ist, dass die Redundancy auf "external" gestellt wird
#Zudem sollte "Quorum" nicht angehackt werden
redundancy external

#Die beiden Disk Groups sollten wie folgt erstellt werden: 
DISK_GROUPS = LGRM_DAT2 zwei Disks
DISK_GROUPS = LGRM_FRA1 zwei Disks

crsstat

#Listener hinzufügen und starten
srvctl add Listener
srvctl start listener

u
. basenv.ksh