--=listener.ora==========================
# listener.ora Network Configuration File: C:\Users\banan\Documents\ORA\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\Users\banan\Documents\ORA\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\Users\banan\Documents\ORA\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
	
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\Users\banan\Documents\ORA

--=sqlnet.ora========================================
# sqlnet.ora Network Configuration File: C:\Users\banan\Documents\ORA\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

--=tnsnames.ora=======================================
# tnsnames.ora Network Configuration File: C:\Users\banan\Documents\ORA\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oratest)
		(SID=ORATEST )
    )
  )

LISTENER_ORATEST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


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

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.168.1.2)
		( SID=ORCL )
    )
  )
--==================================

***********************************************************************
Fatal NI connect error 12514, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL)(CID=(PROGRAM=C:\orant\BIN\PLUS80W.EXE)(HOST=PROGRAMMER_banan)(USER=banan))))

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 8.0.6.3.0 - Production
	Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.0.6.3.0 - Production
  Time: 09-АВГ-2012 01:36:57
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:не могу установить связь с адресатом
    ns main err code: 12564
    TNS-12564: TNS:соединение отвергнуто
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0


***********************************************************************
Fatal NI connect error 12514, connecting to:
 (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ORCL)(SERVER=DEDICATED)(CID=(PROGRAM=C:\orant\BIN\PLUS80W.EXE)(HOST=PROGRAMMER_banan)(USER=banan))))

  VERSION INFORMATION:
	TNS for 32-bit Windows: Version 8.0.6.3.0 - Production
	Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.0.6.3.0 - Production
  Time: 09-АВГ-2012 01:37:28
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:не могу установить связь с адресатом
    ns main err code: 12564
    TNS-12564: TNS:соединение отвергнуто
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0


***********************************************************************

c:\>SET NLS_LANG=RUSSIAN_CIS.RU8PC866

c:\>tnsping oratest

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 10-АВГ-2
012 20:01:56

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

Использованы файлы параметров:
C:\Users\banan\Documents\ORA\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Использован адаптер TNSNAMES для разрешения псевдонима
Выполнена попытка связи с (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = loca
lhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orates
t) (SID=ORATEST)))
OK (20 мсек)

c:\>tnsping80 oratest

TNS Ping Utility for 32-bit Windows: Version 8.0.6.0.0 - Production on 10-АВГ-12
 20:02:20

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))
OK (40 мсек)

c:\>

SET NLS_LANG=RUSSIAN_CIS.RU8PC866 
C:\Users\banan\Documents\ORA\product\11.2.0\dbhome_1\BIN\sqlplus.exe

##исполняем##
C:\Users\banan\Desktop>SET NLS_LANG=RUSSIAN_CIS.RU8PC866

C:\Users\banan\Desktop>C:\Users\banan\Documents\ORA\product\11.2.0\dbhome_1\BIN\sq
lplus.exe

SQL*Plus: Release 11.2.0.1.0 Production on Сб Авг 11 11:39:22 2012

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

Введите имя пользователя: test/test@oratest

Присоединен к:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT 1 AS f FROM DUAL;

         F
----------
         1

SQL>
##кстати sqlplus в том же окне cmd, что и сам батник

SET NLS_LANG=RUSSIAN_CIS.RU8PC866 
cd C:\orant\
C:\orant\BIN\sqlplus.exe
##run##
##cmd-window -1.##
C:\windows\system32>SET NLS_LANG=RUSSIAN_CIS.RU8PC866

C:\windows\system32>cd C:\orant\

C:\orant>C:\orant\BIN\sqlplus.exe
##тут поднимается второе окно##
##sqlplus-window-2.##
SQL*Plus: Release 8.0.6.0.0 - Production on Сбт Авг 11 11:38:59 2012

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Введите имя пользователя: test/test@oratest
## и висит пока не прошлёшь ^{Break} ##
## причем виснет именно если разрешает имя службы ##
## w-2/#

SQL*Plus: Release 8.0.6.0.0 - Production on Сбт Авг 11 11:55:23 2012

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Введите имя пользователя: test/test@netnihera
ошибка:
ORA-12154: TNS:невозможно разрешить имя службы


Введите имя пользователя: test/test@netnihera2
ошибка:
ORA-12154: TNS:невозможно разрешить имя службы


Введите имя пользователя:
##махом откликается, и не виснет ##
##........такие дела.......##