首页 > 数据库 >oracle 19c install steps

oracle 19c install steps

时间:2023-12-22 11:44:37浏览次数:34  
标签:app ORACLE steps install oracle HOME u01

oracle 19c install steps

1. VMware-workstation-full-17.5.0 download and setup

2. redhat8.9,vnc download and setup
--------------------------
VNC Config Steps
Vmware 安装 redhat 8.9
连接网络
subscription-manager register 注册 redhat账户
vi /etc/selinux/config, 设置SELINUX=disabled
yum install tigervnc-server tigervnc
adduser oracle
passwd oracle
su - oracle
vncpasswd
vim /etc/tigervnc/vncserver.users, 添加 :1=oracle
systemctl enable vncserver@:1.service
systemctl start vncserver@:1.service
systemctl stop firewalld
--------------------------

3. download
LINUX.X64_193000_db_home.zip
compat-libcap1-1.10-7.el7.x86_64.rpm
compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

4. hostnamectl set-hostname ora19c

5. vi /etc/hosts and add the following
192.168.99.199 ora19c

6. install dependency

yum -y install bc xdpyinfo binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make policycoreutils policycoreutils-python-utils smartmontools sysstat
yum -y install compat-libcap1-1.10-7.el7.x86_64.rpm
yum -y install compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm
yum -y insatll gcc-c++

7. config user and groups (already have oracle user)

groupadd oinstall
groupadd dba
groupadd asmdba3. export LANG=en_US
groupadd backupdba
groupadd dgdba
groupadd kmdba
groupadd racdba
groupadd oper
groups oracle
usermod -a -G oinstall,dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle
groups oracle


8. vi /etc/sysctl.conf add the following
fs.file-max = 6815744
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

9. vi /etc/selinux/config
SELINUX=disabled

10. systemctl stop firewalld

11. env
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.5.0
export PATH=$PATH:$ORACLE_HOME/bin:/usr/local/bin
export ORACLE_HOSTNAME=ora19c
export ORACLE_SID=orcl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/network/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export CV_ASSUME_DISTID=RHEL8

12. vi /etc/security/limits.conf add the following

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
oracle soft memlock unlimited
oracle hard memlock unlimited

13. make dir and unzip
mkdir -p /u01/app/oracle/product/19.5.0
mkdir -p /u01/app/oraInventory/
chown -R oracle:oinstall /u01/app/oracle
chown -R oracle:oinstall /u01/app/oraInventory/

unzip LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.5.0/


14. switch to desktop and
export LANG=en_US
./runInstaller


15. netca

16. dbca

17. reference

https://blog.csdn.net/bjywxc/article/details/104696121
https://blog.csdn.net/OceanWaves1993/article/details/130232193
https://zhuanlan.zhihu.com/p/388311750
https://www.cnblogs.com/zhwl/p/3723772.html

 

标签:app,ORACLE,steps,install,oracle,HOME,u01
From: https://www.cnblogs.com/pugang/p/17921292.html

相关文章

  • Microsoft MSXML is not installed
    MicrosoftMSXMLisnotinstalled.线程里边加上CoInitializeEx和CoUninitialize就好了,线程外边不起作用。procedureTFrmManager.testinputpwd;beginCoInitializeEx(Nil,COINIT_MULTITHREADED);varfrm:=TFrmKPYBpwinput.Create(nil);frm.showmodal;frm.Free;......
  • Oracle中给表赋予权限
    在Oracle数据库中,为表赋予权限的作用是允许或限制其他用户对该表进行特定操作的访问和修改。通过授权表权限,可以确保数据库的安全性和数据的保护。以下是一些常见的表权限以及它们的作用:SELECT:允许用户查询表中的数据。INSERT:允许用户向表中插入新的数据。UPDATE:允许用户修改表......
  • winget install cuda (Nvidia.CUDA)
    PSC:\Users\Administrator>wingetsearchcuda名称ID版本匹配源------------------------------------------------------------CudaLaunch9NBLGGH40FCJUnknownmsstoreMCXStudiocoti.mcxstudi......
  • ERROR: Could not build wheels for opencv-python, which is required to install py
    目录系统环境问题描述问题解决问题二参考文章系统环境#macOS系统版本$sw_versProductName:MacOSXProductVersion:10.14.4BuildVersion:18E2035#Python版本$python--versionPython3.9.13问题描述安装opencv-python报错,安装失败#安装opencv-python的命令......
  • Oracle12c新增max_idle_time参数的学习与感触
    Oracle12c新增max_idle_time参数的学习与感触TLDR其实任何软件出了新版本.readme是很重要的.尤其是数据库,涉及到底层问题的.比如这次遇到的Oracle的max_idle_time参数,以及前几天遇到的Mysql的新增的parallel关键字.自己之前的积累可能是一盏明灯,也可能是一堵墙.......
  • conda install -c conda-forge cupy
     (base)root@ubuntulenovo:/home/renguoqiang#condainstall-cconda-forgecupyCollectingpackagemetadata(current_repodata.json):/WARNINGconda.models.version:get_matcher(556):Using.*withrelationaloperatorissuperfluousanddeprecatedandwill......
  • debezium同步Oracle数据时,更新操作只有被变更字段,其余字段值为null,主键ID值为0
    1.情景展示使用debezium的Oracle插件(io.debezium.connector.oracle.OracleConnector)自动读取Oracle的归档日志。当我对Oracle数据库受监控的表(待同步表),进行更新操作后,debezium会自动将变更记录推送到kafka当中。新增和删除操作,数据都能同步到另一个数据库。但是,更新操作,数据......
  • pyinstaller 打包 win32ctypes.pywin32.pywintypes.error: (225, '', '无法成功完成操
    背景:使用python写了一个程序,使用pyinstaller打包,不使用-w--noconsole的命令打包隐藏命令行窗口时,是正常的,但是使用-w或者--noconsole就会报错win32ctypes.pywin32.pywintypes.error:(225,'','无法成功完成操作,因为文件包含病毒或潜在的垃圾软件。')在网上搜索了一些资讯,......
  • Could not build wheels for pillow, which is required to install pyproject.toml-b
     参考来源,致敬大佬。ERROR:CouldnotbuildwheelsforPillow,whichisrequiredtoinstallpyproject.toml-basedprojects-CSDN博客报错:Couldnotbuildwheelsforpillow,whichisrequiredtoinstallpyproject.toml-basedprojects的解决-CSDN博客 本人小白......
  • Oracle归档日志清理
    1、检查数据库实例的状态selectstatusfromv$instance; 如果是这个的话就挂在一下alterdatabasemount;alterdatabaseopen;selectstatusfromv$instance; 2、进入rman下rman 3、连接到数据库connecttarget/4、检查没有用的archivelogcrosscheckarchiv......