Oracle CREATE TABLESPACE

Summary: in this tutorial, you will learn how to use the Oracle CREATE TABLESPACE statement to create a new tablespace in a database. Introduction to the CREATE TABLESPACE statement The CREATE TABLESPACE statement allows you to create a new tablespace. The following illustrates how to create a new tablespace named tbs1 with size 1MB: In this statement: First, specify the name of the … Read more Oracle CREATE TABLESPACE

Oracle Tablespace

Summary: in this tutorial, you will learn about the Oracle tablespace and how Oracle uses tablespaces to logically store the data in the database. What is an Oracle Tablespace Oracle divides a database into one or more logical storage units called tablespaces. In other words, Oracle logically stores data in the tablespaces and physically stores data in datafiles associated … Read more Oracle Tablespace

Oracle SHUTDOWN

Summary: in this tutorial, you will learn how to use the Oracle SHUTDOWN statement to shut down the Oracle Database. Use the SHUTDOWN IMMEDIATE command to shut down the Oracle Database gracefully: Introduction to the Oracle SHUTDOWN statement To shut down a currently running Oracle Database instance, you use the SHUTDOWN command as follows: Let’s examine each option of the SHUTDOWN command. SHUTDOWN NORMAL The SHUTDOWN … Read more Oracle SHUTDOWN

Start Oracle Database

Summary: in this tutorial, you will learn how to use the Oracle STARTUP command to start an Oracle Database instance. To start up a database instance, you use the STARTUP command: When the Oracle Database starts an instance, it goes through the following stages: NOMOUNT, MOUNT, and OPEN. The STARTUP command allows you to control the stage of the database instance. 1) NOMOUNT stage In the NOMOUNT stage, … Read more Start Oracle Database

Oracle Listener

Summary: in this tutorial, you will learn about the Oracle listener and how to use the listener control commands to manage the listener. Introduction to the Oracle Listener The listener is a separate database server process that runs locally on the database server or remotely on the Oracle RAC environment. This picture shows the Oracle … Read more Oracle Listener

Oracle Database Architecture

Summary: in this tutorial, you will learn about the Oracle Database architecture and its components. Oracle Database is an object-relational database management system developed and marketed by Oracle Corporation. Oracle Database is commonly referred to as Oracle RDBMS or simply Oracle. Database and Instance An Oracle Database consists of a database and at least one instance. An instance, or database … Read more Oracle Database Architecture

Oracle Installation Steps

1.login with root user and set kernel parameter Set kernel parameters in /etc/sysctl.conf ————————————————— echo kernel.shmall = 2097152 >> /etc/sysctl.conf echo kernel.shmmax = 536870912 >> /etc/sysctl.conf echo kernel.shmmni = 4096 >> /etc/sysctl.conf echo # semaphores: semmsl, semmns, semopm, semmni >> /etc/sysctl.conf echo kernel.sem = 250 32000 100 128 >> /etc/sysctl.conf echo fs.file-max = 65536 >> … Read more Oracle Installation Steps