Pages

Saturday, January 2, 2021

The listener supports no services


New listener or new database cloned, listener not registered.


LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.27.134)(PORT=1526)))

STATUS of the LISTENER

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

Alias                     LISTENER11

Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production

Start Date                02-JAN-2021 21:43:33

Uptime                    0 days 0 hr. 0 min. 33 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /app/oracle/product/11.2.0.2/dbhome_1/network/admin/listener.ora

Listener Log File         /app/oracle/diag/tnslsnr/prjutyu01/listener11/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.27.134)(PORT=1526)))

The listener supports no services

The command completed successfully

LSNRCTL> 




Solution:

    (To register the listener with database)

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.27.134)(PORT=1526)))' scope=both;


SQL> alter system register; 



Tuesday, December 15, 2020

xclock dbca PuTTY X11 proxy: Authorisation not recognised

PuTTY X11 proxy: Authorisation not recognised

Error: Can't open display: localhost:10


Error:


[dbadmin53@brvmoracle ~]$ sudo su - oracle

Last login: Wed Dec 16 09:43:51 +03 2020 on pts/0

[oracle@brvmoracle ~]$ xclock

PuTTY X11 proxy: Authorisation not recognised

Error: Can't open display: localhost:10


or 


[oracle@brvmoracle ~]$ dbca

PuTTY X11 proxy: Authorisation not recognised

Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11.XToolkit

        at java.lang.Class.forName0(Native Method)

        at java.lang.Class.forName(Class.java:264)

        at java.awt.Toolkit$2.run(Toolkit.java:860)

        at java.awt.Toolkit$2.run(Toolkit.java:855)

        at java.security.AccessController.doPrivileged(Native Method)

        at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:854)

        at com.jgoodies.looks.LookUtils.isLowResolution(LookUtils.java:484)

        at com.jgoodies.looks.LookUtils.<clinit>(LookUtils.java:249)

        at com.jgoodies.looks.plastic.PlasticLookAndFeel.<clinit>(PlasticLookAndFeel.java:135)

        at java.lang.Class.forName0(Native Method)

        at java.lang.Class.forName(Class.java:348)

        at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1874)

        at javax.swing.UIManager.setLookAndFeel(UIManager.java:582)

        at oracle.install.commons.util.Application.startup(Application.java:917)

        at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)

        at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:198)

        at oracle.assistants.common.base.driver.AssistantApplication.startup(AssistantApplication.java:320)

        at oracle.assistants.dbca.driver.DBConfigurator.startup(DBConfigurator.java:342)

        at oracle.assistants.dbca.driver.DBConfigurator.main(DBConfigurator.java:386)

[oracle@brvmoracle ~]$


Reason:


Switching from 'dbadmin53' user to 'oracle' user - causing the error.

Try login with oracle user directly from putty.