Fedora core 7(FC7)中成功安装Oracle10g-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Fedora core 7(FC7)中成功安装Oracle10g

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:51 PM

fedora

经过数天的苦战，我终于成功的在Fedora core 7(FC7)中安装了oracle10g，由于玩Linux没多久，又是第一次安装oracle，期间经历了很多磨难，其

经过数天的苦战，我终于成功的在Fedora core 7(FC7)中安装了Oracle10g，由于玩Linux没多久，又是第一次安装oracle，期间经历了很多磨难，其中那个该死的U盘破坏.rar文件着实让俺吃了不少苦头，因为这个我下了N次数据库文件，因为我从来没有怀疑过它，我怀疑的是我下载的文件被破坏了（包括官方下载），期间还重装了好几次FC7,搞的我现在装Linux比装XP还娴熟。好了，思苦这事不能多干，到此打住，抬起头来向前看。现将详细过程记录下来，方便自己也方便别人

注意
1.我安装FC7的时候是没有开防火墙的，因为我怕麻烦！
2.安装前请确保/etc/hosts文件的显示形式为：

如：127.0.0.1 localhost.localdomain localhost
-----------------
详细安装步骤：
1.安装oracle需要的软件包

Editors
Graphical Internet
Administration Tools
Base
X Window System
System Tools
Server Configuration Tools
GNOME Desktop Environment
Development Libraries
Development Tools
Legacy Software Support
Hardware Support

2.在安装oracle之前，当然得下好安装文件10201_database_Linux32.zip，，然后将其解压放到一个地方，最好放到/tmp目录下面，因为如果放到root文件下的话以后安装的时候oracle用户没有权限访问，又要改权限，不很方便。解压：

unzip 10201_database_Linux32.zip

3.设置系统参数
将下面部分拷贝到/etc/sysctl.conf文件后面

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
当然也可以通过终端修改。运行此命令使其生效：

/sbin/sysctl -p

4.将下面灰色部分拷贝到 /etc/security/limits.conf文件中：

* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536

5.将下面灰色部分拷贝到/etc/pam.d/login文件中

session required /lib/security/pam_limits.so

6.修改文件/etc/seLinux/config
使其中SELinux=disabled

SELinux=disabled

7.然后通过终端添加安装需要的rpm包，这些包在DVD光盘的FEDORA目录中。

cd /media/dvd/Fedora-----------（可能不同，自己找到路径）
rpm -Uvh setarch-*
rpm -Uvh --force tcl-*
rpm -Uvh compat-db-*
rpm -Uvh --force libXau-devel-*
还有在Fedora7光盘中没有的包，我们利用yum来添加，很快，十几分钟可以搞定。

yum install libXp libaio
yum install compat-libstdc++* compat-libf2c* compat-gcc* compat-libgcc*

8.创建安装需要的组和用户

groupadd oinstall
groupadd dba
groupadd oper

useradd -g oinstall -G dba oracle
passwd oracle

linux

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AM

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AM

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

See all articles