Forum Stats

  • 3,872,046 Users
  • 2,266,372 Discussions
  • 7,911,040 Comments

Discussions

I am unable to start the listener in my virtual box. Below are the necessary details

/etc/hosts entry:

127.0.0.1  localhost localhost.localdomain localhost4 localhost4.localdomain4

::1     localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.0.6   test.com    test



nsswitch.conf permission:

[[email protected] etc]$ ls -lrt /etc/nsswitch.conf

-rw-r--r--. 1 root root 1746 Apr 21 19:38 /etc/nsswitch.conf



lsnrctl stop:

[[email protected] ~]$ lsnrctl stop


LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 18-JUN-2022 02:15:39


Copyright (c) 1991, 2018, Oracle. All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.com)(PORT=1521)))

TNS-12541: TNS:no listener

 TNS-12560: TNS:protocol adapter error

 TNS-00511: No listener

  Linux Error: 111: Connection refused

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully



lsnrctl start:

[[email protected] ~]$ lsnrctl start


LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 18-JUN-2022 02:17:58


Copyright (c) 1991, 2018, Oracle. All rights reserved.


Starting /u01/app/oracle/product/18/db_1/bin/tnslsnr: please wait...


TNSLSNR for Linux: Version 18.0.0.0.0 - Production

System parameter file is /u01/app/oracle/product/18/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/test/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.com)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.com)(PORT=1521)))

TNS-12541: TNS:no listener

 TNS-12560: TNS:protocol adapter error

 TNS-00511: No listener

  Linux Error: 111: Connection refused

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias           LISTENER

Version          TNSLSNR for Linux: Version 18.0.0.0.0 - Production

Start Date        18-JUN-2022 02:18:00

Uptime          0 days 0 hr. 0 min. 1 sec

Trace Level        off

Security         ON: Local OS Authentication

SNMP           OFF

Listener Parameter File  /u01/app/oracle/product/18/db_1/network/admin/listener.ora

Listener Log File     /u01/app/oracle/diag/tnslsnr/test/listener/alert/log.xml

Listening Endpoints Summary...

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.com)(PORT=1521)))

 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services

The command completed successfully



tnsnames.ora entry:

[[email protected] admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/18/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.


LISTENER_ORCL =

 (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1521))



ORCL =

 (DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1521))

  (CONNECT_DATA =

   (SERVER = DEDICATED)

   (SERVICE_NAME = orcl.com)

  )

 )


ORCLPDB = 

 (DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1521))

  (CONNECT_DATA =

   (SERVER = DEDICATED)

   (SERVICE_NAME = orclpdb.com)

  )

 )



listener.ora entry:

[[email protected] admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/18/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.


LISTENER =

 (DESCRIPTION_LIST =

  (DESCRIPTION =

   (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1521))

   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

  )

 )



Database status:

[[email protected] admin]$ sqlplus / as sysdba


SQL*Plus: Release 18.0.0.0.0 - Production on Sat Jun 18 02:23:17 2022

Version 18.3.0.0.0


Copyright (c) 1982, 2018, Oracle. All rights reserved.



Connected to:

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Version 18.3.0.0.0


SQL> select name,open_mode from v$database;


NAME  OPEN_MODE

--------- --------------------

ORCL  READ WRITE


SQL> sho con_name;


CON_NAME

------------------------------

CDB$ROOT

SQL> 

SQL> 

SQL> sho pdbs;


  CON_ID CON_NAME  OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED  READ ONLY NO

3 ORCLPDB  READ WRITE NO


Kindly suggest what steps are to be taken.

Answers