I’m happy to share that I have successfully cleared the Oracle Golden Gate 12c Implementation Specialist certification! This milestone represents a significant step in my professional journey, and I’m eager to apply the knowledge and skills I’ve gained to drive impactful solutions.



#############################!!! Happy Learning !!!################################

Comments

Post a Comment

Popular posts from this blog

Oracle RAC Database QUIESCE Mode

Image
Oracle RAC database quiesce mode is only privileged user can login to database and perform operation. It is restricted mode for DBA operations only. To put RAC database in quiesce mode, use ALTER SYSTEM QUIESCE RESTRICTED Above statement affect all instances in RAC. Database Resource Manager feature must be activated. After all non-DBA session become inactive then database considered as quiesced. The instance from which you put RAC database in quiesce mode, from same instance you have to unquiesce database, using ALTER SYSTEM UNQUIESCE If you have executed ALTER SYSTEM QUIESCE RESTRICTED statement, and oracle database has not finished processing it, then you cannot open database. WE cannot open database if it is already quiesced. ALTER SYSTEM QUIESCE RESTRICTED and ALTER SYSTEM UNQUIESCE statement affect all instances in RAC database. Cold backup cannot be taken when databas...
Read more

PostgreSQL pg_controldata utility

Image
Hello Guys, In this post we are going see a utility provided by PostgreSQL to find information about database cluster.  If we want know information about PostgreSQL cluster like database block size, catalog information,  checkpoint information, WAL segment size, etc. we will use pg_controdata utility. the location of pg_controldata utility will be same as your postgresql installation then bin directory. to execute this utility we have to provide data directory location as parameter. The sample output is attached here. #############################!!! Happy Learning !!!################################
Read more

PostgreSQL Data Types - I

Image
The data type defines what type of data can contain a column. PostgreSQL database is very rich in native data types. It supports all data types specified by SQL and you can add new type using CREATE TYPE command. PostgreSQL support data types to store geometric data, XML data and network address data. We can use arrays, hstore and JSON data types to make things more dynamics. In this post we are going to look at inet and point data types in PostgreSQL. INET Data Type: The INET type is used when you want to store IPv4 or IPv6 addresses. It can also store networks by specifying a netmask. If you try to store something that isn't a valid IP address or network, PostgreSQL will throw an error, so you're basically getting data validation for free. There are a variety of methods you can use in your SQL queries to interrogate IP and network addresses further. postgres=# CREATE TABLE addrs (address INET); CREATE TABLE postgres=# INSERT INT...
Read more