• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

oracle 12c

MAX_STRING_SIZE Parameter in Oracle Database

by admin

Oracle Database parameter MAX_STRING_SIZE controls the maximum size of VARCHAR2, NVARCHAR2, and RAW data types in SQL. From Oracle Database 12c onwards, table column(s) length can be modified to greater than 4000 characters when this parameter value is set to EXTENDED. Allowed values for this parameter are: STANDARD: Default value. Means that the length limits […]

Filed Under: oracle, oracle 12c, Oracle 18c, Oracle 19c

Connecting PDB in Oracle 12c and 19c

by admin

To connect as sys or other elevated local users, use the same methods as below, but use ‘as sysdba’ wherever necessary. Method 1 alter session set container = pdbName; Method 2 For other methods, you need to know the service-name for the PDB: – Get the service name for the PDB: SELECT name || ‘ […]

Filed Under: 18c, oracle, oracle 12c, Oracle 18c, Oracle 19c

Establish Connection in CDB and PDB

by admin

When it comes to Multi-tenant architecture, one question that comes to our mind is how to connect to container database and pluggable database. Today we will see all possible ways to connect to the container database. Obviously, we connect database using service name for the non-local connection. When we create CDB, a service is created […]

Filed Under: 18c, oracle, oracle 12c, Oracle 18c, Oracle 19c

How to Use Startup, Shutdown, and Alter Database commands in Oracle 12c

by admin

Before 12c there are only a few commands available for startup and shutdown but if we follow that we end up starting and stopping only cdb. The commands in 12c to start and shutdown the CDB and PDB are a little different than the previous version. Below list of commands were used in earlier versions […]

Filed Under: oracle, oracle 12c, Oracle 18c, Oracle 19c

Out-of-Place Refresh Option: Oracle 12c New Feature

by admin

A new refresh option has been introduced to improve materialized view refresh performance and availability in Oracle Database 12c Release 1. This refresh option is called out-of-place refresh. It uses outside tables during refresh instead of the existing “in-place” refresh that directly applies changes to the materialized view container table. This option works with all […]

Filed Under: oracle, oracle 12c

Oracle Net New Features in Oracle Database 12c

by admin

Oracle Net is the communication software that enables a network session between a client application and an Oracle database. After a network session is established, Oracle Net acts as a data courier for the client application and the database. The following are the new features in Oracle Net Services: Larger Session Data Unit Sizes Oracle […]

Filed Under: oracle, oracle 12c

How to Enable or Disable Veritas ODM for Oracle database 12.1.0.2, 18c and 19c

by admin

This post describes the procedures for Enable/Disable Oracle Disk Manager driver for Oracle Database 12.1.0.2, 18c, and 19c. We assume the Veritas ODM driver is already installed, mounted, and available. Follow the steps outlined below to enable/disable ODM for the Oracle database (note that with different versions of the Solaris OS, the path may change […]

Filed Under: 18c, oracle, oracle 12c, Oracle 19c, VCS

How to Enable or Disable Veritas ODM for Oracle database 12.1.0.1

by admin

This post describes the procedures for Enable/Disable Oracle Disk Manager driver for Oracle Database 12.1.0.1. We assume the Veritas ODM driver is already installed, mounted, and available. Follow the steps outlined below to enable/disable ODM for the Oracle database (note that with different versions of the Solaris OS, the path may change to the ODM […]

Filed Under: oracle, oracle 12c, VCS

How to Connect to an Oracle Pluggable Database (PDB)

by admin

When connecting to a pluggable database, a valid service connection string that points to its service (previously configured and started) MUST always be provided, whether the connection is attempted locally or remotely: $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Fri Jul 30 17:32:15 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. […]

Filed Under: 18c, oracle, oracle 12c

How To Find Creation Time of Oracle Pluggable Database (PDB)

by admin

Below query can be used to for PDB creation/cloning time. COLUMN DB_NAME FORMAT A10 COLUMN CON_ID FORMAT 999 COLUMN PDB_NAME FORMAT A15 COLUMN OPERATION FORMAT A16 COLUMN OP_TIMESTAMP FORMAT A10 COLUMN CLONED_FROM_PDB_NAME FORMAT A15 SELECT DB_NAME, CON_ID, PDB_NAME, OPERATION, OP_TIMESTAMP, CLONED_FROM_PDB_NAME FROM CDB_PDB_HISTORY WHERE CON_ID > 2 ORDER BY CON_ID; Here is a sample output […]

Filed Under: 18c, oracle, oracle 12c

Next Page »

Primary Sidebar

Recent Posts

  • powertop Command Examples in Linux
  • powertop: command not found
  • powerstat: command not found
  • powerstat Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright