ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

 

This document describes how fix the "ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only" in 19C CDB/PDB database.

Below are the error details.

SQL> show parameter db_name

NAME      TYPE VALUE

------------------------------------ ----------- ------------------------------

db_name      string GOLD

SQL> alter session set container=GOLDPDB;

Session altered.

SQL> select file_name from dba_data_files;

select file_name from dba_data_files

                      *

ERROR at line 1:

ORA-01219: database or pluggable database not open: queries allowed on fixed

tables or views only

SQL>

Cause: This environment is 19c CDB/PDB environment and we normally observe this error when we bounce the database. After bounce the database, we need to open the pluggable database. Otherwise it will be in mount state.

Solution:

SQL> show pdbs

    CON_ID CON_NAME   OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED   READ ONLY  NO

3 GOLDPDB          MOUNTED

SQL>

SQL> alter session set container=GOLDPDB;

Session altered.

SQL> 

SQL> alter pluggable database open;

Pluggable database altered.

SQL> 

SQL> show pdbs

    CON_ID CON_NAME   OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

3 GOLDPDB   READ WRITE NO

SQL> select file_name from dba_data_files;

FILE_NAME

--------------------------------------------------------------------------------

/u02/oradata/GOLD/GOLDpdb/system01.dbf

/u02/oradata/GOLD/GOLDpdb/sysaux01.dbf

/u02/oradata/GOLD/GOLDpdb/undotbs01.dbf

/u02/oradata/GOLD/GOLDpdb/users01.dbf

/u02/oradata/GOLD/GOLDpdb/apex_data01.dbf

SQL> 

Thanks for going through the post.................

"ORA-01017: invalid username/password; logon denied" issue after EBS database clone(refresh)

This document describes how to fix "ORA-01017: invalid username/password; logon denied" issue.

 

Got below issue as part of post clone steps after refresh of EBS cloned database.

 

Issue:

[oracle@server1 ]$ sqlplus apps

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jan 5 7:10:45 2022

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

Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
[oracle@server1 ]$

 

SQL> conn apps/xxxxxx
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> 

 

Solution:

SEC_CASE_SENSITIVE_LOGON should set to FALSE to overcome this issue.

 

SQL> show parameter SEC_CASE_SENSITIVE_LOGON

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE
SQL> alter system set SEC_CASE_SENSITIVE_LOGON=FALSE
  2  ;

System altered.

SQL> show parameter SEC_CASE_SENSITIVE_LOGON

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     FALSE

SQL> conn apps/xxxxxx
Connected.
SQL>

 

 

Thanks for going through the post.............