Tagged Questions

0
votes
2answers
41 views

Multiple instances in Oracle

I'm really confuse with the term instance and database. So, my first question is how database and Instance are related in Oracle, I mean, whether an instance is associated with one/multiple ...
1
vote
3answers
230 views

Instance Startup Modes & Shutdown Modes

So, I know that there are 3 modes of startup modes available for the instance which is NOMOUNT, MOUNT, and OPEN. What I want to know is in NOMOUNT mode it is stated that the instance started but still ...
1
vote
1answer
71 views

Node and Instance Relationship on Oracle RAC

I'd like to ask about the process of Node and Instance on Oracle RAC functionality. I know that RAC provides Failover, a RAC feature that keeps an application running even if the node that was ...
3
votes
2answers
746 views

Create unique DB_NAME and DB_DOMAIN for an Oracle 11g instance

I am somewhat confused by these terms in the init.ora file: db_domain db_name instance_name plus the database name which is provided to the create database command. I do not completely understand ...
2
votes
1answer
449 views

How to disable instance recovery in ORACLE?

I want my DB to stop instance recovery during opening, how to do it? I want it because it crashes when trying to do instance recovery, I am testing some cases and want to disable it Is there any ...
5
votes
3answers
219 views

For Oracle, we mount the instance to the database or mount the database to the instance?

The following text is extract from oracle documentation. Start the instance, and mount and open the database. This can be done in unrestricted mode, allowing access to all users, or in ...