Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

Error connecting to new listener

edited Feb 5, 2018 4:04AM in Oracle Database Appliance (ODA) (MOSC) 9 commentsAnswered

Hi

We added a new listener to our ODA X7-2M single node bare metal deployment

Here is the entry of that under $GRID_HOME/network/admin/listener.ora

SID_LIST_LISTENER_BG =

  (SID_LIST =

    (SID_DESC =

      (ORACLE_HOME=/u01/app/12.2.0.1/grid)

      (SID_NAME = odaprod)

    )

  )

LISTENER_BG =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ODA-SERVER)(PORT = 1523))

    )

  )

Here is the entry under $ORACLE_HOME/network/admin/tnsnames.ora

oda_bg =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ODA-SERVER)(PORT = 1523))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = odaprod)

    )

  )

Here is the output of listener status and tnsping commands

[grid@ODA-SERVER ~]$ lsnrctl status listener_bg

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center