If you want to fetch data from Oracle to SQL Server, you can use Linked Servers features in SQL Server Database. Linked Server is like a database link (Dblink). Installation steps Install Oracle Client on SQL Server database server Restart SQL Server database service Configure OraOLEDB.Oracle provider in SQL Server database Create user for remote…
Tag: Oracle Administration
Fine Grained Auditing (FGA) in Oracle
Fine Grained Auditing (FGA), introduced with Oracle9i, can be understood as ‘policy-based auditing’. As opposed to the standard auditing functionality, FGA lets you specify the conditions necessary for an audit record. FGA policies are programatically bound to the object (table, view) by using the ‘dbms_fga’ package. You have to have a valid set of Fine-Grained…
How to Auto Start Instance of Oracle Database on Windows Server
Oracle database is not startted when you restart windows server, then you can change regedit parameter for auto start. Each time you install Oracle products into a new Oracle home on your computer, HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME is created. This subkey contains parameter values for most Oracle products. HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOME_NAME includes the following parameters for an Oracle home directory….
Oracle Flashback Database Technology in Oracle 11g
FLASHBACK DATABASE Technology to rewind the database to a target time, SCN or log sequence number. This command works by undoing changes made by Oracle Database to the datafiles that exist when you run the command. Flashback can fix logical failures, but not physical failures. Thus, you cannot use the command to recover from disk…
Oracle DbLink With Odbc Connection From Oracle to MsSQL Server With FreeTDS
I will use Oracle 11g R2 database and SQL Server 2008 R2 on this example. If you want to connect from Oracle to SQL Server, you can use freeTDS connection library on Oracle Linux systems. If we use Windows Server for Oracle database, we can use direct Windows ODBC Driver Manager. On the other hand,…
Limits of Oracle Data Guard
Important situations of Oracle Data Guard Nologging or unrecoverable operations are not applied to standby – so be cautious in using those options. Alarming data block corruption error messages are reported if a user attempts to access any nologging or unrecoverable data blocks. ‘Drop tablespace’, ‘drop datafile’, ‘rename datafile’, and add/drop online redo log files…
How to Add Standby Logfile in Oracle
If you want to use real-time apply Oracle Data Guard, you have to add standby logfile to standby database. Show Logfiles Before Add SQL> select * from gv$logfile; INST_ID GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE 1 3 ONLINE +DATA/testdb/onlinelog/group_3.14134123 NO 1 1 ONLINE +DATA/testdb/onlinelog/group_1.35116731 NO 1 2 ONLINE +DATA/testdb/onlinelog/group_2.32513245 NO 1 4 ONLINE +DATA/testdb/onlinelog/group_4.12255335 NO 1…
Oracle Data Pump (expdp and impdp) in Oracle
Oracle Data Pump is faster and more flexible alternative to the “exp” and “imp” backup system used in previous Oracle versions. impdp and expdp commands use Oracle Directory for processing of backups. Create Directory CONN SYS AS SYSDBA CREATE OR REPLACE DIRECTORY dirname AS ‘/u01/backup/’; GRANT READ, WRITE ON DIRECTORY dirname TO backupuser; Tables Export…
Random Character Generator in Oracle
Oracle dbms_random package can generate random characters in character, numeric or alphanumeric formats. dbms_random.value(Parameter, Value) U – Upper case L – Lower case A – Alphanumeric X – Alphanumeric with upper case alphabets. P – Printable characters only. Create Random Characters SQL> select dbms_random.random value from dual; Value : 531879542 SQL> select dbms_random.value from dual;…
Oracle Data File Occupancy in Oracle
Size of Oracle Data Files can be max 32 GB. If you are not chech data files sizes, The system can give an error when size of data files arrive max extent. You can solve this problem with adding a new data file in tablespace. But this state is not a good. You have to…