IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    oracle 23ai(23.5.0.24.07)完整功能版安装体验

    惜分飞发表于 2024-07-26 15:45:46
    love 0

    联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

    标题:oracle 23ai(23.5.0.24.07)完整功能版安装体验

    作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

    最近oracle 发布了for exadata、oda以及云端的oracle 23ai版本,今天在x86环境中进行了安装测试,安装环境非常顺利,基本上按照安装需求配置好,然后一路下一步(注意选择不创建库)即可
    ORA23AI-install


    dbca创建库会遭遇到ORA-27350
    ora-27350

    由于我这是普通的x86环境,需要设置_exadata_feature_on参数来骗过数据库,参考:ORA-12754: Feature ‘startup’ is disabled due to missing capability ‘Runtime Environment’
    最终效果

    [oracle@xifenfei ~]$ ss
    
    SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Sat Jul 27 07:30:36 2024
    Version 23.5.0.24.07
    
    Copyright (c) 1982, 2024, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
    Version 23.5.0.24.07
    
    SQL> select * from v$version;
    
    BANNER
    --------------------------------------------------------------------------------
    BANNER_FULL
    --------------------------------------------------------------------------------
    BANNER_LEGACY
    --------------------------------------------------------------------------------
        CON_ID
    ----------
    Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
    d Engineered Systems
    Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
    d Engineered Systems
    Version 23.5.0.24.07
    
    BANNER
    --------------------------------------------------------------------------------
    BANNER_FULL
    --------------------------------------------------------------------------------
    BANNER_LEGACY
    --------------------------------------------------------------------------------
        CON_ID
    ----------
    Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud an
    d Engineered Systems
             0
    
    
    SQL> select name from v$datafile;
    
    NAME
    --------------------------------------------------------------------------------
    /u01/app/oracle/oradata/ORA23AI/system01.dbf
    /u01/app/oracle/oradata/ORA23AI/pdbseed/system01.dbf
    /u01/app/oracle/oradata/ORA23AI/sysaux01.dbf
    /u01/app/oracle/oradata/ORA23AI/pdbseed/sysaux01.dbf
    /u01/app/oracle/oradata/ORA23AI/users01.dbf
    /u01/app/oracle/oradata/ORA23AI/pdbseed/undotbs01.dbf
    /u01/app/oracle/oradata/ORA23AI/undotbs01.dbf
    
    7 rows selected.
    
    SQL> show pdbs;
    
        CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    ---------- ------------------------------ ---------- ----------
             2 PDB$SEED                       READ ONLY  NO
    SQL> 
    SQL> 
    SQL> EXIT
    Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
    Version 23.5.0.24.07
    
    • Oracle 23ai 变化之—-默认数据文件变为bigfile
    • ORACLE 12C安装预览
    • PASSWORD_ROLLOVER_TIME—实现新老密码短期共存
    • ORA-12754: Feature ‘startup’ is disabled due to missing capability ‘Runtime Environment’
    • ORACLE 12C move datafile测试
    • ORACLE 12C 控制文件异常恢复
    • Oracle 发布计划—包含Oracle 23ai版本
    • Oracle 23ai rm redo*.log恢复
    • 分布式存储故障导致数据库无法启动故障处理
    • 非tns方式登录pdb方法
    • rm -rf误删Oracle数据库恢复
    • 模拟19c数据库root pdb undo异常恢复


沪ICP备19023445号-2号
友情链接