💡 ORA-00845: MEMORY_TARGET not supported on this system Bạn sẽ gặp lỗi ORA-00845 nếu Shared Memory File System không đủ để cung cấp cho Instance. GIẢI PHÁP / SOLUTION Tăng Shared Memory …

💡 No more data to read from socket Cách fix chạy 2 câu lệnh sau SQL> alter system set “_sql_plan_directive_mgmt_control” = 0; System altered. SQL> alter system set “_optimizer_dsdir_usage_control” = …

 Mình chia sẻ trigger bắt thông tin log in: Thông tin log lưu trong bảng log_login Exclude lưu trong bảng exclude_login Chỉ action với database primary, standby thì bỏ qua …

 [root@server1 ~]# su postgres [postgres@server1 root]$ psql -f all.sql bash: psql: command not found Chạy câu lệnh sau export PATH=/opt/PostgreSQL/9.5/bin:$PATH

 Below are the steps for enabling archive mode or wal archiving in postgres. STEPS TO ENABLE ARCHIVE MODE IN POSTGRES: 1. Check archive setting in the postgres config file: postgres=#select …

 Cách flashback cả database về thời thời điểm bất kỳ: SQL> select * from V$FLASHBACK_DATABASE_LOG; SQL> Shutdown immediate; SQL> Startup mount; SQL> flashback database to timestamp TO_TIMESTAMP( ‘2022-03-04 19:00:00′,’YYYY-MM-DD HH24:MI:SS’); …

 Before start with this article, please check our previous guide how to install and configure openfiler. How to install Oopenfiler how to make Iscsi target disks in Openfiler Now we …

 In this article, I will show you Postgresql installation and its streaming replication configuration of two PostgreSQL instances on different hosts. Our goal is to install Postgres 9.5 on master …