Oracle Database Internal Mechanism

Menu

Skip to content
  • Home
  • Authors
    • Nitish Anand Srivastava
  • Oracle 12c
    • Oracle 12c Architecture
    • Installing 12c Database on Oracle Linux 7
    • Managing a CDB & PDB [Basic DBA Commands]
    • Table PITR in Oracle 12c
    • 12c New Features – Database In-Memory
    • 12c New Features – Online DataFile Move
    • 12c New Features – Global Temporary Table Undo
    • 12c New Features – Partial Indexes
    • 12c New Features – Invisible Columns
    • Long Identifiers in Oracle Database 12c Release 2
    • Flashback PDB in Oracle 12cR2
    • Move Table Partition/Sub-Partition Online – 12cR1
    • Move Table Online – 12cR2
  • Oracle Backup & Recovery
    • Performing Block-Level Recovery
    • Performing Cancel-Based Recovery
    • Performing Database-Level Recovery
    • Performing Datafile-Level Recovery
    • Performing Log Sequence–Based Recovery
    • Performing SCN-Based Recovery
    • Performing Tablespace Point-in-Time Recovery
    • Performing Tablespace-Level Recovery
    • Performing Time-Based Recovery
    • Recovering from the LOSS of REDO log files
    • Recovering Read-Only Tablespaces
    • Restore database in case of dropped table
    • Restoring a Database (NoArchivelog mode)
    • Tips & Tricks
  • Oracle RAC
    • SCAN Internals
    • Split Brain Syndrome
    • GPNP Profile Internals
    • Voting Disk Internals
    • Network & Disk Heartbeats
    • OCR Internals
    • OLR Internals
    • Adding & Removing Voting Disk
    • Installing 12c RAC on Oracle Linux 6
    • Installing 12c RAC on Oracle Linux 7
  • Oracle Dataguard
    • How to Create Active DataGuard
    • How to Create Logical Standby in DataGuard
    • How to Create Physical Standby in DataGuard
    • How to Create Snapshot Standby in DataGuard
    • How to Perform Failover in DataGuard
    • How to Perform Switchover in DataGuard
  • Oracle GoldenGate
    • How to Install oracle Golden Gate on UNIX
    • How to setup GoldenGate Replication in Oracle
    • Oracle GoldenGate Architecture Internals
  • Oracle Performance Tuning
    • Oracle Wait Events
      • db file sequential reads – Oracle wait event
      • db file scattered read – oracle wait event
      • Direct Path Read/Direct Path Read Temp – Oracle Wait Event
      • Library Cache lock – Oracle Wait Event
      • Buffer busy waits – Oracle Wait Event
      • log file sync – Oracle Wait Event
      • log file switch – Oracle Wait Event
      • Library Cache Pin – Oracle Wait Event
      • row cache lock – Oracle Wait Event
      • enq: TM – contention – Oracle wait event
      • enq: TX – index contention – Oracle wait event
      • latch: cache buffers chains – Oracle wait event
    • Queries to Monitor Oracle Sessions
    • How to enable 10046 Trace (SQL_TRACE) to troubleshoot performance issues
    • Oracle TKProf Usage
    • Understanding TKProf output
    • Oracle Database Internals
      • Oracle Memory Architecture (SGA & PGA)
      • Oracle Process Architecture
      • Full Table Scan (FTS)
      • Index Lookup (Unique Scan,Range Scan, Full Scan, Fast Full Scan, Skip Scan)
      • Interpreting an Explain Plan
      • Joins
      • Direct Path Reads
      • Table Access by Rowid
      • Index Unique Scans
      • Index Range Scans
      • Index Skip Scans
      • Index Fast Full Scans
      • Index Full Scans
  • Oracle datapump Internals
    • Oracle datapump expdp & impdp internals
    • How to read Datapump Dumpfile Headers
    • Datapump Export (Everything you need to know)
    • Queries to Monitor Datapump Jobs
  • SQL Server
    • Install SQL Server 2017 on Linux
    • SQL Server on Linux – Directory Structure
  • Sybase ASE
    • Sybase ASE – Take backup for Cross-Platform Load in Quiescent State
    • Sybase ASE – Read a dumpfile with headeronly
    • Sybase ASE – Load Database from a Cross-Platform Dump File using sp_post_xpload
    • Sybase ASE – Dump/Load a database to/from multiple stripes
    • Sybase ASE – Changing Existing Database Device from ‘dsync’ to ‘directio’
    • Sybase ASE – Rename a Database
    • Sybase ASE – Extending an Existing Database Device
    • Sybase ASE – Create new Database & Device in Sybase ASE
    • Sybase ASE – Error while loading shared libraries: libkonavm.so: cannot open shared object file
    • Sybase ASE – Recover a lost or Unknown “sa” password
    • Sybase ASE – Kernel kistartup: could not create shared memory on Linux server
    • Sybase ASE – Exhausted “cpu grace time” when Loading Database Dump
  • MySQL
  • Miscellaneous Issues
    • Resolving tablespace issues (ORA-01650 / ORA-01652 / ORA-01653 / ORA-01654 and ORA-01658)
    • Troubleshooting Listener Startup or Connection Hang issues in 11g.
    • Listener Issues ORA-12505/TNS-12505 or ORA-12514/TNS-12514
    • Resizing Redo Log file
    • Install & Configure Oracle XE on Linux/CentOS
    • Resolving ORA-00845: MEMORY_TARGET not supported on this system
    • ORA-28040: No matching authentication protocol exception
    • Troubleshooting TNS-12519 TNS-12516 ORA-12519 ORA-12516
    • How to change the SID using DBNEWID utility
    • Dead Connection Detection
    • Installing Oracle Linux 6 on VirtualBox VM
    • Installing Linux 7 on Oracle VirtualBox VM
    • ORA-12547: TNS:lost contact
    • Oracle Auto-Startup Script for Linux
    • ORA-01792: maximum number of columns in a table or view is
    • Oracle Listener Tracing & network troubleshooting
    • ORA-12505 TNS-12505 TNS:listener does not currently know of SID given in connect descriptor
    • ORA-14452 attempt to create, alter or drop an index on temporary table already in use
    • ORA-12500 TNS-12500 TNS:listener failed to start a dedicated server process
    • ORA-12504 TNS-12504 – TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
    • ORA-12502 TNS-12502 TNS:listener received no CONNECT_DATA from client

Tag Archives: TNS-12500

ORA-12500 TNS-12500 TNS:listener failed to start a dedicated server process

This error appears when the process of starting up a dedicated server process failed and it could be either because the executable could not be found or the environment isn’t set up correctly. Turn on tracing at the ADMIN level and re-execute the operation. Tracing can be set by adding following clause in listener.ora file…

December 20, 2018 in Listener Issues.

Search this Blog

Popular Posts

  • Queries to Monitor Datapump Jobs
    Queries to Monitor Datapump Jobs
  • ORA-12504 TNS-12504 - TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
    ORA-12504 TNS-12504 - TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
  • ORA-12547: TNS:lost contact
    ORA-12547: TNS:lost contact
  • ORA-14452 attempt to create, alter or drop an index on temporary table already in use
    ORA-14452 attempt to create, alter or drop an index on temporary table already in use
  • Oracle Memory Architecture Internals(SGA & PGA)
    Oracle Memory Architecture Internals(SGA & PGA)
  • How to Upgrade OPatch to Latest Version
    How to Upgrade OPatch to Latest Version
  • Index Lookup (Unique Scan,Range Scan, Full Scan, Fast Full Scan, Skip Scan)
    Index Lookup (Unique Scan,Range Scan, Full Scan, Fast Full Scan, Skip Scan)
  • Oracle Database Internals
    Oracle Database Internals
  • enq: TX - index contention - Oracle wait event
    enq: TX - index contention - Oracle wait event
  • GPNP Profile Internals
    GPNP Profile Internals

All Pages

  • Authors
  • Miscellaneous Issues
    • Resizing Redo Log file
  • Nitish Anand Srivastava
  • Oracle 12c
    • 12c New Features – Database In-Memory
    • 12c New Features – Global Temporary Table Undo
    • 12c New Features – Online DataFile Move
    • 12c New Features – Partial Indexes
    • 12c New Features – Table PITR in Oracle 12c
    • Installing 12c Database on Oracle Linux 7
    • Managing a CDB & PDB [Basic DBA Commands]
    • Oracle 12c Architecture
  • Oracle Backup & Recovery
    • Performing Block-Level Recovery
    • Performing Cancel-Based Recovery
    • Performing Database-Level Recovery
    • Performing Datafile-Level Recovery
    • Performing Log Sequence–Based Recovery
    • Performing SCN-Based Recovery
    • Performing Tablespace Point-in-Time Recovery
    • Performing Tablespace-Level Recovery
    • Performing Time-Based Recovery
    • Recovering from the LOSS of REDO log files
    • Recovering Read-Only Tablespaces
    • Restore database in case of dropped table
    • Restoring a Database (NoArchivelog mode)
    • Tips & Tricks
  • Oracle database Internal Mechanism
  • Oracle Database Internals
    • How to Interpret an Explain Plan
    • Index Lookup (Unique Scan,Range Scan, Full Scan, Fast Full Scan, Skip Scan)
    • Oracle Memory Architecture Internals(SGA & PGA)
    • Oracle Process Architecture Internals
    • What are Joins in Oracle
    • What is a Full Table Scan (FTS) in Oracle
  • Oracle Dataguard
    • How to Create Active DataGuard
    • How to Create Logical Standby in DataGuard
    • How to Create Physical Standby in DataGuard
    • How to Create Snapshot Standby in DataGuard
    • How to Perform Failover in DataGuard
    • How to Perform Switchover in DataGuard
  • Oracle GoldenGate
    • How to Install oracle Golden Gate on UNIX
    • How to setup GoldenGate Replication in Oracle
    • Oracle GoldenGate Architecture Internals
  • Oracle Performance Tuning
  • Oracle RAC
    • GPNP Profile Internals
    • Network & Disk Heartbeats
    • OCR Internals
    • OLR Internals
    • SCAN Internals
    • Split Brain Syndrome
    • Voting Disk Internals

Recent Posts

  • How to shrink a datafile when getting ORA-03297 (Lowering High Watermark)
  • How to Apply Release Update 12.2.0.1.210420 (Patch 32507738 – April 2021 RU)
  • ./opatch: line 839: [: too many arguments Java (1.x) could not be located
  • How to Apply Release Update 19.11.0.0.0 (Patch 32545013)
  • How to Upgrade OPatch to Latest Version

Archives

  • August 2021
  • April 2021
  • February 2021
  • July 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2019
  • December 2018
  • November 2018
  • September 2017
  • August 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • March 2016
Website Powered by WordPress.com.
  • Follow Following
    • Oracle Database Internal Mechanism
    • Join 307 other followers
    • Already have a WordPress.com account? Log in now.
    • Oracle Database Internal Mechanism
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar