ORA-01093 troubleshooting
The environment is the 10.2.0.5 environment of the DG of RAC + RAC.
At that time, I opened the master and slave databases and wanted to start the MRP process (Real-time application). However, the 1093 error occurred when executing the statement:
SQL> alter database recover managed standby database;
Alter database recover managed standby database
*
ERROR at line 1:
ORA-01093: alter database close only permitted with no sessions connected
SQL>! Oerr ora 1093.
01093,000 00, "alter database close only permitted with no sessions connected"
// * Cause: There is at least one more session other than the current one
// Logged into the instance. alter database close is not permitted.
// * Action: Find the other sessions and log them out and resubmit the command
The reason is that more than one session connects to the current database instance. Alter database close is not permitted;
The solution is to exit the session;
I do not understand it clearly. When I check the status of the master and slave databases, I find that the slave database is in the read-only status:
SQL> select open_mode from gv $ database;
OPEN_MODE
----------
READ ONLY
READ ONLY
Ah, careless and mistaken. Starting the real-time application standby database must be in the mount state;
The solution is to start the slave database to the mount state and then execute:
SQL> shutdown immediate;
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 327155712 bytes
Fixed Size 1273516 bytes
Variable Size 96469332 bytes
Database Buffers 226492416 bytes
Redo Buffers 2920448 bytes
Database mounted.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
OK. To solve the problem, you must enable MRP. The slave database must be in the MOUNT status.
(Note: The MRP can be enabled only when the Oracle 10g is in the mount state. However, 11 GB can be used in open mode)
Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform
Installing Oracle 12C in Linux-6-64
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian