前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >RHEL装完oracle 11g后遇到的问题

RHEL装完oracle 11g后遇到的问题

作者头像
明年我18
发布2019-09-18 11:47:48
6540
发布2019-09-18 11:47:48
举报
文章被收录于专栏:明年我18

1.运行sqlplus,提示

  1. sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied

这个问题是由于SELINUX引起的。 解决办法:

编辑/etc/sysconfig/selinux配置文件, 把SELINUX=enforcing 改为 SELINUX=disabled。

  1. # This file controls the state of SELinux on the system.
  2. # SELINUX= can take one of these three values:
  3. # enforcing - SELinux security policy is enforced.
  4. # permissive - SELinux prints warnings instead of enforcing.
  5. # disabled - SELinux is fully disabled.
  6. #SELINUX=enforcing
  7. SELINUX=disabled
  8. # SELINUXTYPE= type of policy in use. Possible values are:
  9. # targeted - Only targeted network daemons are protected.
  10. # strict - Full SELinux protection.
  11. SELINUXTYPE=targeted

保存后重启系统。

2.用sqlplus,输入用户名密码后,提示:

  1. Enter user-name: system
  2. Enter password:
  3. ERROR:
  4. 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

原因竟然是oracle没有启动成功,用sqlplus '/as sysdba'命令,然后输入startup来启动oracle,但发现启动oracle时报错:

  1. [oracle@localhost dbs]$ sqlplus '/as sysdba'
  2. SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 25 14:49:49 2012
  3. Copyright (c) 1982, 2009, Oracle. All rights reserved.
  4. Connected to an idle instance.
  5. SQL> startup
  6. ORA-01078: failure in processing system parameters
  7. LRM-00109: could not open parameter file '/u01/app/oracle/dbs/initliusuping.ora'

继续baigoogledu,这次是百度给了答案:

  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.5252012131333
  6. [oracle@localhost pfile]$ cp init.ora.5252012131333 /u01/app/oracle/dbs/initliusuping.ora

即找到另外一个ora文件,然后把它复制到/u01/app/oracle/dbs下面,并重命名为initliusuping.ora。靠,为什么我的sid是liusuping?我装oracle的时候貌似没看到有设置sid的地方啊,怎么给默认这个了。

再次startup,数据库终于起来了:

  1. [oracle@localhost pfile]$ sqlplus '/as sysdba'
  2. SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 25 15:13:00 2012
  3. Copyright (c) 1982, 2009, Oracle. All rights reserved.
  4. Connected to an idle instance.
  5. SQL> startup
  6. ORACLE instance started.
  7. Total System Global Area 602619904 bytes
  8. Fixed Size 1338168 bytes
  9. Variable Size 360711368 bytes
  10. Database Buffers 234881024 bytes
  11. Redo Buffers 5689344 bytes
  12. Database mounted.
  13. Database opened.

不知道liusuping是怎么来的,自己建一个库吧。进入/u01/app/oracle/bin,输入.dbca,打开管理界面,在这里可以删除、创建数据库。我们创建一个sid为test的数据库:

3.用客户端连它,连不上,"没有监听程序"。

打开/u01/app/oracle/network/admin/listener.ora,它的内容如下:

  1. # listener.ora Network Configuration File: /u01/app/oracle/network/admin/listener.ora
  2. # Generated by Oracle configuration tools.
  3. LISTENER =
  4. (DESCRIPTION_LIST =
  5. (DESCRIPTION =
  6. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  7. (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
  8. )
  9. )
  10. ADR_BASE_LISTENER = /u01/app

把它改为:

  1. # listener.ora Network Configuration File: /u01/app/oracle/network/admin/listener.ora
  2. # Generated by Oracle configuration tools.
  3. SID_LIST_LISTENER =
  4. (SID_LIST =
  5. (SID_DESC =
  6. (GLOBAL_DBNAME = test)
  7. (ORACLE_HOME = /u01/app/oracle)
  8. (SID_NAME =test)
  9. )
  10. )
  11. LISTENER =
  12. (DESCRIPTION_LIST =
  13. (DESCRIPTION =
  14. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  15. (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.199)(PORT = 1521))
  16. )
  17. )
  18. ADR_BASE_LISTENER = /u01/app

然后运行lsnrctl start,结果如下:

  1. [oracle@localhost admin]$ lsnrctl start
  2. LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 25-JUN-2012 18:04:25
  3. Copyright (c) 1991, 2009, Oracle. All rights reserved.
  4. Starting /u01/app/oracle/bin/tnslsnr: please wait...
  5. TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  6. System parameter file is /u01/app/oracle/network/admin/listener.ora
  7. Log messages written to /u01/app/diag/tnslsnr/localhost/listener/alert/log.xml
  8. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  9. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.199)(PORT=1521)))
  10. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  11. STATUS of the LISTENER
  12. ------------------------
  13. Alias LISTENER
  14. Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  15. Start Date 25-JUN-2012 18:04:25
  16. Uptime 0 days 0 hr. 0 min. 0 sec
  17. Trace Level off
  18. Security ON: Local OS Authentication
  19. SNMP OFF
  20. Listener Parameter File /u01/app/oracle/network/admin/listener.ora
  21. Listener Log File /u01/app/diag/tnslsnr/localhost/listener/alert/log.xml
  22. Listening Endpoints Summary...
  23. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  24. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.199)(PORT=1521)))
  25. Services Summary...
  26. Service "test" has 1 instance(s).
  27. Instance "test", status UNKNOWN, has 1 handler(s) for this service...
  28. The command completed successfully

然后在用客户端链接一下:

终于连上去了。。。

本文参与 腾讯云自媒体同步曝光计划,分享自作者个人站点/博客。
原始发表:2012-06-25 ,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
相关产品与服务
数据库
云数据库为企业提供了完善的关系型数据库、非关系型数据库、分析型数据库和数据库生态工具。您可以通过产品选择和组合搭建,轻松实现高可靠、高可用性、高性能等数据库需求。云数据库服务也可大幅减少您的运维工作量,更专注于业务发展,让企业一站式享受数据上云及分布式架构的技术红利!
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档