VMWare上最小化安装Oracle 10g R2
欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 安装RedHat Advanced Server 我装RedHat Advanced Server一直都是先择最小安装的,然后再装必须的开发环境及X11组件, 这样可以节约很多的空间(RHEL3最小安装为580M,RHEL4为646M左右,加上X11和必要的
欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入
安装RedHat Advanced Server
我装RedHat Advanced Server一直都是先择最小安装的,然后再装必须的开发环境及X11组件, 这样可以节约很多的空间(RHEL3最小安装为580M,RHEL4为646M左右,加上X11和必要的开发环境100M多一点吧). 如何手工安装必要的开发库和X11环境呢?
RHEL3
放入第二张安装盘,运行以下命令:
mount /mnt/cdrom
cd /mnt/cdrom/RedHat/RPMS
rpm -ivh cpp*.rpm
rpm -ivh XFree86-4.3*.rpm XFree86-base-fonts-4*.rpm \
XFree86-font-utils-4*.rpm XFree86-xauth-4*.rpm \
XFree86-xfs-4*.rpm chkfontpath*.rpm xinitrc*.rpm \
switchdesk*.rpm ttmkfdir*.rpm XFree86-tools*.rpm \
desktop-file-utils*.rpm gtk+-1.2*.rpm qt-3.1.2*.rpm \
libmng-1*.rpm XFree86-Mesa-libGLU*.rpm xterm*.rpm \
gdk-pixbuf*.rpm
放入第三张安装盘,运行以下命令:
mount /mnt/cdrom
cd /mnt/cdrom/RedHat/RPMS
rpm -ivh gcc-3*.rpm glibc-devel*.rpm glibc-headers*.rpm \
glibc-kernheaders*.rpm \
gcc-c++-3.2.3-42.i386.rpm \
libstdc++-devel-*.i386.rpm \
compat-libstdc++-*.i386.rpm
RHEL4
RedHat 安装开发包
Disk2: rpm -i cpp-3.4.3-22.1.i386.rpm
Disk3: rpm -i gcc-3.4.3-22.1.i386.rpm \
glibc-devel-2.3.4-2.9.i386.rpm \
glibc-headers-2.3.4-2.9.i386.rpm \
glibc-kernheaders-2.4-9.1.87.i386.rpm \
kernel-devel-2.6.9-11.EL.i686.rpm
RedHat 安装X11
Disk2: rpm -i xorg-x11-font-utils-6.8.2-1.EL.13.6.i386.rpm \
xorg-x11-xauth-6.8.2-1.EL.13.6.i386.rpm \
xorg-x11-xfs-6.8.2-1.EL.13.6.i386.rpm \
switchdesk-4.0.6-3.noarch.rpm \
ttmkfdir-3.0.9-14.i386.rpm \
xterm-192-1.i386.rpm \
xorg-x11-Mesa-libGLU-6.8.2-1.EL.13.6.i386.rpm
Disk3 rpm -i xorg-x11-6.8.2-1.EL.13.6.i386.rpm \
chkfontpath-1.10.0-2.i386.rpm \
xinitrc-4.0.14-1.noarch.rpm \
fonts-xorg-base-6.8.1.1-1.EL.1.noarch.rpm \
xorg-x11-6.8.2-1.EL.13.6.i386.rpm \
安装前的准备工作
1,改一下sys.shmmax参数默认值为32M,你可以改成256M或512M就足够了,在/etc/sysctl.conf最后加入一行sys.shmmax=, 运行sysctl -p使其生效.
2,在RHEL4 Update1上运行 ln -s /usr/lib/libstdc++.so.6.0.3 /usr/lib/libstdc++.so.5
3,安装libaio库,应当在第三张安装盘上.
安装Oracle 10g Release 2
安装过程不会有任何问题,我为了节约空间,删除了一些东西,$ORACLE_HOME目录下有jre和jdk目录, 可以将jre下面的内容删除,再建一个软件连链接,就可以了,命令如下:
rm -fr $ORACLE_HOME/jre
ln -s $ORACLE_HOME/jdk/jre $ORACLE_HOME/jre/1.4.2
之外还删除了$ORACLE_HOME/assistants/dcba/templates下面的一些大文件,两部总共可以空出160M空间吧.在安装时不会现什么问题,和第一版或Oracle 9i没什么本质区别.
创建数据库
可以用dbca来创建生成数据库的角本,然后退出dbca,再运行生成的创建角本,不会有什么问题的. 我在一个3G空间的VMware 5 Workstation的机器上安装操作系统,Oracle并生成了一个库,还多余200M空间左右.
附件A:创建Database的语句
connect "SYS"/"&&sysPassword" as SYSDBA
set echo on
spool /home/oracle/createdb/CreateDB.log
startup nomount pfile="/home/oracle/createdb/init.ora";
CREATE DATABASE "DB10G"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/home/oracle/oradata/DB10G/system01.dbf' SIZE 256M REUSE EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/home/oracle/oradata/DB10G/sysaux01.dbf' SIZE 64M REUSE SMALLFILE
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/home/oracle/oradata/DB10G/temp01.dbf'
SIZE SIZE SIZE 48M REUSE SMALLFILE
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/home/oracle/oradata/DB10G/undotbs01.dbf' SIZE 128M REUSE
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1 ('/home/oracle/oradata/DB10G/redo01.log') SIZE 51200K,
GROUP 2 ('/home/oracle/oradata/DB10G/redo02.log') SIZE 51200K,
GROUP 3 ('/home/oracle/oradata/DB10G/redo03.log') SIZE 51200K
USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword";
spool off
附件B:创建Database需要运行的角本
connect "SYS"/"&&sysPassword" as SYSDBA
set termout off
set echo on
spool /home/oracle/createdb/CreateDBCatalog.log
@/home/oracle/product/10g/rdbms/admin/catalog.sql;
@/home/oracle/product/10g/rdbms/admin/catblock.sql;
@/home/oracle/product/10g/rdbms/admin/catproc.sql;
@/home/oracle/product/10g/rdbms/admin/catoctk.sql;
@/home/oracle/product/10g/rdbms/admin/owminst.plb;
connect "SYSTEM"/"&&systemPassword"
@/home/oracle/product/10g/sqlplus/admin/pupbld.sql;
connect "SYSTEM"/"&&systemPassword"
set echo on
spool /home/oracle/createdb/sqlPlusHelp.log
@/home/oracle/product/10g/sqlplus/admin/help/hlpbld.sql helpus.sql;
spool off
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
AI Hentai Generator
Generate AI Hentai for free.
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
1382
52
How to check tablespace size of oracle
Apr 11, 2025 pm 08:15 PM
To query the Oracle tablespace size, follow the following steps: Determine the tablespace name by running the query: SELECT tablespace_name FROM dba_tablespaces; Query the tablespace size by running the query: SELECT sum(bytes) AS total_size, sum(bytes_free) AS available_space, sum(bytes) - sum(bytes_free) AS used_space FROM dba_data_files WHERE tablespace_
How to encrypt oracle view
Apr 11, 2025 pm 08:30 PM
Oracle View Encryption allows you to encrypt data in the view, thereby enhancing the security of sensitive information. The steps include: 1) creating the master encryption key (MEk); 2) creating an encrypted view, specifying the view and MEk to be encrypted; 3) authorizing users to access the encrypted view. How encrypted views work: When a user querys for an encrypted view, Oracle uses MEk to decrypt data, ensuring that only authorized users can access readable data.
How to view instance name of oracle
Apr 11, 2025 pm 08:18 PM
There are three ways to view instance names in Oracle: use the "sqlplus" and "select instance_name from v$instance;" commands on the command line. Use the "show instance_name;" command in SQL*Plus. Check environment variables (ORACLE_SID on Linux) through the operating system's Task Manager, Oracle Enterprise Manager, or through the operating system.
How to uninstall Oracle installation failed
Apr 11, 2025 pm 08:24 PM
Uninstall method for Oracle installation failure: Close Oracle service, delete Oracle program files and registry keys, uninstall Oracle environment variables, and restart the computer. If the uninstall fails, you can uninstall manually using the Oracle Universal Uninstall Tool.
How to check invalid numbers of oracle
Apr 11, 2025 pm 08:27 PM
Oracle Invalid numeric errors may be caused by data type mismatch, numeric overflow, data conversion errors, or data corruption. Troubleshooting steps include checking data types, detecting digital overflows, checking data conversions, checking data corruption, and exploring other possible solutions such as configuring the NLS_NUMERIC_CHARACTERS parameter and enabling data verification logging.
How to set up users of oracle
Apr 11, 2025 pm 08:21 PM
To create a user in Oracle, follow these steps: Create a new user using the CREATE USER statement. Grant the necessary permissions using the GRANT statement. Optional: Use the RESOURCE statement to set the quota. Configure other options such as default roles and temporary tablespaces.
How to solve the problem of closing oracle cursor
Apr 11, 2025 pm 10:18 PM
The method to solve the Oracle cursor closure problem includes: explicitly closing the cursor using the CLOSE statement. Declare the cursor in the FOR UPDATE clause so that it automatically closes after the scope is ended. Declare the cursor in the USING clause so that it automatically closes when the associated PL/SQL variable is closed. Use exception handling to ensure that the cursor is closed in any exception situation. Use the connection pool to automatically close the cursor. Disable automatic submission and delay cursor closing.
How to create oracle dynamic sql
Apr 12, 2025 am 06:06 AM
SQL statements can be created and executed based on runtime input by using Oracle's dynamic SQL. The steps include: preparing an empty string variable to store dynamically generated SQL statements. Use the EXECUTE IMMEDIATE or PREPARE statement to compile and execute dynamic SQL statements. Use bind variable to pass user input or other dynamic values to dynamic SQL. Use EXECUTE IMMEDIATE or EXECUTE to execute dynamic SQL statements.
