The error "ORA-39710: The database mode conflicts with the connection type" usually occurs when your instance is started is upgrade mode and another user other than SYSDBA or SYSOPER roles is trying to connect to the database which will face this error.
Below command will let you know your instance is in RESTRICTED mode or not. SQL> select instance_name,status,logins from v$instance; INSTANCE_NAME STATUS LOGINS ---------------- ------------ ---------- pr OPEN ALLOWED SQL> shut immediate; SQL> startup upgrade SQL> select instance_name,status,logins from v$instance; INSTANCE_NAME STATUS LOGINS ---------------- ------------ ---------- pr OPEN MIGRATE RESTRICTED If your instance is started in upgrade mode and any user or application not having SYSDBA or SYSOPER role is trying to connect the database from another session, then that user will receive below error message. C:\Windows\System32>sqlplus test/test SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 28 14:06:51 2024 Version 19.16.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. ERROR: ORA-39710: The database mode conflicts with the connection type. Enter user-name: In this case, the user who is having SYSDBA or SYSOPER role, only he can connect to the database. Other users have to wait till the upgrade activity is completed or start the database is normal mode. |
Thank you for your comment !