Skant Gupta is certified for: Microsoft Microsoft® Certified Technology Specialist: SQL Server® 2005 Microsoft® Certified Solutions Associate: Office 365 (MCSA) Microsoft® Specialist: Server Virtualization with Windows Server Hyper-V and System Center Specialist Microsoft® Certified Professional IBM IBM Certified Deployment Professional – Tivoli Directory Server V6.1 IBM Certified Associate Developer — Rational Application Developer for WebSphere Software […]
Category: ORACLE DATABASE
Undo Segments are corrupted
Database is shutdown and can’t start it, asking for Undo recovery while dropping Undo tablespace Dropping a Undo tablespace give message The UNDOTBS for our RMAN Catalog database was dropped. Any attempts to switch to a newly created UNDOTBS or removing the old UNDOTBS failed with the following error: ORA-01548: active rollback segment Or Undo […]
Read the Trace file from SQL Plus
Find trace file in Oracle The following script returns the path to the trace file that the current session writes. It returns the path whether or not tracing is enabled. SQL> SELECT s.sid, 2 s.serial#, 3 pa.value || ‘\’ || LOWER(SYS_CONTEXT(‘userenv’,’instance_name’)) || 4 ‘_ora_’ || p.spid || ‘.trc’ AS trace_file 5 FROM v$session s, 6 v$process p, 7 v$parameter […]
Oracle Fixed Views
Oracle maintains a set of virtual tables that record current database activity. These tables are called dynamic performance tables. This post was written by Sriram Sanka in his blog. Why the term “Fixed”? Because They are fixed ..One cannot perform any DML , DDL or any operation other than “SELECT“,that’s why these views/Tables are known […]
ORA-00059:maximum number of DB_FILES exceeded
By default in every Oracle Database, you can have up to 200 total data files (.DBF files) in each Oracle Database instance as indicated by the value of the parameter “db_files” (you can check the value by running “show parameter db_files” in your database. If you need to create more data files than what the […]
Oracle Database Gateway for MySQL
An organization have lot of choices to choose from the RDBMS world. Oracle Database, Microsoft SQL Server, IBM DB2,PostgreSQL, MySQL are few of them. Most of the organizations out there do have a mix of all these which are used to store their data and in course of time it is inevitable that they would […]
Oracle Database Gateway for PostgreSQL
An organization have lot of choices to choose from the RDBMS world. Oracle Database, Microsoft SQL Server, IBM DB2,PostgreSQL, MySQL are few of them. Most of the organizations out there do have a mix of all these which are used to store their data and in course of time it is inevitable that they would […]
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 […]
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) […]
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 […]