SQL> select username from dba_users where username='ABC'; no rows selected SQL> select listagg(username, ',') within group (order by username) userna…
此报错与字符集的转换有关,源端数据字符集与目标端数据库字符集不一致, 注释掉 SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8") 添加: NOCHARSETCONVERSION GGSCI (crm-gl-ora-01) 212> edit param REP_41 NOCHAR…
Oracle固定执行计划---SQL概要 https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=15267614518416&id=271196.1&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=7rs9d9ht4_117 技…
GGSCI (server01 as gguser@ebsprod) 2> dblogin userid gguser, password AACAAAAAAAAAAAGAKBGHFAIBJJMFRJXD , encryptkey default 2023-04-09 15:05:43 WARNING OGG-25108 Failed to …
Oracle18c单机打RU补丁和one-off补丁 一、单机安装RU补丁 1.环境 Oracle DB Version Oracle Home Current RU Version Preparing to Upgrade RU Version Oracle18.3.0.0 /u01/app/oracle/product/18.3.0/db_1 …
配置单机ASM磁盘组 一、Linux逻辑卷方式配置 1.查看磁盘 [root@server ~]# fdisk -l |grep /dev/sd Disk /dev/sda: 53.7 GB, 53687091200 bytes, 104857600 sectors /dev/sda1 * 2048 616447 307200 83 Linux /…
一、故障现象 Oracle18c RAC安装报PRVG-0802错误: PRVG-0802 : Storage type for path "/dev/mapper/ocr1" could not be determined on node "crm-oracle-01". PRVG-0801 : inval…
将本地Spfile迁移至ASM SQL> create pfile='+data/ora12c/PARAMETERFILE/pfile.ora' from spfile; create pfile='+data/ora12c/PARAMETERFILE/pfile.ora' from spfile * …
无法创建ASM密码文件 OPW-00010: Could not create the password file. This resource has a Password File. 一、现象 [grid@server01 ~]$ orapwd file='+data/ASM/PASSWORD/orapwasm' asm=y…
安装rlwrap工具 1.安装相关依赖包 [root@server01 ~]# yum install -y readline readline-devel 2.安装rlwrap [root@server1 soft]# tar xvf rlwrap-0.45.2.tar.gz -C /usr/local/ [root@server1 soft]#…