Home » RDBMS Server » Networking and Gateways » Listener not starting
Listener not starting [message #293678] Mon, 14 January 2008 09:58 Go to next message
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 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

post output of below command.

cmd>lsnrctl status
or
cmd>lsnrctl start
Re: Listener not starting [message #293688 is a reply to message #293678] Mon, 14 January 2008 10:12 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
post the last 100 or so lines from listener.log file back here
Re: Listener not starting [message #293694 is a reply to message #293688] Mon, 14 January 2008 10:41 Go to previous messageGo to next message
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.


Re: Listener not starting [message #293747 is a reply to message #293694] Mon, 14 January 2008 18:24 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Start your listener as follows:

lsnrctl start dbas
Re: Listener not starting [message #293843 is a reply to message #293747] Tue, 15 January 2008 04:31 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello Ebrian,

I did the same to start the listener . But it did'nt work out.
Re: Listener not starting [message #293852 is a reply to message #293843] Tue, 15 January 2008 04:59 Go to previous messageGo to next message
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
Re: Listener not starting [message #293904 is a reply to message #293852] Tue, 15 January 2008 10:15 Go to previous messageGo to next message
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


Re: Listener not starting [message #293983 is a reply to message #293904] Tue, 15 January 2008 18:39 Go to previous messageGo to next message
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 ?

Re: Listener not starting [message #294431 is a reply to message #293983] Thu, 17 January 2008 10:26 Go to previous messageGo to next message
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.
Re: Listener not starting [message #294468 is a reply to message #294431] Thu, 17 January 2008 13:08 Go to previous messageGo to next message
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.
Re: Listener not starting [message #294897 is a reply to message #294468] Sun, 20 January 2008 10:00 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Listener not starting [message #294936 is a reply to message #294912] Sun, 20 January 2008 23:22 Go to previous messageGo to next message
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
Re: Listener not starting [message #295103 is a reply to message #294936] Mon, 21 January 2008 06:14 Go to previous messageGo to next message
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?
Re: Listener not starting [message #295184 is a reply to message #294912] Mon, 21 January 2008 11:33 Go to previous messageGo to next message
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


Re: Listener not starting [message #295188 is a reply to message #293678] Mon, 21 January 2008 11:44 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Now what does your listener.log file say?
Is your oracle home properly set?
Re: Listener not starting [message #295189 is a reply to message #295184] Mon, 21 January 2008 11:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: Listener not starting [message #295193 is a reply to message #295188] Mon, 21 January 2008 11:59 Go to previous messageGo to next message
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





Re: Listener not starting [message #295194 is a reply to message #293678] Mon, 21 January 2008 12:03 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Now post
lsnrctl status
Re: Listener not starting [message #295195 is a reply to message #295189] Mon, 21 January 2008 12:05 Go to previous messageGo to next message
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 218 times)
Re: Listener not starting [message #295198 is a reply to message #295195] Mon, 21 January 2008 12:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: Listener not starting [message #295202 is a reply to message #295198] Mon, 21 January 2008 12:30 Go to previous messageGo to next message
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

Re: Listener not starting [message #295207 is a reply to message #295202] Mon, 21 January 2008 13:47 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 251 times)
Re: Listener not starting [message #295750 is a reply to message #295539] Wed, 23 January 2008 05:08 Go to previous messageGo to next message
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
Re: Listener not starting [message #295822 is a reply to message #295750] Wed, 23 January 2008 10:48 Go to previous messageGo to next message
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
Re: Listener not starting [message #295826 is a reply to message #293678] Wed, 23 January 2008 11:51 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
In your listener file chnage the string EXTPROC to EXTPROC0
Re: Listener not starting [message #295848 is a reply to message #295822] Wed, 23 January 2008 13:54 Go to previous messageGo to next message
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.
Re: Listener not starting [message #296109 is a reply to message #295848] Thu, 24 January 2008 11:23 Go to previous messageGo to next message
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

Re: Listener not starting [message #296110 is a reply to message #295826] Thu, 24 January 2008 11:25 Go to previous messageGo to next message
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
Re: Listener not starting [message #296121 is a reply to message #296109] Thu, 24 January 2008 13:20 Go to previous messageGo to next message
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.
Re: Listener not starting [message #296169 is a reply to message #293678] Thu, 24 January 2008 23:32 Go to previous messageGo to next message
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]

Re: Listener not starting [message #296397 is a reply to message #296169] Sat, 26 January 2008 10:43 Go to previous messageGo to next message
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
Re: Listener not starting [message #296398 is a reply to message #293678] Sat, 26 January 2008 10:50 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Did you get any installation errors?
Re: Listener not starting [message #296403 is a reply to message #296398] Sat, 26 January 2008 11:42 Go to previous messageGo to next message
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
Re: Listener not starting [message #296407 is a reply to message #293678] Sat, 26 January 2008 11:49 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
replace host IP with your computer name.

Re: Listener not starting [message #296474 is a reply to message #296407] Sun, 27 January 2008 20:54 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
I've even done that trying to replace hostname with the IP of my machine.
Re: Listener not starting [message #296489 is a reply to message #293678] Sun, 27 January 2008 23:26 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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 Go to previous messageGo to previous message
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

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


Current Time: Thu Dec 08 00:03:54 CST 2016

Total time taken to generate the page: 0.13366 seconds