File Transfer Commands

linux to linux:
scp file_name username@hostname:/targetlocation/
scp -r directory_name username@hostname:/targetlocation/

windows to linux:

  1. WinSCP
  2. Filezilla
  3. FireFTP
  4. CoreFTP LE


Comments

Post a Comment

Popular posts from this blog

Oracle Patching Using Opatch Utility

Image
Opatch: It is a utility for patching Oracle software, specifically Oracle databases and related products. It is used to apply, roll back, and check Oracle patches, including interim patches, one-off patches, and bundle patches. Types of Patches: Patch Type Purpose Release Frequency Includes Security Fixes? Includes Bug Fixes? Includes New Features? One-off Patch Fix a specific issue As needed No Yes No PSU (Patch Set Update) Security + Bug fixes Quarterly Yes Yes Minimal CPU (Critical Patch Update) Security fixes only Quarterly Yes No No RU (Release Update) Security + Bug + Functional changes Quarterly Yes Yes Yes BP (Bundle Patch) Exadata/Windows patch...
Read more

Oracle Database 19C Performance Tunning - PART 1

Image
Advantages: 1. Improved Query Performance •    Optimized SQL execution plans lead to faster query response times. •    Reduces unnecessary full table scans and improves indexing strategies. •    Parallel execution tuning speeds up large data processing tasks. 2. Better Resource Utilization •    Efficient use of CPU, memory, disk I/O, and network resources. •    Reduces contention on Redo Logs, Undo Tablespaces, and Buffer Cache. •    Helps in load balancing across multiple instances in RAC (Real Application Clusters). 3. Increased System Scalability •    Ensures that the database can handle a growing number of users and transactions. •    Proper tuning allows scaling without degrading performance. •    Optimized parallel processing ensures better performance on multi-core servers. 4. Lower Infrastructure Costs •    Reduces the need for add...
Read more

PostgreSQL Opensource Installation in RHEL or Oracle Linux(OEL) 8 and above

Image
 Types OF Installation Binary(Packages) Source RPM (Red hat Package Management) Notes: Once Installed the PostgreSQL set Password for postgres (OS Level) User. Login the root user and set password like passwd postgres Binary Installation:   (Online Installation – Internet Must) Step 1:   goto https://www.postgresql.org/ and click Download Choose Packages on Top Left Cornor Step 2:   Select Your Operating System. Choose Linux and select your Linux distribution( Redhat/centos ). and scroll down Step 3:   Select PostgreSQL Version. Example Choose 17 Step 4:   Select Linux Platform. Example select Red Hat enterprise, CentOS, Scientific or Oracle version 8 Step 5:   Select OS architecture Type. Example Select x86_64     Step 6:   Copy the Script and paste your terminal Example: # Install the repository RPM: sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm # Disab...
Read more

Oracle RMAN Backup And Restore

Image
RMAN: (Oracle 8) RMAN (Recovery Manager) is a utility provided by Oracle Database to perform backup, restore, and recovery operations. It is a command line tool. Features of RMAN in Oracle 19c Comprehensive Backup Capabilities: Full and incremental backups. Block-level backups for efficient data storage. Archived redo log backups. Fast Recovery Area (FRA) integration for centralized backup storage. Efficient Recovery Options: Point-in-time recovery (PITR). Complete and incomplete recovery. Flashback database capabilities for quick undo of changes. Multitenant Database Support: RMAN fully supports container databases (CDBs) and pluggable databases (PDBs). Provides flexibility to back up and recover individual PDBs or entire CDBs. Automatic Space Management: Manages disk space in the FRA. Automatically deletes obsolete backups and archived logs. Data Deduplication and Compression: Backup optimization through block-level deduplication. Built-in compression algorithms to reduce storage req...
Read more

PostgreSQL Extension - pgcrypto

Image
PostgreSQL Password column Encryption & Decryption use Master Key: Step 1: create an extension                pearl=# create extension pgcrypto ;                Step 2: create test table                pearl=# create table test (id numeric, password text);                Step 3: insert the value use encryption use master key                pearl=# insert into test values (1, pgp_sym_encrypt('0912345678'::text,'IJljCQyuuPyBvJMuTH0v'::text)); Step 4:   Select or Decrypt the data                Decrypt the data use wrong master key:           ...
Read more