article-preview

ORACLE 12C NEW FEATURES 09 – DATABASE TESTING & PATCH QUERYING

Mask-At Source or Mask During Subset
To mask confidential data for non-production use, enterprises needed to make a copy of the production database and then mask the data before sharing it with non-production users such as testers or developers. Masking at the source or masking while subsetting at the source database allows enterprises to provision a secure and reduced size test system directly from the production database without the need for a full production database copy. 

article-preview

ORACLE 12C NEW FEATURES 10 – SECURITY

ORACLE 12C NEW FEATURES 10 – SECURITY
Oracle 12c New Features 10 – Security
Security
The following sections describe the new database security features for Oracle Database 12c Release 1 (12.1).

article-preview

ORACLE 12C NEW FEATURES 10 – SECURITY-2

ORACLE 12C NEW FEATURES 10 – SECURITY-2
htp://ww.ordba.net/oracle/oracle12c/o…es-10-security-2/Security
The following sections describe the new database security features for Oracle Database 12c Release 1 (12.1).
Data Encryption, Hashing and Redaction
The following sections describe the encryption, hashing and redaction features.

article-preview

ORACLE 12C NEW FEATURES 10 – SECURITY-3

ORACLE 12C NEW FEATURES 10 – SECURITY-3
Security
The following sections describe the new database security features for Oracle Database 12c Release 1 (12.1).
Data Encryption, Hashing and Redaction
The following sections describe the encryption, hashing and redaction features.

article-preview

ORACLE 12C NEW FEATURES AND AN UNDERSTANDING

ORACLE 12C NEW FEATURES AND AN UNDERSTANDING TO HELP OURSELVES IN IMPLEMENTING NEW FEATURES.
a. When Oracle 11gR2 premier support ends and we are to buy extended support?
b. That means we have 17 clear months to plan, test and implement.

article-preview

ORACLE 12C NEW FEATURES

ORACLE 12C NEW FEATURES
Oracle 12C new features and an understanding to help ourselves in implemeORACLE 12C NEW FEATURES
Oracle 12C new features and an understanding to help ourselves in implementing new features.
When Oracle 11gR2 premier support ends and we are to buy extended support?
That means we have 17 clear months to plan, test and implement.

article-preview

ORACLE 12C OS REQUIREMENTS SOLARIS 5.10

ORACLE 12C OS REQUIREMENTS SOLARIS 5.10
Oracle 12.1.0. OS Solaris 5.10 requirements
Source document:
https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=149465200197523&id=1517948.1&_afrWindowMode=0&_adf.ctrl-state8zn0sy7k_25

article-preview

ORACLE 11G FEATURES

ORACLE 11G FEATURES
 11g New Features An Overview
 Oracle Advanced Compression - An Oracle White Paper (June 2007)
Real Application Testing Whitepaper
 Real Application Clusters
Performance and Scalability

article-preview

ORACLE 11G PDF DOCUMENTS

ORACLE 11G PDF DOCUMENTS
1 Oracle Advanced Compression
2 Real Application Testing
3 Real Application Testers
4 Performance and Scalability
5 Partitioning

article-preview

AN ANALOGY ON THE ARCHITECTURES OF ORACLE AND ANIMATED LIVING BEING

AN ANALOGY ON THE ARCHITECTURES OF ORACLE AND ANIMATED LIVING BEING
An Analogy on the Architectures of Oracle and Animated Living Being
- By SrinivasMaddali 
Prologue:
To take Oracle more closely than it is to its DBA to Developer, it is necessary that we speak in the terms of audience than in terms of Oracle.

article-preview

ORACLE 12C NEW FEATURES 06 – AQ ENHANCEMENTS

ORACLE 12C NEW FEATURES 06 – AQ ENHANCEMENTS
SrinivasMaddali 
Oracle Database Advanced Queuing Enhancements
The following sections describe Oracle Database Advanced Queuing (AQ) improvements.

article-preview

ARCHIVED LOG FILES

ARCHIVED LOG FILES
What is an archived redo log file?
Oracle enables you to save filled groups of online redo log files to one or more offline destinations, known collectively as the archived redo log, or more simply archive log.

article-preview

HOW TO TURN ARCHIVING ON AND OFF

HOW TO TURN ARCHIVING ON AND OFF???
Doc Id on Metalink 69739.1
Turning Archiving On and Off
You set a database's initial archiving mode as part of database creation.
Usually, you can use the default of NOARCHIVELOG mode at database creation because there is no need to archive the redo information generated at that time.

article-preview

TELL ME HOW MANY BACKGROUND PROCESSES HELP ORACLE INSTANCE TO RUN?

TELL ME HOW MANY BACKGROUND PROCESSES HELP ORACLE INSTANCE TO RUN?
SMON
The System Monitor carries out a crash recovery when a crashed instance is started up again. It also cleans temporary segments. SMON checks the SCN in all datafile headers when the database is started.

article-preview

CATLOG CREATION

CATLOG CREATION
Discussion on creation and use of catalog
(Example scripts as provided by Oracle)
What is to be done in Oracle Version 8.1.x?
SVRMGR> spool create_rman.log
SVRMGR> connect internal
SVRMGR> create user rman identified by rman
temporary tablespace temp
default tablespace rcvcat quota unlimited on rcvcat;

article-preview

CONTROL FILES

CONTROL FILES
How to manage Control Files??
We have discussed briefly the role of control file in an Oracle Database.
The control file of an Oracle database is created at the same time as the database.
A control file is a small binary file that records the physical structure of the database 

article-preview

CONTROL STRUCTURES

CONTROL STRUCTURES
PL/SQL Tutorials - CONTROL STRUCTURES
In this we try to understand IF-THEN, IF-THEN-ELSE and IF-THEN-ELSIF-THEN.
Let me remind you that Boolean means to me not TRUE/FALSE but also NULL. This is true always.

article-preview

CREATE DATA BASE

CREATE DATA BASE
(1) you must be logged in as SYS with SYSDBA privilege invoked.
(2) you must have edited initmynewdb.ora file to spawn an oracle instance
(3) and you started the oracle instance in nomount mode.
(4) after the database is created you are also to create the medata and plsql packages

article-preview

CSSCAN

CSSCAN
(Character Set Scanner)
Introduced in Oracle 8iR2
Metalink Doc Id 123670.1
Before altering the character set of a database, check the convertibility of the data before converting. Character set conversions can cause data loss or data corruption.

article-preview

DATA FILES

DATA FILES
How to manage datafiles??
The earlier discussions are on the control files and redo log files as also archived log files. Control files and redo log files are part of the database files and they count as part of the number of data files a database can have.

article-preview

DATABASE CREATION

DATABASE CREATION
Step 01
Decide on the location of
Three control files (minimum) on different disks/ drives/volumes
Three groups of redo log files, with each group having two members (minimum) on different disks/ drives/volumes Create a file structure for the data files

article-preview

ORACLE 12C DATABASE AUTHENTICATION METHODS FOR THE ADMINISTRATORS

ORACLE 12C DATABASE AUTHENTICATION METHODS FOR THE ADMINISTRATORS
The purpose of differentiating these authentication methods was to differentiate the roles and also secure the database and the docs read “Database Administrators can authenticate database administrators through the data dictionary, (using an account password) like other users. Keep in mind that database passwords are case-sensitive.”

article-preview

DATABASE TESTING AND PATCH QUERYING

DATABASE TESTING AND PATCH QUERYING
Srinivas Maddali
Database Testing
The following sections describe database testing features.
Mask-At Source or Mask During Subset
To mask confidential data for non-production use, enterprises needed to make a copy of the production database and then mask the data before sharing it with non-production users such as testers or developers. 

article-preview

DBNEWID

DBNEWID
D:oracleOra92bin>nid help=yes
DBNEWID: Release 9.2.0.6.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
DBNEWID is a database utility that can change the internal database identifier (DBID) and the database name (DBNAME) for an operational database.

article-preview

HOW ORACLE WORKS

HOW ORACLE WORKS
The following example illustrates an Oracle configuration where the user and associated server process are on separate machines (connected via a network).

article-preview

HOW TO REMOVE STREAMS

HOW TO REMOVE STREAM
01. remove streams
EXEC DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
02. drop queue tables
select OWNER,NAME,QUEUE_TABLE from dba_queues where owner='';

article-preview

HOW TO SPLIT A SINGLE PARTITION INTO MULTIPLE PARTITIONS IN 12C

HOW TO SPLIT A SINGLE PARTITION INTO MULTIPLE PARTITIONS IN 12C‏
APPLIES TO:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later - Information in this document applies to any platform. Oracle 12C supports splitting a partition into more than 2 partitions.

article-preview

INSTALLATION OF ORACLE DATABASE

INSTALLATION OF ORACLE DATABASE
Oracle Installation and Database Development On UNIX and Windows Platforms - A comparison

article-preview

INSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL - REQUIREMENTS‏ (FROM AND BY ORACLE)

NSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL - REQUIREMENTS‏ (FROM AND BY ORACLE)
APPLIES TO:
Oracle Database - Standard Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]

article-preview

LOADING DATA INTO ORACLE TABLES

LOADING DATA INTO ORACLE TABLES
( sp_get_set_and_load )
This doc details the procedure evolved to automate the process of loading the data into Oracle database using SQL*Loader.
The functionality of the procedure:
(1) Go to the destination directory and get the list of the .dat files.

article-preview

LINKS

LINKS
http://sed.sourceforge.net/sedfaq.html
DBA LINKS
The Knowledge center for Oracle Professionals
Documentation OTN

article-preview

LOGICAL STRUCTURES

LOGICAL STRUCTURES
Now that I know what are the physical structures and how I am to care for, please let me know about the logical structures of Oracle database.

article-preview

MAINTENANCE MODE

MAINTENANCE MODE
Avada includes blank pages so you can build all kinds of awesome stuff, like a maintenance mode page!

article-preview

MANAGE TEMPORARY FILES FOR THE DATABASE

MANAGE TEMPORARY FILES FOR THE DATABASE
Command
ALTER DATABASE
(1) Required Privileges
You must have the ALTER DATABASE system privilege.
To specify the RECOVER clause, you must also have the SYSDBA system privilege.

article-preview

METADATA VIEWS

METADATA VIEWS
Oracle_10gR2_Metadata Views PDF

article-preview

MULTITENANT ARCHITECTURE AND MULTI-PROCESS AND MULTI-THREADED

MULTITENANT ARCHITECTURE AND MULTI-PROCESS AND MULTI-THREADED
Information sourced from Oracle Docs.
The multitenant architecture capability enables an Oracle database to function as a multitenant container database (CDB).

article-preview

MV LOG

MV LOG
Determine why that log table is growing
First, determine why the MV log is growing.
This is most likely linked to a registered MView that no longer exists or has not been refreshed for a long time (for example, MViews set to refresh manually or a large time intervals

article-preview

ORA-04030 AND ORA-04031

ORA-04030 AND ORA-04031
ORA-04031 indicates that shared pool configuration is not sufficient to meet that instance requirements. So, shared pool is to be increased. ORA-04031 can be caused if the User profile is NOT as required by Oracle on Oracle Sun Solaris, AIX and HP. I have not used True Unix and hence I do not know.

article-preview

ORA-04045

ORA-04045
What is being done?
I had Oracle 9.2.0.5.0 database
I had a remote 9.0.1.3.1 database
I was testing replication.
I saw some invalid SYSTEM schema replication objects in 9.0.1.3.1

article-preview

INSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL - REQUIREMENTS - ORACLE DOC

INSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL - REQUIREMENTS - ORACLE DOC
You can download Oracle 11.2.0.4 software from My Oracle Support (patch 13390677)
SCOPE
This procedure is meant for those planning/installing Oracle 11gR2 RDBMS release 11.2.0.4.0 (or higher 11.2.0.x version) on Red Hat Enterprise Linux 7.0 (or higher 7.x version) on the 64-bit (x86-64) platform.

article-preview

ORACLE ARCHITECTURE

ORACLE ARCHITECTURE
[accordian class="" id=""]
[toggle title="Raid" open="no"]
Bookmark Fixed font Go to End
Doc ID: Note:38281.1
Subject: RAID and Oracle - 20 Common Questions and Answers

article-preview

ORACLE EDITION AND OPTIONS BUY-ABLE

ORACLE EDITION AND OPTIONS BUY-ABLE
Download and check this execell sheet for information
Oracle Edition and Options Buy-able

article-preview

ORACLE TRINITY

ORACLE TRINITY
How Oracle manages the security to database not in terms of user loggings?
I call this the Oracle Trinity.
The great potential energy is stored in the parameter file that enabled the trinity become active.

article-preview

ORACLE WAIT INTERFACE

ORACLE WAIT INTERFACE
OWI-v7 script by Srinivas Maddali
(NOTE: This script is evolving continuously)
DROP TABLE system.session_event_history;

article-preview

ORADIM

ORADIM
This is a big and voluminous area with large documentation and case studies on the metalink.
There are documented and undocumented utilities provided by Oracle.

article-preview

ORAPWD

ORAPWD
orapwd file=password_file_name_with_complete path password=the_password
orapwd file=password_file_name_with_complete path password=the_password entries = n

article-preview

ORDBA WIZARD

ORDBA WIZARD
This tool is aimed at enabling Oracle DBA to monitor and perform all the jobs of a DBA including creation of database.
This screen is gives all the vital stats that measure performance and information on free space

article-preview

OVERVIEW

OVERVIEW
Oracle Recovery Manager satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats.
A complete high availability and disaster recovery strategy requires dependable data backup, restore, and recovery procedures. 

article-preview

PGA

PGA
Oracle 12c New Features 08 – PGA
Srinivas Maddali 
PGA Size Limit
This feature limits the total amount of Program Global Area (PGA) that an instance can allocate

article-preview

PID FOR ORADEBUG

PID FOR ORADEBUG
How to find PID for setospid in oradebug?
Doc ID: Note:105395.1
PURPOSE
The purpose of this bulletin is to instruct the user how to
get the correct pid for the oradebug command:
oradebug setospid

article-preview

RECOVER_DATABASE

RECOVER_DATABASE
Recover database
(1) Required Privileges
You must have the ALTER DATABASE system privilege. To specify the RECOVER clause, you must also have the SYSDBA system privilege.
(2) Using Parallel Recovery Processes:

article-preview

RECOVERY CATLOG

RECOVERY CATLOG
Setting Up a Recovery Catalog
Oracle 9.1.0.5.0 version
A recovery catalog is not necessary when using RMAN. To use a recovery catalog, you need to create a schema in a recovery catalog database. The catalog will be located in the default tablespace of the scheme. Note that SYS cannot be the owner of the catalog.

article-preview

REDO LOG FILES

REDO LOG FILES
What Oracle says on Redo Log File???
The most crucial and vital structure for recovery operations is the online redo log, which consists of two or more pre-allocated files that store all changes made to the database as they occur.

 

article-preview

REDO RECORDS

REDO RECORDS
How to Control the Writing of Redo Records?
For some database operations, it is possible to control whether redo records are generated. Suppressing redo generation can improve performance, and may be appropriate for easily recoverable operations.

article-preview

REGENERATE DROPPED TABLE

REGENERATE DROPPED TABLE
Oracle 10G New Feature regenerate dropped table
Use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or application error. The time in the past to which the table can be flashed back is dependent on the amount of undo data in the system.

article-preview

REQUIREMENTS

REQUIREMENTS
Oracle 12.1.0. OS Solaris 5.10 requirements
Srinivas Maddali
Source document
https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=149465200197523&id=1517948.1&_afrWindowMode=0&_adf.ctrl-state=s8zn0sy7k_25

article-preview

RESTRICTED SESSION

RESTRICTED SESSION
(1) Required Privileges
You must have the ALTER DATABASE system privilege.
To specify the RECOVER clause, you must also have the SYSDBA system privilege.

article-preview

SAN

SAN
How much Oracle DBA is to know of SAN – Part 1
-Srinivas Maddali
SAN1
SAN2

article-preview

SECURITY

SECURITY
Oracle 12c New Features 10 – Security
Srinivas Maddali
Security
The following sections describe the new database security features for Oracle Database 12c Release 1 (12.1).

article-preview

SEGMENTS II - ROLLBACK SEGMENTS

SEGMENTS II - ROLLBACK SEGMENTS
This discussion is on managing the UNDO segments.
Undo is defined by oracle as:
Every Oracle database must have a method of maintaining information that is used to roll back, or undo, changes to the database.

article-preview

SEGMENTS IV - PARTITIONED TABLES

SEGMENTS IV - PARTITIONED TABLES
Partitioned Tables
Introduced with Oracle8, Oracle partitioning has matured over the years, through Oracle8i and Oracle9i.
From the stage of stripping the datafiles across the disks for better IO

article-preview

SEGMENTS PART I

SEGMENTS PART I
Each tablespace hosts segments. There are many types of segments.
CACHE
CLUSTER
INDEX
INDEX PARTITION
INDEX SUBPARTITION
LOBINDEX

article-preview

SEGMENTS PART V - INDEX ORGANIZED TABLES

SEGMENTS PART V - INDEX ORGANIZED TABLES
Partitioning and IOT
In Oracle 8 and 8.1 Index Organized Tables (IOT) are partitioned on RANGE only. Oracle 9 enables IOT to have hash partitions also.
Before any further discussion on IOT let us recapitulate IOT concepts.

article-preview

SEGMENTS PART VII TEMPORARY SEGMENTS

SEGMENTS PART VII TEMPORARY SEGMENTS
Oracle has tons of Info on Metalink read and use that as you evolve
Oracle over a period evolved the temporary segments and their usage. Evolution is from permanent tablespace with temporary contents to temporary tablespace with tempfile to temporary tabelspace groups. Most importantly all these evolutionary phases are still available depending upon choices.

article-preview

SET DEFAULT TABLESPACE AND TEMPORARY TABLESPACE FOR THE DATABASE

SET DEFAULT TABLESPACE AND TEMPORARY TABLESPACE FOR THE DATABASE
Set Default Tablespace and Temporary Tablespace
ALTER DATABASE
(1) Required Privileges
You must have the ALTER DATABASE system privilege.
To specify the RECOVER clause, you must also have the SYSDBA system privilege.

article-preview

SINGLE PARTITION INTO MULTIPLE PARTITION

SINGLE PARTITION INTO MULTIPLE PARTITION
APPLIES TO:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later - Information in this document applies to any platform. Oracle 12C supports splitting a partition into more than 2 partitions.

article-preview

SOME EASY TO USE TOOLS

SOME EASY TO USE TOOLS
#!/usr/bin/ksh
# source the database instance to be monitored like ORACLE_SID, ORACLE_BASE, ORACLE_HOME ... saved by you to a .profile
$ORACLE_HOME/bin/sqlplus "/ as sysdba" << eof set echo off set trim on set trims on set verify off spool $ORACLE_BASE/log/errors.log select distinct originating_timestamp

article-preview

SOME ONE SAID

SOME ONE SAID
Featuring a multi-tenant architecture that streamlines the process of consolidating databases onto the cloud and enables organizations to manage many databases as one, Oracle Database 12c is a next-generation database.

article-preview

7 EASY STEPS TO CONFIGURE HUGEPAGES FOR YOUR ORACLE DATABASE SERVER

7 EASY STEPS TO CONFIGURE HUGEPAGES FOR YOUR ORACLE DATABASE SERVER
22. September 2016
Sebastian Winkler
Uncategorized

article-preview

ARCHITECTURE OF THE CENTRAL PROCESSING UNIT (CPU)

ARCHITECTURE OF THE CENTRAL PROCESSING UNIT (CPU)
From Computer Science Wiki
Jump to:navigation, search
This is a basic concept in computer science
A central processing unit (CPU) is the electronic circuitry within a computer that carries out the instructions of a computer program by performing the basic arithmetic, logical, control and input/output (I/O) operations specified by the instructions.

article-preview

C FILE EXTENSION

C FILE EXTENSION

File Extension

Type of File

Example

.c

C source file

techonthenet.c

.cc

C++ source file

techonthenet.cc

.cpp

C++ source file

techonthenet.cpp

article-preview

CAUSES AND SOLUTIONS FOR DGMGRL ORA-16664 DATA GUARD BROKER DOC ID 2494260.1

CAUSES AND SOLUTIONS FOR DGMGRL ORA-16664 DATA GUARD BROKER DOC ID 2494260.1
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

article-preview

CENTOS PACKAGE REPOSITORY

CENTOS PACKAGE REPOSITORY
Anyone that is running a modern Operating System is most likely utilizing TCP/IP to send and receive data. Modern TCP/IP stacks are somewhat complex and have a slew of tunables to control their behavior. The choice of when and when not to tune is not always super clear cut, since documentation and the advice of various network “experts” doesn’t always jive.

article-preview

CERT_INSIDER_TRADING

CERT_INSIDER_TRADING

article-preview

CHANGES IN ORACLE DATABASE SECURITY 18C

CHANGES IN ORACLE DATABASE SECURITY 18C
Oracle Database Security Guide for Oracle Database 18c has new security features.
Ability to Create Schema Only Accounts
a.   You now can create schema only accounts, for object ownership without allowing clients to log in to the schema.

article-preview

CONFIGURATION SERVICES ISSUES (CS OR BCS) ON APPS DB PRODUCTS SCHEMA

CONFIGURATION SERVICES ISSUES (CS OR BCS) ON APPS DB PRODUCTS SCHEMA
Wednesday, May 10, 2017
​Configuration Services are configurations that the customer can use modify to change the call behavior. For example, they can modify the call flow to play special prompts like "Back to School Special ...".

article-preview

CONFIGURE_STREAMS

CONFIGURE_STREAMS
connect SYS/&sys_pwd_source@STRM1.NET as SYSDBA
create user STRMADMIN identified by STRMADMIN;
ALTER USER STRMADMIN DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;

article-preview

CONFIGURE_STREAMS_1

CONFIGURE_STREAMS_1
connect SYS/&sys_pwd_source@STRM1.NET as SYSDBA
create user STRMADMIN identified by STRMADMIN;
ALTER USER STRMADMIN DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;

article-preview

CREATING DUPLICATE DATABASE FROM RMAN USING THE BACKUPS DONE AT OS LEVEL DOC ID 419144.1

CREATING DUPLICATE DATABASE FROM RMAN USING THE BACKUPS DONE AT OS LEVEL DOC ID 419144.1
Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later

article-preview

DATA WAREHOUSING

ATA WAREHOUSING
Automatic Indexing
The automatic indexing feature automates index management tasks, such as creating, rebuilding, and dropping indexes in an Oracle Database based on changes in the application workload.
This feature improves database performance by managing indexes automatically in an Oracle Database.

article-preview

DATABASE AND DATAPUMP ENHANCEMENTS

DATABASE AND DATAPUMP ENHANCEMENTS
Ability to Create a Duplicate of an Oracle Database Using DBCA in Silent Mode
You can now create a duplicate of an Oracle Database by using the createDuplicateDB command of Database Configuration Assistant (DBCA) in silent mode.

article-preview

DATAGUARDOBSERVERFSFO

DATAGUARDOBSERVERFSFO
set serveroutput on
declare
v_status integer;
v_threshold number; --This value can be from any table that record application timeout values for example.

article-preview

DBCA SILENT MODE NEW FEATURES IN DATABASE 19C DOC ID 2477805.1

DBCA SILENT MODE NEW FEATURES IN DATABASE 19C DOC ID 2477805.1
APPLIES TO:
Oracle Database Configuration Assistant
Information in this document applies to any platform.

article-preview

DGMGRL_OBSERVER

DGMGRL_OBSERVER
create configuration dgptfm_lab as primary database is 'dgptfm_lab2' connect identifier is 'dgptfm_lab2';
add database 'dgptfm_lab1' as connect identifier is 'dgptfm_lab1' maintained as physical;

article-preview

DIAGONALIZABILITY, PERFORMANCE AND SECURITY IN 19C

DIAGONALIZABILITY, PERFORMANCE AND SECURITY IN 19C
Oracle Trace File Analyzer Support for Using an External SMTP Server for Notifications.
In Oracle Database 19c, you can use an external Simple Mail Transfer Protocol (SMTP) server to receive Oracle Trace File Analyzer notifications.

article-preview

ENCRYPTED_DATA_OB_02262020

ENCRYPTED_DATA_OB_02262020
ATTRIBUTE table in various databases
OLTP (pt135) Seattle

article-preview

EXECUTIVESUMMARY 4.3 - CHD DATA STORAGE (003) MS

Executive Summary – 4.3 Cardholder data storage
Please have the below table completed and returned.
4.3 Cardholder data storage
Identify and list all databases, tables, and files storing post-authorization cardholder data and provide the following details.

article-preview

GLOBAL DATA PRIVACY

GLOBAL DATA PRIVACY

article-preview

GOLDENGATE CLASSIC AND INTEGRATED MODES AND SWITCHING FROM ONE MODE TO ANOTHER

GOLDENGATE CLASSIC AND INTEGRATED MODES AND SWITCHING FROM ONE MODE TO ANOTHER SRINIVAS MADDALI
This documentation is valid for only Oracle RDBMS.

article-preview

GUIDED SR: ORA 600 [KSSRMP1] (DOC ID 2422621.1)

GUIDED SR: ORA 600 [KSSRMP1] (DOC ID 2422621.1)
APPLIES TO:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

article-preview

HOW TO INSTALL/UNINSTALL EXPRESSION FILTER FEATURE OR EXFSYS SCHEMA ALONG WITH RULES MANAGER (DOC ID 258618.1)

HOW TO INSTALL/UNINSTALL EXPRESSION FILTER FEATURE OR EXFSYS SCHEMA ALONG WITH RULES MANAGER (DOC ID 258618.1)
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]

article-preview

SOLARIS 10: HOW TO INSTALL LOGROTATE PACKAGE

SOLARIS 10: HOW TO INSTALL LOGROTATE PACKAGE
(https://lucamerello.wordpress.com/2014/04/13/solaris-10-how-to-install-logrotate-package/)
Logrotate is a great utility designed to administer many large log files generated by the operating system or applications that run on it.

article-preview

HOW TO REVERSE ENGINEER FROM ORACLE SCRIPT

HOW TO REVERSE ENGINEER FROM ORACLE SCRIPT
Launch erwin DM
Go to the menu Actions, Reverse Engineer
Pick Oracle as the DBMS

article-preview

HOW TO UPGRADE FROM GOLDENGATE CLASSIC EXTRACT TO INTEGRATED EXTRACT DOC ID 1484313.1

HOW TO UPGRADE FROM GOLDENGATE CLASSIC EXTRACT TO INTEGRATED EXTRACT DOC ID 1484313.1
APPLIES TO:
Oracle GoldenGate - Version 11.2.1.0.0 and later
Information in this document applies to any platform.

article-preview

INSTALL ORACLE DATABASE 19C WITH AUTOMATIC ROOT SCRIPTS EXECUTION

NSTALL ORACLE DATABASE 19C WITH AUTOMATIC ROOT SCRIPTS EXECUTION
Before You Begin
This 15-minute tutorial shows you how to install the Oracle Database 19c with automated root scripts execution.

article-preview

INSTALLING ORACLE

INSTALLING ORACLE.USING OUIDOCX
Oracle Installation can be done in multiple ways.
01. Using Oracle Universal Installer (OUI)
02. Using Oracle Response Files
03. Using Tar Balls - previously created from a running database and 
04. Using Tar Balls - created for the new installations using 01 or 02 methods

article-preview

IS IT SUPPORTED TO DO A TRANSPORT TABLESPACE (TTS) IMPORT WITH DATA PUMP ON A TABLESPACE WITH BINARY XML OBJECTS? DOC ID 1908140.1

IS IT SUPPORTED TO DO A TRANSPORT TABLESPACE (TTS) IMPORT WITH DATA PUMP ON A TABLESPACE WITH BINARY XML OBJECTS? DOC ID 1908140.1
APPLIES TO:
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.8.0 [Release 10.1 to 12.1]

article-preview

LINUX DOWNLOADS POSTGRESQL INSTALLATION

LINUX DOWNLOADS POSTGRESQL INSTALLATION
Quick Links
Downloads
Binary
Source
Software Catalogue
File Browser

article-preview

NEW_PARAM_12.2.0

NEW_PARAM_12.2.0
Right now, Roy and I are in the final steps to refresh our big slide deck to the new layout, but more important, to have Oracle 12.1.0.2 information included as well (were necessary). 

article-preview

ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KJBRCHKIN:WGL] (DOC ID 2420500.1)

ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KJBRCHKIN:WGL] (DOC ID 2420500.1)
APLIES TO:https://support.oracle.com/epmos/adf/images/t.gif
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

article-preview

ORACLE - MANAGING THE CORRUPTION

ORACLE - MANAGING THE CORRUPTION
Oracle database corruption and recovery
Srinivas Maddali
In this document, I discussed various possible corruptions (HW and SW) and recovery and salvage processes. Many MOS docs and Oracle Docs and my experiences put together is this document.

article-preview

ORACLE DATA GUARD OBSERVER INSTALLATION

ORACLE DATA GUARD OBSERVER INSTALLATION
Oracle Data Guard is included with the Enterprise Edition and Personal Edition of the Oracle database software. You can manage a Data Guard configuration by using either SQL*Plus, the Data Guard broker's command-line interface (DGMGRL), or a compatible version of Oracle Enterprise Manager Grid Control.

article-preview

ORACLE GOLDENGATE UPGRADE

ORACLE GOLDENGATE UPGRADE
(Based on Oracle GG docs 19c)
Prerequisites:
Before performing the upgrade procedure, read the Release Notes for Oracle GoldenGate to determine whether the new release affects the following in your configuration:
New default process behavior.
Parameters that changed or were deprecated.

article-preview

REQUIRED STEPS TO RECREATE A CAPTURE PROCESS. DOC ID 471695.1

REQUIRED STEPS TO RECREATE A CAPTURE PROCESS. DOC ID 471695.1
APPLIES TO:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]

article-preview

REST, SOCIAL SIGN-IN, SQL*NET, DATA GUARD, AUTOMATED INDEXES, DISTINCT ON LISTAGG (ANALYTICAL FUNCTION), RESTORE POINTS PROPAGATION TO STANDBY, FINE GRAINED SUPPLEMENTAL LOGGING AND OBSERVER CHANGES

REST, SOCIAL SIGN-IN, SQL*NET, DATA GUARD, AUTOMATED INDEXES, DISTINCT ON LISTAGG (ANALYTICAL FUNCTION), RESTORE POINTS PROPAGATION TO STANDBY, FINE GRAINED SUPPLEMENTAL LOGGING AND OBSERVER CHANGES
Useful for application development:
REST Enabled SQL Support

article-preview

RMAN AND EMC DD ISSUE WITH AN ARCHIVE LOG WHEN RUNNING A RESTORE ON 1 OF 3 SERVERS (DOC ID 2116741.1)

RMAN AND EMC DD ISSUE WITH AN ARCHIVE LOG WHEN RUNNING A RESTORE ON 1 OF 3 SERVERS (DOC ID 2116741.1)
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
 

article-preview

SRDC_MOS

KNOWLEDGE ARTICLE

Knowledge Article

Product Area

Last Updated

SRDC - Required Diagnostic Data Collection for Segment Corruption (Table, Index, LOB, etc)

Oracle Database Exadata Cloud Machine Oracle Database Cloud Exadata Service Oracle Database Exadata Express Cloud Service Oracle Database Cloud Service Oracle Database - Standard Edition Oracle Cloud Infrastructure - Database Service Oracle Database - Enterprise Edition Oracle Database Cloud Schema Service Oracle Database - Personal Edition Oracle Database Backup Service 

Mon, 19 Aug 2019 07:42 GMT-08:00

article-preview

SYSLOG.DOC

SYSLOG
syslog.conf
- configuration file for syslogd system log daemon
Synopsis
/etc/syslog.conf
Description
The file /etc/syslog.conf contains information used by the system log daemon, syslogd(1M), to forward a system message to appropriate log files and/or users

article-preview

Migrate from Oracle to Mircrosoft SQL Server

Agenda

  • What motivates customers to upgrade?
  • Migration methodology
  • Migration tools
  • Demos
  • Q&A

article-preview

Immutable Tables in Oracle Database 19c and 21c

Immutable Tables in Oracle Database 19c and 21c

An immutable table is a tamper-proof, insert-only table with an associated table-level and row-level retention period. They are similar to blockchain tables, but the rows are not chained using cryptographic hashes.

Blockchain tables were introduced in 21c and backported to 19.10. Immutable tables were introduced to Oracle 21.3 and 19.11 at the same time, so it could be considered a 19c and 21c new feature.

When learning about immutable tables, be careful not to set excessively long retention periods, or you will have to wait a long time to drop your test tables.

 

article-preview

Neural networks

Neural Networks

Neural Networks are a powerful machine learning algorithm, allowing you to create complex and deep learning neural network models to find hidden patterns in your data sets. Neural Networks are available with Oracle 18c and can be easily built and used to make predictions using a few simple SQL commands.

article-preview

Blockchain Tables in Oracle Database 21c

Blockchain Tables in Oracle Database 21c
A blockchain table is a tamper-proof, insert-only table with an associated table-level and row-level retention period. Rows are organised into chains, with each row containing a hash of the data contained in the row, and the hash of the previous rows data.

This feature has been backported to Oracle 19.10, but also requires patch 32431413 and the COMPATIBLE parameter set to 19.10.0 or later. From 19.11 the additional patch is not required.

When learning about blockchain tables, be careful not to set excessively long retention periods, or you will have to wait a long time to drop your test tables.

article-preview

Oracle Database Migration with an Oracle GoldenGate Hub Configuration

This Oracle GoldeGate Maximum Availability Architecture (MAA) migration solution provides step-bystep instructions to set up and migrate any 11g Release 2 and later Oracle database, from any system platform (e.g. AIX, HP UX, Linux), from a single tenant to a multitenant architecture, or from a database not using Transparent Data Encryption (TDE) to a TDE database.

These same MAA best practices are generally applicable while migrating between on-premises or cloud source and target database systems, although cloud-specific details will be outlined in a separate paper.