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>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s