Change Default Temporary Tablespace in Oracle

Being Oracle DBA we all are well known about the tablespace. Oracle RDBMS have multiple kinds of a tablespace with a different kind of purpose. We are going to have look on steps use for “Change Default Temporary Tablespace”. Check the current default temporary tablespace SQL> column property_value format a25 SQL> SELECT property_name,property_value FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’; […]

Read More

Incomplete Time Based Recovery in Oracle

Oracle provides different multiple options to have a “backup& recovery” as per the organization’s requirements. Incomplete recovery is one of the types of recovery. Let’s have look on the incomplete recovery. Check the archive log status SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     7 Next […]

Read More

Hot Backup with RMAN in Oracle

We are going to have look on the backup of Oracle, Which is common in DBA’s life. HOT Backup is the most common way to have a backup. Let’s have look on the steps of Oracle’s HOT Backup. Check the archive status SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            […]

Read More

Cold Backup with Rman in Oracle

Today we are going to have look on Cold Backup. Being DBA we are aware of the importance of Backup in Oracle. Different kind of backup has a different kind of uses. Let’s have look on Cold Backup. Steps for Cold Backup SQL> create table cold_back(name varchar(100)); Table created. SQL> insert into cold_back values(‘********* DATA INSERTED […]

Read More

Advantage Of RMAN in Oracle

This post is for those who are new in “Oracle RDBMS”, Being a part of Oracle technology in Database. “RMAN” plays an important part in “Backup&Recovery”. “RMAN” has its own benefits. Let’s have looked over the “RMAN” benefits.     RMAN helps to DBA have incremental where only modified data blocks will be copied It integrity checks for the […]

Read More

TNS-12547: TNS:lost contact

Being DBA we all are aware that we must have knowledge of OS level too because Database not just runs over the only one OS. In a different organization, we have a different OS. Being a part if IT we understand that different OS environment has a different parameter. We have to set them. Today […]

Read More

ORA-12516:TNS protocol stack in Oracle

Let’s start the series of Oracle listener. Now are going to focus over the issue for the following errors. Let’s have looked over the steps and solve the issues. TNS-12516 TNS: listener could not find an instance with the matching protocol stack ORA-12516 TNS: listener could not find available handler with the matching protocol stack […]

Read More

ORA-12505: TNS:listener in Oracle

Being human being we have a lot of unlimited qualities. Listening is one of them. Normally we ignore it but it is most important for all. Good listing keeps us away from 99% problems away and life makes us simple but if we don’t listen properly we invite unlimited problem in our life. In same […]

Read More

How to Purge Listener Log in Oracle

Being DBA we all are aware that Oracle Database makes a connection with a client with the help of listener. Oracle provides the facility to have look over the status of Oracle listen. Being a part of IT we must be aware that 24*7 We require database live but due to some unfortunate conditions database […]

Read More

ORA-12162: TNS:net service name is incorrectly specified

Let’s have look on some listener issues in the database. Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified. Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If […]

Read More