• Home
  • DBA Scripts
    • Oracle Scripts
    • SQL Server Scripts
  • Knowledge Base
    • Oracle Database
    • MS SQL Server
    • MongoDB
    • MariaDB
  • Troubleshoot
    • Oracle Database Issues
    • SQL Server Issues
  • Interview Questions
    • AWS Interview Questions
    • Oracle DBA Interview Questions
    • SQL Server Interview Questions
  • Courses
    • Oracle Database
    • Oracle DBA L1
    • Oracle DBA L2
    • Oracle DBA L3
  • Home
  • DBA Scripts
    • Oracle Scripts
    • SQL Server Scripts
  • Knowledge Base
    • Oracle Database
    • MS SQL Server
    • MongoDB
    • MariaDB
  • Troubleshoot
    • Oracle Database Issues
    • SQL Server Issues
  • Interview Questions
    • AWS Interview Questions
    • Oracle DBA Interview Questions
    • SQL Server Interview Questions
  • Courses
    • Oracle Database
    • Oracle DBA L1
    • Oracle DBA L2
    • Oracle DBA L3
home/Knowledge Base/Oracle Database/Oracle 12c Database/LREG – Oracle 12c Background Process
Popular Search:Oracle, SQL Server, MongoDB

LREG – Oracle 12c Background Process

164 views 0 September 4, 2019 admin

LREG (Listener Registration) is an Oracle background process created when you start an Oracle 12c or higher database instance. This function was handled by the PMON process in earlier releases.It registers the instance with the listeners.

The Listener Registration process attempts register the information about the database instance and services if the listener is running. If the listener is not running it will keep trying periodically connect to it. It may take some time till LREG makes all listener registration after you start it, if you want to make an immediate registration you must keep using “ALTER SYSTEM REGISTER;” exactly as in the older versions.

[oracle@PROD ]$ ps -ef | grep lreg

oracle 18174 1 0 2018 ? 00:04:37 asm_lreg_+ASM1
oracle 1675 1 0 Jan27 ? 00:00:02 ora_lreg_PROD

To trace the service registration to Listener,

SQL> alter system set events='immediate trace name listener_registration level 3';

System altered.

SQL> alter system register;

System altered.

SQL> SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';

VALUE
----------------------------------------------
/oracle/app/oracle/diag/rdbms/PROD/PROD1/trace

[oracle@PROD trace]$ cd /app/oracle/diag/rdbms/PROD/PROD1/trace
[oracle@PROD trace]$ ls -lrt *lreg*

-rw-r----- 1 oracle oinstall  175 Sep 19 23:44 PROD_lreg_9012.trm
-rw-r----- 1 oracle oinstall 4972 Sep 19 23:44 PROD_lreg_9012.trc

Was this helpful?

Yes  No
Related Articles
  • Duplicate Database Using RMAN in Oracle 12cR1
  • Oracle 12cR1 New Features
  • Step by Step Installation of Oracle RAC 12cR1
  • Oracle 12c Background Process (Memory Manager)
Leave A Comment Cancel reply

Oracle 12c Database
  • LREG – Oracle 12c Background Process
  • Duplicate Database Using RMAN in Oracle 12cR1
  • Oracle 12cR1 New Features
  • Step by Step Installation of Oracle RAC 12cR1
  • Oracle 12c Background Process (Memory Manager)
Popular Articles
  • Upgrade Oracle Database from 11.2.0.3 to 12.1.0.2
  • Upgrading MariaDB on Windows
  • Oracle DBA Basic Interview Questions Part A
  • Purging Oracle Sysaux Tablespace
  • Client – Server Architecture
KB Categories
  • Oracle Database
    • Oracle RAC
    • Oracle ASM
    • Oracle GoldenGate
    • Oracle Tuning
    • Oracle 11g Database
    • Oracle Database Upgrade
    • Oracle 12c Database
    • ALL KB Oracle
    • Oracle 18c Database
    • Oracle Standby Database
  • MongoDB
  • MS SQL Server
  • MySQL
  • Interview Questions
    • AWS Interview Questions
    • Oracle DBA Interview Questions
    • SQL Server Interview Questions
  • MariaDB
Database Organization

Database Organization (DB ORG) is knowledge base for DBA to learn and execute the fundamental of different databases under one website. DB ORG is a non-profit initiative. ORACLE, MS SQL Server, MongoDB, MariaDB, Couchbase

Join Our Community
  • KnowledgeBase
  • Documentation
  • Troubleshoot
  • FAQ
Information Links
  • About DBOrg
  • Licenses
  • Terms
  • Privacy Policy
Contact Us
    DB ORG - Database Administration,
    Knowledge Base for DBA
    Mail: support@databaseorg.com
    WhatsApp: (+91) 9306440957
    Monday to Friday: EST - 11:30 AM to 06:30 PM (IST - 9:00 PM to 4:00 AM)
  • © 2023 Database Organization - DB ORG. All Rights Reserved.

Popular Search:Oracle, SQL Server, MongoDB

WhatsApp DB Org