Прошу прощения за задержку, не мог залогиниться в SQL Plus. Как оказалось, из-за переполненных логов Винды. Подозреваю, что вся проблема была связана именно с этим.:fool: А ларчик-то просто открывался
Вот часть из alert.log для БД Demo.
Цитата: Thu Nov 01 08:55:52 2012
Starting up:
Oracle Database 11g Release 11.2.0.1.0 - Production.
Using parameter settings in server-side spfile D:\ORACLE\ORACLE11_DATABASE\DATABASE\SPFILEDEMO.ORA
System parameters with non-default values:
processes = 150
nls_language = "RUSSIAN"
nls_territory = "RUSSIA"
memory_target = 408M
control_files = "D:\ORACLE\ORADATA\DEMO\CONTROL01.CTL"
control_files = "D:\ORACLE\ORADATA\DEMO\CONTROL02.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
undo_tablespace = "UNDOTBS1"
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
audit_file_dest = "D:\ORACLE\ORADATA\ADMIN\DEMO\ADUMP"
audit_trail = "DB"
db_name = "Demo"
open_cursors = 300
diagnostic_dest = "D:\ORACLE\ORADATA"
Thu Nov 01 08:55:55 2012
PMON started with pid=2, OS id=3124
Thu Nov 01 08:55:55 2012
VKTM started with pid=3, OS id=3172 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Nov 01 08:55:55 2012
GEN0 started with pid=4, OS id=3280
Thu Nov 01 08:55:55 2012
PSP0 started with pid=7, OS id=3460
Thu Nov 01 08:55:55 2012
DIA0 started with pid=8, OS id=3580
Thu Nov 01 08:55:56 2012
MMAN started with pid=9, OS id=3624
Thu Nov 01 08:55:56 2012
DBW0 started with pid=10, OS id=3636
Thu Nov 01 08:55:56 2012
LGWR started with pid=11, OS id=3648
Thu Nov 01 08:55:56 2012
CKPT started with pid=12, OS id=3660
Thu Nov 01 08:55:56 2012
SMON started with pid=13, OS id=3668
Thu Nov 01 08:55:56 2012
RECO started with pid=14, OS id=3680
Thu Nov 01 08:55:56 2012
MMON started with pid=15, OS id=3688
Thu Nov 01 08:55:56 2012
MMNL started with pid=16, OS id=3692
ORACLE_BASE from environment = D:\Oracle\Oradata
Thu Nov 01 08:55:55 2012
DIAG started with pid=5, OS id=3444
Thu Nov 01 08:55:55 2012
DBRM started with pid=6, OS id=3452
Thu Nov 01 08:55:57 2012
AUD: OS Error = 1502 encountered while writing audit record
Fri Nov 02 10:54:59 2012
Starting ORACLE instance (normal)
Fri Nov 02 10:55:11 2012
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as D:\Oracle\Oracle11_database\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Красным выделил подозрительные, по моему мнению, места. С OS Error = 1502 разобрался, а вот LICENSE_MAX_USERS = 0 это нормально?
Спасибо.