0
votes
3answers
66 views

What is the instance name of the box I'm logged into?

I'm at the linux prompt of a computer running Oracle 11. Without connecting to the database, how can I determine what is the instance name of the Oracle server running on this box?
3
votes
2answers
522 views

DB2 (LUW) equivalent for Oracle “drop user cascade”

This question is related to creating and initialising test and development databases for an application that has the database running on LUW (linux-unix-windows) On oracle, we have an os user (on ...
0
votes
1answer
61 views

Is SERVICE_NAME forced to be unique per logical database within a network? Would it have sense the opposite?

I like to know your opinion on these two sentences to see if I understood correctly the concept. Put RAC configuration aside, I am talking about logical databases, I understand RAC is like a group of ...
0
votes
2answers
107 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
1k 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
117 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
2k 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
737 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
431 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 ...