Skip to content

Fatih Acar's blog

About of Database Systems and Information Technologies

Menu
  • Home
  • About Me
  • Contact Me
Menu

Tag: System Administration

Disable root SSH Login on Linux Server

Posted on 29/04/201308/05/2013 by Fatih Acar

Root user is the most authoritative user on linux operating systems. You can take measure for security with disable root ssh. You can connect to server with other users. Edit sshd_config vi /etc/ssh/sshd_config #LoginGraceTime 2m #PermitRootLogin yes #StrictModes yes Note : “PermitRootLogin yes” is default value. This value allows ssh root login You have to…

Oracle DbLink With Odbc Connection From Oracle to MsSQL Server With FreeTDS

Posted on 18/04/201303/10/2019 by Fatih Acar

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

Posted on 28/03/201328/03/2013 by Fatih Acar

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

Posted on 22/03/201322/03/2013 by Fatih Acar

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

Posted on 20/03/2013 by Fatih Acar

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…

File Merge With MsDos in Windows

Posted on 12/03/2013 by Fatih Acar

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

Python Commands and Functions

Posted on 28/02/201328/02/2013 by Fatih Acar

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

Posted on 08/02/201308/02/2013 by Fatih Acar

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…

Python Programing Language Structure

Posted on 29/01/201308/02/2013 by Fatih Acar

Python supports multiple programming paradigms, including object-oriented, imperative and functional programming styles. It features a fully dynamic type system and automatic memory management, similar to that of Scheme, Ruby, Perl, and Tcl. Like other dynamic languages, Python is often used as a scripting language, but is also used in a wide range of non-scripting contexts….

Copy Backup File from ASM to Local Disk

Posted on 12/12/201212/12/2012 by Fatih Acar

If you want to migrate backup or archivelog files from asm disks to local disk, you can use below command. But you have to create a directory to migrate backup and this directory owner have to be grid user. Copy File Command [grid ~]# asmcmd ASMCMD> cd FRA/backups ASMCMD> cp mynewbackupname.bck /localdiskpath/mybackup.bck

Posts pagination

  • Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • Next



View Fatih ACAR's profile on LinkedIn

Categories

  • Databases (329)
    • MsSQL Server (18)
      • Administration (16)
      • Errors and Solutions (4)
      • SQL (2)
    • MySQL (5)
      • Administration (4)
      • Backup And Recovery (1)
      • Errors and Solutions (1)
    • Oracle (290)
      • Administration (79)
      • Backup And Recovery (29)
      • Errors and Solutions (195)
      • Procedure (10)
      • SQL (32)
    • PostgreSQL (16)
      • Administration (15)
      • Errors and Solutions (3)
      • SQL (2)
    • Redis (1)
  • Microsotf Dynamics CRM (1)
  • Operating Systems (47)
    • Linux & Unix (34)
    • Windows (13)
  • Programing (5)
    • Python (5)
  • SAP (15)
    • Errors and Solutions (4)
    • SAP Basis (12)
  • Security (8)
    • Database Security (6)
    • Information Security (1)
    • System Security (4)
  • VMware (4)

Recent Posts

  • Redis 7 Sentinel Infrastructure Installation
  • Oracle Database 19c Multi Data Guard and DML Redirect, Switchover-Failover Operations on Oracle Linux 8
  • Oracle Database 23ai Free Installation Steps on Oracle Linux 9
  • Oracle Database 19c Active Data Guard Installation and DML Redirect, Switchover-Failover Operations on Oracle Linux 8
  • Oracle Database 19c Installation and 19.22 RU Patch Apply on Oracle Linux 8

Resources

  • Oracle
  • PostgreSQL

Blogroll

  • Gökhan Atıl
  • H. Koray Gündüz
  • Hakan Talip Öztürk
  • Zekeriya Beşiroğlu

Web Pages

  • BT Çözümleri

Tag Cloud

Administration Backup and Recovery Cluster Systems Database Administration Database Security Linux Linux Administration MsSQL Server MsSQL Server Error and Solutions MySQL MySQL Administration ORA-00018 ORA-00020 Oracle Oracle 12c Oracle 19c Oracle Administration Oracle Backup and Restore Oracle Data Guard Oracle Data Guard Failover Oracle Data Guard Switchover Oracle Error Solutions Oracle Linux Oracle Rman Backup Oracle Security Oracle SQL Query PostgreSQL PostgreSQL Administration PostgreSQL High Availability PostgreSQL Hot Standby Python SAP Basis Sap Errors and Solutions Sap System Administration SQL SQL Server Administration SQL Server Availability Group Stored Procedure System Administration System Security VMware VMware Administration Windows Windows Batch Script Windows Server

Social

  • View facar1987’s profile on Twitter
  • View facar’s profile on LinkedIn

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 17 other subscribers
©2026 Fatih Acar's blog | Built using WordPress and Responsive Blogily theme by Superb