作者:LINUX伊甸园会员TERRAN 硬件环境 :PIII 700 ; 512M ram ; 40G 磁盘分区 :主分区 9GBB
作者:LINUX伊甸园会员TERRAN
硬件环境 :PIII 700 ; 512M ram ; 40G
磁盘分区 :主分区 9GB;交换分区 1GB
软件环境 :Redhat 7.1 完全安装(kernel 2.4.2-2 ; glibc-2.2.2-10)
准备工作 :
如果你的Redhat 7.1不是完全安装的话,请安装以下软件包。
compat-glibc-6.2-2.1.3.2.rpm (Redhat第一张盘里)
rpm -Uvh compat-glibc-6.2-2.1.3.2.rpm
compat-libs-6.2-3.rpm (Redhat第二张盘里)
rpm -Uvh compat-libs-6.2-3.rpm
compat-egcs-6.2-1.1.2.14.rpm(Redhat第二张盘里)
rpm -Uvh --force --nodeps compat-egcs-6.2-1.1.2.14.rpm
安装JDK118_v3
从Blackdown()下载jdk118_v3.tar.bz2
解压缩,安装在/usr/local
bunzip2 jdk118_v3.tar.bz2
tar -xvf jdk118_v3.tar
ln -s jdk118_v3 java
安装binutils-2.10.0.18-1.i386.rpm(Redhat 7.0安装盘中附带)
rpm -Uvh --force --nodeps binutils-2.10.0.18-1.i386.rpm
创建用户和组
groupadd -g 400 dba
useradd -u 400 -c "Oracle Owner" -d /home/oracle -g "dba" -m -s /bin/bash oracle
passwd oracle
输入新的用户密码。
创建安装目录(以/opt/oracle为例)
cd /opt
mkdir oracle
chown oracle:dba oracle
chmod 777 oracle
退出系统,以Oracle 用户登陆
修改用户配置文件:
vim .bash_profile
添加以下内容:
ORACLE_HOME=/opt/oracle/product/9.0.1; export ORACLE_HOME
ORACLE_SID=Test; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_OWNER=oracle; export ORACLE_OWNER
TNS_ADMIN=/home/oracle/config/9.0.1; export TNS_ADMIN
NLS_LANG=american_america.ZHS16GBK; export NLS_LANG
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
export JAVA_HOME=/usr/local/jdk
export JSDK_HOME=/usr/local/jsdk
CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JSDK_HOME/lib/jsdk.jar
export CLASSPATH
PATH=$POSTFIX/bin:$POSTFIX/sbin:$POSTFIX/sendmail
PATH=$PATH:/usr/local/jre/bin:/usr/local/jdk/bin:/bin:/sbin:/usr/bin:/usr/sbin
PATH=$PATH:/usr/local/bin:$ORACLE_HOME/bin:/usr/local/jsdk/bin
PATH=$PATH:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin
PATH=$PATH:/usr/local/samba/bin
export PATH
存盘退出,退出系统,再以Oracle 用户登陆。
从光盘运行安装程序,
/mnt/cdrom/runInstaller
出现安装画面如下:
点击Next继续,注意:此时的NUM LOCK键必须关闭,否则安装程序不会继续!!!
在对话框里选择安装目录,可以是任何Oracle用户拥有的目录。
填入Unix组,上面所建立的组为DBA。
系统提示要在/tmp下以Root身份运行orainstRoot.sh,打开终端窗口,以Root身份运行/tmp/orainstRoot.sh,然后点Continue。
选择安装目录,本例在/opt/oracle/product/9.0.1下,
选择安装产品,选择Oracle DataBase,
选择安装类型,可以自己选择,如果是新手,建议使用Enterprise Edition。
安装后不要让系统自动建库,自动建库会出问题,所以选择Software Only,按Next,出现语言选择,如果你使用中文界面的话,选上简体中文。
出现安装组件列表,点击安装,开始拷贝文件。
中间有两次需要换盘。
文件拷贝完成后系统提示运行Root.sh脚本,打开终端,以Root身份运行Root.sh。之后系统会自动运行配置脚本,一般情况下会很快通过,也有可
能会没有响应,没有关系,停掉他,以后手工配置。之后出现安装成功的画面如下。

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

TostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov

When selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns


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

SublimeText3 Chinese version
Chinese version, very easy to use

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
