ORA-39127: unexpected error from call to “EXFSYS”.”DBMS_EXPFIL_DEPASEXP” during datapump export

Scenario: A full database export using both conventional export utility and datapump has so many errors and warnings in their log file. Conventional Export log EXP-00008: ORACLE error 6550 encountered ORA-06550: line 1, column 14: PLS-00201: identifier ‘EXFSYS.DBMS_EXPFIL_DEPASEXP’ must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored EXP-00083: The previous problem occurred when […]

Read More

ORA-00959 Error while trying to drop a tablespace

Scenario: A tablespace has been created in the database through a script using Mixed case.Now we want to drop the tablespace.

We are unable to drop the tablespace even if it is available. The reason is while creating the tablespace the name was specified in mixed case within double quotes as follows

[…]

Read More

Compatibility Matrix for Oracle Database

Upgrade Compatibility Matrix for Upgrading to 12.2.x Minimum Version of the database that can be directly upgraded to Oracle Database 12c Release 2            Source Database                         Destination Database                                  11.2.0.3 / 11.2.0.4                                  12.2.x                                  12.1.0.1 / 12.1.0.2                                  12.2.x The following […]

Read More

kupprdp: master process DM00 started

In the alert log we find this error while taking export. Alert log: ======= kupprdp: master process DM00 started with pid=42, OS id=7353 to execute – SYS.KUPM$MCP.MAIN(‘SYS_EXPORT_TABLE_01’, ‘S2’, ‘KUPC$C_1_20160821122303’, ‘KUPC$S_1_20160821122303’, 0); kupprdp: worker process DW01 started with worker id=1, pid=25, OS id=7355 to execute – SYS.KUPW$WORKER.MAIN(‘SYS_EXPORT_TABLE_01’, ‘S2’); Solutions. ======== Step1: Check the job name with […]

Read More

Data Guard Archive Tracing

You can trace the archive logs on either the primary or the standby database by setting the log_archive_trace initialization parameter

Trace files located in user_dump_dest location. On the primary database, the log_archive_trace parameter controls the output of the ARCn (archiver) FAL (fetcharchived log) LGWR (log writer) background processes. On the standby databases, it traces […]

Read More

Oracle 18c.. New Features.. What’s NEWS..

This article was written by Skant Gupta and Joel Perez in Oracle OTN. If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS Well.. Oracle 18c.. one release more.. ? Uhmm perhaps not.. Oracle 18c has a that kind of […]

Read More

OLSNODES command in RAC

The olsnodes command provides the list of nodes and other information for all nodes participating in the cluster. You can use this command to quickly check that your cluster is operational, and all nodes are registered as members of the cluster. This command also provides an easy method for obtaining the node numbers.

SYNTAX […]

Read More

RAC Useful Srvctl Commands

Use the Server Control (SRVCTL) utility to manage various components and applications in your cluster. This appendix contains reference information for Server Control commands, including utility usage information and a comprehensive listing of the SRVCTL commands. SRVCTL is installed on each node in a cluster by default. To use SRVCTL, log in to the operating […]

Read More

RAC Useful CRSCTL Commands

CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects. Oracle Clusterware 11g release 2 (11.2) introduces cluster-aware commands with which you can perform check, start, and stop operations on the cluster. You can run these commands from any node in the cluster on another node […]

Read More

Oracle Cloud (DBaaS): Access Oracle Cloud Instance in GUI Mode

This article was written by Skant Gupta and Joel Perez in Oracle OTN. If you want to be updated with all our articles send us the Invitation or Follow us: Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ or Join our LinkedIn group: Oracle Cloud DBaaS In this article we will show you how to access oracle cloud instance in GUI mode. Create […]

Read More