首页
学习
活动
专区
圈层
工具
发布
    • 综合排序
    • 最热优先
    • 最新优先
    时间不限
  • 来自专栏MySQL解决方案工程师

    MySQL身份验证——Pluggable Authentication

    authentication_pam:使用PAM(Pluggable Authentication Modules)进行外部验证的插件,并且可以支持代理用户,该插件包含在MySQL的企业版内。 关于插件验证的内容介绍到这里,更为详细的内容可以访问“https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html” 感谢您关注

    2.8K20发布于 2020-09-28
  • 来自专栏硅光技术分享

    OFC2022: 从Pluggable到CPO的演变

    今年OFC有一个workshop, topic是"Is Paradigm Shift from Pluggable Optics to Co-packaged Optics Inevitable in Pluggable遇到这一问题的话,可以直接替换一个光模块,发挥其flexible的优势。针对这一问题,需要硅光fab进一步优化工艺,提高光器件与系统的可靠性与良率。 短期内CPO无法在数据中心大范围部署,CPO未来也会与pluggable光模块共存一段时间。硅光技术在CPO的角色是无可替代的,大部分厂家都是采用微环调制器这一技术,需要控制电路调节微环的工作点。

    2.9K20编辑于 2022-04-27
  • 来自专栏Godot游戏开发引擎介绍和入门

    Godot游戏开发实践之四:搬运Unity的Pluggable AI教程

    在之前的几篇文章里我简单地介绍了 AI 寻路方式以及 Resource 的相关应用,那其实都是为这篇文章做铺垫的,本篇的内容是基于油管上一个比较老的 Unity AI 系列教程: Unity tutorial: Pluggable [Unity tutorial: Pluggable AI With Scriptable Objects] 因为 Unity 中的 ScriptObject 在 Godot 中相当于 Resource [Godot Pluggable AI] 什么是可插拨AI 所谓可插拨其实和安装插件、热插拨等概念类似,就是可以随意添加或者删除某个功能,通过直接拖拽就能组成复杂的 AI 体系而无须手动重复编写代码,在 …… 三、总结 这种 AI 系统具有比较强的扩展性和易用性,有点复杂问题简单模块化的思维,用起来应该会相当爽,当然我也没有具体项目案例,另外也有一些不足之,个人经验主要概括为这两点: Pluggable 本篇的 Demo 以及相关代码已经上传到 Github ,地址: https://github.com/spkingr/Godot-Pluggable-AI , 后续继续更新,原创不易,希望大家喜欢!

    1.4K00发布于 2020-09-10
  • 来自专栏小麦苗的DB宝专栏

    Oracle重命名PDB

    脚本 -- 步骤1、启动pdb到受限模式(在pdb里边操作) alter session set container=pdblhr3; alter pluggable database pdblhr3 close immediate; alter pluggable database pdblhr3 open restricted; -- 或: shutdown immediate startup ; alter pluggable database open; -- 或 shutdown immediate startup 例如:将JDE重命名为JDEPROD alter pluggable =JDE; alter pluggable database rename global_name to JDEPROD; alter pluggable database close immediate from outside a pluggable database”。

    94010编辑于 2023-04-27
  • 来自专栏Oracle数据库技术

    Oracle数据库工程师手记:探究 Oracle PDB Application Container (二)

    Application Container 中 application 的升级: 需要执行: ALTER PLUGGABLE DATABASE APPLICATION ref_app BEGIN UPGRADE '1.0' TO '1.1'; 对数据的增减、对结构的改动语句等 ALTER PLUGGABLE DATABASE APPLICATION ref_app END UPGRADE; 验证过程:如同Oracle USER pdb_admin IDENTIFIED BY Password1; ALTER PLUGGABLE DATABASE apppdb1 OPEN; ALTER SESSION SET 这个PDB 无法直接删除,可以这样删除: 先删除 APPPDB1, 再删除 APPCON1: alter pluggable database appcon1 close; drop pluggable SQL> ALTER PLUGGABLE DATABASE APPLICATION ref_app BEGIN UPGRADE '1.0' TO '1.1'; Pluggable database

    39310编辑于 2022-08-19
  • 来自专栏开源部署

    Oracle 12C CDB、PDB常用管理命令

    =orcl1;  --切换到PDB进去开启数据库 startup --关闭PDB alter pluggable database orcl1 close;      --关闭指定的PDB alter database test admin user admin identified by admin;    alter pluggable database test_pdb open;    - -将test_pdb 打开 --克隆PDB(需要CBD下sysdba权限) create pluggable database orcl2 from orcl1;  --test_pdb必须是打开的, 才可以被打开 alter pluggable database orcl2 open;  --然后打开这个pdb --删除PDB(需要CBD下sysdba权限) alter pluggable database   orcl2 close;  --关闭之后才能删除 drop pluggable database orcl2 including datafiles;  --删除PDB orcl2 --设置CDB启动

    1.3K10编辑于 2022-08-16
  • 来自专栏Oracle数据库技术

    探究 Oracle PDB Application Container (五)

    Password1; ALTER PLUGGABLE DATABASE apppdb1 OPEN; CREATE PLUGGABLE DATABASE apppdb2 ADMIN USER pdb_admin SQL> SQL> ALTER PLUGGABLE DATABASE APPLICATION ALL SYNC; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION ref_app BEGIN UPGRADE '1.0' TO '1.1'; Pluggable database SQL> ALTER PLUGGABLE DATABASE APPLICATION ref_app END UPGRADE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION ALL SYNC; Pluggable database altered.

    47910编辑于 2022-08-19
  • 来自专栏数据和云

    Oracle 18c 新特性:动态 Container Map 增强 Application Container 灵活性

    SQL> alter pluggable database all open; Pluggable database altered. SQL> alter pluggable database set container_map='EYGLE.CONTAINERMAP'; Pluggable database altered. SQL> alter pluggable database application EMAPP end install '1.0'; Pluggable database altered. SQL> alter pluggable database application EMAPP sync; Pluggable database altered. SQL> alter pluggable database application EMAPP sync; Pluggable database altered.

    79020发布于 2018-12-12
  • 来自专栏数据库架构之美

    史上最全-oracle12c pdb迁移实践

    SQL> alter pluggable database pdbtest_new open; Pluggable database altered. SQL> alter pluggable database pdbtest open; Pluggable database altered. SQL> alter pluggable database noncdb_new open; Pluggable database altered. SQL> alter pluggable database pdb1 close immediate; Pluggable Database closed. SQL> alter pluggable database pdb1 open; Pluggable database altered.

    2.7K40发布于 2019-12-18
  • 来自专栏沃趣科技

    Oracle 12c系列(五)|PDB Refresh

    该子句目前只在"Create Pluggable Database... 另外也可以使用Alter Pluggable Database命令将Refreshable PDB从手动刷新更改为自动刷新,也可以从自动刷新更改为手动刷新,同样通过语句Alter Pluggable Database sys. ora12c>CREATE PLUGGABLE DATABASE qdatapdb FROM woqupdb@orcl12c REFRESH MODE MANUAL; Pluggable Pluggable database altered. 05:00 QDATAPDB(4):alter pluggable database refresh QDATAPDB(4):Completed: alter pluggable database refresh

    1.7K60发布于 2018-03-26
  • 来自专栏DATABASE

    创建可插拔数据库PDB

    ls -ld /u01/app/oracle/oradata/cdb1/pdb21.1.5 创建 pdb2SYS@cdb1> create pluggable database pdb2admin user database pdb1 close immediate;SYS@cdb1> alter pluggable database pdb1 open read only;SYS@cdb1> show =('pdb1','pdb3');1.2.6 open 打开 pdb3SYS@cdb1> show pdbsSYS@cdb1> alter pluggable database pdb3 open;SYS pluggable database pdb1 open;SYS@cdb1> show pdbs1.3 删除 PDB从容器数据库 CDB1 中删除可插拔数据库 PDB3 以及对应的数据文件1.3.2 删除 PDB3SYS@cdb1> drop pluggable database pdb3 including datafiles;

    73830编辑于 2022-07-11
  • 来自专栏程序猿

    Oracle_12C的新特性

    ’ ON OrdersClosedPolicy; #11 Application Continuity 应用持续性增强, 事务卫士(Transaction Guard)保证了解事务结果: #12 Pluggable Databases 可插入数据库: 一个容器数据库(container database)中可以存放多个Pluggable Databases 对于外部应用程序和开发者来说Pluggable Databases 看上去就是一个普通的版本12.1之前的数据库 用户连接到Pluggable Databases时看到的是一个单一数据库和从前一样 新的管理模式 数据库管理员DBA可以连接到Pluggable Database 并仅仅管理该数据库 超级DBA可以连接到容器数据库并如同管理单系统镜像那样管理 RAC中的每一个实例均打开容器数据库并可以选择打开哪些Pluggable Database 内建的多分租(Multi-tenancy ) 每个Pluggable Database均独立于其他Pluggable Database Resource Manager特性被扩展到Pluggable Database中 Pluggable Databases

    1.1K90发布于 2018-03-09
  • 来自专栏数据库与编程

    【翻译mos文章】怎么startup/shutdown PDB?

    SQL> SHUTDOWN IMMEDIATE; Pluggable Database closed. database PDB1 close; Pluggable database altered. SQL> alter pluggable database PDB1 open; Pluggable database altered. database PDB1 open restricted; Pluggable database altered. database PDB1 open FORCE; Pluggable database altered.

    29910编辑于 2024-04-03
  • 来自专栏沃趣科技

    Oracle12c R2版本Application Containers特性(三)

    BY password; ALTER PLUGGABLE DATABASE qdatacon1$SEED OPEN; ALTER SESSION SET CONTAINER=qdatacon1$SEED ; ALTER PLUGGABLE DATABASE APPLICATION ALL SYNC; ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE; ALTER PLUGGABLE Creating an Application Seed From an Application PDB CREATE PLUGGABLE DATABASE AS SEED FROM qdcpdb1; ALTER PLUGGABLE DATABASE qdatacon1$SEED OPEN; ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE; ALTER PLUGGABLE /rdbms/admin/pdb_to_apppdb.sql ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE; ALTER PLUGGABLE DATABASE OPEN

    96870发布于 2018-03-26
  • 来自专栏数据库学习笔记

    记录一次Oracle 19.11使用PDB Refresh方式迁移PDB

    alter pluggable database xxx refresh mode every 1 hours; 此步骤完成,可以正常刷新的话,后面没发现有什么坑。 测试增量传输 可以在源库创建测试表,目标端以read only方式打开查看,测试是否能正常到目标库 --目标端操作 alter pluggable database xxx open read only alter pluggable database xxx refresh; 源库操作:应用关闭后,一致性关闭源库,再以read only模式打开。 (确保无新业务进来,job也不再运行) alter pluggable database xxx close immediate instances=all; alter pluggable database (不可逆) alter pluggable database xxx refresh mode none; 打开目标库 alter pluggable database xxx open instances

    2.6K20编辑于 2022-03-30
  • 来自专栏公众号:Lucifer三思而后行

    关于PDB的几种启动方式

    database all open; Pluggable database altered. database all close; Pluggable database altered. database all save state; Pluggable database altered. database ORCL close; Pluggable database altered. database ORCL save state; Pluggable database altered.

    2.1K30发布于 2021-08-17
  • 来自专栏数据和云

    回答了这四个问题,少踩12c 多租户的好多坑

    SQL>alter pluggable database yhem open; Pluggable database altered. SQL> startup Pluggable Database opened. eygle_ora_14095.trc ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE [oracle@12c01db trace]$ grep -i pluggable SQL> alter pluggable database YHEM open; Pluggable database altered. SQL> alter pluggable database PDBPROD1 open; Pluggable database altered. SQL> !

    1.3K60发布于 2018-03-07
  • 来自专栏数据库新发现

    Oracle 20c 新特性:区块链表的加密HASH以及删除保护

    打开PDB,创建一个独立的测试用户: SQL> alter pluggable database enmo open; Pluggable database altered. SQL> alter pluggable database enmo close; Pluggable database altered. SQL> drop pluggable database enmo; drop pluggable database enmo * ERROR at line 1: ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged SQL> drop pluggable database enmo including datafiles; Pluggable database dropped.

    66340发布于 2020-04-01
  • 来自专栏bisal的个人杂货铺

    创建PDB的两种操作

    方式1,直接创建PDB 直接从PDB$SEED这个种子PDB,创建新的PDB, SQL> create pluggable database test1 admin user bisal identified database test1 open; Pluggable database altered. SQL> create pluggable database test1 from bisalpdb1; Pluggable database created. 从trace日志,能看到Oracle做了Incomplete Recovery, create pluggable database test1 from bisalpdb1 2021-10-31T18 database test1 from bisalpdb1 打开这个PDB,能看到源库已经创建的对象了, SQL> alter pluggable database test1 open; Pluggable

    1.9K20发布于 2021-11-08
  • 来自专栏杨建荣的学习笔记

    Oracle 12c PDB浅析(r9笔记第10天)

    启动一下新的pdb SQL> alter pluggable database pdb1 open; Pluggable database altered. 这个时候再次查看就是两条记录了。 SQL> drop pluggable database pdb1 including datafiles; drop pluggable database pdb1 including datafiles 想要删除先得close SQL> alter pluggable database pdb1 close; Pluggable database altered. close之后就可以放心删除了 SQL > drop pluggable database pdb1 including datafiles; Pluggable database dropped. SQL> shutdown immediate Pluggable Database closed. SQL> startup Pluggable Database opened.

    1.1K70发布于 2018-03-16
领券