Linux下Oracle10g安装文档.doc

Linux下安装Oracle10.2.0文档1. 上传Oracle10.2.0安装压缩文件oracle_database_.0_ia32.tar.gz到FTP上2. 转到路径/var/ftp/uploads下，解压：tar xzvf oracle_database_.0_ia32.tar.gz3. 创建用户、组rootxxuploads# groupadd dbarootxxuploads#groupadd oinstallrootxxuploads#useradd oracle -g oinstall -G dbarootxxuploads#id oracleuid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)说明前面命令生效rootxxuploads#passwd oracleChanging password for user oracle.New password:Retype new password:passwd:all authentication tokens updated successfully.表明重设密码成功4. 配置环境变量以root用户登录，设置root用户的环境，打开.bash_profile文件，将如下内容加入：export ORACLE_BASE=/home/oracle/oracleexport ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1export PATH=$PATH:$ORACLE_HOME/binexport ORACLE_OWNER=oracleexport ORACLE_SID=orclexport NLS_LANG=AMERICAN_AMERICA.UTF8使用Oracle用户登录，设置oracle用户的环境rootcxx uploads#su oraclerootcxx uploads #vi .bash_profile打开.bash_profile文件，将如下内容加入：export ORACLE_BASE=/home/oracle/oracleexport ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1export PATH=$PATH:$ORACLE_HOME/binexport ORACLE_OWNER=oracleexport ORACLE_SID=orclexport NLS_LANG=AMERICAN_AMERICA.UTF85. 安装oracle使用oracle帐号登录rootcxx uploads # ./runInstaller会弹出图形安装界面，一步步走下来，与Windows下安装方法一样（可参见Windows下安装Oracle10.2g文档），注意选择高级安装，安装目录采用默认的，字符集选第二个的ALTUTF8那个，设置管理员密码可以设成同一个密码，新建库实例名为orcl。中间会出现要求以root身份运行一个文件，按照要求执行即可。6. 设置随机启动在/etc/rc.d/rc.local中加入如下： su - oracle -c /u01/app/oracle/product//bin/lsnrctl startsu - oracle -c /u01/app/oracle/product//bin/dbstart start7. 重启机器，验证oracle是否自动启动oraclecxx $ sqlplus /nologSQL*Plus: Release .0 - Production on Tue Apr 24 16:31:43 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL connect / as sysdbaConnected.SQL shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL startupORACLE instance started.Total System Global Area 285212672 bytesFixed Size 1218992 bytesVariable Size 100664912 bytesDatabase Buffers 180355072 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.SQLSQL exitDisconnected from Oracle Database 10g Enterprise Edition Release .0 - ProductionWith the Partitioning, OLAP and Data Mining optionsoraclexx$ dbshutoraclexx$ lsnrctl stopLSNRCTL for Linux: Version .0 - Production on 24-APR-2007 16:36:25Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)The command completed successfullyoraclexx$ lsnrctl startLSNRCTL for Linux: Version .0 - Production on 24-APR-2007 16:36:38Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting /home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait.TNSLSNR for Linux: Version .0 - ProductionSystem parameter file is /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.oraLog messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=calis73.localdomain)(PORT=1521)Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)STATUS of the LISTENER-Alias LISTENERVersion TNSLSNR for Linux: Version .0 - ProductionStart Date 24-APR-2007 16:36:38Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.oraListener Log File /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.logListening Endpoints Summary.(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=calis73.localdomain)(PORT=1521)Services Summary.Service PLSExtProc has 1 instance(s).Instance PLSExtProc, status UNKNOWN, has 1 handler(s) for this service.The command completed successfullyoraclexx$ dbstartFailed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnrProcessing Database instance orcl: log file /home/oracle/oracle/product/10.2.0/db_1/startup.logoraclexx$ emctl start dbconsoleTZ set to PRCOracle Enterprise Manager 10g Database Control Release .0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http:/calis73.localdomain:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 10g Database Control . started. -Logs are generated in directory /home/oracle/oracle/product/10.2.0/db_1/calis73.localdomain_orcl/sysman/log oraclexx$ emctl stop dbconsoleTZ set to PRCOracle Enterprise Manager 10g Da