Summary of problems encountered during oracle Installation

Problems encountered during oracle installation 1. When configuring disk partitions, the root can only be 50 GB at the maximum and home860G at the same time. I want to set the disk space of Home to 50 GB, this is because the recommended partition scheme provided by centos is the first time centos is installed by default. When centos is re-installed next time, the above Partition Scheme will prevail by default. You need to enter

Problems encountered during oracle installation 1. When configuring disk partitions,/root can only be 50 GB at most,/home 860 GB, and you want to set/Home disk space to 50 GB, this is because centos provides the recommended partitioning solution when centos is installed by default for the first time. When centos is re-installed next time, the above partitioning scheme will prevail by default.

Problems encountered during oracle Installation

1. When configuring disk partitions,/root can only be 50 GB at most,/home 860 GB, and you want to set/Home disk space to 50 GB, and move others to/root directory

This is because centos provides the recommended partitioning solution when centos is installed by default for the first time. When centos is re-installed next time, the above partitioning scheme will be used by default, and you need to enter the self-created partition, delete the partition solution provided by the system, and create/root (mounted to/root directory) and swap partitions. Do not set the size of/home partitions.

2. sysctl-p error

Fs. file-max = 6815744
Fs. aio-max-nr = 1048576
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
"Sysctl. conf" 54L, 1461C
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Net. ipv4.ip _ local_port_range = 9000 65500
Net. core. rmem_default = 4194304
Net. core. rmem_max = 4194304
Net. core. wmem_default = 262144
Net. core. wmem_max = 1048576

The system prompts that the sysctl command does not exist when the sysctl-p command is executed directly because the kernel. shmmni is written as kernel. shmmin. Therefore, when writing scripts, make sure that every word is correct and every letter is case-sensitive (linux case-sensitive). Pay special attention to the messages prompted by the compiler.

3. sysctl-p Display Error

error: "net.bridge.bridge-nf-call-ip6tables" is an unknown keyerror: "net.bridge.bridge-nf-call-iptables" is an unknown keyerror: "net.bridge.bridge-nf-call-arptables" is an unknown key

Solution: Reference http://serverfault.com/questions/477718/sysctl-p-etc-sysctl-conf-returns-error

modprobe bridgelsmod | grep bridge

4. The configuration information of root and oracle users is incorrect.

-Bash: [root: command not found

-Bash: [oracle: command not found

The reason is that no double quotation marks or spaces are added.

If ["$ USER" = "oracle"]; then
If ["$ SHELL" = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi

5.-bash: [: missing ']'

Cause: space is missing.

6. garbled characters are executed during./runInstall.

Solution: Execute export LANG = en_US in the oracle account

7. No protocol specified
Exception in thread "main" java. lang. NoClassDefFoundError
At java. lang. Class. forName0 (Native Method)
At java. lang. Class. forName (Class. java: 164)
At java. awt. Toolkit $ 2.run( Toolkit. java: 821)
At java. security. AccessController. doPrivileged (Native Method)
At java. awt. Toolkit. getdefatooltoolkit (Toolkit. java: 804)
At com. jgoodies. looks. LookUtils. isLowResolution (Unknown Source)
At com. jgoodies. looks. LookUtils. (Unknown Source)
At com. jgoodies. looks. plastic. PlasticLookAndFeel. (PlasticLookAndFeel. java: 122)
At java. lang. Class. forName0 (Native Method)
At java. lang. Class. forName (Class. java: 242)
At javax. swing. SwingUtilities. loadSystemClass (SwingUtilities. java: 1783)
At javax. swing. UIManager. setLookAndFeel (UIManager. java: 480)
At oracle. install. commons. util. Application. startup (Application. java: 758)
At oracle. install. commons. flow. FlowApplication. startup (FlowApplication. java: 164)
At oracle. install. commons. flow. FlowApplication. startup (FlowApplication. java: 181)
At oracle. install. commons. base. driver. common. Installer. startup (Installer. java: 265)
At oracle. install. ivw. db. driver. DBInstaller. startup (DBInstaller. java: 114)
At oracle. install. ivw. db. driver. DBInstaller. main (DBInstaller. java: 132)

Solution: log out of the root account and execute./runInstall under the oracle account. You cannot use su-oracle.

8. The password entered does not conform to the Oracle recommended standards.
Solution: Complicated password settings

9. central inventory location was not writable

Set the ACL for the folder: chown-R oracle: oinstall/usr/oracle

10. ip address localhost cocould not be determined

Vi/etc/hosts Add the host name to the Host Name List of 127.0.0.1

Hostname RAID

11. the selected oracle home contained directories or files

To start with an enpty oracle home, either remove its contents or choose another location

Solution: delete all files and folders in/usr/oracle \

11. this is a prerequisite condition to test whether the package "make-3.8"

Solution: yum-y install gcc automake autoconf libtool make

12. After the server is restarted, all nameserver settings in/etc/resolv. conf are cleared.

Solution: Add DNS1 = 192.168.1.1 to/etc/network-scripts/ifcfg-em1

13. this is a prerequisite condition to test whether the package "make-3.8"

Solution: yum install make

14. After the installation of oracle is interrupted and centos is restarted, the root user name and password (correct user name and password) cannot be successfully logged on to the local machine.

Solution: During the oracle installation process, the general installation documents will mention setting/etc/security/limits. conf and/etc/pam. d/login parameter files are used to limit the number of files and processes that can be opened by the oracle server. d. Add the session required/lib/security/pam_limits.so In the login file to implement/etc/security/limits. the limits defined in conf are similar to setting resource settings directly through the ulimit command. This is also set during the installation process of this machine, but the problem occurs here.

This machine uses a 64-bit operating system, so there is no/lib/security/pam_limits.so file at all, instead of the/lib64/security/pam_limits.so file, otherwise, this file cannot be found during login, and the local machine cannot be logged on.

15. ORA-01017: invalid username/password; logon denied

Cause of error: Oracle password loss, account lock Solution

Solution:

SQL> sqlplus

SQL> conn/as sysdba

SQL> alter user system identified by system;

16. Oracle the network adapter cocould not establish the connection exception

Cause: the port is not open, and port 1521 is not open.

Solution: lsnrctl start

17. linux TNS: listener does not currently know of service requested in connect

Cause: oracle service not started

Solution:./dbstart

18. PL/SQL Developer Chinese garbled Solutions

Modify local environment variables and set

1. Run select * from v $ nls_parameters to query the NLS_LANG and NLS_CHARACTERSET of the oracle server.

1. Enter my computer, properties, advanced, environment variables, and add two items: LANG = zh_CN.GBK and NLS_LANG =The value of NLS_LANG on the oracle server.

2. Choose pl/SQL developer> tools> preferences> user interface> fonts to change the font to a Chinese font.