Consult, the newly installed Oracle, cannot access problem, installation reference "http://www.jianshu.com/p/36a78274a00e",
See the blogger also encountered the same problem, but I don't know whether have been solved;

Environment: centos7 + oracle 12 c


Command operation shows as follows:

[oracle @ mes ~] $LSNRCTL status

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 04 - JAN - 2017 04:28:41

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

Connecting to (the DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=mes.dfec.com) (1521) PORT=))
The STATUS of the LISTENER
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
The Start Date 04 - JAN - 2017 04:28:28
Uptime 0 days 0 hr. 13 SEC
0 min.The Trace Level off
Security ON: the Local OS Authentication
SNMP OFF
The Listener Parameter File/oracle/app/oracle/product/12.1.2/db_1/network/admin/Listener. Ora
The Listener Log File/oracle/app/oracle/diag/TNSLSNR/mes/Listener/alert Log. XML
Listening Endpoints Summary...
(the DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=mes.dfec.com) (1521) PORT=))
(the DESCRIPTION=(ADDRESS=(PROTOCOL=ipc) (KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully


[oracle @ mes ~] $up sqlplus/as sysdba

SQL * Plus: Release 12.1.0.2.0 Production on Wed Jan 4 04:28:57 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

ERROR:
ORA - 12547: TNS: lost contact

Enter the user name: -
ERROR:
ORA - 12547: TNS: lost contact

Enter the user name: -
ERROR:
ORA - 12547: TNS: lost contact

SP2-0157: unable to CONNECT to the ORACLE after 3 attempts, exiting SQL * Plus
[oracle @ mes ~] $

CodePudding user response:

Look at the folder $ORACLE_HOME/bin/oracle file permissions to see if there is problem

If the wrong permissions
Chmod 6751 $ORACLE_HOME/bin/oracle

CodePudding user response:

reference 1st floor js14982 response:

see folder $ORACLE_HOME/bin/oracle file permissions if there were any problems

If the wrong permissions
Chmod 6751 $ORACLE_HOME/bin/oracle

Thank you, that I have set the permissions;
[oracle @ mes bin] $ll oracle
- RWSR - s - x. 1 oracle oinstall 0 Jul 7 2014 oracle

CodePudding user response:

In order to verify your problem, I have to be done from scratch, feel this document some not so good, haven't begun to pack, lots to see later I will not have this problem,

CodePudding user response:

reference xiaohanshou reply: 3/f

in order to verify your problem, I have to be done from scratch, feel this document some not so good, haven't begun to pack, lots to see later I will not have this problem,

Eldest brother, I said that have happen?

CodePudding user response:

Everybody is good, I see online said, $ORACLE_HOME/bin/oracle size can't is 0, I checked the, the file size is 0.

According to the tutorial, I just do a configuration monitoring, use LSNRCTL start the LISTENER can start listening, Telnet 127.0.0.1 1521 can also be connected,

CodePudding user response:

/oracle/app/oracle/diag/TNSLSNR/mes/listener/trace/listener. Log
Content is as follows: a WARNING...

Fri Feb 03 21:58:33 2017
The System parameter file is/oracle/app/oracle/product/12.1.2/db_1/network/admin/listener. Ora
Log messages written to/oracle/app/oracle/diag TNSLSNR/mes/listener/alert Log. The XML
Trace information written to/oracle/app/oracle/diag TNSLSNR/mes/listener/Trace/ora_2789_140201565447680 TRC
The Trace level is currently 0

Started with the pid=2789
Listening on: (the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=mes) (1521) PORT=))
Listening on: (1) the DESCRIPTION=(ADDRESS=(PROTOCOL=ipc) (KEY=EXTPROC1521)))

TIMESTAMP DATA PROTOCOL: INFO] [* * * CONNECT EVENT SID] [* * RETURN CODE
WARNING: the Subscription for the node down event still pending
03 - FEB - 2017 21:58:35 * (CONNECT_DATA=https://bbs.csdn.net/topics/(CID=(PROGRAM=) (HOST=mes.dfec.com) (USER=oracle) (the COMMAND=status) (the ARGUMENTS=64) (SERVICE=LISTENER) (202375680) VERSION=) * status * 0

CodePudding user response:

refer to 6th floor jieguo4 response:

/oracle/app/oracle/diag/TNSLSNR/mes/listener/trace/listener. Log
Content is as follows: a WARNING...

Fri Feb 03 21:58:33 2017
The System parameter file is/oracle/app/oracle/product/12.1.2/db_1/network/admin/listener. Ora
Log messages written to/oracle/app/oracle/diag TNSLSNR/mes/listener/alert Log. The XML
Trace information written to/oracle/app/oracle/diag TNSLSNR/mes/listener/Trace/ora_2789_140201565447680 TRC
The Trace level is currently 0

Started with the pid=2789
Listening on: (the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=mes) (1521) PORT=))
Listening on: (1) the DESCRIPTION=(ADDRESS=(PROTOCOL=ipc) (KEY=EXTPROC1521)))

TIMESTAMP DATA PROTOCOL: INFO] [* * * CONNECT EVENT SID] [* * RETURN CODE
WARNING: the Subscription for the node down event still pending
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull