| tru55 |
| Можно в принципе показать файл параметров, с которым стартуешь (или содержимое alert.log в момент старта). А что касаемо коннекта, то, сидя на сервере и не указывая в строке коннекта @<alias>, можно соединятся с базой БЕЗ listener |
Thu Mar 01 06:34:06 2007
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1706M/2046M, Ph+PgF:2732M/2921M, VA:1945M/2047M
Thu Mar 01 06:34:06 2007
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 =10
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.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 155189248
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
sga_target = 599785472
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 432013312
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 199229440
PMON started with pid=2, OS id=2788
PSP0 started with pid=3, OS id=2792
MMAN started with pid=4, OS id=2796
DBW0 started with pid=5, OS id=2800
LGWR started with pid=6, OS id=2804
CKPT started with pid=7, OS id=2808
SMON started with pid=8, OS id=2812
RECO started with pid=9, OS id=2816
CJQ0 started with pid=10, OS id=2820
MMON started with pid=11, OS id=2824
MMNL started with pid=12, OS id=2828
Thu Mar 01 06:34:07 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Thu Mar 01 06:34:07 2007
alter database mount exclusive
Thu Mar 01 06:34:11 2007
Setting recovery target incarnation to 2
Thu Mar 01 06:34:11 2007
Successful mount of redo thread 1, with mount id 2497207327
Thu Mar 01 06:34:11 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Mar 01 06:34:11 2007
alter database open
Thu Mar 01 06:34:12 2007
Beginning crash recovery of 1 threads
Thu Mar 01 06:34:12 2007
Started redo scan
Thu Mar 01 06:34:12 2007
Completed redo scan
113 redo blocks read, 21 data blocks need recovery
Thu Mar 01 06:34:13 2007
Started redo application at
Thread 1: logseq 18, block 19311
Thu Mar 01 06:34:13 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 18 Reading mem 0
Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_2Y7PT3YC_.LOG
Thu Mar 01 06:34:13 2007
Completed redo application
Thu Mar 01 06:34:13 2007
Completed crash recovery at
Thread 1: logseq 18, block 19424, scn 568098
21 data blocks read, 21 data blocks written, 113 redo blocks read
Thu Mar 01 06:34:14 2007
Thread 1 advanced to log sequence 19
Thread 1 opened at log sequence 19
Current log# 2 seq# 19 mem# 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_2Y7PT93J_.LOG
Successful open of redo thread 1
Thu Mar 01 06:34:15 2007
SMON: enabling cache recovery
Thu Mar 01 06:34:18 2007
Successfully onlined Undo Tablespace 1.
Thu Mar 01 06:34:18 2007
SMON: enabling tx recovery
Thu Mar 01 06:34:18 2007
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2556
Thu Mar 01 06:34:21 2007
Completed: alter database open
Thu Mar 01 06:34:21 2007
db_recovery_file_dest_size of 10240 MB is 0.98% 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.
Это запуск до и после настроек.
SQL> connect sys
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
попытка коннекта на сервере.