Scenario: Trying to reset to the existing password throws following error. ERROR at line 1: ORA-28007: the password cannot be reused Solution: Check the user profile set for the user. Check for the existence of a password verify function in the profile. Set the password_verify_function to NULL Another reason could be that the PASSWORD_REUSE_MAX limit has reached. If […]
All posts by Skant Gupta
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 […]
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]# […]
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 […]
TWO_TASK Environment Variables Oracle 12c
There are two environment variables for Unix to connect an Oracle database.One of them is ORACLE_SID and the other one is TWO_TASK. ORACLE_SID is used for connecting a database which is installed to the same host. TWO_TASK is used for connecting an oracle database which is installed another host. I must thank to my fellow DBA […]