Tag: ORA-06512

Oracle Error : ORA-31003/ORA-06512

Posted on by Osama Mustafa in Database
The Below Error Appear when you are trying to use dbms_network_acl_admin

ORA-31003: Parent /sys/acls/File_name.xml already contains child entry
ORA-06512: at “SYS.DBMS_NETWORK_ACL_ADMIN”, line 226
ORA-06512: at line 30
ORA-01403: no data found

The Solution Is Simple

exec dbms_network_acl_admin.drop_acl(‘/sys/acls/file_name.xml’);
Commit
Re-Run Script Again.

Thank you
Osama Mustafa

ORA-20222: Workload was not captured in the current database

Posted on by Osama Mustafa in Database


Happy New Year For All , And Wish you All Best 

ORA-20222 “Given capture_id \”%s\” is invalid or the corresponding capture failed”

ORA-20222: Workload was not captured in the current database. Cannot export!
ORA-06512: at “SYS.DBMS_WORKLOAD_CAPTURE”, line 1588
ORA-06512: at line 2

 Regarding to Https://support.oracle.com Note :

DATABASE CAPTURE AND REPLAY COMMON ERRORS AND REASONS [ID 463263.1]
This Error 

is a generic error message that can occur due other underlying error during Capture.
Check the error accompanying with ORA-20222.

Ensure correct directory name is used including check the case-sensitivity of the directory name.
The directory name is case sensitive. Ensure READ and WRITE privilege on the DIRECTORY object to the which is the capture is written.

Thank you 
Osama mustafa

Happy New Year Again . 

ora-29540 class oracle/jpub/runtime/dbws/dbwsproxy does not exist

Posted on by Osama Mustafa in Database 
ERROR at line 1:
ORA-29540: class oracle/jpub/runtime/dbws/DbwsProxy does not exist
ORA-06512: at "SYS.UTL_DBWS", line 195
ORA-06512: at "INTERFACE.GET_JOKE", line 13
 
Logout of sqlplus and run:
loadjava -u / -r -v -f -s -grant public -genmissing  dbwsclientws.jar dbwsclientdb102.jar
 
 
Enjoy 
osama mustafa

ORA-39002,ORA-39070,ORA-29283,ORA-06512

Posted on by Osama Mustafa in Database

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 475
ORA-29283: invalid file operation
This problem is encountered when you try to import a data-pump dump file.
Actually, it is somewhere related to permission issues and also due to mismatch of the steps performed during import operation.
You can Check you permission by below command :

select * from all_directories where directory_name = ‘DIRECTORY_NAME‘;

select * from user_tab_privs
where table_name = ‘DIRECTORY_NAME‘;

select * from user_sys_privs

where privilege = 'CREATE ANY DIRECTORY';

Check the Below Steps : 

 1) Create data-pump directory

CONN / AS SYSDBA

CREATE OR REPLACE DIRECTORY test_dir AS '';

2.) Grant permission now to this directory 

GRANT READ, WRITE ON DIRECTORY test_dir TO ;

3.)Copy the desired dump-file at directory Location :
4.)Start import now .

Good Luck

Thank you
Osama mustafa

ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 960

Posted on by Osama Mustafa in Database
This Error Appear when you try to create MATERIALIZED VIEW On remote View 

First you have to know it

 Bug 5583712  ORA-942 on create materialized view on remote view

Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 11
Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected

 You can check Metalink Doc : 5583712.8 


But I would Share this solution All you Have to do is follow the below steps :

CREATE   MATERIALIZED VIEW RHC
  BUILD IMMEDIATE
  USING INDEX
  REFRESH COMPLETE ON DEMAND START WITH SYSDATE+1 NEXT SYSDATE + 8/24
  AS SELECT * FROM vw_RHC@remotedb;
 

ORA-00942: TABLE OR VIEW does NOT exist
ORA-06512: AT “SYS.DBMS_SNAPSHOT_UTL”, line 960
ORA-06512: AT line 1

The Solution is :

CREATE   MATERIALIZED VIEW RHC
  BUILD IMMEDIATE
  USING INDEX
  REFRESH COMPLETE ON DEMAND START WITH SYSDATE+1  NEXT   SYSDATE + 8/24
  AS   AS SELECT * FROM (SELECT * FROM vw_employees@remotedb);

Materialized VIEW created.

Thank you
Osama mustafa