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 […]
Category: ORACLE DATABASE
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 […]
Ways to avoid ORA-01555 snapshot too old error
Being the “Oracle DBA ” when the UNDO topic comes in an interview question. Normally interviewer as an about ORA-01555 snapshot too old error. We reply about three or four lines as an answer For this question. For strong knowledge, we must have deep knowledge about this. Let’s have look on ORA-01555 snapshot too old error. ORA-01555: snapshot too old: rollback […]
Tuning the locks of SGA
This post describes some deep knowledge of SGA. LOCK_SGA is used to make sure that the contents from the SGA are not flushed, i.e data from the DB buffer cache not written back to disc. It is like to pin the contents of SGA. SGA_LOCK locks the entire SGA into physical memory. It is usually advisable to […]
MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET
Today’s article is about to add some deep knowledge in the Oracle’s database knowledge. We are going to have look at basic elements of Oracle database. This article is most useful for freshers and beneficial for experienced DBAs too. In Oracle Database we read about MEMORY_TARGET, SGA_TARGET, and PGA_AGGREGATE_TRAGET. Let’s have a technical definition of these teams. […]
How To Find DBID in NOMOUNT State
Oracle Database identifier in short DBID is an internal, unique identifier for an Oracle database. Database administrator must note down the DBID in safe place, so that any miss-happening to the database could be easily identified and recovered. In case it is required to recover SPFILE or control file from autobackup, such as disaster recovery, […]
Schema and Non-Schema Objects in Oracle Database
Oracle database contains schema objects like views, tables, triggers etc., and several other types of objects which are also stored in the database but are not contained in a schema. A schema is a collection of logical structures of data, or schema objects which is owned by a database user and has the same name […]