Oracle dewdrops - Jul 2024

Dewdrop #11 05-Jul-24

Install Oracle Database 21c on Oracle Linux 8.9

Dewdrop #12 06-Jul-24

Connect two linux machines with ethernet cable or a LAN crossover cable

Dewdrop #13 15-Jul-24

When opening the pluggable database if ypu get below error 

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Check the local_listener init.ora parameter for your database. 

Details are in the link below.    

 

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Dewdrop #14 15-Jul-24

Steps to open a database with a missing datafile

Dewdrop #15 15-Jul-24

To create a RMAN recovery catalog and take an RMAN full backup

Dewdrop #16 16-Jul-24

To restore a database with an RMAN backup after the database has been dropped

Dewdrop #17 16-Jul-24

Oracle JSON : Select Level 1 and Level 2 data

Dewdrop #18 23-Jul-24

Restore a full rman packup of a database on another server

Dewdrop #19 25-Jul-24

JSON select and order level 2 data

Dewdrop #20 27-Jul-24

Materialized view with DB Link error when REFRESH ON COMMIT

Dewdrop #21 31-Jul-24

ORA-04062: timestamp of function has been changed -- How to avoid

Dewdrop #22 31-Jul-24

Dataguard physical standby setup using dataguard broker in Oracle database 21c

Dewdrop #23 02-Aug-24

To Find List of Database objects using a Database link

Thought for the day

The fear of the LORD is the beginning of knowledge.  

Fools despise wisdom and instruction

Proverbs 1:7