linux mint安装oracle 12cR2 出现ora-12547 TNS lost contact问题

最新推荐文章于 2023-08-21 10:57:30 发布

weixin_43123581

最新推荐文章于 2023-08-21 10:57:30 发布

阅读量1k

点赞数

本文链接：https://blog.csdn.net/weixin_43123581/article/details/103494159

版权

linux mint 19.2 (x64)安装 oracle 12cR2版本, server only已经安装成功了,并无报错
但dbca创建库实例的时候报错:

ORA-12547: TNS:lost contact

怀疑是libaio有问题,但经查阅资料暂时有效解决方案, 请教下各位大神, 欢迎回帖

sqlplus登录出错

oracle@x230:~$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Dec 11 15:44:17 2019
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
ERROR:
ORA-12547: TNS:lost contact

Enter user-name:

按照这个教程装的
https://tutorialforlinux.com/2019/07/21/how-to-install-oracle-12c-r2-database-on-linux-mint-19-2-64-bit-installing-packages/

hosts配置

oracle@x230:~$ cat /etc/hosts
127.0.0.1	localhost
127.0.0.1	x230
127.0.0.1	local.vbill.cn
127.0.0.1 	localhost.localdomain

listener状态

oracle@x230:~$ lsnrctl stat

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 11-DEC-2019 15:50:33

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                11-DEC-2019 15:20:16
Uptime                    0 days 0 hr. 30 min. 16 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/app/oracle/product/12/dbhome_1/network/admin/listener.ora
Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/x230/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

listener配置

oracle@x230:~$ cat /home/oracle/app/oracle/product/12/dbhome_1/network/admin/listener.ora
# listener.ora Network Configuration File: /home/oracle/app/oracle/product/12/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

1521端口监听状态

oracle@x230:~$ netstat -an|grep 1521
tcp        0      0 127.0.0.1:1521          0.0.0.0:*               LISTEN     
unix  2      [ ACC ]     STREAM     LISTENING     37016    /var/tmp/.oracle/sEXTPROC1521

句柄限制

oracle@x230:~$ ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 46576
max locked memory       (kbytes, -l) 16384
max memory size         (kbytes, -m) unlimited
open files                      (-n) 65535
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 2047
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

环境变量(.bashrc部分配置)

# Oracle Settings
export TMP=/tmp;
export TMPDIR=$TMP;
export ORACLE_HOSTNAME=127.0.0.1;
export ORACLE_BASE=/home/oracle/app/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/12/dbhome_1;
export ORACLE_SID=orcl;
export ORACLE_UNQNAME=$ORACLE_SID;
export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64;
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

文件权限

oracle@x230:~$ ll $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle oinstall 407826136 Dec 11 06:11 /home/oracle/app/oracle/product/12/dbhome_1/bin/oracle*

oracle@x230:~$ ll $ORACLE_HOME
total 328
drwxrwxr-x 73 oracle oinstall  4096 Dec 11 06:12 ./
drwxrwxr-x  3 oracle oinstall  4096 Dec 11 05:43 ../
drwxr-xr-x  2 oracle oinstall  4096 Dec 11 06:11 addnode/
drwxr-xr-x  6 oracle oinstall  4096 Dec 11 06:10 apex/
drwxr-xr-x 10 oracle oinstall  4096 Dec 11 06:09 assistants/
drwxr-xr-x  2 oracle oinstall 12288 Dec 11 06:14 bin/
drwxr-xr-x  7 oracle oinstall  4096 Dec 11 06:11 ccr/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:11 cdata/
drwxr-xr-x  4 oracle oinstall  4096 Dec 11 06:14 cfgtoollogs/
drwxr-xr-x  4 oracle oinstall  4096 Dec 11 06:11 clone/
drwxr-xr-x  6 oracle oinstall  4096 Dec 11 06:09 crs/
drwxr-xr-x  6 oracle oinstall  4096 Dec 11 06:11 css/
drwxr-xr-x 11 oracle oinstall  4096 Dec 11 06:11 ctx/
drwxr-xr-x  7 oracle oinstall  4096 Dec 11 06:09 cv/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 data/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 dbjava/
drwxr-xr-x  2 oracle oinstall  4096 Dec 11 15:41 dbs/
drwxr-xr-x  2 oracle oinstall  4096 Dec 11 06:10 dc_ocm/
drwxr-xr-x  5 oracle oinstall  4096 Dec 11 06:11 deinstall/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 demo/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 diagnostics/
drwxr-xr-x  8 oracle oinstall  4096 Dec 11 06:10 dmu/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 dv/
-rw-r--r--  1 oracle oinstall   852 Aug 19  2015 env.ora
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 has/
drwxr-xr-x  5 oracle oinstall  4096 Dec 11 06:11 hs/
drwxr-xr-x  9 oracle oinstall  4096 Dec 11 06:31 install/
drwxr-xr-x  2 oracle oinstall  4096 Dec 11 06:10 instantclient/
drwxr-x--- 13 oracle oinstall  4096 Dec 11 06:12 inventory/
drwxr-xr-x  8 oracle oinstall  4096 Dec 11 06:09 javavm/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:10 jdbc/
drwxr-xr-x  7 oracle oinstall  4096 Dec 11 06:10 jdk/
drwxr-xr-x  2 oracle oinstall  4096 Dec 11 06:10 jlib/
drwxr-xr-x 12 oracle oinstall  4096 Dec 11 06:11 ldap/
drwxr-xr-x  3 oracle oinstall 16384 Dec 11 06:11 lib/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:28 log/
drwxr-xr-x  7 oracle oinstall  4096 Dec 11 06:09 md/
drwxr-xr-x  6 oracle oinstall  4096 Dec 11 06:11 mgw/
drwxr-xr-x 10 oracle oinstall  4096 Dec 11 06:11 network/
drwxr-xr-x  5 oracle oinstall  4096 Dec 11 06:09 nls/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:11 oc4j/
drwxr-xr-x  7 oracle oinstall  4096 Dec 11 06:09 odbc/
drwxr-xr-x  5 oracle oinstall  4096 Dec 11 06:09 olap/
drwxr-xr-x 12 oracle oinstall  4096 Dec 11 06:10 OPatch/
drwxr-xr-x  8 oracle oinstall  4096 Dec 11 06:11 opmn/
drwxr-xr-x  4 oracle oinstall  4096 Dec 11 06:09 oracore/
-rw-r-----  1 oracle oinstall    64 Sep 28 09:15 oraInst.loc
drwxr-xr-x  7 oracle oinstall  4096 Dec 11 06:09 ord/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 ordim/
drwxr-xr-x  4 oracle oinstall  4096 Dec 11 06:10 ords/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 oss/
drwxr-xr-x  8 oracle oinstall  4096 Dec 11 06:11 oui/
drwxr-xr-x  4 oracle oinstall  4096 Dec 11 06:09 owm/
drwxr-xr-x  5 oracle oinstall  4096 Dec 11 06:09 perl/
drwxr-xr-x  6 oracle oinstall  4096 Dec 11 06:09 plsql/
drwxr-xr-x  6 oracle oinstall  4096 Dec 11 06:09 precomp/
drwxr-xr-x  2 oracle oinstall  4096 Dec 11 06:10 QOpatch/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 R/
drwxr-xr-x  7 oracle oinstall  4096 Dec 11 06:11 racg/
drwxr-xr-x 14 oracle oinstall  4096 Dec 11 06:11 rdbms/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 relnotes/
-rwx------  1 oracle oinstall   666 Dec 11 06:11 root.sh*
-rw-r--r--  1 oracle oinstall  2826 Mar  9  2016 schagent.conf
drwxr-xr-x  4 oracle oinstall  4096 Dec 11 06:09 scheduler/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 slax/
drwxr-xr-x 22 oracle oinstall  4096 Dec 11 06:10 sqldeveloper/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 sqlj/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 sqlpatch/
drwxr-xr-x  7 oracle oinstall  4096 Dec 11 06:11 sqlplus/
drwxr-xr-x  9 oracle oinstall  4096 Dec 11 06:11 srvm/
drwxr-xr-x  5 oracle oinstall  4096 Dec 11 06:09 suptools/
drwxr-xr-x  4 oracle oinstall  4096 Dec 11 06:09 sysman/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:10 ucp/
drwxr-xr-x  4 oracle oinstall  4096 Dec 11 06:09 usm/
drwxr-xr-x  2 oracle oinstall  4096 Dec 11 06:10 utl/
drwxr-xr-x  3 oracle oinstall  4096 Dec 11 06:09 wwg/
drwxr-x---  7 oracle oinstall  4096 Dec 11 06:09 xdk/

oracle@x230:~$ ll $ORACLE_BASE
total 44
drwxrwxr-x 11 oracle oinstall 4096 Dec 11 06:33 ./
drwxrwxr-x  4 oracle oinstall 4096 Dec 11 06:05 ../
drwxr-x---  3 oracle oinstall 4096 Dec 11 08:18 admin/
drwxr-x---  2 oracle oinstall 4096 Dec 11 06:33 audit/
drwxr-xr-x  4 oracle oinstall 4096 Dec 11 06:30 cfgtoollogs/
drwxr-xr-x  2 oracle oinstall 4096 Dec 11 06:14 checkpoints/
drwxrwxr-x 21 oracle oinstall 4096 Dec 11 06:12 diag/
drwxr-x---  3 oracle oinstall 4096 Dec 11 06:33 fast_recovery_area/
drwxr-x---  3 oracle oinstall 4096 Dec 11 06:33 oradata/
drwxrwxr-x  3 oracle oinstall 4096 Dec 11 05:43 product/
drwxr-xr-x  4 root   root     4096 Dec 11 06:14 tfa/