Re: If I delete the INSTANCE, will it affect the database?

The instance is NOT the same as the database. An instance is composed of a set of Oracle processes plus the shared memory space (i.e. the SGA). The database is a set of files (or raw partitions) on disk. A database is mounted and opened by an instance, allowing you application folks to access it. An instance can mount and open different databases (one at a time), and a database can be mounted and opened by different instances (several at a time, in the case of parallel server).

So, getting back to the original question, an instance can be deleted without affecting a database. The original posters statement: "I have two databases under ORCL instance" doesn't make a lot of sense I'm afraid.

Jack Sanders wrote:

> Well, in Oracle-Speak, the instance is the database...
>
> Hope this helps!!!
>
> i'm sorry these guy's are so rude! I am also computer illiterate, so i
> hope you can get something from their information.
>
> -hopplessswssssssss
> ashesh48_at_my-dejanews.com wrote in message
> <6olpsd$l06$1_at_nnrp1.dejanews.com>...
> >Hi AIl, I ran into a problem. Due to problems in CTL1ORCL.ORA file
> >(sid=ORCL) I am not able to start the Instance eventhoguh services are
> >running. I have two databases under ORCL instance. My question is Will it
> >affect the Database if I delete the Instance? Will it delete the database
> >also? OR is there any way that I can recreate only CTL1ORCL.ORA for that
> >instance???Thanks in advance for any help.Ashesh
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sat Jul 18 1998 - 20:17:31 CDT