Remote Oracle Database Support

Tabs

Home
ORA-Errors »
Performance Tuning »
- SQL
- Segment
- OS
Emerging DBA's »
- Learning
- Lessons
Installation »
- 10g
- 11g
- 12c
Backup & Recovery »
- RMAN
- SAP
- ExportImport
Administration »
Out Of Box »

Cloud

TOP 30 Oracle 19c features quick look to make dba life easy

Future of DBA post autonomous database

What is Oracle 18c Autonomous database

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

No comments:

Post a Comment

Latest

20 Pre Upgrade Checklist for Migrating Oracle Database to New version

Taking appropriate steps prior to major oracle database upgrades helps to prevent any warning , slowness during or after migration to new or...

Most Popular

ORA-12545: Connect failed because target host or object does not exist

Error: ORA-12545: Connect failed because target host or object does not exist Background: ORA-12545 is a generic error as a result o...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS

Error: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [PROCACT_SCHEMA ORA-06502: PL/SQL: numeric or value error LPX...
What is Oracle Database ?

An Oracle Database is a Relational Database management System used to store & retrieve the related information. An Oracle Databa...
Improving FTS oracle

This blog is written after resolving sev1 performance issue post DB migration to new setup Issue: Sql Full table Scan (FTS) Slowness...
ORA-02049: timeout: distributed transaction waiting for lock

Issue: ORA-02049: timeout: distributed transaction waiting for lock Background: Application has reported the error ORA-02049 during...
ORA-01157 ORA-01110 ORA-27037 ASM file Addition Issues

This blog is intended to make DBA’s aware of what havoc it will create if we misplace a command of datafile addition in ASM disk group...
Unable to discover any voting files, retrying discovery in 15 seconds

Errors: From: $GRID_HOME/log/<hostname>/alert<<hostname>>.log [ohasd(13154)]CRS-2112:The OLR service...
ORA-14402: updating partition key column would cause a partition change

Error: ORA-14402: updating partition key column would cause a partition change Analysi s: Created a Sample test t able to check if a ...
ORA-15063: ASM discovered an insufficient number of disks for diskgroup

Error: ERROR: diskgroup DG02 was not mounted ORA-15032: not all alterations performed ORA-15017: diskgroup "DG02" cannot be m...
ORA-01156: recovery or flashback in progress may need access to files

Error: ORA-01156: recovery or flashback in progress may need access to files When: While adding standby redo log files in standby dat...

Search In My Blog

ORA-Errors (60) ORA-Generic (32) EmergingDBA (29) Administration (26) EmergingDBALearn (16) Installation (16) AdministrationTroubleshooting (13) ORA-Network (9) PerformanceTuning (8) BackupRecoveryRMAN (6) ORA-Cluster (6) Installation11g (5) Installation12c (5)

Trending

ORA-12545: Connect failed because target host or object does not exist

Error: ORA-12545: Connect failed because target host or object does not exist Background: ORA-12545 is a generic error as a result o...
ORA-01086: savepoint never established in this session or is invalid

SAVEPOINT is transaction control language in SQL , PL/SQL used to manage transaction consistent state within a complex coding during tra...
sqlplus: error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory

1 2 3 » Error: Post Client installation receiving error as [oracle@testlaba ~]$ sqlplus "/ as sysdba" sq...
too many parse errors error=12872 ORA-12842 Cursor Invalidated During Parallel Execution

Issue: Sql job getting stucked on sql id 21j18k2raxgpc when a package is executed in Oracle 12c database .. Alert log errors .. WARNING: too...
ORA-04023: Object could not be validated or authorized

ORA- Error: SQL>SELECT DAT.*,DATE_MODE||';'||SYS_META_KEY MIS_XDISPARE FROM MIS_SYS_DATA DAT WHERE 1 = 0 ORA-04023: Object could...

History

▼ 2021 (1)
- ▼ February (1)
  - 20 Pre Upgrade Checklist for Migrating Oracle Data...

► 2020 (47)
- ► December (2)
- ► November (4)
- ► October (5)
- ► September (2)
- ► August (5)
- ► July (10)
- ► June (17)
- ► May (2)

► 2018 (2)
- ► December (1)
- ► August (1)

► 2017 (39)
- ► December (3)
- ► November (13)
- ► September (1)
- ► August (2)
- ► July (16)
- ► June (4)

► 2015 (4)
- ► October (1)
- ► September (1)
- ► February (2)

► 2014 (3)
- ► February (1)
- ► January (2)

► 2013 (41)
- ► December (1)
- ► November (1)
- ► October (3)
- ► September (1)
- ► August (3)
- ► July (1)
- ► June (2)
- ► May (3)
- ► April (5)
- ► March (8)
- ► February (5)
- ► January (8)

► 2012 (11)
- ► December (4)
- ► November (7)

Database Errors

ORA-Generic
ORA-Disk
ORA-Cluster
ORA-Backup
ORA-Network
ORA-Errors

How To

Installation
Administration
Backup & Recovery
Performance Tuning
Emerging DBA's
Out Of Box

Technology

RAC
RMAN
Data Guard
Cloud