Detailed procedures for installing oracle9i on Redhat ____oracle

Source: Internet
Author: User
Tags dba error handling mkdir posix oracle database

    oracle9i Installation
    It took the Monday and Tuesday two days to finally install Oracle, and here is the steps for later reference.
    installs Oracle9i (oracle9201) on Rh9 (2.4.20-8).


    1 in the RH installation process should be aware of four points
    one is hard disk space to be a bit larger, Rh9 all installed about 4.5G of space, the Oracle9i database about the need for 2-2.5g space, so the file partition at least 7G, too small easy to problem, the bigger the better ha.
    II is to perform oracle9i standard installation and create prototypes (simple prototype) databases, Oracle recommends that oracle9i (9.0.1) servers require at least 512M of memory, Twice times the memory or not less than 400M of swap space, I strongly recommend that set at 1G or so, if the swap is small, such as 512M, in the database creation phase will prompt "Out of memory" error. Of course, you can also temporarily increase the swap space by establishing a temporary swap file instead of using the original device (raw device) as follows:
    Su-
    dd If=/dev/zero Of=tmpswap bs=1k count=900000 Note: about 1G
    chmod tmpswap
    mkswap tmpswap
    swapon tmpswap
    to cancel the temporary swap space, you can execute the following command:
    Su-
     swapoff tmpswap
    rm-rf tmpswap
    Third is rh9 to install English, there are two times to choose the opportunity to install, It is best to install English on both occasions. I was in the installation of the first choice of Chinese, the second choice in English, Oracle or garbled, log off in English environment landing are not. Therefore, the first choice of English, the second choice of English and Chinese two, but the installation of Oracle must be an English environment.
    Four is to install a few more development packs, because subsequent installations may be required as long as you have room to fully install.


2 Creating Oracle Users and Groups
Su-
Groupadd Oinstall # Group owner Oracle Files
Groupadd dba #group of users to is granted with SYSDBA system privilege
GROUPADD-G oinstall-g dba Oracle
passwd Oracle


3 Preparing the Oracle file directory
Su-
Mkdir-p/opt/ora9/product/9.2
Mkdir/var/opt/oracle
Chown oracle.dba/var/opt/oracle
Chown-r oracle.dba/opt/ora9
Note: The first time I installed a problem, the or9/deleted, and then mkdir, but forgot chown, the results of the installation of Oracle users prompted no directory operation permissions.


4 Installing Support Packages
Su-
Run the following command to check that the development pack is installed
Rpm–q gcc cpp compat-libstdc++ glibc-devel glibc-kernheaders binutils
If either of these are not installed, such as the package CPP is not installed, insert the RH9 installation disk, and the CDROM Mount command is
Mount-t iso9660/dev/cdrom/mnt
When you find the CPP in the RPMs folder, run the following command to install
RPM–IVH cpp-3.2.2-5.i386.rpm
Note: The version of CPP in different RH versions is not the same


5 Set kernel parameters, adjust semaphore and shared memory
Open the/etc/sysctl.conf file, write the following data to the end and save
Kernel.shmmax =.
Note: To install oracle9i (9.2.0), you need to increase the maximum shared memory (maximum shared memeory) for all RH versions of the Linux server. Otherwise, the Oracle Database Configuration Assistant (the Oracle DB Configuration Assistant) displays the following error message:
Ora-27123:unable to attach to shared memory segment unable to attach to share memory
Kernel.shmmni = 4096
Kernel.shmall = 2097152
Kernel.sem = 250 32000 100 128
Fs.file-max = 65536
Net.ipv4.ip_local_port_range = 1024 65000
Suggestions about Net.ipv4.ip_local_port_range do not change, you can use cat/proc/sys/net/ipv4/ip_local_port_range see the scope of the definition of RH9 has been met, and the port range is smaller than this.
Where Kernel.shmmax is the maximum size of a shared memory segment, Kernel.shmmin is the smallest size of a shared memory segment, and entering/proc/sys/kernel can view its values with the following command.
Cat Shmmax
Cat Shmmni
Cat Shmall
The Kernel.shmmax calculation method is generally RAM (K) *1024*2,ram values can be viewed with the following command.
grep memtotal/proc/meminfo
Memtotal:xxxx KB
For Kernel.sem values, 250 is the value of the parameter SEMMSL, 32000 is the value of the parameter semmns, 100 is the value of the parameter semopm, and 128 is the value of the parameter Semmni.
Next, open the/etc/security/limits.conf file and write the following data to the end and save, which sets Oracle's requirements for the file.
Oracle Soft Nofile 65536
Oracle Hard Nofile 65536
Oracle Soft Nproc 16384
Oracle Hard Nproc 16384


6 Setting Oracle's system environment
Su-oracle
Edit the/HOME/ORACLE/.BASHRC file and add the following data
#oracle9i
Export ORACLE_BASE=/OPT/ORA9 Note: Do not have spaces before and after equals sign
Export oracle_home=/opt/ora9/product/9.2
Export path= $ORACLE _home/bin: $ORACLE _home/apache/apache/bin: $PATH
Export Oracle_owner=oracle
Export oracle_sid=ora9i Note: This value uniquely identifies a database that can be changed, and is recommended in uppercase letters (lowercase also can)
Export oracle_term=vt100
Export ld_assume_kernel=2.4.1
Note: The RH9 default uses the local POSIX line threading (the Native POSIX thread LIBRARY-NPTL) to implement the Linux improvements for POSIX threads. However, due to the use of the nptl,oracle application will cause some problems, RH9 did not pass oracle9i authentication. To fix these problems, you can set the environment variable ld_assume_kernel=2.4.1 to notify the system to use the original floating-point stack Linux thread (linuxthreads with floating stacks). Failure to do so can cause problems such as the Oracle installer Runinstaller pending, the database Configuration Assistant (the DB Configuration Assistant) DBCA does not start.
Export Threads_flag=native
Export Ld_library_path=/opt/ora9/product/9.2/lib: $LD _library_path
Export Path=/opt/ora9/product/9.2/bin: $PATH
The configuration of environment variables is critical, and you must be careful.


7 Decompression installation files
Copy the oracle9i installation files from the download or CD to a directory, for example (CD-ROM)
Su-
Mkdir/mnt/oracle
Mount-t iso9660/dev/cdrom/mnt
Waiting
cp/mnt/cdrom/lux_920_disk*/mnt/oracle
Note that there are generally three installation files lux_920_disk1.cpio.gz,lux_920_disk2.cpio.gz,lux_920_disk3.cpio.gz, and remember before you change the disc
Umount/dev/cdrom
Note: The reason why I write so in detail is because I am a rookie, and often make some weak and weak mistakes: (
Now start to extract the files under/mnt/oracle, Linux support multithreading, open three terminal, enter the following instructions
Terminal1#zcat lux_920_disk1.cpio.gz | Cpio-idmv
Terminal2#zcat lun_920_disk2.cpio.gz | Cpio-idmv
Terminal3#zcat lun_920_disk3.cpio.gz | Cpio-idmv
During decompression, three directories containing installation files were automatically created under/mnt/oracle
Disk1
Disk2
Disk3
Remember, the warm-up work is finished, reset, must be restarted. It is not clear that some of the parameters set above may require a reboot to take effect.


8 Installation and error handling
Su-
Export display=localhost.localdomain:0.0
Xhost +localhost.localdomain
The localhost.localdomain is actually hostname, which can be viewed with command hostname.
Note: The above two items will not be set to error, Runinstaller can not run, prompts the following error:
Xlib:connection to ': 0.0 ' refused by server
Xlib:client is isn't authorized to connect to Server
The above problem seems to be more complicated, I did not look carefully. Presumably Oracle no longer supports the character setup mode, so you need to set it up to display the Runinstaller interface, or x information, on the Remote Desktop. Note that if you do not use Exceed,x to display the relink mechanism, you cannot work on the NT desktop machine. Because I am a local installation, the problem is simple ha:)
Then switch to the Oracle user and start the installation
Su-oracle
Cd/mnt/oracle/disk1
./runinstaller
Do you see the exciting Oracle installation interface? Hehe
Oh Baby,come on!
You need to enter some information at the beginning of the installation, refer to the following:
---What would you as the base directory (Inventory Location)
/opt/ora9/orainventory
---UNIX Group name (permission for updating Oracle software)
Oinstall Note: DBA can also be used, but DBA is not recommended for security reasons
---full path name for Oracle Home
/opt/ora9/product/9.2
Wait a minute
During the next installation process, you will typically encounter four problems.
The first problem is the installation interface character garbled, is definitely the reason for Chinese, the solution
Su-oracle
Export Lang=en_us:lang
Note: I also encountered this problem, but using the solution did not succeed, finally I have to reload rh9, all over the UK. If there is a better way, please tell me w_fenghui@sina.com.cn, but I suggest to install the English system.
The second question is the hint about this file ins_oemagent.mk, solution, ignore, we will fix it in the following steps.
The third issue is the prompt "Error in invoking target install of makefile $ORACLE _home/ctx/lib/ins_ctx.mk", solution, edit file $oracle_home/ctx/lib/ ENV_CTX.MK, add "$ (ldlibflag) DL" to the "Inso_link =" line (line 1365th), as follows:
Inso_link =-l$ (ctxlib) $ (Ldlibflag) M $ (ldlibflag) DL $ (Ldlibflag) Sc_ca $ (Ldlibflag) Sc_fa $ (Ldlibflag) SC_EX $ (LDLIBFLAG ) Sc_da $ (Ldlibflag) Sc_ut $ (Ldlibflag) Sc_ch $ (Ldlibflag) Sc_fi $ (LLIBCTXHX) $ (ldlibflag) C-wl,rpath,
$ (ctxhome) Lib $ (corelibs) $ (COMPEOBJS)
Press the "Retry" key to continue.
The fourth problem is that the Oracle Agent configuration Assistant failed to start, prompting the following error:
Parameter "NodeInfo" =no_value
Agent service failed
The solution to the problem is---I don't know: (
Because I did not use the Agentctl service, so did not solve the problem, generally not to use it. A patch package is required to resolve the problem.
Finally, you also need to follow the prompts to perform a $ORACLE with the root user _home/root.sh,oracle software is initially installed.
We'll go back and solve the ins_oemagent.mk problem above. Execute with Oracle User:
CD $ORACLE _home/network/lib
Make-f ins_net_client.mk Install
Edit the 第13-14 line of the $oracle_home/ctx/lib/ins_ctx.mk file by:
CTXHX: $ (ctxhxobj)
$ (LINK) $ (ctxhxobj) $ (inso_link)
To
CTXHX: $ (ctxhxobj)
$ (LINK)-LDL $ (ctxhxobj) $ (inso_link)
And then execute
Make-f $ORACLE _home/ctx/lib/ins_ctx.mk Install
Now that Oracle software has been completely installed, you can use the DBCA command to set up a database or execute other DBA commands.


9 Experience Summary
One: The reload is not a solution to the problem, encounter problems to the Internet to check, you encounter problems estimated that others have already met
Two: If the installation was unsuccessful for any other reason, please clear the following files before running again:
/etc/orainst.loc/etc/oratab/tmp/<otheroracleownerfile> $ORACLE _base/*

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.