ORA-01102: cannot mount database in EXCLUSIVE mode

数据库参数和我的实例名称不一致

SQL> startup
Oracle instance started.

Total System Global Area  422670336 bytes
Fixed Size                              1336960 bytes
Variable Size                        402655616 bytes
Database Buffers                12582912 bytes
Redo Buffers                        6094848 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode


SQL> show user
USER is "SYS"
SQL> show parameter name

NAME        TYPE  VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert      string
db_name                              string        orcl
db_unique_name              string        orcl
global_names                    boolean    FALSE
instance_name                  string        tmp
lock_name_space              string
log_file_name_convert      string
service_names                  string    orcl
SQL>
SQL> select status from v$instance;

STATUS
------------
STARTED

SQL>
SQL>


SQL> alter system set db_unique_name=tmp scope=spfile;

System altered.

 再次启动OK!

相关推荐