Oracle 管理之 Linux 网络基础
1、TCP/IP 网络配置文件2、使用命令配置网络3、网络诊断工具 TCP/IP 网络配置文件IP配置文件:/etc/sysconfig/network-scripts/i
首页 → 数据库技术
背景:
阅读新闻
Oracle 管理之 Linux 网络基础
[日期:2013-02-16] 来源:blog.csdn.net/xiangsir 作者:xiangsir [字体:]
1、TCP/IP 网络配置文件
2、使用命令配置网络
3、网络诊断工具
TCP/IP 网络配置文件
IP配置文件:/etc/sysconfig/network-scripts/ifcfg-eth0
网管配置文件:/etc/sysconfig/network
域名解析:/etc/host.conf
主机配置:/etc/hosts
路由配置:/etc/resolv.conf
服务端口配置:/etc/services
网络接口启动脚本:
[root@asm ~]# more /etc/sysconfig/network-scripts/ifcfg-eth0
# Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]
DEVICE=eth0
BOOTPROTO=static
BROADCAST=192.168.8.255
HWADDR=00:0C:29:8B:86:65
IPADDR=192.168.8.160
NETMASK=255.255.255.0
NETWORK=192.168.8.0
ONBOOT=yes
[root@asm ~]# more /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=asm.Oracle.com
GATEWAY=192.168.8.1
/etc/hosts
该文件是系统本地的主机名称解析数据库
[root@asm ~]# more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.8.160 asm.oracle.com asm
/etc/host.conf 文件用于指定如何解析主机名,可用选项:
order:设置主机名解析的可用方法及顺序,可用方法包括hosts(使用/etc/hosts文件进行解析)、bind
(使用DNS服务器解析)、nis(使用网络信息服务NIS解析)
multi:设置是否从 /etc/hosts 文件中返回主机的多个 IP 地址,取值为 on/off
/etc/resolv.conf 文件是 DNS (DNS域名服务的客户端配置文件):
[root@asm ~]# more /etc/resolv.conf
nameserver 192.168.8.11
search oracle.com
domain oracle.com
/etc/services 设置网络服务默认使用的 TCP 或 UDP 端口
使用命令行工具或GUI工具配置 Linux 网络:
[root@asm ~]# ifconfig
eth0 Link encap:Ethernet HWaddr 00:0C:29:8B:86:65
inet addr:192.168.8.160 Bcast:192.168.8.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:23894 errors:0 dropped:0 overruns:0 frame:0
TX packets:1864 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1708719 (1.6 MiB) TX bytes:309503 (302.2 KiB)
Interrupt:75 Base address:0x2000
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:18747 errors:0 dropped:0 overruns:0 frame:0
TX packets:18747 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:1215290 (1.1 MiB) TX bytes:1215290 (1.1 MiB)
[root@asm ~]# ifconfig eth0 192.168.8.161 netnask 255.255.255.0 up
[root@asm ~]# ifconfig eth0 192.168.8.160 netnask 255.255.255.0 up
[root@asm ~]# ifconfig eth0
eth0 Link encap:Ethernet HWaddr 00:0C:29:8B:86:65
inet addr:192.168.8.160 Bcast:192.168.8.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:24260 errors:0 dropped:0 overruns:0 frame:0
TX packets:2001 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1736070 (1.6 MiB) TX bytes:327830 (320.1 KiB)
Interrupt:75 Base address:0x2000
修改配置文件重启网卡也可修改IP地址:
vi /etc/sysconfig/network-scripts/ifcfg-eth0
service network restart
vi /etc/sysconfig/network
vi /etc/resolv.conf
Oracle中的转义字符用法
Oracle GoldenGate安装配置
相关资讯 Oracle基础教程 Oracle管理 Linux网络基础
图片资讯
本文评论 查看全部评论 (0)
评论声明
最新资讯
本周热门

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

InnoDB uses redologs and undologs to ensure data consistency and reliability. 1.redologs record data page modification to ensure crash recovery and transaction persistence. 2.undologs records the original data value and supports transaction rollback and MVCC.

MySQL's position in databases and programming is very important. It is an open source relational database management system that is widely used in various application scenarios. 1) MySQL provides efficient data storage, organization and retrieval functions, supporting Web, mobile and enterprise-level systems. 2) It uses a client-server architecture, supports multiple storage engines and index optimization. 3) Basic usages include creating tables and inserting data, and advanced usages involve multi-table JOINs and complex queries. 4) Frequently asked questions such as SQL syntax errors and performance issues can be debugged through the EXPLAIN command and slow query log. 5) Performance optimization methods include rational use of indexes, optimized query and use of caches. Best practices include using transactions and PreparedStatemen

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.

MySQL is suitable for small and large enterprises. 1) Small businesses can use MySQL for basic data management, such as storing customer information. 2) Large enterprises can use MySQL to process massive data and complex business logic to optimize query performance and transaction processing.

MySQL index cardinality has a significant impact on query performance: 1. High cardinality index can more effectively narrow the data range and improve query efficiency; 2. Low cardinality index may lead to full table scanning and reduce query performance; 3. In joint index, high cardinality sequences should be placed in front to optimize query.

The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA

MySQL is suitable for web applications and content management systems and is popular for its open source, high performance and ease of use. 1) Compared with PostgreSQL, MySQL performs better in simple queries and high concurrent read operations. 2) Compared with Oracle, MySQL is more popular among small and medium-sized enterprises because of its open source and low cost. 3) Compared with Microsoft SQL Server, MySQL is more suitable for cross-platform applications. 4) Unlike MongoDB, MySQL is more suitable for structured data and transaction processing.
