Oralce installation-Remote Installation of Oracle10g Database on a Windows client on a Linux host

Keywords: ORACLE10G linux installation

Use a personal account to telnet the LINUX host, enable exceed on the client, and use the following command to set environment variables:
Setenv DISPLAY yourIP: 0.0
The purpose is to install ORACLE10G on the GUI and return the interface to your client.

 

Use the following command to convert to a root user (the root password must be known)

$ Su-root
Password:
#

View the LINUX host information:

1. OS version
# Cat/etc/issue

Red Hat Enterprise Linux AS release 4 (Nahant Update 2)
Kernel \ r on an \ m
2. kernel version
# Uname-r

2.6.9-22. ELsmp

3. Memory and swap space
RAM Swap Space
Between 1024 MB and 2048 MB 1.5 times the size of RAM
Between 2049 MB and 8192 MB Equal to the size of RAM
More than 8192 MB 0.75 times the size of RAM

4. view memory:
# Grep MemTotal/proc/meminfo
MemTotal: 2065388 kB
Here is 2G
-- Requires at least 1 GB,

5. view the swap space:
# Grep SwapTotal/proc/meminfo
SwapTotal: 2031608 kB
If the memory is 2 GB, the swap zone should be 1.5 times the memory, and it should be 3 GB. No warning information is provided during later installation.

6. view memory and swap space usage (I installed it on a new LINUX host ):
# Free
Total used free shared buffers cached
Mem: 2065388 2048136 17252 0 1912 1761616
-/+ Buffers/cache: 284608 1780780
Swap: 2031608 109832 1921776

7. Check the disk space to see if it meets the disk requirements for installation.
# Df-k/-h
Filesystem 1K-blocks Used Available Use % Mounted on
/Dev/mapper/VolGroup00-LogVol00
151656620 16387356 127565508 12%/
/Dev/sda1 101086 12535 83332 14%/boot
None 1032692 0 1032692 0%/dev/shm
Cnxafs01:/export/home/ymiao
206424760 130102152 65836848 67%/home/ymiao
The disk space required by ORACLE of different versions is as follows:

Installation Type Requirement for Software Files (GB)
Enterprise Edition 1.85
Standard Edition 1.85
Custom (maximum) 1.99

8. Check whether the software requirements for LINUX Hosts are met (varies by version)
--- Red Hat Enterprise Linux 4.0:
Package name version
Binutils-2.15.92.0.2-10. EL4
Compat-db-4.1.25-9
Control-center-2.8.0-12
Gcc-3.4.3-9. EL4
Gcc-c ++-3.4.3-9. EL4
Glibc-2.3.4-2
Glibc-common-2.3.4-2
Gnome-libs-1.4.1.2.90- 44.1
Libstdc ++-3.4.3-9. EL4
Libstdc ++-devel-3.4.3-9. EL4
Make-3.80-5
Pdksh-5.2.14-30
Sysstat-5.0.5-1
Xscreensaver-4.18-5.rhel4.2

Run the following command to View Details:
# Rpm-q package name
The result should be consistent or higher than the previous version.


Modify core parameters: (if not modified, there will be many warnings during installation)

# Vi/etc/sysctl. conf

Add at the end:

Kernel. shmall = 2097152
Kernel. shmmax = 2147483644
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Fs. file-max = 65536
Net. ipv4.ip _ local_port_range = 1024 65000
Net. core. rmem_default = 1048576
Net. core. rmem_max = 1048576
Net. core. wmem_default = 262144
Net. core. wmem_max = 262144

Save and exit
#/Sbin/sysctl-p
Make the configuration take effect

 

Create users and related groups:
#/Usr/sbin/groupadd oinstall // create an Oracle Inventory group
#/Usr/sbin/groupadd dba // create an OSDBA group
#/Usr/sbin/useradd-g oinstall-G dba oracle-d/root/oracle // create an Oracle software owner and add it to the preceding two groups

Set the installation environment variable

Log on as the root user
# Su-root
$ Cd
$ Vi. bash_profile

Add:
Export ORACLE_BASE =/export/oracle
Export ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1
Export ORACLE_SID = orcl
Export PATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/bin
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib
Export LC_CTYPE = en_US.UTF-8
Save and exit.

Then execute
$ Source. bash_profile
Make environment variables take effect

Copy the 10201_database_linux32.zip package to the/oracle directory and decompress it.
Method:
First, copy the compressed package to your ymiao directory,
Enter the following command as the root user:

Cd/home/ymiao
Cp 10201_database_linux32.zip/oracle

# Unzip 10201_database_linux32.zip
Decompress and generate the database directory

Enter the database directory
As an oracle user
Input:

$ Sh runInstaller

Go to the installation page and install the SDK as required.

Start the listener:

Go to/oracle/product/10.2.0/db_1/bin/
Lsnrctl start

 

Task after installation
Use Oracle10g Database
After the installation is complete, the Oracle database will be automatically started. The following describes how to start the Oracle10g Database.
And disable. & Nbsp;
In x-windows, open a console window with "login:" First displayed. log on to the database as an Oracle user:

Login: oracle
Password:

1. Start Oracle10g Database
$ Sqlplus "scott/tiger as sysdba"
The following Connection database information is displayed:
SQL * Plus: Release 10.1.0.2.0-Production on Wednesday March 24 16:23:27 2004
Copyright (c) 1982,200 4, Oracle. All rights reserved.

 

Connect:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0-Production
With the Partitioning, OLAP and Data Mining options
SQL>

Indicates that the database system is successfully logged on. Run the startup command to start the database.

SQL> startup
ORACLE instance started.

Total System Global Area 336356520 bytes
Fixed Size 279720 bytes
Variable Size 268435456 bytes
Database Buffers 67108864 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL>
Indicates that the database is started normally.

2. Shut down the Oracle10g Database
$ Sqlplus "scott/tiger as sysdba" // log on to the database as a sysdba user

After successfully logging on to the database system, run the shudown command to close the database.
SQL> shutdown

3. Start the Oracle10g listener
Oracle listeners provide interfaces for client connection. In the console window, enter the following command:
$ Lsnrctl
The following listener information appears:
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0-Production on 24-3 months-2004 16
: 59: 51
Copyright (c) 1991,200 4, Oracle. All rights reserved.
Welcome to LSNRCTL. Enter & quot; help "for information.
LSNRCTL>

Indicates that the listener console is successfully logged on. Run the start command to start the listener.

LSNRCTL> start
Lists the startup and configuration information of the listener.
When The last line of The information line is "The command completed successfully", The listener starts
.

4. Disable the Oracle10g listener
Run the stop command to close the listener.
LSNRCTL> stop