| Connecting Oracle [message #53911] |
Wed, 16 October 2002 23:42  |
Tamjeed Akhtar
Messages: 5
Registered: October 2002
|
Junior Member |
|
|
Hello !
Last night I successfully logged on to Oracle8 server and did my work. The very next day when I started my application, it displayed the message "Oracle not available". I tried to log on from developer, sql, enterprise manager but got the same message.
|
|
|
|
|
|
| Re: Connecting Oracle [message #53922 is a reply to message #53911] |
Thu, 17 October 2002 15:27  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Check the OracleService<SID> in your Control Panel -> Services. It should be started.
Also check your alert log to see what happend after the last time db was running. It is in your ORACEL HOME adminbdump directory.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: Connecting Oracle [message #53945 is a reply to message #53922] |
Sat, 19 October 2002 01:09 |
Tamjeed Akhtar
Messages: 5
Registered: October 2002
|
Junior Member |
|
|
Here is my alert log. Please examin and tell me what to do because I am not a master in Oracle8. This is of two days. First Oct 19 and second Oct 11. Start is the same on both days but at the end both differes.
Sat Oct 19 11:22:04 2002
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V5.0, OS V8.147, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 11534336
control_files = C:orantDATABASEctl1ORCL.ora
db_block_buffers = 1000
db_block_size = 2048
log_buffer = 8192
log_checkpoint_interval = 10000
db_files = 1024
db_file_multiblock_read_count= 8
sequence_cache_entries = 10
sequence_cache_hash_buckets= 10
remote_login_passwordfile= SHARED
global_names = TRUE
distributed_lock_timeout = 300
distributed_transactions = 5
open_links = 4
db_name = ORCL
text_enable = TRUE
job_queue_processes = 2
job_queue_interval = 10
job_queue_keep_connections= FALSE
parallel_max_servers = 5
background_dump_dest = %RDBMS80%trace
user_dump_dest = %RDBMS80%trace
max_dump_file_size = 10240
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
Sat Oct 19 11:22:05 2002
alter database "orcl" mount exclusive
Sat Oct 19 11:22:10 2002
Successful mount of redo thread 1, with mount id 1003492066.
Sat Oct 19 11:22:10 2002
Database mounted in Exclusive Mode.
Completed: alter database "orcl" mount exclusive
Sat Oct 19 11:22:10 2002
alter database "orcl" open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 1 Seq 157 Reading mem 0
(From here, the difference begins. Following is the error on Oct 19.)
Mem# 0 errs 0: C:ORANTDATABASELOG4ORCL.ORA
ORA-1115 signalled during: alter database "orcl" open...
Dump file C:orantRDBMS80traceorclALRT.LOG
(And following is the last successful log on to Oracle on Oct 11.)
Mem# 0 errs 0: C:ORANTDATABASELOG2ORCL.ORA
Crash recovery completed successfully
Fri Oct 11 17:15:09 2002
Thread 1 advanced to log sequence 156
Thread 1 opened at log sequence 156
Current log# 4 seq# 156 mem# 0: C:ORANTDATABASELOG1ORCL.ORA
Successful open of redo thread 1.
Fri Oct 11 17:15:09 2002
SMON: enabling cache recovery
Fri Oct 11 17:15:20 2002
SMON: enabling tx recovery
Fri Oct 11 17:15:21 2002
Completed: alter database "orcl" open
Dump file C:orantRDBMS80traceorclALRT.LOG
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
