свежеустановлено. секурити есеншл, но он и на остальных компах и нормально работает.
Path:
Цитата: Path=D:\oracle\product\10.2.0\client_1\bin;D:\oracle\product\10.2.0\db_1\bin;C:\
Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Wi
ndows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPo
werShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;
C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program File
s (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\I
ntel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\OpenVPN\bi
n;C:\Program Files (x86)\Common Files\Borland Shared\BDE;d:\Oracle\Orant\bin;C:\
Program Files (x86)\OpenVPN\bin
через sqlplus/nolog база опенится нормально. сервер приложений стартует нормально.
alert:
Цитата: Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 268435456
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
nls_language = RUSSIAN
nls_territory = RUSSIA
sga_target = 658505728
control_files = D:\ORACLE\ORADATA\SHUBA14\CONTROL01.CTL, D:\ORACLE\ORADATA\SHUBA14\CONTROL02.CTL, D:\ORACLE\ORADATA\SHUBA14\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 373293056
compatible = 10.2.0.3.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
O7_DICTIONARY_ACCESSIBILITY= TRUE
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=SHUBA14XDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\SHUBA14\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\SHUBA14\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\SHUBA14\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\SHUBA14\CDUMP
db_name = SHUBA14
open_cursors = 300
pga_aggregate_target = 219152384
PMON started with pid=2, OS id=1540
PSP0 started with pid=3, OS id=3800
MMAN started with pid=4, OS id=4716
DBW0 started with pid=5, OS id=5232
LGWR started with pid=6, OS id=5568
CKPT started with pid=7, OS id=5736
SMON started with pid=8, OS id=3336
RECO started with pid=9, OS id=5916
CJQ0 started with pid=10, OS id=2448
Mon Dec 03 17:03:01 2012
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр
O/S-Error: (OS 183) Невозможно создать файл, так как он уже существует. !
MMON started with pid=11, OS id=5768
Mon Dec 03 17:03:01 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Dec 03 17:03:01 2012
starting up 1 shared server(s) ...
Mon Dec 03 17:03:02 2012
ALTER DATABASE MOUNT
MMNL started with pid=12, OS id=5200
Mon Dec 03 17:03:07 2012
Setting recovery target incarnation to 1
Mon Dec 03 17:03:07 2012
Successful mount of redo thread 1, with mount id 407747526
Mon Dec 03 17:03:07 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon Dec 03 17:03:08 2012
ALTER DATABASE OPEN
Mon Dec 03 17:03:08 2012
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Mon Dec 03 17:03:08 2012
Started redo scan
Mon Dec 03 17:03:08 2012
Completed redo scan
336 redo blocks read, 85 data blocks need recovery
Mon Dec 03 17:03:08 2012
Started redo application at
Thread 1: logseq 77, block 3
Mon Dec 03 17:03:09 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 77 Reading mem 0
Mem# 0: D:\ORACLE\ORADATA\SHUBA14\REDO02.LOG
Mon Dec 03 17:03:09 2012
Completed redo application
Mon Dec 03 17:03:09 2012
Completed crash recovery at
Thread 1: logseq 77, block 339, scn 1672746
85 data blocks read, 85 data blocks written, 336 redo blocks read
Mon Dec 03 17:03:09 2012
Thread 1 advanced to log sequence 78 (thread open)
Thread 1 opened at log sequence 78
Current log# 3 seq# 78 mem# 0: D:\ORACLE\ORADATA\SHUBA14\REDO03.LOG
Successful open of redo thread 1
Mon Dec 03 17:03:09 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Dec 03 17:03:09 2012
SMON: enabling cache recovery
Mon Dec 03 17:03:10 2012
Successfully onlined Undo Tablespace 1.
Mon Dec 03 17:03:10 2012
SMON: enabling tx recovery
Mon Dec 03 17:03:11 2012
Database Characterset is CL8MSWIN1251
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=4392
Mon Dec 03 17:03:16 2012
Completed: ALTER DATABASE OPEN
Mon Dec 03 17:03:16 2012
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Dec 03 17:03:17 2012
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр !
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр
O/S-Error: (OS 1) Неверная функция. !
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр
O/S-Error: (OS 1) Неверная функция. !
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр
O/S-Error: (OS 1) Неверная функция. !
Mon Dec 03 17:03:31 2012
OER 7451 in Load Indicator : Error Code = OSD-04500: задан недопустимый параметр
O/S-Error: (OS 1) Неверная функция. !