Oracle

Hi, I will explain How to Change the Public IP Addresses in Oracle RAC in this post.  594 views last month,  2 views today

Hi, I will explain How to Create and Stop Start a Database Service Using DBMS_SERVICE in Oracle Database in this post.  577 views last month,  2 views today

Hi, I will explain How to Change Existing Range Partitioned Table to Interval Partitioned Table and Interval Partitioned to Range Partitioned Table in this post.    570 views last month,  3 views today

Hi, I will explain How to List and Analyze Partitions of Table Order by High Value Column in Oracle Database in this post.  715 views last month,  6 views today

Hi, I will explain What is the Recycle bin and How to Restore Dropped Tables from Recycle Bin in this post.  554 views last month,  3 views today

Hi, I will share with you Step by Step Flashback Database, Table, Query Tutorials For Beginners in the Oracle Database in this article.  968 views last month,  5 views today

Hi, I will explain How to Flashback Database to Guaranteed Restore Point in this article.  579 views last month,  3 views today

Hi, I will explain How to List and Monitor DBMS Jobs and Scheduler Jobs in Oracle Database in this post.  714 views last month,  8 views today

Hi, I will explain How to Export ( EXPDP ) Oracle Database with Crontab Job and Place a Date in a Datapump Export File Name in this article.  590 views last month,  3 views today

Hi, I will explain How to Get DDL ( Create Script ) of any Object in Oracle Using DBMS_METADATA.GET_DDL in this article.  1,313 views last month,  116 views today

Hi, I will explain How to Drop and Recreate Temp Tablespace in Oracle Database in this article.  589 views last month,  2 views today

Hi, I will explain How to Upgrade Timezone ( DST ) Manually During Oracle 12c  Upgrade.  609 views last month,  2 views today

Hi, I will explain How to Resolve Gaps in Data Guard Apply Using Incremental RMAN Backup in this article.  730 views last month,  3 views today

Rename asm diskgroup name on 12c. Data and Reco asm disk group name switch operation steps are below. Step1:Startup asm with created asm pfile. startup pfile=$ORACLE_HOME/dbs/init+ASM.ora; Step2:Dismount all disks. alter diskgroup all dismount; Step3:First operation , rename diskgroup name as metadata. renamedg phase=one dgname=DATA newdgname=DATA1 asm_diskstring='/dev/oracleasm/disks/DATA_VOL01' config=/tmp/disk.conf verbose=true keep_voting_files=true renamedg …

Hi, Goldengate Extract process is abended with ” OGG-02028 Failed to attach to logmining server Error code 27144, error message: ORA-27144: attempt to kill process failed ” error.  480 views last month,  6 views today

Hi, I will explain What is the Dataguard Broker and How to Enable / Disable Dataguard Broker Configurations in this article.  709 views last month,  2 views today

Author     : Cihan Gedik Email        : cihangedik@gmail.com Linkedin  : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group      : https://www.linkedin.com/groups/13792740/   Monitoring Tool for All Unix/Linux Distrubitions ( Oracle,Red Hat,AIX,Centos,Debian,Ubuntu ) Compatible Versions AIX,Linux,Redhat, Centos, Debian ( All Unix/Linux Distrubitons ) Requirements Linux System Resource Monitoring Solution 1-Download rpm/tar.gz or etc. You can download …

Hi, I will explain what are the Oracle DBA Daily/Weekly/Monthly or Quarterly Routine Checklist and Tasks in this article.  1,556 views last month,  7 views today

Hi, I will explain Bulk Insert and Bulk Update in Oracle Database in this article.  718 views last month,  2 views today

Hi, I will explain How to Delete or Purge Audit Trail Table and Records in Oracle Database in this article.  833 views last month,  2 views today

Hi, Sometimes you may need changing Oracle ASM Diskgroup name.  315 views last month,  2 views today

Author     : Cihan Gedik Email        : cihangedik@gmail.com Linkedin  : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group      : https://www.linkedin.com/groups/13792740/   Compatible Versions Weblogic 10.3.6 or Later Error Message weblogic.application.ModuleException: java.lang.OutOfMemoryError: GC overhead limit exceeded Solution This error can be caused due to the lack of memory for java heap. To solve this problem …

You can grant users various privileges to tables. These privileges can be any combination of SELECT, INSERT, UPDATE, DELETE, REFERENCES, ALTER, INDEX, or ALL.   GRANT SELECT ANY CUBE TO BARANYILDIZ ; GRANT SELECT ANY TABLE TO BARANYILDIZ ; GRANT SELECT ANY DICTIONARY TO BARANYILDIZ ; GRANT CREATE ANY PROCEDURE   …