{"id":3831,"date":"2025-06-09T11:45:26","date_gmt":"2025-06-09T11:45:26","guid":{"rendered":"https:\/\/w3buddy.com\/?post_type=cposts&#038;p=3831"},"modified":"2025-06-09T11:45:27","modified_gmt":"2025-06-09T11:45:27","slug":"linux-commands-for-oracle-dba","status":"publish","type":"cposts","link":"https:\/\/w3buddy.com\/blog\/notes\/oracle-dba-d2d-tasks\/linux-commands-for-oracle-dba\/","title":{"rendered":"Linux Commands for Oracle DBA"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A concise list of essential Linux commands every Oracle DBA should know to efficiently manage database servers, perform system checks, and troubleshoot issues.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">System Information<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>uname -a                      # Show kernel version and system architecture\ncat \/etc\/*release             # Display OS version details\nuptime                        # Show system uptime and load averages\ntop                           # Interactive CPU and memory usage\nvmstat                        # Report virtual memory and CPU stats\ndf -h                         # Display disk space usage in human-readable form\nfree -m                       # Show memory usage in MB\ndmesg                         # Kernel message buffer\niostat                        # CPU and disk I\/O statistics\nsar                           # Collect and report system activity<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">User and Group Management<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>id                            # Display current user UID and GID\nwhoami                        # Show current logged-in user\nwho                           # List logged-in users\nw                             # Detailed list of logged-in users and processes\ngroups                        # Display user\u2019s group memberships\nsu - &lt;user>                   # Switch to another user\nsudo -i                       # Switch to root user shell\npasswd                        # Change user password<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Process Management<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>ps -ef                        # List all running processes\nkill &lt;pid>                   # Terminate process by PID\nkill -9 &lt;pid>                # Force terminate process\ntop                           # Real-time process monitoring<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Disk Management<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>df -h                         # Disk space usage summary\ndu -sh &lt;dir>                  # Disk usage of directory\nlsblk                         # List block devices and partitions\nmount | grep &lt;filesystem>     # Show mounted filesystems\numount &lt;device>               # Unmount filesystem\nfdisk -l                      # List disk partitions\nblkid                         # Show UUIDs of filesystems<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Network Commands<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>ip a                          # Display IP addresses and interfaces\nifconfig                      # Network interface info (older tool)\nping &lt;host>                   # Check network connectivity\ntraceroute &lt;host>             # Trace network route to host\nnetstat -tulnp                # List listening ports and associated processes\nss -tulnp                     # Modern alternative to netstat\ndig &lt;hostname>                # DNS query\nnslookup &lt;hostname>           # DNS lookup tool\ncurl -I &lt;URL>                 # Fetch HTTP headers\nwget &lt;URL>                    # Download files from URL\nscp &lt;file> user@host:\/path    # Secure copy to remote server\nsftp user@host                # Secure FTP session<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">File Management<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>ls -lh                        # List files with sizes and permissions\ncd \/path\/to\/dir               # Change directory\npwd                           # Show current directory path\ncp -r &lt;source> &lt;dest>         # Copy files or directories recursively\nmv &lt;source> &lt;dest>            # Move or rename files\/directories\nrm -rf &lt;file\/dir>             # Remove files or directories forcefully\nfind \/path -name &lt;filename>   # Search files by name\ngrep -r \"pattern\" \/path       # Search recursively for a pattern in files\ntar -cvf archive.tar \/path    # Create tar archive\ntar -xvf archive.tar          # Extract tar archive\nzip -r archive.zip \/path      # Create zip archive\nunzip archive.zip             # Extract zip archive<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Oracle Database Commands<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>sqlplus \"\/ as sysdba\"         # Connect to Oracle DB as SYSDBA\nlsnrctl status                # Check Oracle listener status\nlsnrctl start                 # Start Oracle listener\nlsnrctl stop                  # Stop Oracle listener\nexport ORACLE_HOME=\/u01\/app\/oracle\/product\/12.1.0\/dbhome_1  # Set ORACLE_HOME\nexport PATH=$ORACLE_HOME\/bin:$PATH                          # Update PATH for Oracle binaries\nexport ORACLE_SID=ORCL        # Set Oracle SID\ntnsping &lt;service_name>        # Test Oracle TNS connectivity\ndbstart                       # Start Oracle database services\ndbshut                        # Shutdown Oracle database services\nrman target \/                 # Connect to RMAN for backup\/recovery\ncrsctl status resource -t     # Check RAC Clusterware resource status\nsrvctl status database -d ORCL # Check Oracle RAC DB status\nsrvctl start database -d ORCL # Start RAC database\nsrvctl stop database -d ORCL  # Stop RAC database<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Log and Monitoring<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>tail -f alert_ORCL.log        # Monitor Oracle alert log in real-time\nvi \/u01\/app\/oracle\/diag\/...   # Edit Oracle diagnostic log files\ngrep \"ORA-\" alert_ORCL.log    # Search for ORA errors in alert log\ndf -h | grep \/u01             # Check disk usage for Oracle mount points\ncat \/etc\/oratab               # List Oracle instances configured on system<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Backup and Scheduling<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>crontab -l                    # List scheduled cron jobs\ncrontab -e                    # Edit cron jobs\nrsync -av \/source \/dest       # Synchronize files\/directories\nrman target \/                 # RMAN backup and recovery utility\ntar -cvf oracle_backup.tar \/u01\/app\/oracle\/datafiles  # Create backup archive<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">System Administration<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl status &lt;service>    # Check status of a service\nsystemctl restart &lt;service>   # Restart a service\njournalctl -xe                # View detailed system logs\nhistory                       # Show command history\nalias                         # List defined command aliases\nunalias &lt;name>                # Remove an alias\nshutdown -h now               # Shutdown system immediately\nreboot                        # Reboot system<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This list covers essential Linux commands for Oracle DBAs to manage databases, monitor systems, handle backups, and perform administrative tasks efficiently.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A concise list of essential Linux commands every Oracle DBA should know to efficiently manage database servers, perform system checks, and troubleshoot issues. System Information User and Group Management Process Management Disk Management Network Commands File Management Oracle Database Commands Log and Monitoring Backup and Scheduling System Administration This list covers essential Linux commands for [&hellip;]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,984],"class_list":["post-3831","cposts","type-cposts","status-publish","hentry","category-notes","category-oracle-dba-d2d-tasks"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/3831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=3831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=3831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}