Database - RAC/Scalability (MOSC)

MOSC Banner

I forgot to shutdown an Oracle 11g Database before patching

edited Jul 9, 2019 1:18PM in Database - RAC/Scalability (MOSC) 6 commentsAnswered

I have an Exadata server with 2 nodes. I try to apply a patch but I forgot to shutdown the database. I applyed the patch only in node 2.

When I try to login into the instance with sqlplus, it shows this message:

[oracle@dm01dbadm02 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 2 20:39:36 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected.

pgeminis2 SYS:SQL> select * from dual;

select * from dual

*

ERROR at line 1:

ORA-01012: not logged on

Process ID: 0

Session ID: 0 Serial number: 0

pgeminis2 SYS:SQL>

I try to startup the database, and shows this:

pgeminis2 SYS:SQL> startup

ORA-01012: not logged on

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center