(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listener Log File /home/oracle/app/oracle/diag/tnslsnr/OLE1/listener/alert/log.xml Listener Parameter File /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ole1)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Log messages written to /home/oracle/app/oracle/diag/tnslsnr/OLE1/listener/alert/log.xml System parameter file is /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora TNSLSNR for Linux: Version 11.2.0.1.0 - Production Starting /home/oracle/app/oracle/product/11.2.0/dbhome_1//bin/tnslsnr: please wait. Welcome to LSNRCTL, type "help" for information.Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ole1)(PORT=1521))) With the Partitioning, OLAP, Data Mining and Real Application Testing Desktop]$ lsnrctl All rights reserved.ĭisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production Now see I've also faced the same problem and resolved: Desktop]$ sqlplus / as sysdba And it should be able to ping from the local and remote server. It should be same in listener.ora and tnsnames.ora file Check the IP ADDRESS in /etc/hosts file. It basically has two reasons which are:ġ) Your database and service name is not properly set in Oracle environment it should be same everywhere check below parameter values -ORACLE_SID in oracle environment.Ģ) Host name/IP address is missing, not correct or spelling mistake, so please check the below. This error solution is very simple, first, let's understand why this error occurs. My questions are: Is this the normal behavior on a Linux box? Did I miss something during the Oracle install? If these services are supposed to start automatically, what do I need to do to fix this? I can connect to the Oracle db from any Oracle client. I will see a message something like: The listener supports no servicesĪfter that, everything is running as normal. To fix it, I have to run these two commands: If these services are not running, naturally I can't connect
#Oracle database services windows#
The only thing I don't understand is when I reboot my Linux box, both the Oracle listner and the database service do not start automatically as they do on a Windows Server 2012 R2 system. Now I think I have a pretty good setup up & running. I blew away my VM and started everything from scratch again. In the end and yes, I was able to stand up Oracle on a RHEL 7.2 VM but not without problems - a lot of them. So I spent last weekend devoted to in an attempt to see if I could stand up Oracle 12c on RHEL 7.2. I am just starting to get my feet wet in Red Hat Linux 7.2 and Oracle 12c.