Arch Linux

SteveDeFacto

Member

Registered: 2013-08-16

Posts: 158

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)

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

stee1rat

Member

Registered: 2013-10-22

Posts: 70

Re: How to start Oracle Database 11g listener?

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

SteveDeFacto

Member

Registered: 2013-08-16

Posts: 158

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

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

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

lsnrctl start

gurnaik

Member

From: Smethwick

Registered: 2011-09-07

Posts: 13

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.

---

---
"You know what they say: no good deed goes unpunished."

stee1rat

Member

Registered: 2013-10-22

Posts: 70

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.