Database Blog

MIGRATING 19C DATABASE FROM LINUX TO WINDOWS.

INTRODUCTION The below steps showes us how to migrate a 19c database using Transportable Tablespace. MIGRATION FROM LINUX TO WINDOWS MIGRATION FROM LINUX TO WINDOWS BY TRANSPORTABLE TABLESPACE CREATED A TABLESPACE CREATED A TABLE BY HAVING DEFAULT TABLESPACE AS TBS(CREATED TABLESPACE),   EXECUTED THE DBMS_TTS.TRANSPORT_SET_CHECK FOR TRANSPORTING TABLESPACE TBS THAT IS TRUE, ALSO CHECKED IF THERE IS ANY VIOLATIONS   CHECKED THE ENDIAN FORMAT ON BOTH THE PLATFORMS PERFORMED EXPORT BY DATAPUMP FOR TRANSPORT TABLESPACE   DATABASE IN THE WINDOWS PLATFORM   PERFORMED AN IMPORT IN THE TARGET PLATFORM   AFTER THE IMPORT HECK WHETHER THE TABLESPACE IS AVAILABLE AND MAKE IT READ WRITE, CHECK FOR THE TABLE CREATED WITH DEFAULT TABLESPACE(TBS)

Read More

Steps to scp file from one server to another server in oracle cloud

INTRODUCTION: The below steps shows us how to enable the scp for file transfers in oracle cloud. Open the puttygen Import the target server ppk file It will ask for the target server ppk file we are going to scp Select the file and click open The ssh keys will be generated. Select the Export OpenSSH Key Save the File with ssh extension move the file to source server in /etc/ssh folder Now we are able to move the pfile to target server.

Read More

Moving Table from one tablespace to another tablespace

    The alter table  move command moves rows down into un-used space and adjusts the HWM but does not adjust the segments extents, and the table size remains the same. …

Read More

RMAN – Backup Based Clone

RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server…

Read More

Recycle Bin in Oracle

  Oracle database has the recycle bin which is a data dictionary table and contains information about dropped objects.  Until we don’t use the purge option, all dropped tables and…

Read More

Useful TFACTL Commands

1. Check tfactl status with version: tfactl status 2. Check tfactl tool status: tfactl toolstatus 3. Get config details: tfactl print config 4. List of user having access to tfactl:…

Read More

PDB Lockdown Profiles In Oracle 12.2

ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user operations in pluggable databases (PDBs). Create a…

Read More

SGA TARGET ADVISORY IN ORACLE

The V$SGA_TARGET_ADVICE view provides information that helps us in deciding optimal value for  SGA_TARGET. MMON background process gather statistics about sga_target usage and update the V$SGA_TARGET_ADVICE view. Check sga target advisory is…

Read More

Query To Find Dependent Objects Of An Invalid Object

SELECT owner, object_type, object_name FROM dba_objects WHERE status = ‘INVALID’ AND object_name IN (SELECT referenced_name FROM dba_dependencies WHERE name = ‘<INVALID_OBJECT_NAME>’);

Read More

Query to Check locks on a table

Select object_id, session_id, oracle_username, os_user_name, Process, locked_mode From sys.v_$locked_object; Select a.object_name, b.oracle_username From all_objects a, v$locked_object b Where a.object_id = b.object_id And a.object_name like ‘po%’;

Read More