Top Reviews

Oracle Unveils AI-Voice for the Enterprise Oracle introduces natural voice conversations to Digital Assistant and enhances deep learning semantic parser to handle complex linguistic constructs

Oracle today announced availability of its AI-trained voice with Oracle Digital Assistant. Now, enterprise customers can use voice commands to communicate with their enterprise applications to drive desired actions and outcomes, enriching the user experience with conversational AI, simplifying interactions and improving productivity.  “Enterprises are demanding an AI-powered voice assistant that understands their specific vocabulary and enables…

Read more

PostgreSQL 11 Streaming Replication/Hot Standby

To create PostgreSQL replication first we must install PostgreSQL on  Primary and  Standby server. On Primary and Standby: [root@localhost ]# yum -y install epel-release [root@localhost ]# yum -y install bash-completion [root@localhost ]# yum -y install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm [root@localhost ]# yum install postgresql11-server [root@localhost ]# yum install postgresql11-contrib On Primary: [root@localhost ]# /usr/pgsql-11/bin/postgresql-11-setup initdb Initializing database ……

Read more

RAC|ASM

Directory Index Full Today I encountered with short system hang in my 2 node RAC database.When I investigate the cause of the problem a saw “Kernel: EXT4-fs warning (device sda1): ext4_dx_add_entry:2021: Directory index full!” warning in the /var/log/messages file. Jan 22 14:45:09 mydb1 kernel: EXT4-fs warning (device sda1): ext4_dx_add_entry:2021: Directory index full! Jan 22 14:45:09 mydb1 kernel:…

Read more

Saving Archive logs in different destinations and changing log_archive_format

Resolving 101 SYS@ola> alter system set log_archive_dest_2 = ‘LOCATION=/u01/’; SYS@ola> alter system set log_archive_dest_2 = ‘LOCATION=/tmp/’; SYS@ola> SHOW PARAMETER LOG_ARCHIVE_FORMAT; NAME                                 TYPE        VALUE ———————————— ———– —————————— log_archive_format                   string      %t_%s_%r.dbf LOG_ARCHIVE_FORMAT-a We ignore the settings above alter system set LOG_ARCHIVE_FORMAT=’log%a_%d_%T_%S_%t_%s_%r.arc’ scope=spfile; SYS@ola> startup force; SYS@ola> SHOW PARAMETER LOG_ARCHIVE_FORMAT; NAME                                 TYPE        VALUE ———————————— ———– —————————— log_archive_format                   string     …

Read more

2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment