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 […]
Monthly Archives: October 2017
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. SQL> select tablespace_name,status from dba_tablespaces; TABLESPACE_NAME STATUS ————————– ——— SYSTEM ONLINE SYSAUX […]
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 […]
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 […]
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 alter system set log_archive_trace=8 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 […]
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 […]
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. oracle@vgeb07hr:/dev/mapper [+ASM1]# […]
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 […]
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 […]
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 […]