Posted by Mir Sayeed Hassan on 5th November 2022
How to Prevent an OS Authenticated Oracle User To Connect via SQLPLUS / AS SYSDBA Login to the server [oracle@testdb ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Sat Nov 5 03:24:11 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database… Read more..
Posted in Oracle 12C & 18C | Comments Off on How to Prevent an OS Authenticated Oracle User To Connect via sqlplus / as sysdba
Posted by Mir Sayeed Hassan on 20th September 2022
Oracle 21C New Features: Immutable Tables Overview of Immutable table: – The Functionality of the immutable table is inherits the similar syntax of Native Blockchain Table, but removes the link of internal row records to improve performance. – Benifits of the this immutable table is a read-only table, this can prevent the unauthorized/accidental/hacks/illegal… Read more..
Posted in Oracle 12C & 18C | Comments Off on Oracle 21C New Features: Immutable Tables
Posted by Mir Sayeed Hassan on 18th March 2019
Oracle 18c – Unplug/Plug Pluggable Database (PDB) with RMAN restore & recover The given scenario tested with Oracle 18c(18.3) DB with Preplugin backup, restore & recover, In this case the backup is taken from the PDB before they plugged into a target DB and we are unplugging it form the target DB & plugging into Read More
Posted in Oracle 12C & 18C | Comments Off on Oracle 18c – Unplug/Plug Pluggable Database (PDB) with RMAN restore & recover
Posted by Mir Sayeed Hassan on 14th October 2017
How to connect Oracle 12c database (CDB and PDB) Container Database (CDB) Pluggable Database (PDB) [oracle@ora12c ~]$ !sq sqlplus / as sysdba SQL> show con_name CON_NAME —————————— CDB$ROOT SQL> select… Read more..
Posted in Oracle 12C & 18C | Comments Off on How to connect Oracle 12c database (CDB and PDB)
