Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dell PowerEdge Linux 8.3 Database 19c

Amin AdatiaDec 21 2020

Hi
I am trying to install Oracle 19c (19.9 Patch applied) on Linux 8.3. When I run dbca and select 4 pdbs with prefix p19 and Container C19; the summary gives zero for PDBS and creates only the Container and the seed PDBs. I then tried the same thing on a laptop and only the first time did I get to see the 4 pdbs as selected. However, while creating the database views I get ORA-03113:end of channel communication error.
Am I missing a patch? I have applied to Oracle 19c
6880880 - version OPatch 19.0.0.0.0
P688P31668882
P31750108 (P31771877 and P31772784)
Regards

Comments

Timo Hahn
Answer

You can you an EL that is pointing to a bean that returns the current year as a string. Like EL:

<af:outputText id="footSp" value="Copyright © #{Mybean.currentYear}">

and in the MyBean java class

public String getCurrentYear() {
// do the calculation to get the current year
String year = ...
return year
}

Now, each time you use this outputtext you get the copyright with the current year.

Timo

Marked as Answer by Timo Hahn · Jan 26 2023
Neha Narkhede

@timo-hahn1 Thanks for the reply.
So there is no alternative way to get year from direct EL expression? That way I can avoid bean binding.

Timo Hahn

Sure, you can create a method in the application module that returns the year. Then you can use the return value inside an EL.
The solution using a bean is simpler to implement.

Timo

1 - 3

Post Details

Added on Dec 21 2020
4 comments
411 views