Skip to main content

Featured

Missing Java Classes - Oracle Database

 Recently in out UAT database our DBA had found that the component JAVAVM (JServer JAVA Virtual Machine) is invalid, and hence he did the JVM reload. One thing he forgot was that the impact of JVM reload on existing JAVA objects in the database. Yes, all the java classes/objects got dropped due to the sudden JVM reload.   Ours is not a standalone database it has various applications running on top of using several java classes, and hence all our applications stopped working. So after a lot of trial and errors, we figured out the complete steps to fix our issue. Query to check the java objects in the database: select owner , count(*) from dba_objects where OBJECT_TYPE like '%JAVA%' group by owner;   Oracle EBusiness Suite Application - APPS                a)        Take a backup of $AD_TOP/admin/driver/adldjava.drv and replace all loadjava commands with below lines loadjava csf java...
1 comment
Read more
Labels

Oracle Data Dictionaries - Quick overview

Data dictionaries are views that are created by combining various system level tables in Oracle database.
These data dictionary views are nothing but the metadata of the database.
There are copious views as such, to provide information on database, tablespaces, objects, segments, etc.
Below are few of the most ubiquitously used dictionary views.
Every DBA_ views has an equivalent USER_ views and ALL_ views, which are specific to each and every user/schema
  • Dba_tablespaces
  • Dba_data_files
  • Dba_temp_files
  • Dba_directories
  • Dba_users
  • Dba_objects
  • Dba_segments
  • Dba_sys_privs
  • Dba_tables , etc…
Privilege required
By default SYS and SYSTEM database users will have access to these views, if any other user needs access to these views then that user should be provided with the below grant.
Grant select any dictionary to <username>;
Hope this helps!!
Labels:

Comments

Post a Comment

Popular Posts