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

    非tns方式登录pdb方法

    惜分飞发表于 2023-10-09 14:16:04
    love 0

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

    标题:非tns方式登录pdb方法

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

    非tns方式登录pdb方法之—-alter session set container

    [oracle@db01 ~]$ env|grep ORA
    ORACLE_SID=DCXFF
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/19c/db_1
    [oracle@db01 ~]$ sqlplus / as sysdba
    
    SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 9 22:10:34 2023
    Version 19.20.0.0.0
    
    Copyright (c) 1982, 2022, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    Version 19.20.0.0.0
    
    SQL> show pdbs;
    
        CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    ---------- ------------------------------ ---------- ----------
             2 PDB$SEED                       READ ONLY  NO
             3 XFFPDB1                        READ WRITE NO
    SQL> show con_name;
    
    CON_NAME
    ------------------------------
    CDB$ROOT
    SQL> alter session set container=XFFPDB1;
    
    Session altered.
    
    SQL> show con_name;
    
    CON_NAME
    ------------------------------
    XFFPDB1
    SQL> exit
    Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    Version 19.20.0.0.0
    

    非tns方式登录pdb方法之—-ORACLE_PDB_SID

    [oracle@db01 ~]$ export ORACLE_PDB_SID=XFFPDB1
    [oracle@db01 ~]$ sqlplus / as sysdba
    
    SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 9 22:11:30 2023
    Version 19.20.0.0.0
    
    Copyright (c) 1982, 2022, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    Version 19.20.0.0.0
    
    SQL> SHOW pdbs;
    
        CON_ID CON_NAME                       OPEN MODE  RESTRICTED
    ---------- ------------------------------ ---------- ----------
             3 XFFPDB1                        READ WRITE NO
    SQL> show con_name;
    
    CON_NAME
    ------------------------------
    XFFPDB1
    SQL> exit
    Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    Version 19.20.0.0.0
    

    参考:How To Connect to PDB By OS Authentication In 19c Container Database Environment (Doc ID 2729416.1)

    • 设置pdb随cdb一起启动
    • 模拟19c数据库root pdb undo异常恢复
    • 某个pdb可以在root pdb open状态下进行恢复
    • ORACLE 12C PDB 维护基础介绍
    • ORACLE 12C move datafile测试
    • ORACLE 12C CDB中PDB参数管理机制
    • pdb正常运行丢失数据文件相关恢复
    • 11GR2升级到12CR1并插入CDB
    • 模拟19c数据库pdb undo异常恢复
    • sys用户密码含$ sqlplus登录数据库诡异事件分析
    • 19c sqlplus / as sysdba 登录慢分析
    • ORACLE 12C 控制文件异常恢复


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