Home > Developer > Oracle

Problems encountered after RHEL installed Oracle 11g

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

1. Run sqlplus, prompt

    1. Sqlplus: ErrorWhileLoading shared libraries:/u01/APP/Oracle/product/11.2.0/dbhome_1/lib/libclntsh. so.11.1: cannot restore segment prot after reloc: Permission denied

This problem is caused by SELinux. Solution:

Edit the/etc/sysconfig/SELinux configuration file and change SELinux = enforcing to SELinux = disabled.

  2. # This file controls the state of SELinux on the system.
  4. # SELinux = can take one of these three values:
  6. # Enforcing-SELinux Security PolicyIsEnforced.
  8. # Permissive-SELinux prints warnings instead of enforcing.
  10. # Disabled-SELinuxIsFully disabled.
  12.  
  14. # SELinux = enforcing
  16. SELinux = disabled
  18.  
  20. # Selinuxtype = type of policyInUse. Possible values are:
  22. # Targeted-only targeted network daemons areProtected.
  24. # Strict-full SELinux protection.
  26. Selinuxtype = targeted

Save and restart the system.

2. With sqlplus, enter the user name and password, and the prompt is:

    1. Enter user-Name: System
    2. Enter password:
    3. Error:
    4. A ORA-01034: Oracle not available
    5. ORA-27101: Shared Memory realm does not exist
    6. Linux error: 2: no such file or directory
    7. Process ID: 0
    8. Session ID: 0 serial number: 0

The reason is that Oracle was not started successfully. Run the sqlplus '/As sysdba' command and enter startup to start oracle. However, an error is reported when oracle is started:

    1. [Oracle @ localhost DBS] $ sqlplus '/AsSysdba'
    2.  
    3. SQL * Plus: Release 11.2.0.1.0 production ction on Mon Jun 25 14:49:49 2012
    4.  
    5. Copyright (c) 1982,200 9, Oracle. All rights reserved.
    6.  
    7. Connected to an idle instance.
    8.  
    9. SQL> startup
    10. ORA-01078: FailureInProcessing System Parameters
    11. LRM-00109: cocould not open parameter file '/u01/APP/Oracle/dbs/initliusuping. ora'

Continue to baigoogledu. This time Baidu gave the answer:

    1. [Oracle @ localhost Oracle] $ find/u01-name pfile
    2. /U01/APP/admin/orcl/pfile
    3. [Oracle @ localhost Oracle] $ CD/u01/APP/admin/orcl/pfile
    4. [Oracle @ localhost pfile] $ ls
    5. Init. ora.525201213success
    6. [Oracle @ localhost pfile] $ CP init. ora.52520151120.20./ u01/APP/Oracle/dbs/initliusuping. ora

Find another ora file, copy it to/u01/APP/Oracle/DBS, and rename it initliusuping. ora. Why is my Sid liusuping? When I installed Oracle, it seems that I didn't see the place where I set Sid. How can I set this by default.

Startup again, the database finally got up:

  2. [Oracle @ localhost pfile] $ sqlplus '/AsSysdba'
  4.  
  6. SQL * Plus: Release 11.2.0.1.0 production ction on Mon Jun 25 15:13:00 2012
  8.  
  10. Copyright (c) 1982,200 9, Oracle. All rights reserved.
  12.  
  14. Connected to an idle instance.
  16.  
  18. SQL> startup
  20. Oracle instance started.
  22.  
  24. Total system global area 602619904 bytes
  26. Fixed size 1338168 bytes
  28. Variable Size 360711368 bytes
  30. Database buffers 234881024 bytes
  32. Redo buffers 5689344 bytes
  34. Database mounted.
  36. Database opened.

I don't know how liusuping came from. Please create a library by yourself. Enter/u01/APP/Oracle/bin, enter. dbca, and open the management interface. You can delete and create databases here. We create a database with Sid test:

 

3. connect it with a client and fail to connect. "No listeningProgram".

Open/u01/APP/Oracle/Network/admin/listener. ora with the following content:

  2. # Listener. ora network configuration file:/u01/APP/Oracle/Network/admin/listener. ora
  4. # Generated by Oracle configuration tools.
  6.  
  8. Listener =
  10. (Description_list =
  12. (Description =
  14. (Address = (Protocol = IPC) (Key = extproc1521 ))
  16. (Address = (Protocol = TCP) (host = localhost. localdomain) (Port = 1521 ))
  18. )
  20. )
  22.  
  24. Adr_base_listener =/u01/APP

Change it:

  2. # Listener. ora network configuration file:/u01/APP/Oracle/Network/admin/listener. ora
  4. # Generated by Oracle configuration tools.
  6.  
  8. Sid_list_listener =
  10. (Sid_list =
  12. (Sid_desc =
  14. (Global_dbname = test)
  16. (ORACLE_HOME =/u01/APP/Oracle)
  18. (Sid_name = test)
  20. )
  22. )
  24.  
  26. Listener =
  28. (Description_list =
  30. (Description =
  32. (Address = (Protocol = IPC) (Key = extproc1521 ))
  34. (Address = (Protocol = TCP) (host = 192.168.0.199) (Port = 1521 ))
  36. )
  38. )
  40.  
  42. Adr_base_listener =/u01/APP

Then run LSNRCTL start. The result is as follows:

  2. [Oracle @ localhost admin] $ LSNRCTL start
  4.  
  6. LSNRCTLForLinux: Version 11.2.0.1.0-production on 25-jun-2012 18:04:25
  8.  
  10. Copyright (c) 1991,200 9, Oracle. All rights reserved.
  12.  
  14. Starting/u01/APP/Oracle/bin/tnslsnr: Please wait...
  16.  
  18. TnslsnrForLinux: Version 11.2.0.1.0-Production
  20. System parameter fileIs/U01/APP/Oracle/Network/admin/listener. ora
  22. Log messages written to/u01/APP/diag/tnslsnr/localhost/listener/alert/log. xml
  24. Listening On: (description = (address = (Protocol = IPC) (Key = extproc1521 )))
  26. Listening On: (description = (address = (Protocol = TCP) (host = 192.168.0.199) (Port = 1521 )))
  28.  
  30. Connecting to (description = (address = (Protocol = IPC) (Key = extproc1521 )))
  32. Status of the listener
  34. ------------------------
  36. Alias listener
  38. Version tnslsnrForLinux: Version 11.2.0.1.0-Production
  40. Start date 25-jun-2012 18:04:25
  42. Uptime 0 days 0 HR. 0 min. 0 sec
  44. Trace Level off
  46. Security on: Local OS Authentication
  48. SNMP off
  50. Listener parameter file/u01/APP/Oracle/Network/admin/listener. ora
  52. Listener log file/u01/APP/diag/tnslsnr/localhost/listener/alert/log. xml
  54. Listening endpoints summary...
  56. (Description = (address = (Protocol = IPC) (Key = extproc1521 )))
  58. (Description = (address = (Protocol = TCP) (host = 192.168.0.199) (Port = 1521 )))
  60. Services summary...
  62. Service"Test"Has 1 instance (s ).
  64. Instance"Test", Status unknown, has 1 handler (s)For
    ThisService...
  66. The command completed successfully

Then you can use the client link:

Finally connected...

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

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

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

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

    Open a Ticket

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

    Learn More