While changing the password of internal oracle users in oracle 12c , after it got expired, you may get error as below. ORA-600:[kpdbModAdminPasswdInRoot: ...
ORA-
ORA-20013: DBMS_QOPATCH ran mostly in non install area
While running datapatch tool in Oracle 12c, as part of post patching got ORA-20013 error. Use below steps to solve the issue. Problem: cd /oracle/app/oracle/product/12.1.0.2/dbhome...
ORA-29548: Java system class reported
You might have faced below error. SQL> select dbms_java.get_jdk_version() from dual; select dbms_java.get_jdk_version() from dual * ERROR at line 1: ORA-29548: Java system class reported: release o...
ORA-02304: invalid object identifier literal while doing impdp
While doing import, got below error. CREATE TYPE "TEST_CVGCM02"."TEST_TEST2" OID 'BE4C0AFD318A07CBE0443C4A923B4794' AS OBJECT ( NAME varchar2(40), AGE number(4), ID number(5) ) ORA-39083: Object type ...
ORA-02030: can only select from fixed tables/views
While providing select privilege on a v$ view , you may get below error. ORA-02030: can only select from fixed tables/views Problem: SQL> grant select on v$session to test; g...
ORA-04063: view “SYS.KU$_RADM_FPTM_VIEW” has errors
While taking export dump using expdp , if are getting below error. Error: Processing object type DATABASE_EXPORT/SYS_USER/USER Processing object type DATABASE_EX...
ORA-04063: package body “SYS.DBMS_CUBE_EXP” while expdp
PROBLEM: Received ORA-4063 error while taking expdp, like below. $ expdp system/manager directory=EXPDP dumpfile=exptest.dmp logfile=exp_test.log schemas=TEST Export: Release 11.2.0.4.0 - Producti...
ORA-04045 errors and ORA-01031 while running utlrp.sql
There can be scenarios where you will get below error while running utlrpl.sql SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual ...
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
I was getting ORA-00119 and ORA-00132 error while startup nomount a new db. SQL> startup nomount ORA-00119: invalid specification for system parameter LOCAL_LIS...