Re: Can't log in any more - Help

K Kien wrote:

>I bought a new and bigger harddisk and migrated to it using Symantec Ghost
>7.5. Everything else works fine except Oracle. When I try to login using
>'Scott' - 'tiger', it gives me an error.
>
>"ERROR:
>ORA-01033: ORACLE initialisation or shutdown in progress"
>
>I'm new to Oracle, can anybody please help me how to fix this problem?
>
>Note:
> I'm using:
> W2K Server SP3
> Oracle 9i
> 512Mb RAM
> 120gig HD in 6 partitions
> Oracle program is installed in C:\ but database is
>in E:\. In the old harddisk it works fine but in new one I don't
>know what's wrong.
>
>Regards
>
>
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.515 / Virus Database: 313 - Release Date: 1/09/2003
>
>
>

Try the following at the DOS command prompt:

lsnrtl status? Is the listener started?

sqlplus /nolog
conn / as sysdba
select count(*) from tab$;
if not started:
startup

If there is a problem use oradim.exe to recreate the Oracle service.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)