My Oracle Support Banner

Database Resource Status Not Recognize When Instance Startup Using Sqlplus with Different Version of Database and Grid Infrastructure (Doc ID 2559465.1)

Last updated on NOVEMBER 27, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Database instance status still appear in OFFLINE state when instance start with sqlplus in a mixed version environment consisting of database in 12c and Grid in 18c

[<USER>@<HOSTNAME1> ~]$ export ORACLE_SID=<test1>
[<USER>@<HOSTNAME1> ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jun 14 06:22:31 2019

Copyright (c) 1982, 2014, <USER>. All rights reserved.

Connected to an idle instance.

SQL> startup
oracle instance started.

Total System Global Area 1207959552 bytes
Fixed Size 2923776 bytes
Variable Size 503317248 bytes
Database Buffers 687865856 bytes
Redo Buffers 13852672 bytes
Database mounted.
Database opened.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.