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 JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation 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 |