Install oracle10 in SUSE Linux and solve the problem. suseoracle10

Install oracle10 in SUSE Linux and solve the problem. suseoracle10

I have summarized my experience in installing oracle10g on Redhat5.5 and SUSE10.1.

When SUSE10 is installed with OraRun, the oracle user, oinstall group, and dba group will be automatically created in the etc/profile. d/generate oracle under the directory. sh script (set ORACLE environment variables), generate a file named "oracle" in the etc/sysconfig directory (configuration file ). Before installation, you must manually modify the default shell of the oracle user in the etc/passwd file, and change it to oracle: x: 103: 108: Oracle user:/opt/oracle: /bin/bash, and then run "passwd oracle" as the root user to set a password for it, and then use oracle to enter the installation.

Although Orarun claims that it is a lazy package installed in oracle, it is the first time it has caused a lot of trouble. I think it is better not to use it. After all, it is best to master the installation information on your own. We assume that Orarun will replace us with kernel parameters, but it seems that this is not the case. Otherwise, we have never seen anything that allows us to choose kernel parameters. is the kernel parameters used by Orarun uniform. Under SUSE10, no Kernel shared memory configuration is found in/etc/sysctl. conf. However, the value of these kernel parameters must be determined. Which of the following questions can be answered. We recommend that you manually enter the kernel parameters in sysctl. conf to clarify the current Kernel Parameters of your system.

If the installation interface is garbled: Modify the environment variable export LANG = CN or export LANG = EN

Problem 1: dhcp Problems

Checking Network Configuration requirements...
Check complete. The overall result of this check is: Not executed <

Solution:

First, make sure that your machine is configured with a static IP address. do not obtain it automatically through dhcp. If it is not an error but "1 requirement to be verified", select the above box and retry it. It can be understood that this is for the user to verify. I have been entangled for a long time because I didn't understand the meaning of English. If there is no prompt after retry, it means it is normal. What's important is that you don't need to modify the hosts file or something on the Internet, but the more you change it, the more you get wrong. You only need to confirm that the static IP address is configured. If the host and domain name are configured, for example, if the host name is set to ibm and the domain name is site, we recommend that you change the domain name to localdomain, my personal understanding is that we do not need to find any Domain Name Server to resolve the site domain name.

Question 2: Version problems occur during OS Version Detection

Solution:

1. Take SUSE10 as an example. oracle does not support SUSE10. Modify the/etc/SuSe-release file and change VERSION to 9.

2. Add the parameter "-ignoreSysPreReqs ". Run./runInstaller-ignoreSysPreReqs to ignore pre-detection of the operating system version.

Question 3:"Unable to attach to shared memory segment"

Solution:

Permission issues. Add the suid permission to the $ ORACLE_HOME/bin/directory by using chmod u + s-R $ ORACLE_HOME/bin/. The permission is 6751 oracle.

Question 4:ORA-01031: insufficint privileges

Solution:

The problem occurs when other users (non-oracle users) are used. For example, you want to use another user conn/as sysdba. On the Internet, the grant command is used to add permissions to the user. However, I used a simple and crude method to add the user directly to the dba group. The command is usermod-G dba username. -G can be used to set the group to which the user belongs.-g is the only basic group to which the user belongs.

Question 5:ORA-27102 out of memory

Solution:

First, check the kernel parameters of the Local Machine and the shared memory size parameters. view the file content in/pro/sys/kernel/cat, shmmax shared memory segment size shmmni shared memory segment maximum number shmall system can use the total shared memory (in the unit of pages, not smaller than the shmmax/single page size ). Increase the maximum value allowed by the system or reduce the memory size required by oracle. Modify the SHMMAX value in/etc/sysconfig/oracle.

To install Oracle in a system other than SUSE, You need to manually configure the kernel parameters (although I did not manually configure it during Redhat5 installation, because the default Kernel configuration of Redhat5 has met the Oracle Installation requirements), the kernel parameter configuration file/etc/sysctl. conf.

The Kernel configuration in Redhat is as follows. For other systems, refer to modify some parameters and run the "sysctl-p" command immediately after modification (read the sysctl. conf file)

# Controls IP packet forwarding
Net. ipv4.ip _ forward = 0

# Controls source route verification
Net. ipv4.conf. default. rp_filter = 1

# Do not accept source routing
Net. ipv4.conf. default. accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
Kernel. sysrq = 0

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
Kernel. core_uses_pid = 1

# Controls the use of TCP syncookies
Net. ipv4.tcp _ syncookies = 1

# Controls the maximum size of a message, in bytes
Kernel. msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
Kernel. msgmax = 65536

# Controls the maximum shared segment size, in bytes
Kernel. shmmax = 4294967295

# Controls the maximum number of shared memory segments, in pages
Kernel. shmall = 268435456

ORACLE 10 Gb English document

Respect every ERROR