| oracel not found [message #52252] |
Thu, 11 July 2002 00:21  |
R.SIVAKUMAR
Messages: 48
Registered: February 2002
|
Member |
|
|
hi,
i have a problem connected to sql worksheet.
when i login to system/manager password, the oracle will display the message ora-01034 oracle not found.
After that i connected from command prompt , using internal/****** , and set the oracle_sid=abc and
login to svrmgr30.
Afterthat i used this commands in svrmgr30
shutdown abort
startup
then i got the error
ora-01113 file 6 needs media recovery
ora-01110 data file 6: 'abc_data'
any one help me to solve this problem
bye
siva
|
|
|
|
| Re: oracel not found [message #52253 is a reply to message #52252] |
Thu, 11 July 2002 00:36  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
Hi !
May be this file has been deleted ? or is corrupted.
You should NEVER use shutdown abort. ABORT is the must be use in last resort.
If datafile still here try a recover datafile
|
|
|
|
| Re: oracel not found [message #52261 is a reply to message #52252] |
Thu, 11 July 2002 05:51 |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
heyy try to follow the below steps...
alter database datafile 6 offline (incase of Archivelog mode)
or
alter database datafile 5 offline drop; (incase of no archivelog mode at the svrmgr prompt).
then say startup;
at the svrmgrl prompt... c if it works...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
