A newcomer just learning oracle, a little confused, if you have multiple databases, sys after logging in, can be shutdown close the database, which is closed, another startup time, which is open, or closed and open all database, hope everybody can help me to solve, thank you very much

CodePudding user response:

ORACLE database is started, if you can narrow understanding is given priority to the sample database startup, and then have the control file to load the corresponding database file, are successfully loaded, foreign service

You said multiple databases is more than one user?

CodePudding user response:

Log on to only one database, startup and shutdown, that is, there is only one instance of the
Multiple database you say may refers to the schema, we usually think of oracle is according to the user to organize data, a database instance can have multiple users under
Start stop all start, full stop

CodePudding user response:

If there are multiple instance, the operation is determined the current sid

CodePudding user response:

reference 1st floor sych888 response:

ORACLE database is started, if you can narrow understanding is given priority to the sample database startup, and then have the control file to load the corresponding database file, are successfully loaded, foreign service

You said multiple databases is more than one user?
A database can be connected to right multiple users, since the start an Oracle software can manage multiple databases? If you can manage multiple databases, when loading the database is to choose which database control file? Is such a little confused, thank you very much

CodePudding user response:

reference jdsnhan reply: 3/f

if there are multiple instance, the operation is determined the current sid

if it is sysdba login, which database is enabled, thank you!

CodePudding user response:

The

CKC quote 2 floor response:

log on only one database, startup and shutdown, that is, there is only one instance of the
Multiple database you say may refers to the schema, we usually think of oracle is according to the user to organize data, a database instance can have multiple users under
Start stop all start, stop all

an Oracle software can have multiple databases? When have sysdba login, enable instance load which database? Thank you very much!

CodePudding user response:

You use PLSQL dev login, the default table must be the users under the table!