Typical ORA-12547 error handling

Source: Internet
Author: User


ORA-12547 error handling this morning around, the leaders told me, let me help a colleague to ORACLE Installation, he encountered problems in the installation process, error, unable to continue to install. I. Due to the NLS_LANG setting error, cause ora-12547 error I looked at in the past, found in AIX5.3 System Using DBCA database to the last point after the completion of the ORA-12547 tns lost connect error, at that time, I felt quite strange. Then I checked the system environment in detail. asynchronous IO was enabled, and the HOST file was also normal. The parameter file does not seem to be too problematic, the ulimit limit is changed to-1, and no obvious problems are found. The installation log shows that the operating system environment is not satisfied. At that time, I couldn't find out why I deleted the previously installed DBSOFT and re-installed the DBSOFT database. No error was reported during DBSOFT installation, we had to check the problem again and found that [db: oracle] $ cat ~ in the oracle user environment configuration file ~ /. The NLS_LANG = ZHS16GBK parameter is found in the profile. I think this parameter is not required later. www.2cto.com may cause an error during installation and disable it immediately, the parameter file is as follows: $ cat. profile PATH =/usr/bin:/etc:/usr/sbin:/usr/ucb: $ HOME/bin:/usr/bin/X11:/sbin :. export patlif [-s "$ MAIL"] # This is at Shell startup. in normalthen echo "$ MAILMSG" # operation, the Shell checksfi # periodically. ORACLE_BASE =/oracleORACLE_SID = orclORACLE_HOME = $ ORACLE_BASE/app/10.2.0/db_1 # NLS_LANG = ZHS1 6 GBKPATH = $ ORACLE_HOME/bin: $ PATH: export ORACLE_BASE ORACLE_SID ORACLE_HOME PATH $ disable the database and create a database in DBCA again. If the database fails to be created again, the database is created successfully. 2, dbca database creation this problem, after the online search, basically caused by the following four reasons: 1, asynchronous IO caused by dbca report ORA-12547
Solution: AIX: a, smitty chaio (only supported by the AIX 5 Series) b. Set STATE to be configured at system restart to available c. Run DBCA again to create a successful www.2cto.com HP-UNIX. You can refer to (Metalink Note: 139272.1). create an aio character device #/sbin/mknod/dev/async c 101 0x0 # chown oracle: dba/dev/async # chmod 660/dev/async B. use sam to adjust Kernel parameters-> Kernel Configuration-> Drivers-> select 'asyncdsk'-> Actions> Add Driver to Kernel. (in this case, the pending state changes from out to in.)-> Kernel Con Figuration-> Configurable Parameters-> max_async_ports is set to the 'Processes' value in the initialization file + number of oracle background processes (according to v $ bgprocess, the maximum number of background processes for a single instance is 78) c. use sam to set aio_max_ops-> Kernel Configuration-> retriable Parameters-> aio_max_ops-> to the default value of 2048 or above. The host needs to rebuild the core and restart. d. the oracle user must have the MLOCK permission. A. roolt # setprivgrp dba MLOCK B. to avoid failure after restart, you must set vi/etc/privgroup to add the following line: dba MLOCK www.2cto.com e. check whether aio has taken effect # fuser/dev/async has a process column indicating that aio has taken effect. 2. The default value of ulimit is not modified.
Solution: Linux a. Modify the limits parameter file and add the following content: vi/etc/security/limits. conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 AIX a. Modify the limits parameter file. Add the following content at the end: (Note:-1 indicates unlimited use) vi/etc/security/limitsdefault: fsize =-1 core = 2097151cpu =-1 data = 262144 rss = 65536 stack = 65536 nofiles = 2000 root: daemon: bin: sys: adm: uucp: guest: nobody: lpd: oracle: data =-1 stack =-1 3. The SELinux configuration in Linux is incorrect,

Solution a: Use the root user to log on to the system and execute setenforce 0 (no restart required) B. Modify selinux = "" in the/etc/SELINUX/config file to disabled and restart www.2cto.com.
4. libaio (x86_64) is not installed (like AIX, asynchronous IO is enabled and this package is packaged in Linux)
Solution: a. Insert the operating system installation disc B. log on to the operating system as the root user and mount the operating system installation disc: # mount-t iso9660/dev/cdrom/mnt # cd/mnt/Serverc, check and install the libaio package, run the following command # rpm-qa | grep-I ^ libaio # rpm-ivh libaio -*. i386.rpm # rpm-ivh libaio -*. x86_64.rpmd: Check whether the package has been installed successfully. # rpm-qa | grep ^ libaioe. Run the installation again. Problem Solving is taken from the wuweilong column.

Related Article

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.