| Connecting Oracle [message #53952] |
Mon, 21 October 2002 01:48  |
Tamjeed Akhtar
Messages: 5
Registered: October 2002
|
Junior Member |
|
|
I can't even log on to oracle as sys or system user. It displays message 'Oracle not available'.
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
|
|
|
|
| Re: Connecting Oracle [message #53958 is a reply to message #53952] |
Mon, 21 October 2002 12:40  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
"Mem# 0 errs 0: C:ORANTDATABASELOG4ORCL.ORA
ORA-1115 signalled during: alter database "orcl" open...
Dump file C:orantRDBMS80traceorclALRT.LOG"
Here is what the docs are saying:
ORA-01115 IO error reading block from file string (block # string)
Cause: The device on which the file resides is probably off line.
Action: Restore access to the device, then retry the operation.
And the file of question is C:ORANTDATABASELOG4ORCL.ORA
Check what is going on with this file - is't there, can you copy it or read it, is it corrupted?
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: Connecting Oracle [message #53961 is a reply to message #53952] |
Tue, 22 October 2002 02:11 |
Tamjeed Akhtar
Messages: 5
Registered: October 2002
|
Junior Member |
|
|
C:ORANTDATABASELOG4ORCL.ORA
I can open this file in notepad but it is in coded language.
Secondly I viewed some error messages in :
Component Services > Event Viewer (local) > Application. These are as below.
First....
Event Type: Error
Event Source: perfctrs
Event Category: None
Event ID: 3101
Date: 22-Oct-02
Time: 11:13:25 AM
User: N/A
Computer: AD-MASTER
Description:
Unable to read IO control information from NBT device.
Second...
Event Type: Error
Event Source: PerfNet
Event Category: None
Event ID: 2002
Date: 22-Oct-02
Time: 11:13:19 AM
User: N/A
Computer: AD-MASTER
Description:
Unable to open the Redirector service. Redirector performance data will not be returned. Error code returned is in data DWORD 0.
Data:
0000: 34 00 00 c0 4..À
Third...
Event Type: Error
Event Source: PerfNet
Event Category: None
Event ID: 2004
Date: 22-Oct-02
Time: 11:13:19 AM
User: N/A
Computer: AD-MASTER
Description:
Unable to open the Server service. Server performance data will not be returned. Error code returned is in data DWORD 0.
Data:
0000: 34 00 00 c0 4..À
After that there are two warnings.
First...
Event Type: Warning
Event Source: Oracle80.orcl
Event Category: None
Event ID: 16
Date: 22-Oct-02
Time: 11:13:10 AM
User: N/A
Computer: AD-MASTER
Description:
Instance orcl has been terminated.
Second...
Event Type: Warning
Event Source: Oracle80.orcl
Event Category: None
Event ID: 12
Date: 22-Oct-02
Time: 11:13:09 AM
User: N/A
Computer: AD-MASTER
Description:
All process in instance orcl stopped
I tried to open CTL1ORCL.ORA but both notepad and wordpad refused to open it. I think it is control file. Please let me know if it helps.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
