SiteMap

11gR2

1. DATABASE NAME MAX SIZE in ORACLE

23AI

1. Unlocking Oracle 23c AI's JSON Relational Duality: Simplifying Data Handling for Modern Applications - New!

ADR

1. TNS-01251: Cannot set trace/log directory under ADR

ASCII values

1. chr function and its values - CHR and ASCII values

ASM

1. Adding disk group to ASM instance using ASMCA
2. Adding disks to ASM library
3. create shared disks (vdi) on Virtualbox for ASM - vboxmanage command line

ASMCA

1. Adding disk group to ASM instance using ASMCA

Auditing

1. AUDIT DDLS in database with trigger
2. Audit failed logon attempts - Oracle
3. Auditing DDL changes in Oracle Database
4. Automate Kill SNIPED SESSION Oracle Database
5. DELETE OS AUDIT FILES IN ORACLE
6. Enable Database Auditing in oracle
7. How To Shrink Table AUD$
8. Inserting Data into table with DML Error Logging (catching errors whiles inserting data into table)
9. LAST DDL change time on a table in ORACLE
10. Oracle Table Monitoring - DML ACTIVITY
11. Oracle audting explained
12. PLSQL code to audit all (similar) tables in schema - oracle
13. Trigger to backup the data before delete or update on a table - Oracle
14. Trigger to disable create objects in database starting with TMP or BAK
15. find the LAST_DDL_TIME change time of an Oracle object

CHR

1. chr function and its values - CHR and ASCII values

CPU patching

1. Applying CPU Patch On Primary Database Server Environment
2. Applying CPU Patch in a dataguard (Physical Standby) environment

Constraints

1. Create a PrimaryKey on existing table without unique values

Control File

1. Create Control file manually - Oracle

DBMS_JOBS

1. Configure email server to send job notifcations- Oracle

Database Load capture

1. Oracle Database Load Capture

EXPDP/IMPDP

1. Generate sql file from datapump export
2. IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE
3. ORA-39021: Database compatibility version 11.2.0.4.4.4.4 is not supported.
4. Restore a schema from full expdp backup
5. expdp content=data_only
6. import a single table from a full export backup in oracle - New!
7. restore single table from expdp full backup

Education

1. Connecting to CDB and PDB - Oracle 12c
2. Dropping large columns in database - ORACLE
3. OCA 1Z0-051 dumps

Feature

1. CREATE INVISIBLE INDEX ON A TABLE
2. Create Temporary Tables in Oracle
3. Dropping large columns in database - ORACLE
4. Online table redefination
5. Unlocking Oracle 23c AI's JSON Relational Duality: Simplifying Data Handling for Modern Applications - New!
6. chr function and its values - CHR and ASCII values
7. select from table with no direct relation or foriegn keys

Flash_recovery_area

1. Flashback Database setup in Oracle

Generate DDL

1. Generate sql file from datapump export

Grid Infrastructure

1. Adding disk group to ASM instance using ASMCA

High Availabilty

1. CHANGE STANDBY DATABASE PROTECTION MODE
2. CREATE ORACLE DATABASE SERVICE
3. ENABLE REAL TIME APPLY ON STANDBY DATABASE

Invisible Index

1. CREATE INVISIBLE INDEX ON A TABLE

Kill Sessions

1. ALTER SYSTEM KILL SESSION
2. Automate Kill SNIPED SESSION Oracle Database

LISTAGG

1. Retrieve data from column as a row - Using LISTAGG function - Oracle

Linux

1. java.lang.SecurityException: The jurisdiction policy files are not signed by a trusted signer
2. Linux commands
3. UNIX Permissions - table
4. create shared disks (vdi) on Virtualbox for ASM - vboxmanage command line
5. uninstall java on linux

ORA-00020

1. ORA-00020: maximum number of processes exceeded

ORA-14074

1. ORA-14074: partition bound must collate higher than that of the last partition
2. ORA-14074: partition bound must collate higher than that of the last partition

ORA-17629

1. RMAN-06820: WARNING: failed to archive current log at primary database

ORA-39021

1. ORA-39021: Database compatibility version 11.2.0.4.4.4.4 is not supported.

Opatch

1. set up the OPatch environment variable for Oracle Patching - New!

Oracle 12c

1. Connecting to CDB and PDB - Oracle 12c
2. Step by Step installation oracle 12c database on Linux 6 (centos)

Oracle Maintenance

1. Is it safe to move/recreate alertlog while the database is up and running
2. ORA-00020: maximum number of processes exceeded
3. Oracle Resource Manager: Granular Control for Managing Idle Sessions - New!
4. Plsql Package to receive an Oracle Database AWR Report sent to EMAIL

Oracle Patching

1. Applying CPU Patch On Primary Database Server Environment
2. Applying CPU Patch in a dataguard (Physical Standby) environment
3. BACKUP ORACLE HOME AND INVENTORY
4. Oracle Which Patch has been applied?
5. set up the OPatch environment variable for Oracle Patching - New!

Oracle Security

1. TNS-00583: Valid node checking: unable to parse configuration parameters
2. Enable Database Auditing in oracle
3. Find accounts unused for days
4. How Secure Can We Make Our Oracle Databases?
5. ORA-24247: network access denied by access control list
6. Oracle Database files to be excluded in Anti-virus or any third party tools scan
7. Oracle user profile setup guide
8. Restricting database access to IP addeess using sqlnet.ora
9. Simple Oracle Plsql Package for password encryption and decryption - New!
10. Trigger to backup the data before delete or update on a table - Oracle
11. Using special characters in ORACLE DB passwords
12. configure complex password (password verify function) in oracle database
13. select grants on tables to users or roles

PRCF-2010

1. [PRCF-2010 : All connections to the remote nodes got refused. Cannot proceed with the file transfer. There has to be at least one remote node to send the installer files!

Performance

1. Automating Oracle ADDM Reports with PL/SQL: A Guide to Sending Performance Reports via Email
2. CREATE INVISIBLE INDEX ON A TABLE
3. Create Temporary Tables in Oracle
4. ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
5. Online table redefination
6. Oracle Shrink Table - regain your space back
7. Plsql Package to receive an Oracle Database AWR Report sent to EMAIL
8. Using Index Hints in oracle

PrimaryKey

1. Create a PrimaryKey on existing table without unique values
2. select from table with no direct relation or foriegn keys

RAC

1. Adding disk group to ASM instance using ASMCA
2. PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing - Oracle installation requires old rpm versions, what to do?
3. RAC - Missing Cvuqdisk package
4. [PRCF-2010 : All connections to the remote nodes got refused. Cannot proceed with the file transfer. There has to be at least one remote node to send the installer files!
5. create shared disks (vdi) on Virtualbox for ASM - vboxmanage command line

RMAN

1. RMAN FULL database recovery scenerio
2. RMAN-06820: WARNING: failed to archive current log at primary database
3. Restore and recover database from RMAN backup - DB in No archive log mode
4. Restoring archive logs from an RMAN backup - New!
5. Rman Recovery comands....
6. Rman System datafile recovery scenerio
7. delete noprompt obsolete archive log - RMAN
8. restore archive logs from backup

Real time apply

1. Real Time Log Apply on Standby Database

Resource Manager

1. Oracle Resource Manager: Granular Control for Managing Idle Sessions - New!

SQLSERVER

1. SQLSERVER QUERIES - SQLSERVER2015

STANDBY DATABASE

1. ARCHIVE LOG Switch - shell script (for Oracle)
2. CHANGE STANDBY DATABASE PROTECTION MODE
3. Configure second physical standby database - Oracle
4. ENABLE REAL TIME APPLY ON STANDBY DATABASE
5. FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY
6. OPEN STANDBY DATABASE IN READ ONLY
7. ORACLE FAL_CLIENT and FAL_SERVER explained
8. RMAN-06820: WARNING: failed to archive current log at primary database
9. Real Time Log Apply on Standby Database
10. database switch over using dgmgrl
11. restore archive logs from backup

Shrink table

1. Oracle Shrink Table - regain your space back

TNS-00583

1. TNS-00583: Valid node checking: unable to parse configuration parameters

Temp Tables

1. Create Temporary Tables in Oracle

Terminate Session

1. Identify and Terminate Sessions in oracle - New!

UniqueKey

1. Create a PrimaryKey on existing table without unique values

Views

1. Create Materialized Views

administration

1. ALTER SYSTEM KILL SESSION
2. Optimizing Storage and Performance with Oracle Database Advanced Compression - New!
3. java.lang.SecurityException: The jurisdiction policy files are not signed by a trusted signer
4. Automate Kill SNIPED SESSION Oracle Database
5. CHANGE STANDBY DATABASE PROTECTION MODE
6. CREATE ORACLE DATABASE SERVICE
7. Count rows in all tables in a schema
8. Create Control file manually - Oracle
9. Create Temporary Tables in Oracle
10. Drop all tables in a schema
11. Enable Database Auditing in oracle
12. IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE
13. Identify and Terminate Sessions in oracle - New!
14. Inserting Data into table with DML Error Logging (catching errors whiles inserting data into table)
15. Is it safe to move/recreate alertlog while the database is up and running
16. LAST DDL change time on a table in ORACLE
17. OPEN STANDBY DATABASE IN READ ONLY
18. ORA-00020: maximum number of processes exceeded
19. ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
20. ORA-39021: Database compatibility version 11.2.0.4.4.4.4 is not supported.
21. ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener
22. Online table redefination
23. Oracle Database files to be excluded in Anti-virus or any third party tools scan
24. PLSQL code to audit all (similar) tables in schema - oracle
25. Using special characters in ORACLE DB passwords
26. chr function and its values - CHR and ASCII values
27. configure complex password (password verify function) in oracle database
28. expdp content=data_only
29. select from table with no direct relation or foriegn keys
30. select grants on tables to users or roles

alertlog

1. Is it safe to move/recreate alertlog while the database is up and running

alter table set column unused

1. Dropping large columns in database - ORACLE

archive logs

1. ARCHIVE LOG Switch - shell script (for Oracle)
2. Restoring archive logs from an RMAN backup - New!

cmdline

1. run sql from windows cmd prompt CLI

compression

1. Optimizing Storage and Performance with Oracle Database Advanced Compression - New!

database-restore

1. Restore and recover database from RMAN backup - DB in No archive log mode
2. restore single table from expdp full backup

datagaurd

1. CHANGE STANDBY DATABASE PROTECTION MODE
2. ENABLE REAL TIME APPLY ON STANDBY DATABASE
3. FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY
4. OPEN STANDBY DATABASE IN READ ONLY
5. Real Time Log Apply on Standby Database
6. database switch over using dgmgrl

dgmgrl

1. CHANGE STANDBY DATABASE PROTECTION MODE
2. database switch over using dgmgrl

drop tables

1. Drop all tables in a schema

error

1. TNS-00583: Valid node checking: unable to parse configuration parameters
2. Failed to auto-stop Oracle Net Listener using ORACLE_HOME/bin/tnslsnr
3. Inserting Data into table with DML Error Logging (catching errors whiles inserting data into table)
4. ORA-00020: maximum number of processes exceeded
5. ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
6. ORA-14074: partition bound must collate higher than that of the last partition
7. bash: /bin/install/.oui: No such file or directory
8. dbstart: line 275: ORACLE_HOME_LISTNER: command not found

exclude=table

1. Exclude some tables from schema export

expd

1. Exclude some tables from schema export

export/import

1. Export table data with filtered clause - Query based export (oracle expdp)
2. Exporting partitions from a Partitioned tables
3. IMPDP TABLE_EXISTS_ACTION = APPEND, REPLACE, [SKIP] and TRUNCATE
4. ORA-31633: unable to create master table ".SYS_IMPORT_FULL_05"
5. Restore a schema from full expdp backup
6. restore single table from expdp full backup

index

1. CREATE INVISIBLE INDEX ON A TABLE

indexes

1. CREATE INVISIBLE INDEX ON A TABLE
2. Using Index Hints in oracle

installation

1. Step by Step installation oracle 12c database on Linux 6 (centos)
2. bash: /bin/install/.oui: No such file or directory
3. prvf-0002 : could not retrieve local node name

java

1. java.lang.SecurityException: The jurisdiction policy files are not signed by a trusted signer
2. uninstall java on linux

listener

1. TNS-00583: Valid node checking: unable to parse configuration parameters
2. CREATE ORACLE DATABASE SERVICE
3. How To Change the Listener Log Filename Without Stopping the Listener
4. ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener
5. TNS-01251: Cannot set trace/log directory under ADR
6. information provided for listener is currently in use by another software - Virtualbox

materialized view

1. Create Materialized Views

memory issue

1. ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

missing package

1. PRVF-7532 : Package "libaio-0.3.105 (i386)" is missing - Oracle installation requires old rpm versions, what to do?

online table re-def

1. Online table redefination

oracle

1. Identify and Terminate Sessions in oracle - New!
2. Is it safe to move/recreate alertlog while the database is up and running
3. Oracle Resource Manager: Granular Control for Managing Idle Sessions - New!
4. USING SELECT 'X' in query/subqueries.
5. Unlocking Oracle 23c AI's JSON Relational Duality: Simplifying Data Handling for Modern Applications - New!
6. bash: /bin/install/.oui: No such file or directory
7. expdp content=data_only
8. import a single table from a full export backup in oracle - New!
9. passing variables in sqlplus scripts
10. sql for first day of month and last day of month

password verify function

1. Using special characters in ORACLE DB passwords
2. configure complex password (password verify function) in oracle database

plsql

1. COUNT ROWS FROM ALL TABLES AND PRINT THEM - plsql - oracle
2. Column level triggers - Oracle
3. Count rows in all tables in a schema
4. Drop all tables in a schema
5. Learn Plsql - Loops
6. Sample plsql code- for practice
7. grant permissions on all tables to a user
8. passing variables in sqlplus scripts
9. plsql - CASE STATEMENT
10. plsql - IF-THEN, IF-THEN-ELSE,IF-THEN-ELSIF STATEMENT

putty

1. Configure Putty tunnel

recovery

1. Real Time Log Apply on Standby Database
2. Restore a schema from full expdp backup
3. delete noprompt obsolete archive log - RMAN

rpm

1. uninstall java on linux

shell script

1. ARCHIVE LOG Switch - shell script (for Oracle)

sql

1. Directory permissions granted to a user in Oracle database
2. Drop all tables in a schema
3. passing variables in sqlplus scripts
4. run sql from windows cmd prompt CLI
5. select grants on tables to users or roles
6. update rows from multiple tables (correlated update)

sql-query

1. Check duplicates for combination of multiple columns
2. Directory permissions granted to a user in Oracle database
3. Inserting Data into table with DML Error Logging (catching errors whiles inserting data into table)
4. Retrieve data from column as a row - Using LISTAGG function - Oracle
5. SQLSERVER QUERIES - SQLSERVER2015
6. Split Fullname into firstname and last name thru sql - Oracle
7. USING SELECT 'X' in query/subqueries.
8. chr function and its values - CHR and ASCII values
9. find the LAST_DDL_TIME change time of an Oracle object
10. select from table with no direct relation or foriegn keys
11. sql for first day of month and last day of month

table partitioning

1. ORA-14074: partition bound must collate higher than that of the last partition

timestamp

1. sql for first day of month and last day of month

triggers

1. AUDIT DDLS in database with trigger
2. Column level triggers - Oracle
3. Trigger to backup the data before delete or update on a table - Oracle
4. Trigger to disable create objects in database starting with TMP or BAK
5. create shared disks (vdi) on Virtualbox for ASM - vboxmanage command line

trouble-shootting

1. ORA-00020: maximum number of processes exceeded
2. ORA-01113: file string needs media recovery

tuning

1. CREATE INVISIBLE INDEX ON A TABLE
2. Inserting Data into table with DML Error Logging (catching errors whiles inserting data into table)
3. Using Index Hints in oracle

uninstall

1. uninstall java on linux

unix

1. Configure Putty tunnel
2. UNIX Permissions - table

virtual columns

1. Virtual Columns in oracle 11g

windows

1. run sql from windows cmd prompt CLI

Get This Widget