Bug 5324 - [DBT-05509] Failed to connect to the specified database
Summary: [DBT-05509] Failed to connect to the specified database
Status: NEW
Alias: None
Product: Anolis OS 7
Classification: Anolis OS
Component: Desktop (show other bugs) Desktop
Version: 7.9
Hardware: All Linux
: P3-Medium S3-normal
Target Milestone: ---
Deadline: 2023-06-20
Assignee: yunqi-zwt
QA Contact: shuming
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-05-26 18:04 UTC by anolis_al
Modified: 2023-11-23 13:51 UTC (History)
2 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description anolis_al 2023-05-26 18:04:53 UTC
Description of problem:
虚拟机vmware16搭建anolis 7.9 安装oracle19c,进行到dbca 步骤时报错,提示如下:
[DBT-05509] Failed to connect to the specified database (webdb).
Cause - OS Authentication might be disabled for this database (webdb).  
Action - Specify a valid sysdba user name and password to connect to the database.

Version-Release number of selected component (if applicable):
anolis 7.9

How reproducible:
多次进行重新安装操作系统,dbca 步骤时报同样错误

Steps to Reproduce:
/usr/sbin/groupadd -g 60001 oinstall
/usr/sbin/groupadd -g 60002 dba
/usr/sbin/groupadd -g 60003 oper

useradd -u 61001 -g oinstall -G dba,oper oracle

echo "oracle" | passwd --stdin oracle



mkdir -p /oracle/app/oracle
chown -R oracle:oinstall /oracle/app/oracle

mkdir -p /oracle/app/oraInventory
chown -R oracle:oinstall /oracle/app/oraInventory

mkdir -p /oracle/app/oracle/product/19.3.0/dbhome_1

chown -R oracle:oinstall /oracle
chmod -R 775 /oracle

###虚拟机方式
mkdir -p /mnt/cdrom
mount /dev/sr0 /mnt/cdrom

cd /etc/yum.repos.d
mkdir bk
mv *.repo bk/

echo "[EL]" >> /etc/yum.repos.d/AnolisOS-os.repo
echo "name =Linux 7.x DVD" >> /etc/yum.repos.d/AnolisOS-os.repo
echo "baseurl=file:///mnt/cdrom" >> /etc/yum.repos.d/AnolisOS-os.repo
echo "gpgcheck=0" >> /etc/yum.repos.d/AnolisOS-os.repo
echo "enabled=1" >> /etc/yum.repos.d/AnolisOS-os.repo 

cat /etc/yum.repos.d/AnolisOS-os.repo

# From Public Yum or ULN
yum -y install autoconf 
yum -y install automake 
yum -y install binutils
yum -y install binutils-devel 
yum -y install bison 
yum -y install cpp 
yum -y install dos2unix 
yum -y install ftp 
yum -y install gcc 
yum -y install gcc-c++ 
yum -y install lrzsz 
yum -y install python-devel 
yum -y install compat-db* 
yum -y install compat-gcc-34 
yum -y install compat-gcc-34-c++ 
yum -y install compat-libcap1*
yum -y install compat-libstdc++-33 
yum -y install compat-libstdc++-33.i686
yum -y install glibc-* 
yum -y install glibc-*.i686 
yum -y install libXpm-*.i686 
yum -y install libXp.so.6 
yum -y install libXt.so.6 
yum -y install libXtst.so.6 
yum -y install libXext
yum -y install libXext.i686
yum -y install libXtst 
yum -y install libXtst.i686
yum -y install libX11
yum -y install libX11.i686
yum -y install libXau
yum -y install libXau.i686
yum -y install libxcb
yum -y install libxcb.i686
yum -y install libXi
yum -y install libXi.i686
yum -y install libXtst
yum -y install libstdc++-docs
yum -y install libgcc_s.so.1
yum -y install libstdc++.i686
yum -y install libstdc++-devel
yum -y install libstdc++-devel.i686
yum -y install libaio
yum -y install libaio.i686
yum -y install libaio-devel
yum -y install libaio-devel.i686
yum -y install ksh 
yum -y install libXp 
yum -y install libaio-devel 
yum -y install numactl 
yum -y install numactl-devel 
yum -y install make -y
yum -y install sysstat -y
yum -y install unixODBC 
yum -y install unixODBC-devel 
yum -y install elfutils-libelf-devel-0.97 
yum -y install elfutils-libelf-devel
yum -y install redhat-lsb-core

yum -y install compat-libical1*

rpm -ivh compat-libcap1-1.10-7.el7.x86_64.rpm --nodeps --force   
rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm --nodeps --force   
rpm -ivh pdksh-5.2.14-1.i386.rpm --nodeps --force 


echo "oracle               soft    nproc   16384" >> /etc/security/limits.conf
echo "oracle               hard    nproc   16384" >> /etc/security/limits.conf
echo "oracle               soft    nofile  65536" >> /etc/security/limits.conf
echo "oracle               hard    nofile  65536" >> /etc/security/limits.conf
echo "oracle               soft    stack   32768" >> /etc/security/limits.conf
echo "oracle               hard    stack   32768" >> /etc/security/limits.conf
echo "oracle               hard    memlock 8388608" >> /etc/security/limits.conf
echo "oracle               soft    memlock 8388608" >> /etc/security/limits.conf

echo "session    required     pam_limits.so" >> /etc/pam.d/login
echo "session required /lib64/security/pam_limits.so" >> /etc/pam.d/login

cat /etc/pam.d/login

vi /etc/sysctl.conf

#ORACLE SETTING
echo "fs.aio-max-nr = 1048576" >> /etc/sysctl.conf
echo "fs.file-max = 6815744" >> /etc/sysctl.conf
echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf
echo "net.core.rmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.rmem_max = 4194304" >> /etc/sysctl.conf
echo "net.core.wmem_default = 262144" >> /etc/sysctl.conf
echo "net.core.wmem_max = 1048586" >> /etc/sysctl.conf
echo "kernel.panic_on_oops = 1" >> /etc/sysctl.conf
echo "kernel.shmmax = 5368709120" >> /etc/sysctl.conf
echo "kernel.shmall = 1310720" >> /etc/sysctl.conf
echo "kernel.shmmni = 4096" >> /etc/sysctl.conf
echo "vm.nr_hugepages = 1000" >> /etc/sysctl.conf


sysctl -p


if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi


echo "if test -f /sys/kernel/mm/transparent_hugepage/enabled; then" >>/etc/rc.d/rc.local
echo "echo never > /sys/kernel/mm/transparent_hugepage/enabled" >>/etc/rc.d/rc.local
echo "fi" >>/etc/rc.d/rc.local
echo "if test -f /sys/kernel/mm/transparent_hugepage/defrag; then" >>/etc/rc.d/rc.local
echo "echo never > /sys/kernel/mm/transparent_hugepage/defrag" >>/etc/rc.d/rc.local
echo "fi" >>/etc/rc.d/rc.local

chmod +x /etc/rc.d/rc.local

vi /etc/default/grub

numa=off

grub2-mkconfig -o /etc/grub2.cfg


echo "SELINUX=disabled" > /etc/selinux/config
echo "#SELINUXTYPE=targeted " >> /etc/selinux/config
setenforce 0

systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl status firewalld.service


su - oracle
vim ~/.bash_profile
export TMP=/tmp
export LC_ALL="en_US"
export LANG="en_US"
##export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
export TMPDIR=$TMP
export TZ=Asia/Shanghai
export ORACLE_UNQNAME=webemr
ORACLE_SID=webemr; export ORACLE_SID
ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
PATH=.:$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_BASE/product/19.3.0/dbhome_1/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if [ $USER = "oracle" ]; then
        if [ $SHELL = "/bin/ksh" ]; then
            ulimit -p 16384
              ulimit -n 65536
  else
   ulimit -u 16384 -n 65536
      fi
    umask 022
fi


root:
xhost +


su - oracle
cd $ORACLE_HOME
export DISPLAY=192.168.10.100:0.0;

./runInstaller
##oracle 19C 软件安装正常完成


dbca 

##提示:[DBT-05509] Failed to connect to the specified database (webdb).
Cause - OS Authentication might be disabled for this database (webdb).  
Action - Specify a valid sysdba user name and password to connect to the database.





Actual results:


Expected results:
anolis7.9能正常安装oracle19c

Additional info:
Comment 1 ruofeng 2023-11-23 13:51:02 UTC
请问后来怎么解决的呢