数据库

本类阅读TOP10

·SQL语句导入导出大全
·SQL Server日期计算
·SQL语句导入导出大全
·SQL to Excel 的应用
·Oracle中password file的作用及说明
·MS SQLServer OLEDB分布式事务无法启动的一般解决方案
·sqlserver2000数据库置疑的解决方法
·一个比较实用的大数据量分页存储过程
·如何在正运行 SQL Server 7.0 的服务器之间传输登录和密码
·SQL中两台服务器间使用连接服务器

分类导航
VC语言Delphi
VB语言ASP
PerlJava
Script数据库
其他语言游戏开发
文件格式网站制作
软件工程.NET开发
oracle 10G 安装 for Linux86

作者:未知 来源:月光软件站 加入时间:2005-2-28 月光软件站

Configuring Linux for the Installation of Oracle Database 10g

In this lesson, you learn how to configure Linux and prepare for the installation of Oracle Database 10g.

This lesson covers the following topics:

Place the cursor on this icon to display all the screenshots in the lesson. You can also place the cursor on each individual icon in the following steps to see only the screenshot that is associated with that step.

Back to List

The lesson prepares the Linux operating system for the installation of Oracle Database 10g.

Back to Topic List

Before starting this lesson, you should have:

1.

Installed an Oracle Database 10g certified version of Linux on a platform certified for that version of Linux. To see the latest certification information, use Metalink and select Certify & Availability. You can also use OTN.

 

Back to Topic List

The system on which you install Linux must meet the following requirements:

512 MB of physical random access memory (RAM)

1 GB of swap space (or twice the size of RAM)

Swap space between one and two times the size of RAM (on systems with 2 GB or more of RAM)

400 MB of disk space in the /tmp directory

2.1 GB of disk space for the Oracle software and Sample Schema Database

Back to Topic List

To configure the system, follow these steps (written for Bourne, Korn, and bash shells):

1.

Open a terminal window and log in as the root user.

 

2.

The following local UNIX groups and user must exist on the system:

Groups: oinstall and dba
User: oracle

Optionally, the oper group can be created.

Group: oper

We now create the three groups oinstall, dba, and oper:

/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/groupadd oper 

Move your mouse over this icon to see the image

 

3.

Create the operating system user oracle:

/usr/sbin/useradd -g oinstall -G dba,oper oracle

Move your mouse over this icon to see the image

4.

Enter the following command to set the password of the oracle user:

/usr/bin/passwd oracle

Move your mouse over this icon to see the image

 

5.

With an editor of your choosing, open /home/oracle/.bash_profile. If you are using another shell, please add the entries to the appropriate file.

umask 022

PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib 
        
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1
ORACLE_SID=orcl
PATH=$ORACLE_HOME/bin:$PATH

export PATH LD_LIBRARY_PATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID

Move your mouse over this icon to see the image

 

6.

Create the directory for the software installation and assign ownership to oracle:oinstall. In the example, you use /u01/app/oracle.

mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app
chmod -R 775 /u01/app

Move your mouse over this icon to see the image

 

7.

Set required kernel parameters:


Parameter                       Value
----------------------------    -----------------
kernel.semmsl                   250
kernel.semmns                   3200
kernel.semopm                   100
kernel.semmni                   128
kernel.shmall                   2097152
kernel.shmmax                   2147483648
kernel.shmmni                   4096
fs.file-max                     65536
net.ipv4.ip_local_port_range    1024 65000

Open the /etc/sysctl.conf file in any text editor and add lines similar to the following:

kernel.sem = 250 32000 100 128
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

With specified values for these parameters in the /etc/sysctl.conf file, the values persist when you reboot the system.

Move your mouse over this icon to see the image

 

8.

The kernel changes made previously take effect with each reboot.

Issue this command to set the kernel parameters:

/sbin/sysctl -p

Move your mouse over this icon to see the image

 

9.

Log in as operating system user oracle. You must install the software from an X Window System workstation, an X terminal, or a PC or other system with X server software installed.

 

Installing Oracle Database 10g on Linux

In this lesson, you learn how to install Oracle Database 10g on Linux.

This lesson covers the following topics:

Overview
Prerequisites
Installing Oracle Database 10g on Linux

Place the cursor on this icon to display all the screenshots in the lesson. You can also place the cursor on each individual icon in the following steps to see only the screenshot that is associated with that step.

Using the Oracle Universal Installer, you install the Oracle Database 10g software and create a database.

Before starting this lesson, you should have:

1.

Completed the Configuring Linux for the Installation of Oracle Database 10g lesson.

 

To install the Oracle software, you must use the GUI installer.

1.

Log in to the Linux box as user oracle and mount the Oracle Database 10g CD. Change directory to the CD and execute the script /mnt/cdrom/runInstaller from your home directory:

/mnt/cdrom/runInstaller

Move your mouse over this icon to see the image

 

Move your mouse over this icon to see the image

 

2.

At the Welcome window, click Next.

Move your mouse over this icon to see the image

 

3.

You need to specify your Inventory directory. The location should be set to /u01/app/oracle/oraInventory. Accept the default Operating System group name, oinstall. Then click Next.

Move your mouse over this icon to see the image

 

4.

The following window appears. Leave this window open.

Move your mouse over this icon to see the image

 

5.

You need to execute orainstRoot.sh as the root user. Open a terminal window and enter the following commands:

su
<rootpassword>
cd /u01/app/oracle/oraInventory
./orainstRoot.sh
exit
exit

Move your mouse over this icon to see the image

 

6.

Switch back to the Universal Installer window and click Continue.

Move your mouse over this icon to see the image

 

7.

At the Specify File Locations window, change the path to /u01/app/oracle/product/10.1.0/db_1. Then click Next.

Move your mouse over this icon to see the image

 

8.

Make sure the Installation Type Enterprise Edition is selected and click Next.

Move your mouse over this icon to see the image

 

9.

The installer now verifies that the system meets all the minimum requirements for installing and configuring the chosen product. Please correct any reported issues before continuing. When the check successfully completes, click Next.

Move your mouse over this icon to see the image

 

10.

You want to create a starter database. Make sure that Create a starter database and General Purpose are both selected. Then click Next.

Move your mouse over this icon to see the image

 

11.

Enter orcl.oracle.com in the Global Database Name field, and select the Create database with example schemas check box. Then click Next. If you plan to perform any of the multilingual lessons, you should select Unicode standard UTF-8 AL32UTF8 as the database character set.

Move your mouse over this icon to see the image

 

12.

The Select Database Management Option window enables you to choose between Database Control or Grid Control of your database. In this example, you accept the default, which is Database Control. Click Next.

Move your mouse over this icon to see the image

 

13.

Specify the database file location as /u01/app/oracle/oradata and click Next.

Move your mouse over this icon to see the image

 

14.

In the Specify Backup and Recovery Options window, you do not want to enable automated backups at this time. Accept the default and click Next.

Move your mouse over this icon to see the image

 

15.

Enter and confirm a password for all accounts, and then click Next.

Move your mouse over this icon to see the image

 

16.

Review the Summary window to verify what is to be installed. Then click Install.

Move your mouse over this icon to see the image

 

17.

The progress window appears.

Move your mouse over this icon to see the image

 

18.

The Configuration Assistants window appears.

Move your mouse over this icon to see the image

 

19.

Your database is now being created.

Move your mouse over this icon to see the image

 

20.

When the database is created, click OK.

Move your mouse over this icon to see the image

 

21.

When the Setup Privileges window appears, open a new terminal window.

Move your mouse over this icon to see the image

 

22.

You need to execute root.sh as the root user. From your terminal window, enter the following commands:

cd $ORACLE_BASE/product/10.1.0/db_1
su
<rootpassword>
./root.sh
exit
exit

Move your mouse over this icon to see the image

 

23.

The End of Installation summary appears. The ports shown in the summary can be found in $ORACLE_BASE/product/10.1.0/db_1/portlist.ini. Click OK.

Move your mouse over this icon to see the image

 

24.

Click Yes to exit.

Move your mouse over this icon to see the image

 

Place the cursor on this icon to hide all screenshots.




相关文章

相关软件