You are not logged in.

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

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)

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: 158

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: 12

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."

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