
ORACLE DATABASE PROBLEM AND SOLUTIONS
202 FOLLOWERS
This blog help Oracle DBA to oracle installation, backup, recovery, performance, patching, upgrade, data guard, RAC, RMAN, oracle 9i/10g/11g/12c/18c.
ORACLE DATABASE PROBLEM AND SOLUTIONS
1d ago
To maintain the integrity of the data, there are four properties described in the database management system, which are known as the ACID properties
ACID properties are a set of principles that ensure reliable transaction processing in a database. They stand for:
Atomicity – A transaction is either fully completed or fully rolled back. If one part of the transaction fails, the entire transaction is undone to maintain database integrity.
Example: If you transfer money from one account to another, both debit and credit operations must succeed. If the debit succeeds but the c ..read more
ORACLE DATABASE PROBLEM AND SOLUTIONS
1w ago
Oracle Database vs. Oracle Database Instance
Oracle uses a multi-layered architecture where the database and database instance are distinct yet interconnected. Understanding their differences is key for Oracle DBAs.
1. Oracle Database ?
An Oracle Database is a collection of physical files that store data and metadata. It consists of:
✅ Datafiles (.dbf) – Store actual user and system data.
✅ Control files (.ctl) – Track database structure and SCN.
✅ Redo log files (.log) – Record all changes for recovery.
✅ Temporary & Undo tablespaces – Handle transactions and rollback.
✅ Archived ..read more
ORACLE DATABASE PROBLEM AND SOLUTIONS
1w ago
Oracle Database comes in different editions, each designed for specific use cases, from small businesses to large enterprises. Here’s a breakdown of the available Oracle Database Editions:
1. Oracle Database Standard Edition 2 (SE2)
? Designed for small to medium-sized businesses.
? Supports basic high availability with Oracle RAC (up to 2 nodes).
? Limited to 16 CPU threads (across a maximum of 2 sockets).
? No advanced features like Partitioning, Data Guard, or In-Memory.
? Cost-effective compared to Enterprise Edition.
2. Oracle Database Enterprise Edition (EE)
? Full-featured enter ..read more
ORACLE DATABASE PROBLEM AND SOLUTIONS
1w ago
In this article , I am going to give you brief about what is Oracle database .
Before going to deep dive let's discuss some basic terminology :-
What is Data ?
Data is fact or figures , Data is any collection of facts, statistics, or information that can be stored, processed, and analyzed. It can exist in various forms, such as numbers, text, images, audio, or video.
In computing and databases, data refers to raw information that is stored in structured or unstructured formats.
Structured data: Organized in databases, tables, and spreadsheets (e.g., customer records, sales transactions ..read more
ORACLE DATABASE PROBLEM AND SOLUTIONS
1M ago
postgres=# \set AUTOCOMMIT off
postgres=#
postgres=# \echo :AUTOCOMMIT
off
postgres ..read more
ORACLE DATABASE PROBLEM AND SOLUTIONS
1M ago
postgres=# \s
\d
\l
\l
\c
\c postgres
select pg_backend_pid();
alter user postgres password 'abcd12345';
\c demo
\c
\l
\c
\l
select * from pg_database;
show data_directory
show data_directory;
show data_directory;
select setting from pg_settings;
select * from pg_settings;
show data_directory;
\q
\conninfo
SELECT *
FROM pg_settings
WHERE name = 'port';
\c
\!
\! ls -lrt
\s
\d
\l
\s
postgres ..read more
ORACLE DATABASE PROBLEM AND SOLUTIONS
1M ago
postgres=#
postgres=# \!
bash-4.4$
bash-4.4$
bash-4.4$ ls -la
total 16
drwx------. 3 postgres postgres 79 Jan 15 08:33 .
drwxr-xr-x. 47 root root 4096 Jan 10 12:04 ..
drwx------. 4 postgres postgres 51 Jan 10 12:05 16
-rw-------. 1 postgres postgres 1405 Jan 15 12:17 .bash_history
-rwx------. 1 postgres postgres 391 Jan 15 08:33 .bash_profile
-rw-------. 1 postgres postgres 352 Jan 15 10:00 .psql_history
bash-4.4$
postgres=#
postgres=#
postgres=#
postgres=# \! ls -lrt
total 0 ..read more
ORACLE DATABASE PROBLEM AND SOLUTIONS
1M ago
postgres=# show data_directory;
data_directory
------------------------
/var/lib/pgsql/16/data
(1 row)
postgres ..read more
ORACLE DATABASE PROBLEM AND SOLUTIONS
1M ago
How to check which port running our postgreSQL database ?
[postgres@myserver ~]$ netstat -plunt |grep postgres
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 5963/postgres
tcp6 0 0 ::1:5432 :::*   ..read more