BigDBA | Database & Devops Blog
149 FOLLOWERS
Keep up with articles from BigDBA.
BigDBA | Database & Devops Blog
2w ago
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
BigDBA | Database & Devops Blog
2w ago
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
BigDBA | Database & Devops Blog
1M ago
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
BigDBA | Database & Devops Blog
4M ago
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
BigDBA | Database & Devops Blog
5M ago
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
BigDBA | Database & Devops Blog
6M ago
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
BigDBA | Database & Devops Blog
6M ago
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
BigDBA | Database & Devops Blog
11M ago
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
BigDBA | Database & Devops Blog
1y ago
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
BigDBA | Database & Devops Blog
1y ago
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