Understanding Oracle APEX: Oracle APEX is a low-code development platform that empowers users to build data-centric web applications swiftly. Leveraging SQL and PL/SQL, developers can create responsive and feature-rich applications without extensive programming knowledge. APEX offers a plethora of pre-built components and templates, facilitating rapid prototyping and deployment. Key Features of Oracle APEX: Drag-and-Drop Interface: APEX’s user-friendly interface allows developers to design applications effortlessly by simply dragging and dropping components onto the canvas. Responsive Design ..read more

Oracle Advanced Support Gateway is a crucial component for managing and maintaining Oracle Engineered Systems effectively. It provides advanced support capabilities, allowing businesses to optimize performance, enhance security, and streamline operations. The installation process involves several steps, including preparation, software download, configuration, testing, and documentation. Each step must be executed carefully to ensure a successful installation and integration with existing systems. During the preparation phase, it’s essential to review system requirements and ensure compatibilit ..read more

Hi folks, I decided to write a practical article for the Undo retention calculation. The transaction undo information generated in the database is stored in the rollback segments until the commit or rollback is performed. Sometimes our long-running queries in the database are met with the error ”ORA-01555:Snapshot Too Old”. This is due to the fact that our UNDO parameters are not configured correctly. If you are wondering how many ORA-1555 errors our database receives in total, you can find it with the following query. select ‘”ORA-01555 (Snapshot too old)” hata sayisi: ‘ || sum(ssolderrcnt ..read more

I recently had to face such a problem. For those who give up, the answer is below exec dbms_Stats.gather_schema_stats(‘TESTSCHEMA’); ERROR at line 1: ORA-20000: Schema ” TESTSCHEMA” does not exist or insufficient privileges ORA-06512: at “SYS.DBMS_STATS”, line 38330 ORA-06512: at “SYS.DBMS_STATS”, line 38289 ORA-06512: at “SYS.DBMS_STATS”, line 8593 ORA-06512: at “SYS.DBMS_STATS”, line 38172 ORA-06512: at “SYS.DBMS_STATS”, line 38317 ORA-06512: at line 1 select dbms_stats.get_prefs(‘concurrent’) from dual; exec dbms_stats.set_global_prefs(‘CONCURRENT’,’FALSE’); SQL> exec dbms_Stats ..read more

Recently, I needed to use bluetooth on my computer using the linux operating system, and I saw that the services were turned off, I share the steps and controls I applied as follows. You can also follow the same similar steps to give an idea in these distro’s as well: debian, ubuntu, kali, redhat, rhel6,7,8,9 sudo apt-get update sudo apt-get upgrade sudo nano /etc/apt/sources.list –> we’ve linux distros deb file is ok. Example sources.listfor Debian 12/Bookworm (stable). deb http://deb.debian.org/debian bookworm main deb-src http://deb.debian.org/debian bookworm main deb http://deb.debi ..read more

Unable to allocate memory for new incident error in file /u01/app/oracle/diag/rdbms/instance_name/instance_name/trace/instance_name_m72034.trc: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT I had a same problem and solved it by doing the following. See what the current pga_aggregate_limit is using this (in case you want to revert your changes): show parameter pga_aggregate_limit; alter system set pga_aggregate_limit = 0; or alter system set pga_aggregate_limit=30348M scope=both; The post PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT “ORA-04036” appe ..read more

Hi Folks, I recently saw wait events on the single instance database, the root cause of the problem was caused by the undo event “Wait for a undo record”. There are cases where parallel process recovery is not as fast as serial process recovery, because the PQ secondary can interfere with each other’s operation by competing for the same resource. With such a process rollback, the performance may be worse in parallel compared to serial rollback. Due to this contention and the perceived slowness and ‘hang’-like symptoms (the database may seem to hang, the SMON and parallel query secondary may se ..read more

You can’t close an extract that is a long running transaction with Golden gate. Let’s find out how it’s done. ./ggsci You can check extract GGSCI (dev) 21> info all GGSCI (dev) 21> send extract name showtrans tabular GGSCI (dev) 21> stop extractname STOP request pending. There are open, long-running transactions. Before you stop Extract, make the archives containing data for those transactions available for when Extract restarts. To force Extract to stop, use the SEND EXTRACT GREPORA_EXT, FORCESTOP command. Oldest redo log file necessary to restart Extract is: You can copy e ..read more

None of the ASM Ctl commands are working and are idle. when checked with ps -ef, you can see that the ASM instance is working and the database is also working well. But we have a problem, the Cluster high availability services are not working. -> asmcmd lsdg ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run ps -ef | grep pmon grid 62954 1 0 Sep 20 ? 74:20 asm_pmon_+ASM1 Solutions crsctl stop has crsctl start has Have a nice day The post ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run appeared first on BigDBA - Database,Devops,Big Data ..read more

CONTENTS SECTION 1-) GOLDENGATE INSTALLATION • Goldengate Installation • Extract Process • GGSCI commands • Parameter Files • As400 Extract Example • Oracle Extract Example • Pump Example • Replicate Process • GGSCI commands • Parameter files • Replicate Example • Manager Operation • GGSCI commands • Parameter File • Manager Example • Useful commands SECTION 2-) USE OF GOLDENGATE • Goldengate Daily Usage • INFO • STATS • Using Extract a. As400 Example I. info ii. Stats iii. Adding/Deleting Tables b. Oracle Example • Info • Stats • Adding/Deleting Tables • Pump Usage a. As400 Example I. info ii ..read more