[ale] Probably a stupid Oracle question.

[Jim Popovitch]

Josh,

Have you deleted/moved/unmounted any physical files that Oracle needs? 
The reason I ask this is because I have seen similar errors if you add
a tablespace to Oracle, and then delete the physical file that the
tablespace existed in (without doing a proper drop).

Based on those errors I would say that Oracle is not starting up
completely because it is trying to initially mount a database (file or
partition) in exclusive mode, and that file/partition doesn't exist.  

The solution is to add a parameter to 'connect system' that forces it
to load regardless of missing tables.  Unfortunately the name of this
parameter escapes me, and I don't currently have access to a Oracle
system.  Once you have forced a session, all you will need to do is
drop the offending table.  Unfortunately (again), I'm not too sure how
to tell which table is causing you problems.

hth some. ;)

-Jim P.

--- Josh Freeman <josh.freeman at arch.gatech.edu> wrote:
> Many thanks to those that responded to my previous Oracle question. I
> 
> was able to get Oracle 8.1.7 to install pretty effortlessly on SuSE
> 7.0. 
> Now I have one hopefully trivial question and I will be off to the
> races.
> 
> when I try to work in svrmgrl, I  get this error:
> 
> SVRMGR> connect system
> Password:
> ORA-01033: ORACLE initialization or shutdown in progress
> SVRMGR>
> SVRMGR>
> SVRMGR>
> SVRMGR> shutdown
> ORA-01012: not logged on
> SVRMGR> connect internal
> Connected.
> SVRMGR> shutdown
> ORA-01507: database not mounted
> ORACLE instance shut down.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area                         72704160 bytes
> Fixed Size                                          73888 bytes
> Variable Size                                    55681024 bytes
> Database Buffers                                 16777216 bytes
> Redo Buffers                                       172032 bytes
> ORA-01102: cannot mount database in EXCLUSIVE mode
> SVRMGR>
> 
> 
> What have  I  done wrong?
> 
> Thanks.
> 
> 
> 
> -- 
> Josh Freeman
> Technical Manager
> Center for Rehabilitation Technology
> 
> --
> To unsubscribe: mail majordomo at ale.org with "unsubscribe ale" in
> message body.


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
To unsubscribe: mail majordomo at ale.org with "unsubscribe ale" in message body.