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 …