-- 103.63.109.
220
How To Fix “Could not retrieve mirrorlist” Error in CentOS 7
The problem occurs due to the repository URLs found in /etc/yum.repos.d/ folder.
The repositories are automatically configured to lookup on mirror.centos.org and
since CentOS 7 has gone EOL, mirrors are also gone.
The fix is to replace the mirror.centos.org baseurl with vault.centos.org. You can
do this by executing the following commands as root:
root@localhost:~$ sed -i 's/mirrorlist/#mirrorlist/g' /etc/yum.repos.d/CentOS-*
root@localhost:~$ sed -i
's|#baseurl=http://mirror.centos.org|baseurl=http://vault.centos.org|g'
/etc/yum.repos.d/CentOS-*
Upon successful execution of the above replace (sed) commands, you should be able
to install any software package using yum or even update your CentOS 7 server (yum
update).
install req
yum -y install binutils compat-libcap1 gcc gcc-c++ glibc glibc.i686 glibc-devel
glibc.i686 ksh libaio libaio.i686 libaio-devel libaio-devel.i686 libgcc libgcc.i686
libstdc++ libstdc++l7.i686 libstdc++-devel libstdc++-devel.i686 compat-libstdc++-33
compat-libstdc++-33.i686 libXi libXi.i686 libXtst libXtst.i686 make sysstat
yum -y install xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-apps
yum install xorg-x11-utils*
[root@fasttrackdb ~]# cat /etc/ssh/sshd_config | grep -i X11
X11Forwarding yes
X11DisplayOffset 10
X11UseLocalhost no
systemctl restart sshd
yum install -y oracle-database-preinstall-19c
hostnamectl set-hostname fasttrackdb.vinatti.vn --static
hostnamectl --transient set-hostname fasttrackdb.vinatti.vn
Add the following lines to the "/etc/sysctl.conf" file, or in a file called
"/etc/sysctl.d/98-oracle.conf".
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
Add the following lines to a file called "/etc/security/limits.d/oracle-database-
preinstall-19c.conf" file.
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
i=54321; for group in oinstall dba oper backupdba dgdba kmdba asmdba asmoper
asmadmin racdba; do
groupadd -g $i $group; i=$(expr $i + 1)
done
[root@dlp ~]# i=54321; for group in oinstall dba oper backupdba dgdba kmdba asmdba
asmoper asmadmin racdba; do
groupadd -g $i $group; i=$(expr $i + 1)
done
[root@dlp ~]# useradd -u 54321 -g oinstall -G
dba,oper,backupdba,dgdba,kmdba,asmdba,racdba -d /usr/oracle oracle
[root@dlp ~]# passwd oracle
Changing password for user oracle.
New password:
Retype new password: Vin@tti2024#@!
passwd: all authentication tokens updated successfully.
mkdir -p /u01/app/oracle
mkdir -p /u02/oradata
chown -R oracle:oinstall /u01 /u02
chmod -R 775 /u01 /u02
vim /etc/pam.d/login
# line 15: add
session required pam_selinux.so open
session required pam_namespace.so
session required pam_limits.so --> add
session optional pam_keyinit.so force revoke
session include system-auth
-session optional pam_ck_connector.so
cat > /usr/oracle/bin/setEnv.sh <<EOF
# Oracle Settings
export TMP=/tmp
export TMPDIR=\$TMP
export ORACLE_HOSTNAME=fasttrackdb.vinatti.vn
export ORACLE_UNQNAME=fasttrackdb
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/19.0.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=fasttrackdb
#export PDB_NAME=pdb1
export DATA_DIR=/u02/oradata
export PATH=/usr/sbin:/usr/local/bin:\$PATH
export PATH=\$ORACLE_HOME/bin:\$PATH
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
EOF
vim ~/.bash_profile
[oracle@dlp ~]$ vi ~/.bash_profile
# add to the end
umask 022
export ORACLE_BASE=/u01/app/oracle
Add a reference to the "setEnv.sh" file at the end of the
"/home/oracle/.bash_profile" file.
echo ". /usr/oracle/bin/setEnv.sh" >> /usr/oracle/.bash_profile
chown -R oracle:oinstall /usr/oracle/bin
chmod u+x /usr/oracle/bin/*.sh
sys / FastTrackDb321
https://fasttrackdb.vinatti.vn:5500/em
alter system set log_archive_dest_1='location=/u02/archive';
alter system set log_archive_dest_state_1=enable;
shutdown immediate
startup mount
alter database archivelog;
alter database open;
CREATE TABLESPACE fasttrack_i DATAFILE
SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
CREATE USER fasttrack IDENTIFIED BY Vnt8Fast321 DEFAULT TABLESPACE fasttrack_d
TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT,RESOURCE TO fasttrack;
GRANT DBA to fasttrack;
grant DEBUG CONNECT SESSION to fasttrack;
QuikMobility
AdminQM / Vin@tti2024!@#
firewall-cmd --permanent --new-zone=oracledb
firewall-cmd --zone=oracledb --add-interface=eth2 --permanent
firewall-cmd --zone=oracledb --add-port=1521/tcp --permanent
firewall-cmd --zone=oracledb --add-source=192.168.168.1/24 --permanent
firewall-cmd --reload
CREATE TABLESPACE quiktt_d DATAFILE
'/home/oracle/u01/app/oracle/oradata/DEVBTXHDB/QuikMobility/quiktt_d.dbf'
SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
CREATE TABLESPACE quiktt_i DATAFILE
'/home/oracle/u01/app/oracle/oradata/DEVBTXHDB/QuikMobility/quiktt_i.dbf'
SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
CREATE USER quiktt IDENTIFIED BY Vinatti321 DEFAULT TABLESPACE quiktt_d TEMPORARY
TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT,RESOURCE TO quiktt;
GRANT DBA to quiktt;
grant DEBUG CONNECT SESSION to quiktt;
