Oracle Database Gateway for Microsoft SQL Server

The gateway system identifier (SID) is an alphanumeric character string that identifies a gateway instance. You need one gateway instance, and therefore one gateway SID, for each SQL Server database you are accessing. The SID is used as part of the file name for the initialization parameter file. The default SID is dg4msql. You can […]

Read More

Installation of Oracle Database Gateway

Downloading Gateway Products Oracle Database Gateway products can be downloaded from the following – 1. Oracle Technology Network – OTN – http://www.oracle.com/technology/software/products/database/index.html Choose the relevant platform and version then the ‘See All‘ option. Under that there will be an option to download the Gateway products, for example – Oracle Database Gateways 11g Release 2 (11.2.0.1.0) […]

Read More

Overview For Oracle Database Gateway

Gateway Installation You can install Oracle Database Gateway in either of the following configurations: ■ On the same computer as an existing Oracle database but in a different Oracle home. ■ On a system with no Oracle database. ■ On the same computer as the Oracle database and in the same Oracle home directory. Note that in this […]

Read More

ORA-28007: the password cannot be reused

Scenario: Trying to reset to the existing password throws following error.

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 so set to a higher value or to UNLIMITED […]

Read More

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

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 […]

Read More

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 […]

Read More