You are not logged in.

#1 2013-10-21 15:38:20

SteveDeFacto
Member
Registered: 2013-08-16
Posts: 151

How to start Oracle Database 11g listener?

When I try to run the listener it gives me this error message:

Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS
 TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
  TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
   Linux Error: 2: No such file or directory

I assume it is a configuration file I need to edit but I have not found any instructions?

Last edited by SteveDeFacto (2013-10-21 15:49:06)

Offline

#2 2013-10-21 17:42:39

Janilson
Member
From: Recife-PE/Brazil
Registered: 2013-03-05
Posts: 55

Re: How to start Oracle Database 11g listener?

I don't know which oracle version you are using but, I use the Express version (Oracle-xe)
In order to configure it I run

sudo /etc/rc.d/oracle-xe configure

After configure oracle, I start oracle service

sudo /etc/rc.d/oracle-xe start

I don't know if it helps sad

Offline

#3 2013-10-22 13:20:02

stee1rat
Member
Registered: 2013-10-22
Posts: 34

Re: How to start Oracle Database 11g listener?

What command do you use to run it? And what are your environment variables?

Offline

#4 2013-10-23 13:24:15

SteveDeFacto
Member
Registered: 2013-08-16
Posts: 151

Re: How to start Oracle Database 11g listener?

Janilson wrote:

I don't know which oracle version you are using but, I use the Express version (Oracle-xe)
In order to configure it I run

sudo /etc/rc.d/oracle-xe configure

After configure oracle, I start oracle service

sudo /etc/rc.d/oracle-xe start

I don't know if it helps sad

I don't see any thing in rc.d. I use systemctl to start daemons.

stee1rat wrote:

What command do you use to run it? And what are your environment variables?

lsnrctl start

Offline

#5 2013-10-24 13:22:37

gurnaik
Member
From: Smethwick
Registered: 2011-09-07
Posts: 11

Re: How to start Oracle Database 11g listener?

The error messages are:

TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist

I'm not sure how you installed Oracle 11g, but the instructions here: https://wiki.archlinux.org/index.php/Or … erlands%29 (use Google translate if you need to), have worked for me. You can try running netca and dbca to see if you can get them to configure the database correctly.

Offline

#6 2013-10-24 14:12:12

stee1rat
Member
Registered: 2013-10-22
Posts: 34

Re: How to start Oracle Database 11g listener?

What are your environment variables?

env | grep ORA
env | grep TNS

The configuration files for SQL*Net stored in $ORACLE_HOME/network/admin by default or in $TNS_ADMIN if it's set.
But it doesn't seem that you have problem with them. It looks like lsnrctl couldn't find its message files in $ORACLE_HOME/network/mesg.
You probably haven't set your ORACLE_HOME variable correctly.

Offline

Board footer

Powered by FluxBB