# 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

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 16:05:08 2017

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE\ORAADMIN\PRODUCT\12.1.0\DBHO
ME_1\DATABASE\INITRSBANK.ORA'
SQL>

Instance terminated by USER, pid = 1512
Starting ORACLE instance (normal) (OS id: 3496)
Sat Feb 18 03:15:21 2017
CLI notifier numLatches:3 maxDescs:519
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 2
Number of processor cores in the system is 2
Number of processor sockets in the system is 1
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production.
Windows NT Version V6.2  
CPU                 : 2 - type 8664, 2 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:3000M/4095M, Ph+PgF:1417M/4799M 
VM name             : VMWare Version (6)
Using parameter settings in server-side spfile C:\ORACLE\ORAADMIN\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILERSBANK.ORA
System parameters with non-default values:
  processes                = 300
  shared_pool_size         = 544M
  large_pool_size          = 0
  java_pool_size           = 208M
  nls_language             = "RUSSIAN"
  nls_territory            = "RUSSIA"
  control_files            = "D:\DBASE\ORADATA\RSBANK\CONTROL01.CTL"
  control_files            = "D:\DBASE\FAST_RECOVERY_AREA\RSBANK\CONTROL02.CTL"
  db_block_size            = 8192
  db_cache_size            = 1616M
  compatible               = "12.1.0.2.0"
  db_recovery_file_dest    = "D:\DBase\fast_recovery_area"
  db_recovery_file_dest_size= 4815M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=RSBankXDB)"
   local_listener           = "LISTENER_RSBANK"  ???
   audit_file_dest          = "C:\ORACLE\ORAADMIN\ADMIN\RSBANK\ADUMP"
  audit_trail              = "DB"
  db_name                  = "RSBank"
  open_cursors             = 300
  optimizer_index_cost_adj = 10
  optimizer_index_caching  = 95
  pga_aggregate_target     = 810M
  deferred_segment_creation= FALSE
  diagnostic_dest          = "C:\ORACLE\ORAADMIN"
NOTE: remote asm mode is local (mode 0x1; from cluster type)
Sat Feb 18 03:15:33 2017
USER (ospid: 3496): terminating the instance due to error 119
Sat Feb 18 03:15:33 2017
Instance terminated by USER, pid = 3496

sqlplus / as sysdba
create pfile from spfile;

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

SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 20 23:18:36 2017

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

Connected to an idle instance.

SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file
'%ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 2525)

...

SQL> startup pfile;
SP2-0714: invalid combination of STARTUP options