# listener.ora Network Configuration File: C:\Oracle\OraAdmin\product\12.1.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:\Oracle\OraAdmin\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\OraAdmin\product\12.1.0\dbhome_1\bin\oraclr12.dll")
    )
  )

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

# tnsnames.ora Network Configuration File: C:\Oracle\OraAdmin\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

RSBANK =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ServerOracle)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RSBank)
    )
  )

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

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 18-FEB-2017 09:08
:32

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ServerOracle)(PORT=1521)
))
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
The command completed successfully

C"           ˜K                                                                               —  ЏЗ7                                                                                                                                                                                                                                                                                                                                                                                                                C  C"           .B  rsbank.__oracle_base='C:\Oracle\OraAdmin'#ORACLE_BASE set from environment
*.audit_file_dest='C:\Oracle\OraAdmin\admin\RSBank\adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='D:\DBase\oradata\RSBank\control01.ctl','D:\DBase\fast_recovery_area\RSBank\control02.ctl'
*.db_block_size=8192
*.db_cache_size=1604m
*.db_domain=''
*.db_name='RSBank'
*.db_recovery_file_dest='D:\DBase\fast_recovery_area'
*.db_recovery_file_dest_size=4815m
*.deferred_segment_creation=FALSE
*.dC  C"           1U  iagnostic_dest='C:\Oracle\OraAdmin'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=RSBankXDB)'
*.java_pool_size=200m
*.large_pool_size=0m
 *.local_listener='LISTENER_RSBANK' 
*.nls_language='RUSSIAN'
*.nls_territory='RUSSIA'
*.open_cursors=300
*.optimizer_index_caching=95
*.optimizer_index_cost_adj=10
*.pga_aggregate_target=810m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=534m
*.undo_tablespace='UNDOTBS1'
                                                          C  C"           Ge                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          C  C"           Fe                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          C  

C:\Oracle\OraAdmin\product\12.1.0\dbhome_1\BIN>set ORACLE_SID=RSBANK

C:\Oracle\OraAdmin\product\12.1.0\dbhome_1\BIN>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Feb 19 15:43:54 2017

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

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0

# 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 = (none)

SQL> select * from DBA_SERVICES;
select * from DBA_SERVICES
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0