Comments for DBACLASS https://dbaclass.com/ database administration Wed, 21 Feb 2024 11:26:15 +0000 hourly 1 https://wordpress.org/?v=6.5.5 Comment on POSTGRES DB SCRIPTS by Ed https://dbaclass.com/postgres-db-scripts/#comment-225593 Wed, 21 Feb 2024 11:26:15 +0000 https://dbaclass.com/?page_id=5861#comment-225593 Nice collection, would be nice if can be downloaded as a zip file though 🙂

]]> Comment on POSTGRES DB SCRIPTS by Allan Sun https://dbaclass.com/postgres-db-scripts/#comment-220080 Wed, 27 Dec 2023 22:52:46 +0000 https://dbaclass.com/?page_id=5861#comment-220080 Thank you for sharing so many great scripts. but could you also please provide a script that can read errors from the log file and then send the error messages to an email address for notifications?
Thanks so much!

]]> Comment on _optimizer_ignore_hint by Ilya Tebelev https://dbaclass.com/article/_optimizer_ignore_hint/#comment-215443 Wed, 08 Nov 2023 08:57:25 +0000 http://dbaclass.com/?post_type=article&p=3408#comment-215443 For PARALLEL hints Oracle has another setting that can be set by:
alter session set optimizer_ignore_parallel_hints=true;

]]> Comment on Oracle 12c multitenant architecture by Vimal Rathinasamy https://dbaclass.com/article/oracle-12c-multitenant-architecture/#comment-212120 Tue, 03 Oct 2023 09:11:04 +0000 http://dbaclass.com/?post_type=article&p=429#comment-212120 This is excellent
..Thanks for this article!

]]> Comment on ORA-14404: partitioned table contains partitions in a different tablespace by Amin Adatia https://dbaclass.com/article/ora-14404-partitioned-table-contains-partitions-in-a-different-tablespace/#comment-210085 Thu, 14 Sep 2023 11:16:07 +0000 http://dbaclass.com/?post_type=article&p=3067#comment-210085 Seems to be a “)” missing in the query against dba_tab_partitions

]]> Comment on ORA-12720: operation requires database is in EXCLUSIVE mode by Anand https://dbaclass.com/article/ora-12720-operation-requires-database-is-in-exclusive-mode/#comment-209131 Tue, 05 Sep 2023 05:01:15 +0000 http://dbaclass.com/?post_type=article&p=2964#comment-209131 This parameter cant be changed in Memory it should from SPFILE.

]]> Comment on ORA-20013: DBMS_QOPATCH ran mostly in non install area by Hari Chattopadhyay https://dbaclass.com/article/ora-20013-dbms_qopatch-ran-mostly-in-non-install-area/#comment-208680 Sun, 27 Aug 2023 12:49:10 +0000 http://dbaclass.com/?post_type=article&p=565#comment-208680 please correct :
create or replacce directory OPATCH_SCRIPT_DIR as ‘/oracle/app/oracle/product/12.1.0.2/dbhome_1/QOpatch’;
to
create or replace directory OPATCH_SCRIPT_DIR as ‘/oracle/app/oracle/product/12.1.0.2/dbhome_1/QOpatch’;

]]> Comment on How to make a postgres database readonly by Micah Willi https://dbaclass.com/article/how-to-make-a-postgres-database-readonly/#comment-208542 Mon, 21 Aug 2023 20:52:36 +0000 https://dbaclass.com/?post_type=article&p=6197#comment-208542 IN trying to reset back to default_transaction_read_only=off; I get
ERROR: cannot execute ALTER DATABASE in a read-only transaction
even after a restart.

]]> Comment on How to duplicate database using RMAN backup set by John Namias https://dbaclass.com/article/how-to-duplicate-database-using-rman-backup-set/#comment-205486 Fri, 21 Jul 2023 16:11:20 +0000 https://dbaclass.com/?post_type=article&p=7150#comment-205486 I noticed that in Step 4 two of the directories being created are exactly the same (1st & 3rd). Can you let me know the correct directories that need to be created?

Thanks!

]]> Comment on DBA SCRIPTS by Maryam https://dbaclass.com/monitor-your-db/#comment-203356 Tue, 20 Jun 2023 10:13:44 +0000 http://dbaclass.com/?page_id=1370#comment-203356 can you please upload script for the daily/ weekly/ monthly and one-time activities for a DBA?

]]>