Error ORA-01219 , ORA-01172, ORA-01151, ORA-01033 (Doc ID 1605148.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 7.0 to 8.3.1.0 [Release 7.0 to 8.3]
Information in this document applies to any platform.
Affected Database: Oracle

Symptoms

Primavera P6 Professional Project Portfolio Management 8.3

When attempting to login in p6,
the following error occurs.

ERROR
-----------------------

Popup window shows: "unable to connect to the database"

Database configuration shows:

"error: ORA-01219: database not open: queries allowed on fixed tables/views only."
"ORA-01172: recovery of thread 1 stuck at block 1949 of file 2"
"ORA-01151: use media recovery to recover block, restore backup if needed"

"ORA-01033: ORACLE initialization or shutdown in progress"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. open P6
2. Enter user name and password
3. First pop up message appear.
4. creating alias connection.
5. error appear.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot login in P6.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms