记一次测试环境 sqlplus / as sysdba 报 ORA-12547: TNS:lost contact错误解决

最新推荐文章于 2024-04-08 13:49:33 发布

desert_xu

最新推荐文章于 2024-04-08 13:49:33 发布

阅读量1k

点赞数 1

分类专栏： internal trubleshooting 文章标签： p2p oracle 数据库

本文链接：https://blog.csdn.net/xxjj2003/article/details/122470405

版权

trubleshooting 同时被 2 个专栏收录

17 篇文章 0 订阅

订阅专栏

internal

4 篇文章 0 订阅

订阅专栏

测试环境 linux 6 oracle 11.2.0.4

这个环境这是安装了软件，想测试一下 sqlplus / as sysdba

竟然报ORA-12547

百思不饶查看bin/oracle 权限也是对的

用strace -f sqlplus / as sysdba

跟踪找到了一个trace文件

oracle@oracle6 db_1]$ vi /opt/app/oracle/product/11.2.0/db_1/rdbms/log/orcl_ora_3144.trc

Dump file /opt/app/oracle/product/11.2.0/db_1/rdbms/log/orcl_ora_3144.trc

*** 2022-01-13 11:10:57.702
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/app/oracle/product/11.2.0/db_1
System name:    Linux
Node name:      oracle6
Release:        2.6.32-71.el6.x86_64
Version:        #1 SMP Wed Dec 15 12:36:54 EST 2010
Machine:        x86_64
Instance name: ORCL
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Unix process pid: 3144, image: oracle@oracle6


*** 2022-01-13 11:10:57.703
ORA-00600: internal error code, arguments: [SKGMINVALID], [13], [16777216], [0], [1520200], [], [], [], [], [], [], []
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+41        call     kgdsdst()            000000000 ? 000000000 ?
                                                   7FFF26D28860 ? 7FFF26D28938 ?
                                                   7FFF26D2D3E0 ? 000000002 ?
ksedst1()+103        call     skdstdst()           000000000 ? 000000000 ?
                                                   7FFF26D28860 ? 7FFF26D28938 ?
                                                   7FFF26D2D3E0 ? 000000002 ?
ksedst()+39          call     ksedst1()            000000000 ? 000000001 ?
                                                   7FFF26D28860 ? 7FFF26D28938 ?
                                                   7FFF26D2D3E0 ? 000000002 ?
dbkedDefDump()+2746  call     ksedst()             000000000 ? 000000001 ?
                                                   7FFF26D28860 ? 7FFF26D28938 ?
                                                   7FFF26D2D3E0 ? 000000002 ?
ksedmp()+41          call     dbkedDefDump()       000000003 ? 000000000 ?
                                                   7FFF26D28860 ? 7FFF26D28938 ?

后台竟然报 600 错误了，看到了一个参数 1520200 好像很眼熟，因为我本来想验证 shmall 这个参数 ,这个参数就是shmmax 的值，

查询资料 ora 600 SKGMINVALID 得知是shmmax 值太小了不正确，

调整这个值到2G 再sqlplus / as sysdba 回答正常的idle 状态了。