1.环境准备,observer安装在192.168.56.100[oracle@observeradmin]$cat/etc/hosts127.0.0.1localhostlocalhost.localdomainlocalhost4localhost4.localdomain4::1localhostlocalhost.localdomainlocalhost6localhost6.localdomain6192.168.56.100observer192.168.56.101d...(more)

1.环境准备2台虚拟机，操作系统安装Redhat7.9。其他信息规划如下：sourcedbtargetdbIP地址192.168.56.101192.168.56.102数据库SIDorclorclDB_UNIQUE_NAMEorcl_porcl_s在2台虚拟机分别安装19c数据库软件，主库创建CDB实例orcl，PDB实例：hbhe。备库只安装数据库软件，不创建实例。在d...(more)

1.expdp导出相关#sqlplus/assysdba创建逻辑目录、查看逻辑目录SQL>createdirectorymydataas'/u01/mydata';SQL>select*fromdba_directories;导出t1表#su-oracle1)导出用户及其对象expdphbhe/wwwwww@PDB01schemas=scottdumpfile=expdp.dmpdirectory=dump_dirlogfile=expdp...(more)

1.在GRUB_CMDLINE_LINUX加入选项transparent_hugepage=neverecho'GRUB_CMDLINE_LINUX="transparent_hugepage=never"'>>/etc/default/grub2.重新生成grub文件#grub2-mkconfig-o/boot/grub2/grub.cfgGeneratinggrubconfigurationfile...Foundlinuximage:/boot/vmlinuz-3.1...(more)

1.关于配置memlock关于配置memlock详见MOS：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=253125856850627&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2511230.1&_afrWindowMode=0&_adf.ctrl-state=h5de21l1e_6332.查看memlock...(more)

1.下载ogg安装包191004_fbo_ggs_Linux_x64_shiphome.zip2、将安装文件上传至服务器ogg安装包上传至服务器的Oracle用户并解压缩。编辑静默安装所需的response文件[root@node01response]#cd/home/oracle/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response[root@node01respon...(more)

1.查看当前DB环境[oracle@db01~]$cat/etc/redhat-releaseRedHatEnterpriseLinuxServerrelease7.9(Maipo)[oracle@db01~]$lsnrctlstatusLSNRCTLforLinux:Version19.0.0.0.0-Productionon13-SEP-202121:33:46Copyright(c)1991,2021,Oracle.Allrightsreserved.Connectingto(...(more)

1.创建测试表SQL>createtablet1(idint);Tablecreated.2.查看表占用的块数量SQL>SELECTblocks,empty_blocks,num_rowsFROMdba_tablesWHEREtable_name='T1';BLOCKSEMPTY_BLOCKSNUM_ROWS--3.对T1表做统计信息收集SQL>ANALYZETABLET1COMPUTESTATISTICS;Tableanalyzed.4.再次...(more)

//开启数据库sqlplus/assysdba;//登录连接CDB，默认是rootcontainer;startupopen;//open模式，但此时的pdb模式是mounted，需要手工开启PDBSQL>altersessionsetcontainer=PDB;//切换到某个pdbSQL>alterpluggabledatabaseopen;//开启选定的pdbSQL>alterpluggabledatabaseallopen...(more)

1.查看CDB名称和PDB名称SQL>selectnamefromv$database;NAME--ORCLSQL>showpdbsCON_IDCON_NAMEOPENMODERESTRICTED2PDB$SEEDREADONLYNO3PDBREADWRITENO2.修改/u01/app/oracle/product/19.3.0/dbhome_1/network/admin/tnsnames.ora文件LISTENER_ORCL=(ADDRESS=(PROTOCOL=TC...(more)