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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Illegible or invisible fonts in dbca using X server in OEL7

Javier-Garduño-M-OracleNov 17 2016 — edited Jan 13 2017

Hello Masters.

I am using Oracle Linux 7.2 installed from an OBI image. When I try to install a database (12.1.0.2) by using runInstaller script in a virtual machine with Oracle Linux 6.6 running in VirtualBox (5.0.26), I get an installation window with illegible fonts. In the beginning I thought it was due to my hots OS needed fonts packages because I had already opened the runInstaller script in my virtual machine correctly, but after install all the fonts packages in my host OS based on the packages included in the virtual machine, I did not see changes. My second attempt was to use the same Oracle Database software in my host in order to run the runInstaller script without an ssh connection, that execution was successful, After, I used a ssh connection from my host to my host and after execute the runInstaller script I got an installation window with illegible fonts again, also I tried to run NETCA, NETMGR and DBUA but I saw the same problem, however running SLQDeveloper it shows the fonts correctly.

Could someone help me to discover and fix the problem?

Additional information:

My java version is 1.8.0_101.

My OS has all updates until November 17, 20016.

Selecting with pointer some illegible fonts they become legible.

Screenshot from 2016-11-17 15-12-23.png

Comments

Jasper Tanglib

Tried to clear browser's cache and tried to use another browser (Firefox). I does not work.

Jasper Tanglib

I am able to delete other files like
image.pngimage.png
But for some reason I cannot delete this specific file I uploaded named Process.zip, When I try to delete this rows, it would just hang or the page just freezes forever.
image.png
I am working with files called Process.zip and I have successfully uploaded and deleted this kind of file before. Just this day it decides to be freezing now.

jariola

I don't know what is issue with your browser. But you shouldn't directly update, insert or delete anything from APEX internal tables. That isn't supported.

Billy Verreynne

Do the DELETE statement - then find that session in v$session and look at its wait and event states.

Jasper Tanglib

@billy-verreynne , I found out about the term locks and this is very new to me and I think this is the cause of my issue. It's something like a session that's still running so I think I'll need to find out where that is and then kill it.
I remember I did execute a WHILE LOOP on those rows that will never exit the loop.
I have tried to query FROM v$session, or v$lock, or dba_objects but I'm only getting table or view does not exist.
image.pngCan you help how I could query this in Oracle Apex?

Billy Verreynne

Your Oracle schema needs select privs on the data dictionary.
Talk to your DBA about providing this grant, or to assist in determining the wait and events states of the problem session.
Wearing my DBA hat, I have no issues granting developers access to v$ virtual performance views in dev environments - it provides them with better insights into the technical workings of Oracle.

Jasper Tanglib

Would the query my DBA need to execute be this? grant select any dictionary to schema_name;

Billy Verreynne

Would the query my DBA need to execute be this? grant select any dictionary to schema_name;
Yes.

Jasper Tanglib

Thank you @billy-verreynne. I'll be trying this approach as it also seems to be the only solution I have seen through my extensive research on this today.

Jasper Tanglib
Answer

Just a reference for anyone reading this thread.
We were not sure how to specifically locate the locked rows and table and was taking much time so a workaround that my DBA did was restart the Autonomous database and that seemed to kill all the sessions on the locked rows so now it's working well.
I think this is not recommended if you have multiple developers and your app should be running all the time.

Marked as Answer by Jasper Tanglib · Apr 20 2021
Billy Verreynne

Jasper, the v$session view has columns indicating the session (if any), blocking the current session.
Remember that hitting the db reset button, effectively destroys the runtime context and data required for root cause analysis - and usually leaves you blind from preventing the problem in future.

1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 10 2017
Added on Nov 17 2016
12 comments
2,401 views