SQLPLUS VERSION IS DIFFERENT FROM DATABASE VERSION
Cause:
When i open sqlplus cmd for 11.2.0.4 , it connects to 19c instance which already run on the system.
E:\app\product\11.2.0\dbhome_1\BIN>sqlplus.exe
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 5 12:49:33 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Workaround:
Set the oracle sid and oracle home and other environment variables properly
E:\app\product\11.2.0\dbhome_1\oracore\zoneinfo>set ORACLE_SID=saeuv07
E:\app\product\11.2.0\dbhome_1\oracore\zoneinfo>set ORACLE_HOME=E:\app\product\11.2.0\dbhome_2
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Windows\system32>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 5 16:01:07 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>