Oracle multi-instance

Create and manage multiple database instances in Oracle
1007 people read comments (0) collect reports

1. After the database assist or create database statement is used, the system prompts that the database already exists.

2. Create with database configuration maintenance ance, which is time-saving, secure, and efficient.

Next, the question is, which database did I log on to after using sqlplus? In the experiment, the default value is the one you just created,

How do I select which one to log on?

The following format is used when the user is input after being connected with sqlplus:

Username/password @ Database Name

You can.

 

Of course, multiple instances can also be started at the same time.
The method is:
CMD
-- Start an instance whose Sid is SN1
Set oracle_sid = SN1
Sqlplus/nolog
Conn/As sysdba
Startup
-- Start an instance whose Sid is Sn2
Exit -- exit sqlplus
Set oracle_sid = Sn2
Sqplus/nolog
Conn/As sysdba
Startup

In this way, two database instances can work simultaneously.

In Windows, it is simpler. Each instance corresponds to a service and is set to auto start or manually start.

 

However, after a database is closed, other users will be prompted with an adapter problem when logging on, that is, the port listening program is also closed.

Static registration listening is required from the Internet, but you do not understand what is going on. The online example is as follows:

You need to add the service to be listened to in listener. ora. In Automatic Registration mode, you can only disable it remotely but cannot start it. Therefore, if you want to remotely start the service, you must manually register the service. Make sure that the client and server versions are consistent.

(Sid_desc =
(Sid_name = test)
(ORACLE_HOME =/APP/Oracle/product/10.2)
(Global_dbname = test. World)
)