OraFAQ Forum: Networking and Gateways » Listener not starting

Home » RDBMS Server » Networking and Gateways » Listener not starting

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Listener not starting [message #293678]

Mon, 14 January 2008 09:58

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello All,

I'm working on Linux AS4 , my database is fine . But when I start my listener.ora file , nothing happens . It stays as it is . Below is my listener.ora file

dbas =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
)
)
)
SID_LIST_dbas =
(SID_LIST=
(SID_DESC=
(SID_NAME=prod)
(ORACLE_HOME=/oraeng/app/oracle/product/10.2.0))
)

Dont know what and where is the problem lying .
How to configure the hostname in oracle . The above mentioned is my IP address.

Please let me know.

Regards,
Raj

[Updated on: Mon, 14 January 2008 10:00]

Report message to a moderator

Re: Listener not starting [message #293683 is a reply to message #293678]

Mon, 14 January 2008 10:06

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

post output of below command.

cmd>lsnrctl status
or
cmd>lsnrctl start

Report message to a moderator

Re: Listener not starting [message #293688 is a reply to message #293678]

Mon, 14 January 2008 10:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post the last 100 or so lines from listener.log file back here

Report message to a moderator

Re: Listener not starting [message #293694 is a reply to message #293688]

Mon, 14 January 2008 10:41

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

hello,

these are the lines of my listener.log

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 14-JAN-2008 21:30:06

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

System parameter file is /oraeng/app/oracle/product/10.2.0/listener.ora
Log messages written to /oraeng/app/oracle/product/10.2.0/network/log/dbas.log
Trace information written to /oraeng/app/oracle/product/10.2.0/network/trace/dbas.trc
Trace level is currently 0

Started with pid=4215
TNS-01151: Missing listener name, dbas, in LISTENER.ORA

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 14-JAN-2008 21:32:19

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

System parameter file is /oraeng/app/oracle/product/10.2.0/listener.ora
Log messages written to /oraeng/app/oracle/product/10.2.0/network/log/dbas.log
Trace information written to /oraeng/app/oracle/product/10.2.0/network/trace/dbas.trc
Trace level is currently 0

. Thats all in the file.

Report message to a moderator

Re: Listener not starting [message #293747 is a reply to message #293694]

Mon, 14 January 2008 18:24

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Start your listener as follows:

lsnrctl start dbas

Report message to a moderator

Re: Listener not starting [message #293843 is a reply to message #293747]

Tue, 15 January 2008 04:31

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello Ebrian,

I did the same to start the listener . But it did'nt work out.

Report message to a moderator

Re: Listener not starting [message #293852 is a reply to message #293843]

Tue, 15 January 2008 04:59

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You should make a backup of your listener.ora file and recreate a new with with the netca tool. It appears there is a issue with your listener.ora file. The netca tool will ensure the spacing and syntax is correct.

If this doesn't seem to work, what is the output of the following:

ifconfig -a

and

netstat -na | grep 1521

Report message to a moderator

Re: Listener not starting [message #293904 is a reply to message #293852]

Tue, 15 January 2008 10:15

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello Ebrian,

I tried creating new listeners with netca, but I'm able to create but unable to start the created listeners .

When I gave ifconfig -a , I got this message:

[oracle10g@localhost bin]$ ifconfig -a
bash: ifconfig: command not found

When I gave netstat -na | grep 1521, I got this message.

[oracle10g@localhost bin]$ netstat -na | grep 1521
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LIST EN
tcp 203 0 127.0.0.1:1521 127.0.0.1:32836 CLOS E_WAIT
tcp 203 0 127.0.0.1:1521 127.0.0.1:32871 CLOS E_WAIT
tcp 203 0 127.0.0.1:1521 127.0.0.1:32896 CLOS E_WAIT
tcp 203 0 127.0.0.1:1521 127.0.0.1:32883 CLOS E_WAIT
tcp 198 0 192.168.1.2:1521 192.168.1.2:32850 CLOS E_WAIT

Please help me out.

Regards,
Raj

Report message to a moderator

Re: Listener not starting [message #293983 is a reply to message #293904]

Tue, 15 January 2008 18:39

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What is the output of ps -ef | grep tns ?

For the ifconfig command, you'll have to issue it as /sbin/ifconfig -a

If you are saying that you can't start the listener, then by the looks of it, something else is using port 1521. In addition, why does your listener file show 192.168.1.12 and the netstat output show 192.168.1.2 ?

Report message to a moderator

Re: Listener not starting [message #294431 is a reply to message #293983]

Thu, 17 January 2008 10:26

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hi,

What is the output of ps -ef | grep tns ?

[oracle10g@localhost ~]$ ps -ef | grep tns
1002 5496 4078 0 21:54 pts/4 00:00:00 grep tns

For the ifconfig:

[oracle10g@localhost ~]$ /sbin/ifconfig -a
eth0 Link encap:Ethernet HWaddr 00:16:EC:E8:11:77
inet addr:192.168.1.2 Bcast:192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::216:ecff:fee8:1177/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:2420 errors:0 dropped:0 overruns:0 frame:0
TX packets:2586 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1265625 (1.2 MiB) TX bytes:595543 (581.5 KiB)
Interrupt:169 Base address:0xe800

lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:1470 errors:0 dropped:0 overruns:0 frame:0
TX packets:1470 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:1764734 (1.6 MiB) TX bytes:1764734 (1.6 MiB)

sit0 Link encap:IPv6-in-IPv4
NOARP MTU:1480 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

And sorry my ipaddress is 192.168.1.2 .

Please help me out.

Report message to a moderator

Re: Listener not starting [message #294468 is a reply to message #294431]

Thu, 17 January 2008 13:08

ebrian
Messages: 2794
Registered: April 2006

Senior Member

ebrian wrote on Tue, 15 January 2008 19:39

If you are saying that you can't start the listener, then by the looks of it, something else is using port 1521. In addition, why does your listener file show 192.168.1.12 and the netstat output show 192.168.1.2 ?

As I mentioned previously, it looks like you have two problems. Find out what else is using port 1521 and change your listener.ora file to use the correct IP address.

Report message to a moderator

Re: Listener not starting [message #294897 is a reply to message #294468]

Sun, 20 January 2008 10:00

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello,

No one else is using that port number and infact I even tried changing the port numbers also. I'm doing all this at my home and I'm the only one doing. And the IP address was mentioned by mistake , Sorry.

My dount is , if we are doing Networking at home, do we need to configure any kind of other parameters anywhere else?

Please help me out.

Regards,
Raj

[Updated on: Sun, 20 January 2008 10:01]

Report message to a moderator

Re: Listener not starting [message #294912 is a reply to message #294897]

Sun, 20 January 2008 19:12

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Are you only reading a portion of what I post?? For the third time, check the IP address you are using in your listener.ora file.

Report message to a moderator

Re: Listener not starting [message #294936 is a reply to message #294912]

Sun, 20 January 2008 23:22

jkirankumar_307@yahoo.com
Messages: 12
Registered: April 2007

Junior Member

Hi Ebrian,

1. Can U check the entries in /etc/hosts file. In that check the ip address and alias name and check in listener.ora file. If any difference is there do changes accordingly.

2. Check the file permissions of /etc/hosts file.

3. Can U able to restart the database. Let me know

Regards,
Kiran

Report message to a moderator

Re: Listener not starting [message #295103 is a reply to message #294936]

Mon, 21 January 2008 06:14

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Not really sure why this is addressed to me ??

Nevertheless, the /etc/hosts file has nothing to do with the OP's situation. It's primarily due to a lack of reading.

BTW, where did the OP mention he wasn't able to start the database?

Report message to a moderator

Re: Listener not starting [message #295184 is a reply to message #294912]

Mon, 21 January 2008 11:33

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello Ebrain,

I did followed all the changes suggested by you, but still no avail. I gave the correct IP address
Here is the file contents ..

SID_LIST_prod =
(SID_LIST =
(SID_DESC =
(SID_NAME = prod)
(ORACLE_HOME = /oraeng/app/oracle/product/10.2.0)
(PROGRAM = extproc)
)
)

prod =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 2820))
)
)
)

After this when I start the listener , it just hangs as it is in this way

[oracle10g@hostname admin]$ lsnrctl start prod

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 21-JAN-2008 22:53:27

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

I even tried with my hostname also , but still NO.

I do the same thing in my office , there it works . Do we need to set anything if doing at home.

please help me out.!

Regards,
Raj

Report message to a moderator

Re: Listener not starting [message #295188 is a reply to message #293678]

Mon, 21 January 2008 11:44

varu123
Messages: 754
Registered: October 2007

Senior Member

Now what does your listener.log file say?
Is your oracle home properly set?

Report message to a moderator

Re: Listener not starting [message #295189 is a reply to message #295184]

Mon, 21 January 2008 11:45

Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you posted your file with code tags and indented maybe it would be easier to see if something is wrong.

Regards
Michel

Report message to a moderator

Re: Listener not starting [message #295193 is a reply to message #295188]

Mon, 21 January 2008 11:59

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello ,

My ORACLE_HOME is properly set.This is the location

[oracle10g@hostname ~]$ echo $ORACLE_HOME
/oraeng/app/oracle/product/10.2.0.

And these are the messages in the listener.log file

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 21-JAN-2008 22:42:17

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

System parameter file is /oraeng/app/oracle/product/10.2.0/listener.ora
Log messages written to /oraeng/app/oracle/product/10.2.0/network/log/listener.log
Trace information written to /oraeng/app/oracle/product/10.2.0/network/trace/listener.trc
Trace level is currently 0

Started with pid=3847
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.2)(PORT=2802)))

Any help on this please

Report message to a moderator

Re: Listener not starting [message #295194 is a reply to message #293678]

Mon, 21 January 2008 12:03

varu123
Messages: 754
Registered: October 2007

Senior Member

Now post

lsnrctl status

Report message to a moderator

Re: Listener not starting [message #295195 is a reply to message #295189]

Mon, 21 January 2008 12:05

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello Michel,

This is my listener.ora file, I'm attaching.

Please have a look and let me know where is the mistake.

I've been stuck up at this for the past 10 days. Infact I do in the same way in my office , it starts with no issues.

Do we need to set something else if doing at home.

Please help me out.

Regards,
Raj

Attachment: listener.ora
(Size: 0.46KB, Downloaded 1319 times)

Report message to a moderator

Re: Listener not starting [message #295198 is a reply to message #295195]

Mon, 21 January 2008 12:15

Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

try:

SID_LIST_prod =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = prod)
          (ORACLE_HOME = /oraeng/app/oracle/product/10.2.0)
          (PROGRAM = extproc)
        )
      )

prod =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
          )
        )
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 2820))
          )
        )
      )

Also try to find on Metalink if there is any bug in your version.

Regards
Michel

Report message to a moderator

Re: Listener not starting [message #295202 is a reply to message #295198]

Mon, 21 January 2008 12:30

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello Michel,

I did tried to start the listener as suggested by you, but when I start it just hangs like that only.,

[oracle10g@hostname ~]$ lsnrctl start prod

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 21-JAN-2008 23:58:45

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

I dont have metalink ID, as I told you I'm doing this at my home.

Please help me out.

Regards,
Raj

Report message to a moderator

Re: Listener not starting [message #295207 is a reply to message #295202]

Mon, 21 January 2008 13:47

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Do you have iptables running?

If not, then maybe you should also try:

strace lsnrctl start prod

and see where it may be hanging.

[Updated on: Mon, 21 January 2008 13:57]

Report message to a moderator

Re: Listener not starting [message #295539 is a reply to message #295207]

Tue, 22 January 2008 11:43

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello Ebrian,

I did the following as suggested by you.And the output of that, I'm attaching as a file.

Please look into that and help me out.

Regards,
Raj

Attachment: trace
(Size: 20.02KB, Downloaded 1563 times)

Report message to a moderator

Re: Listener not starting [message #295750 is a reply to message #295539]

Wed, 23 January 2008 05:08

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Does the listener eventually start?

What is the output of these two commands:

$ id
$ ls -l /var/tmp/.oracle

Report message to a moderator

Re: Listener not starting [message #295822 is a reply to message #295750]

Wed, 23 January 2008 10:48

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello Ebrian,

The Listener is not even starting . And the output of the two commands are

[oracle10g@hostname ~]$ id
uid=1002(oracle10g) gid=1000(oinstall)groups=1000(oinstall),2000(dba) context=user_u:system_r:unconfined_t

[oracle10g@hostname ~]$ ls -l /var/tmp/.oracle
total 120
srwxrwxrwx 1 oracle10g oinstall 0 Jan 22 22:08 s#3730.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 22 22:08 s#3730.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 22 22:12 s#3769.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 22 22:12 s#3769.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 21 22:42 s#3847.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 21 22:42 s#3847.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 15 1999 s#3880.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 15 1999 s#3880.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 20 23:07 s#3976.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 20 23:07 s#3976.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 21 23:06 s#3983.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 21 23:06 s#3983.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 15 1999 s#4121.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 15 1999 s#4121.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 21 23:10 s#4130.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 21 23:10 s#4130.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 14 21:14 s#4139.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 14 21:14 s#4139.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 15 1999 s#4206.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 15 1999 s#4206.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 13 22:11 s#4331.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 13 22:11 s#4331.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 13 22:16 s#4368.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 13 22:16 s#4368.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 20 23:28 s#4465.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 20 23:28 s#4465.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 20 23:29 s#4472.1
srwxrwxrwx 1 oracle10g oinstall 0 Jan 20 23:29 s#4472.2
srwxrwxrwx 1 oracle10g oinstall 0 Jan 22 22:12 sEXTPROC
srwxrwxrwx 1 oracle10g oinstall 0 Jan 21 23:06 sEXTPROC0

These are the findings of the commands.

Regards,
Raj

Report message to a moderator

Re: Listener not starting [message #295826 is a reply to message #293678]

Wed, 23 January 2008 11:51

varu123
Messages: 754
Registered: October 2007

Senior Member

In your listener file chnage the string EXTPROC to EXTPROC0

Report message to a moderator

Re: Listener not starting [message #295848 is a reply to message #295822]

Wed, 23 January 2008 13:54

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Stop any Oracle processes that are running and then as root issue the following:

rm -rf /var/tmp/.oracle

Then log back in as oracle10g and try to restart the listener.

Report message to a moderator

Re: Listener not starting [message #296109 is a reply to message #295848]

Thu, 24 January 2008 11:23

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hi Ebrian,

STill no go .I did the same as you asked me to. But when I start the listener , it's just hangs up. Nothing moves on

[oracle10g@hostname ~]$ lsnrctl start prod

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 24-JAN-2008 22:46:50

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

.

I have a small doubt, Is there anyway that either my database or my Oracle or my Linux AS4 OS, getting corrupted. If yes, how to detect it and how to debug it.

Please let me know.

Regards,
Raj

Report message to a moderator

Re: Listener not starting [message #296110 is a reply to message #295826]

Thu, 24 January 2008 11:25

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello Varu,

I did the changed the string as suggested by you. But still when I start my listener , it just hangs up. I mean nothing moves on.

[oracle10g@hostname ~]$ lsnrctl start prod

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 24-JAN-2008 22:46:50

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

Regards,
Raj

Report message to a moderator

Re: Listener not starting [message #296121 is a reply to message #296109]

Thu, 24 January 2008 13:20

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You may want to enable tracing and see if that provides any additional information.

I see your version shows 10.2.0.1, but have you patched anything recently? I wouldn't think it would be needed, but have you tried to relink oracle? You'd run relink utilities from the ORACLE_HOME.

Report message to a moderator

Re: Listener not starting [message #296169 is a reply to message #293678]

Thu, 24 January 2008 23:32

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

14 Jan to 24 Jan very long & interesting thread. Reddy, you have a messed up installation, trace file you have uploaded indicates this, If it is a production installation [else continue with R & D] than why don't you backup your database files & reinstall every thing fresh & restore your database , it will hardly take few hours.

Regards

Manjit Kumar [mkbhati]

Report message to a moderator

Re: Listener not starting [message #296397 is a reply to message #296169]

Sat, 26 January 2008 10:43

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

Hello Manoj,

If I wanted to resintall I'd have done that long back itself. I just want to know where am I going wrong when everything else is right.

I thank all the orafaq moderators for trying to help me out , but being still positive I'm expecting help from them so that I can keep my show running.

Regards,
Raj

Report message to a moderator

Re: Listener not starting [message #296398 is a reply to message #293678]

Sat, 26 January 2008 10:50

varu123
Messages: 754
Registered: October 2007

Senior Member

Did you get any installation errors?

Report message to a moderator

Re: Listener not starting [message #296403 is a reply to message #296398]

Sat, 26 January 2008 11:42

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

No,

everything was fine with the installation of both Oracle and Linux.
I tried even relinking oracle also. But even that did'nt help out.

Is there anyway where we can find if any bugs in the oracle Software or in the Linux.If yes , let me know.

Regards,
Raj

Report message to a moderator

Re: Listener not starting [message #296407 is a reply to message #293678]

Sat, 26 January 2008 11:49

varu123
Messages: 754
Registered: October 2007

Senior Member

replace host IP with your computer name.

Report message to a moderator

Re: Listener not starting [message #296474 is a reply to message #296407]

Sun, 27 January 2008 20:54

rsreddy28
Messages: 295
Registered: May 2007

Senior Member

I've even done that trying to replace hostname with the IP of my machine.

Report message to a moderator

Re: Listener not starting [message #296489 is a reply to message #293678]

Sun, 27 January 2008 23:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I've said this before more than once.
With V10 no listener.ora file is required.
What happens if you rename the listener.ora file out of the way & then do -

lsnrctl start
date
# wait 3 - 5 minute & then do
date
lsnrctl status
date

use cut & paste to post results from above code block

[Updated on: Sun, 27 January 2008 23:27] by Moderator

Report message to a moderator

Re: Listener not starting [message #296499 is a reply to message #296489]

Mon, 28 January 2008 00:19

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Ana,
You always confuse about LISTENER.ORA file.

There is two thing.
1. we can connect to database without LISTENER.ORA file When we DON'T use "TNS_ENTRY" with username & password.

C:\>lsnrctl stop

LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 28-JAN-2008 10:0
:11

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxxxx.loc
l)(PORT=1521)))
The command completed successfully

C:\>set ORACLE_SID=db1

C:\>sqlplus system/oracle

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jan 28 10:05:26 2008

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

2. LISTENER.ORA file always require with "TNS_ENTRY"
but If listener services is started and we remove "LISTENER.ORA" file manully then we can connect to database without LISTENER.ORA file

C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 28-JAN-2008 10:07
:54

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxxxx.loca
l)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.1.0.5.0 - Produ
ction
Start Date                28-JAN-2008 10:07:49
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\oracle\product\10.1.0\Db_1\network\admin\listener.o
ra
Listener Log File         D:\oracle\product\10.1.0\Db_1\network\log\listener.log

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxx.xxxxx.local)(PORT=1521
)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\>del D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\LISTENER.ORA

C:\>sqlplus system/oracle@db1

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jan 28 10:08:36 2008

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

But after restart listener services we are not able to connect too database without LISTENER.ORA file.

D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN>rename listener.ora listener_1.ora

D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN>cd\

D:\>lsnrctl stop

LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 28-JAN-2008 10:14
:08

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
The command completed successfully

D:\>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.1.0.5.0 - Production on 28-JAN-2008 10:14
:14

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.1.0.5.0 - Production
Log messages written to D:\oracle\product\10.1.0\Db_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxxxx.loca
l)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.1.0.5.0 - Produ
ction
Start Date                28-JAN-2008 10:14:15
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         D:\oracle\product\10.1.0\Db_1\network\log\listener.log

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxxx.local)(PORT=1521
)))
The listener supports no services
The command completed successfully

D:\>sqlplus system/oracle@db1

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jan 28 10:14:24 2008

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

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Correct me if i am wrong.

Regards
Taj

[Updated on: Mon, 28 January 2008 00:20]

Report message to a moderator

Pages (2): [1 2 › »]

Previous Topic:	TNS-12541:No Listener
Next Topic:	oracle in vmware JDBC problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 01:11:51 CDT 2024