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,…
How to Install .Net Framework 3.5 on Windows Server 2012
You have to insert Windows Server 2012 DVD into DVD Reader. After you can install .Net FrameWork 3.5. Installation Steps insert Windows Server 2012 DVD or iso to D Drive. Open Add Roles and Features Wizard From Server Manager. Select .NET Framework 3.5 Features. Select Specify an alternate source path and select path that is…
Copy Files Without Overwrite Existing Files With xcopy Command on Windows
You can use xcopy command for copy and move files. Below command does that it copy files and paste to new destination without overwrite existing files. xcopy C:\> xcopy D:\source_dest E:\target_dest /E /D Note : /E parameter make that it copy files with subfolders Note : /D parameter make that it copy files without overwrite
Vi Editor on Linux
Vi editor very useful text editor on linux systems. Below commands most use commands. Vi Editor Commands i > insert ESC + q! > exit without save ESC + wq! > exit with save ESC + w! > only save /searchtext > search to down ?searchtext < search to up n > next text of…
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…
SAP Basis Fundamentals
SAP R/3 is 3 tier architecture. You can see below picture. SAP Basis architecture presentation is here
File Merge With MsDos in Windows
If you want to merge files into one file. You can use copy command. For example, you have a directory as name testdir and 10 csv files in testdir. Open cmd prompt. C:> copy file1.csv+file2.csv+file3.csv commonfile.csv
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…
Python Commands and Functions
Take value from user. input(“Enter a number : “) raw_input(“Enter a character : “) Counters range(100) # write from 0 to 100 range(100,200) # write from 100 to 200 range(100,200,2) # write from 100 to 200 as 2 by 2 len(“Fatih”) # character count result 5 File and Directory Operations listdir(“/home”/) # list all file…
Mail Send With Python
Mail Send Function | File name : sender.py import string import smtplib from email.mime.text import MIMEText def mailSend(subject,content): mailserver = “192.168.5.2” # Mail Server IP Address mail = MIMEText(content) mail[“From”] = “fromaddress@example.com” mail[“To”] = “toaddress@example.com” mail[“Subject”] = subject gonder = smtplib.SMTP(mailserver) gonder.sendmail(mailfrom,mailto,mail.as_string()) gonder.quit() Notification Example for Disk Status Check | File name : diskcheck.py from…