I had a similar problem. I also have an Oracle8i dB
on a Windows2000 platform. The service is started as
part of the power up procedure.
After I am logged in I have an icon on my desktop
that kicks off a batch file which in turn calls a SQL
file that alters the database open.
My instance is called Road. Here is what I did.
Created two files: a batch file and a SQL file.
Batch file: RoadOpen.bat contains one line:
D:\oracle\ora81\bin\SQLPLUS.exe internal/[Email Address Removed] @.\RoadAlter.SQL
SQL file: RoadAlter.SQL Three lines:
alter database open;
commit;
/
Then I created an icon on my desktop to run the batch
file. This opens up a DOS window that logs in as
internal and alters the dB open. When it is finished
I
close the window and I can then log in as any other
use to the database.
Maybe this will work for you. Good luck.
-- Jim Borths
-- Have a good day today and a better day tomorrow --
--- "Nelson, Paula" <Paula.[Email Address Removed] wrote:
>
> Hi all,
>
> I installed Oracle 8i on a 2000 server, created a
> database, opened the
> database... all was well. I shutdown the database
> and powered down the
> server. Now I cannot get it to open again. There
> has been no activity,
> since I am the only one who knows it exists so far.
>
>
> I can start the database from DBA studio (no mount),
> but cannot start it. I
> get errors from SQL*Plus that will not allow me to
> start it from there.
> Please help!! This project is due tomorrow!!!
>
> Thanks!!
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
=====
- - - Have a good day today and a better day tomorrow - - -
[Email Address Removed] you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
Oracle LazyDBA home page