Posts

Image
BRIEF ABOUT  System Activity Reporter System Activity Reporter is an important tool that helps system administrators to get an overview of the server machine with status of different important metrics at different points of time. If suppose you are having an issue with the system currently, Like some of your customers are unable to list some data from the database. The first thing that most of the Linux system administrators do is to recall the same issue when it previously occurred, and If you remember the day of its previous occurrence then you can easily compare the internal system statistics with the current statistics. SAR is very much helpful in doing exactly that. The first thing that we need to do is check and confirm whether you have SAR utility installed on the machine. Which can be checked by listing all rpm's and finding for this utility. SAR is one of the utility inside sysstat.  You can easily download and install it in your machine very easily thro...

RDBMS vs ORDBMS

RDBMS vs ORDBMS  A Relational Database Management System (RDBMS) is a Database Management System (DBMS) that is based on the relational model. Most popular DBMSs currently in use are RDMSs. Object-Relational database (ORDBMS) is also a DBMS that extends RDBMS to support a broader class of applications and attempts to create a bridge between relational and object-oriented paradigms. As mentioned, earlier RDBMS is based on the relational model and data in a RDMS are stored in the form of related tables. So, a relational database can simply be seen as a collection of one or more relations or tables with columns and rows. Each column corresponds to an attribute of the relation and each row corresponds to a record that consists of data values for an entity. RDMSs are developed by extending hierarchical and the network models, which were two previous database systems. Main elements of a RDMS are the concepts of relational integrity and normalization. These concepts are based on t...

different ways to create the pdb in oracle 12c

#different ways to create the pdb in oracle 12c 1)       You can create it by using dbca gui tool Database Configuration Assistant (DBCA) Below is the link for create on oracle-base https://oracle-base.com/articles/12c/multitenant-create-and-configure-pluggable-database-12cr1 2) Now another method is by creating manually Now for that you firstly have to log in into CDB$ROOT By using SQL> ALTER SESSION SET CONTAINER = CDB$ROOT; Now you have to create it manually by using command CREATE PLUGGABLE DATABASE PDB9 ADMIN USER PDB002_ADMIN IDENTIFIED BY oracle storage (maxsize 5G MAX_SHARED_TEMP_SIZE 500M) DEFAULT TABLESPACE sales datafile '/opt/app/oracle/sale.dbf' SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT = ('/opt/app/oracle/oradata/anand_poc/','/opt/app/oracle/new') FILE_NAME_CONVERT for new location of datafiles which it only create system and sysaux tablespace into the new locations that is from above command is ( /opt/...

Transportable Tablespaces

Transportable Tablespaces Transportable tablespaces were introduced in Oracle 8i to allow whole tablespaces to be copied between databases in the time it takes to copy the datafiles. In Oracle 8i one of the restrictions was that the block size of both databases must be the same. In Oracle 9i the introduction of multiple block sizes has removed this restriction. In this article I will run through a simple example of transporting a tablespace between two databases. Setup For this example I'm going to create a new tablespace, user and table to work with in the source database. CONN / AS SYSDBA CREATE TABLESPACE test_data DATAFILE '/u01/app/oracle/oradata/DB11G/test_data01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M; CREATE USER test_user IDENTIFIED BY test_user DEFAULT TABLESPACE test_data TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON test_data; GRANT CREATE SESSION, CREATE TABLE TO test_user; CONN test_user/test_user CREATE TABLE test_tab ( id NUMBE...