DBA-Philiac

Here I have posted about how to connect with MSSQLSERVER from Oracle. There is a difference between Oracle 10g and 11g. In 10g parameter HSODBC is used inithsodbc file and In 11g DG4ODBC is used in initdg4odbc file. Using Generic Connectivity (HSODBC) we can create db link between Oracle and SQL server. Machine (1) DB Version : Oracle 10g Operating System : RHEL 5.4 IP : 192.168.0.31 Host : abcdbt Machine (2) Version : SQL Server 2005 Operating System : Windows server 2008 x86 IP : 192.168.0.175 Host : SQLDEV1 User/PW : sa/abc@123! (Connect to database) Database : SQLTEST (exsisting) Table : T (“ T “ is the table existing in SQLTEST database with 10 rows) Prerequisites in Machine (2): a) Oracle 10g software b) User account to access SQL Server database (sa/abc@123!) c) Existing SQL Server Database (SQLTEST) d) Tables (testing purpose) (T) Steps: 1) Install Oracle 10.2.0.1 (Only SW,No need of database) (Machine 2) 2) Create a DSN where your windows Oracle 10g SW resides (Machine 2) Cont...

Hi All, This is Shaon and probably my first blog will gonna be proved as a boring one. Oracle is the platform where my earning and living depend on. Actually I am playing the role of DBA in an organization. So what I did in my workplace I try to document it with any form. For this purpose I initiated my blog and here i will try to share some silly knowledge with you who loves DBA and Oracle as well. Ok lets start with something like DBLink in Oracle. PURPOSE: ------------------ CREATE A DBLINK FROM ORCL DATABASE TO CONNECT TO XLE SCHEMA IN DEVP DATABASE TO ACCESS THOSE TABLES WHICH HAS PRIVILEGES IN SOME TABLES OF DEVP DATABASE. ############################################################################################################################# PRE-REQ: --------- CREATE A USER NAMED XCLE IN DEVP DB.GRANT REQUIRED PRIVILEGE TO XCLE SO THAT USER IN ORCL CAN DIRECTLY ACCESS ON THOSE TABLES OF DEVP DB. ################################################################################...