Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "orcl2.icexpert.local" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:2 refused:0 state:ready
         LOCAL SERVER
Service "orcl2XDB.icexpert.local" has 1 instance(s).
  Instance "orcl2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: ORACLE, pid: 3420>
         (ADDRESS=(PROTOCOL=tcp)(HOST=Oracle.icexpert.local)(PORT=54792))
The command completed successfully

C:\Users\admin>sqlplus -L test/test@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1
92.168.1.142)(PORT=1522)(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME = orcl2.
icexpert.local)))"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 2 04:27:31 2016

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


SQL*Plus: Release 11.2.0.1.0 Production

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

Use SQL*Plus to execute SQL, PL/SQL and SQL*Plus statements.

Usage 1: sqlplus -H | -V

    -H             Displays the SQL*Plus version and the
                   usage help.
    -V             Displays the SQL*Plus version.

Usage 2: sqlplus [ [<option>] [{logon | /nolog}] [<start>] ]

  <option> is: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]

    -C <version>   Sets the compatibility of affected commands to the
                   version specified by <version>.  The version has
                   the form "x.y[.z]".  For example, -C 10.2.0
    -L             Attempts to log on just once, instead of
                   reprompting on error.
    -M "<options>" Sets automatic HTML markup of output.  The options
                   have the form:
                   HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
                   [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
    -R <level>     Sets restricted mode to disable SQL*Plus commands
                   that interact with the file system.  The level can
                   be 1, 2 or 3.  The most restrictive is -R 3 which
                   disables all user commands interacting with the
                   file system.
    -S             Sets silent mode which suppresses the display of
                   the SQL*Plus banner, prompts, and echoing of
                   commands.

  <logon> is: {<username>[/<password>][@<connect_identifier>] | / }
              [AS {SYSDBA | SYSOPER | SYSASM}] [EDITION=value]

    Specifies the database account username, password and connect
    identifier for the database connection.  Without a connect
    identifier, SQL*Plus connects to the default database.

    The AS SYSDBA, AS SYSOPER and AS SYSASM  options are database
    administration privileges.

    <connect_identifier> can be in the form of Net Service Name
    or Easy Connect.

      @[<net_service_name> | [//]Host[:Port]/<service_name>]

        <net_service_name> is a simple name for a service that resolves
        to a connect descriptor.

        Example: Connect to database using Net Service Name and the
                 database net service name is ORCL.

           sqlplus myusername/mypassword@ORCL

        Host specifies the host name or IP address of the database
        server computer.

        Port specifies the listening port on the database server.

        <service_name> specifies the service name of the database you
        want to access.

        Example: Connect to database using Easy Connect and the
                 Service name is ORCL.

           sqlplus myusername/mypassword@Host/ORCL

    The /NOLOG option starts SQL*Plus without connecting to a
    database.

    The EDITION specifies the value for Session Edition.


  <start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]

    Runs the specified SQL*Plus script from a web server (URL) or the
    local file system (filename.ext) with specified parameters that
    will be assigned to substitution variables in the script.

When SQL*Plus starts, and after CONNECT commands, the site profile
(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
(e.g. login.sql in the working directory) are run.  The files may
contain SQL*Plus commands.

Refer to the SQL*Plus User's Guide and Reference for more information.

LISTENER_ORCL2 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.142)(PORT = 1522))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.142)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = 	orcl2.icexpert.local)
    )
  )

C:\app\cognos\product\11.2.0\client_1\BIN>tnsping orcl2

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-МАР-2
016 15:47:05

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Использованы файлы параметров:
C:\app\cognos\product\11.2.0\client_1\network\admin\sqlnet.ora


Использован адаптер TNSNAMES для разрешения псевдонима
Выполнена попытка связи с (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.
168.1.142)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = or
cl2.icexpert.local)))
OK (0 мсек)

C:\app\cognos\product\11.2.0\client_1\BIN>

C:\app\cognos\product\11.2.0\client_1\BIN>tnsping orcl2
Выполнена попытка связи с (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.142)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL2)))
...
sqlplus -L test/test@192.168.1.142:1522/orcl2.icexpert.local

C:\app\cognos\product\11.2.0\client_1\BIN>tnsping orcl2

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-╠└╨-2
016 16:21:59

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

╚ёяюы№чютрэ√ Їрщы√ ярЁрьхЄЁют:
C:\app\cognos\product\11.2.0\client_1\network\admin\sqlnet.ora


╚ёяюы№чютрэ рфряЄхЁ TNSNAMES фы  ЁрчЁх°хэш  яёхтфюэшьр
┬√яюыэхэр яюя√Єър ёт чш ё (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.
168.1.142)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = or
cl2.icexpert.local)))
OK (20 ьёхъ)

C:\app\cognos\product\11.2.0\client_1\BIN>

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)