1.直接登陆Oracle用户如下报错,从一下报错信息可以得知,open file修改没有权限,也就是nofile参数设置有问题
正在进行认证,请稍后 ...... Using username "oracle". Last login: Wed Mar 9 09:25:23 2022 from xx.xx.xx.xx stty erase ^H -bash: ulimit: open files: cannot modify limit: Operation not permitted [oracle@xxx~]$ ulimit -u -n max user processes (-u) 65536 open files (-n) 1024
2.从以上报错马上想到可能是/etc/profile中设置的参数要比/etc/security/limits.conf参数文件中设置的要大导致的报错
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022 fi
grid soft nproc 65536 grid hard nproc 65536 grid soft nofile 65536 grid hard nofile 65536 grid soft stcak 10240 grid hard stcak 10240 oracle soft nproc 65536 oracle hard nproc 65536 oracle soft nofile 65536 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 10240 oracle soft memlock -1 oracle hard memlock -1 grid soft memlock -1 grid hard memlock -1
切换到oracle用户查看资源限制,这里发现参数设置正常,那么为什么会出现此类问题呢? 这里是因为UsePam参数未打开,导致的问题
[root@xxx~]# su - oracle [oracle@xxx~]$ ulimit -u -n max user processes (-u) 65536 open files (-n) 65536
3.问题解决
修改/etc/ssh/sshd_config配置文件中,我们需要体添加如下配置.
UsePAM yes
重启sshd服务 --此时发现了如下报错,提示不支持UsePam,这里是因为没有安装openssh,重新安装即可
[root@xxx~]# service sshd restart Stopping sshd: [ OK ] Starting sshd:/etc/ssh/sshd_config line 82: Unsupported option UsePAM [ OK ]
安装openssh并重启sshd服务
[root@xxx~]# rpm -qa | grep openssh [root@xxx~]# yum -y install openssh-server Loaded plugins: fastestmirror, refresh-packagekit, security Setting up Install Process Determining fastest mirrors base | 2.9 kB 00:00 epel | 2.9 kB 00:00 epel/primary_db | 6.0 MB 00:00 extras | 2.9 kB 00:00 extras/primary_db | 27 kB 00:00 updates | 2.9 kB 00:00 updates/primary_db | 967 kB 00:00 Resolving Dependencies --> Running transaction check ---> Package openssh-server.x86_64 0:5.3p1-124.el6_10 will be installed --> Processing Dependency: openssh = 5.3p1-124.el6_10 for package: openssh-server-5.3p1-124.el6_10.x86_64 --> Running transaction check ---> Package openssh.x86_64 0:5.3p1-124.el6_10 will be installed --> Finished Dependency Resolution Dependencies Resolved =================================================================================================================================================================== Package Arch Version Repository Size =================================================================================================================================================================== Installing: openssh-server x86_64 5.3p1-124.el6_10 updates 330 k Installing for dependencies: openssh x86_64 5.3p1-124.el6_10 updates 278 k Transaction Summary =================================================================================================================================================================== Install 2 Package(s) Total download size: 607 k Installed size: 1.4 M Downloading Packages: (1/2): openssh-5.3p1-124.el6_10.x86_64.rpm | 278 kB 00:00 (2/2): openssh-server-5.3p1-124.el6_10.x86_64.rpm | 330 kB 00:00 ------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 2.5 MB/s | 607 kB 00:00 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Warning: RPMDB altered outside of yum. ** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows: python-meh-0.12.1-3.el6.noarch has missing requires of openssh-clients Installing : openssh-5.3p1-124.el6_10.x86_64 1/2 warning: /etc/ssh/moduli created as /etc/ssh/moduli.rpmnew Installing : openssh-server-5.3p1-124.el6_10.x86_64 2/2 warning: /etc/ssh/sshd_config created as /etc/ssh/sshd_config.rpmnew Verifying : openssh-5.3p1-124.el6_10.x86_64 1/2 Verifying : openssh-server-5.3p1-124.el6_10.x86_64 2/2 Installed: openssh-server.x86_64 0:5.3p1-124.el6_10 Dependency Installed: openssh.x86_64 0:5.3p1-124.el6_10 Complete! [root@hrdb2 ~]# service sshd restart Stopping sshd: [ OK ] Starting sshd: [ OK ]
编辑推荐:
- 系统参数nofile设置不生效问题03-03
- 影响MySQL性能的硬件因03-03
- ocp 19c考题,科目082考试题(31) - resource_limit03-03
- Oracle 创建表空间和用户脚本03-03
- [重庆思庄每日技术分享]-oracle ins,INS-32027 during Oracle 12 upgrade03-03
- OGG-Oracle 11.2.0.1 ->19.3 pdb 使用Ogg 同步版本相关问题学习整理03-03
- 【TABLESPACE】Oracle 表空间结构说明03-03
- [重庆思庄每日技术分享]-ORA-38775: cannot disable recovery area 异常处理03-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 【TABLESPACE】Oracle 表空间结构说明
【TABLESPACE】Oracle 表空间结构说明
26-03-03 - About the Oracle GoldenGate Trail
About the Oracle GoldenGate Trail
26-03-03 - 19c RAC 双实例
19c RAC 双实例
26-03-03 - Oracle ADG 自动切换脚本分享
Oracle ADG 自动切换脚本分享
26-03-03 - 【UP_ORACLE】能够升级到Oracle 19c的数据库版本清单
【UP_ORACLE】能够升级到Oracle 19c的数据库版本清单
26-03-03 - Release Schedule of Current Database Releases (Doc ID 742060.1)
- Oracle 架构汇总
Oracle 架构汇总
26-03-03 - 盖世无双之国产数据库风云榜-2022年02月
盖世无双之国产数据库风云榜-2022年02月
26-03-03 - db file sequential read
db file sequential read
26-03-03 - Oracle ADG 备库添加备库
Oracle ADG 备库添加备库
26-03-03
