• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Oracle 12c New Feature: LREG Background Process

by admin

Instance registration in Oracle Net 12c behaves differently. In 12c and higher, there is a new background process called ora_lreg_sid-name.

In previous releases, PMON always handled instance registration logic. In 12c, LREG (Listener REGistration) now takes over with the instance registration logic.

LREG (Listener REGistration)

– Registers instance information with the listener.
– It is a critical background process for each database instance (if it is killed, Oracle goes down).
– It does everything PMON used to do and report: service_update, service_register, service_died in the listener.log.

LREG can be traced using the same methods as one would trace PMON:

  • Enabling an Oracle Net server side sqlnet tracing will invoke a trace for LREG on instance startup.
  • The old PMON trace command now traces LREG: alter system set events = ‘10257 trace name context forever, level 5’;
  • Listener registration information can also be dumped into the ora_lreg trace file: alter system set events = ‘immediate trace name listener_registration level 3’;
  • LREG can be traced dynamically.
How to Trace Dynamic Registration from PMON or LREG (Oracle 12c)

Filed Under: oracle, oracle 12c

Some more articles you might also be interested in …

  1. How to list all the named events set for a database
  2. Beginners Guide to Oracle Database In-Memory in RAC
  3. Oracle Database 12c New feature: Local Temporary Tablespaces
  4. ORA-00214: control file inconsistent with file
  5. Oracle ASM 11gR2 instance is unable to start due to missing ASM spfile
  6. RMAN backup Concepts for Oracle RAC
  7. How to Drop Undo Tablespace in Oracle Database
  8. How To Convert A Partitioned Table To A Non-Partitioned Table Using DataPump In Oracle 11g and 12c
  9. SQL script to find tables that are fragmented
  10. Oracle 12C Enhancements for Cascaded Standby Databases

You May Also Like

Primary Sidebar

Recent Posts

  • aws ec2: CLI for AWS EC2 (Command Examples)
  • aws cur – Create, query, and delete AWS usage report definitions (Command Examples)
  • aws configure – Manage configuration for the AWS CLI (Command Examples)
  • aws cognito-idp: Manage Amazon Cognito user pool and its users and groups using the CLI

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright