I am having trouble creating a listener in Oracle 19C

0 votes
0 answers
115 views
                          These are my active services:

    SQL> SELECT NAME FROM V$ACTIVE_SERVICES;

    NAME
    ----------------------------------------------------------------
    
    pdb3
    orcldb
    pdb2
    pdb1

and this is my listener.ora config file:

        [oracle@oracle admin]$ cat listener.ora
    # listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/db_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
        )
      )
    
    
    ORCLDB =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL=TCP)(HOST = oracle)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcldb)
        )
      )

This is my tnsnames.ora file:

    [oracle@oracle admin]$ cat tnsnames.ora
    # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/db_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.
    
    LISTENER_ORCL =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
    
    
    ORCLDB =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcldb)
        )
      )


I am gettting this error after lsnrctl stop and start commands:

    [oracle@oracle admin]$ lsnrctl start
    
    LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-SEP-2023 20:38:41
    
    Copyright (c) 1991, 2019, Oracle.  All rights reserved.
    
    Starting /u01/app/oracle/product/19.0.0/db_1/bin/tnslsnr: please wait...
    
    TNSLSNR for Linux: Version 19.0.0.0.0 - Production
    System parameter file is /u01/app/oracle/product/19.0.0/db_1/network/admin/listener.ora
    Log messages written to /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
    Start Date                04-SEP-2023 20:38:41
    Uptime                    0 days 0 hr. 0 min. 0 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /u01/app/oracle/product/19.0.0/db_1/network/admin/listener.ora
    Listener Log File         /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    The listener supports no services
    The command completed successfully

Once I connect orcldb, I will then move forward to pdbs.
                        
Asked by dbafix (64 rep)
Sep 5, 2023, 12:48 AM
Last activity: Jul 6, 2024, 08:44 PM
I am having trouble creating a listener in Oracle 19C

Related Questions
