oracle network - ghdrako/doc_snipets GitHub Wiki

tnsping MITP

$ lsnrctl services
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 
07-FEB-2020 18:46:20
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
Connecting to 
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serv2)(PORT=1521)))
Services Summary...
Service "MITP.world" has 1 instance(s).
  Instance "MITP", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:8 refused:0 state:ready
         LOCAL SERVER
Service "MITPXDB.world" has 1 instance(s).
  Instance "MITP", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: serv2.dbexperts.com, pid: 22360>
         (ADDRESS=(PROTOCOL=tcp)(HOST=serv2)(PORT=17451)

$ lsnrctl stop

tnsnames.ora:
MITP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = serv2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = MITP.world)
    )
  )

sqlplus <username>/<Passwort>@<TNS_ALIAS>
sqlplus system/manager@MITP