OraFAQ Forum: Networking and Gateways » changing of listener port number

Home » RDBMS Server » Networking and Gateways » changing of listener port number (11 g r2 on solaris 10 single instance)

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

changing of listener port number [message #577374]

Thu, 14 February 2013 11:34

janakors
Messages: 232
Registered: September 2009

Senior Member

hi,
i have a listener configured on default port 1521 and i wanted to change it. i did following:-

1. stop the listener through lsnrctl stop
2.change the port number in tnsnames.ora and listener.ora and save both files.
3.now i start the listener as lsnrctl start
4.it started successfully but saying that it cannot register to instance.
5.i connect sqlplus / as sysdba and execute "Alter system register" and "System Altered"

but even then the listener is not registering.

kindly help

Regards

Report message to a moderator

Re: changing of listener port number [message #577375 is a reply to message #577374]

Thu, 14 February 2013 11:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>but even then the listener is not registering.
Listeners NEVER* "register".
Instances register with listener.

Since we really do not know what you did do, we can not say what you did wrong (or not do right).

Is COPY & PASTE broken for you?

Report message to a moderator

Re: changing of listener port number [message #577376 is a reply to message #577375]

Thu, 14 February 2013 11:43

janakors
Messages: 232
Registered: September 2009

Senior Member

yes, my apology. we are not allowed to have internet connection so i can't copy paste. kindly help me how can i register my instance with listener.

Regards

Report message to a moderator

Re: changing of listener port number [message #577377 is a reply to message #577376]

Thu, 14 February 2013 11:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If you go back to using port #1521, does the instance register itself?

Report message to a moderator

Re: changing of listener port number [message #577378 is a reply to message #577377]

Thu, 14 February 2013 11:52

janakors
Messages: 232
Registered: September 2009

Senior Member

yes, it does .

Report message to a moderator

Re: changing of listener port number [message #577379 is a reply to message #577378]

Thu, 14 February 2013 11:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Consider staying with what works.
Nothing is gained by changing listener port number.

Report message to a moderator

Re: changing of listener port number [message #577381 is a reply to message #577376]

Thu, 14 February 2013 11:59

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

Senior Member
Account Moderator

Quote:

we are not allowed to have internet connection ...

How do you access OraFAQ then?

Regards
Michel

Report message to a moderator

Re: changing of listener port number [message #577386 is a reply to message #577381]

Thu, 14 February 2013 12:08

janakors
Messages: 232
Registered: September 2009

Senior Member

i am using it at home, why i am changing the port?because of following

i got this error when select query fire in PL/SQL or through HORA (KEEP TOOLS)

ORA-12569: TNS:packet checksum failure

so i search the net and found that i dont know how? but this error resolved when we change the listener port number

so kinldy help

Regards

Report message to a moderator

Re: changing of listener port number [message #577387 is a reply to message #577376]

Thu, 14 February 2013 12:08

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Quote:

kindly help me how can i register my instance with listener.

Check this parameter
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams118.htm#i1128493
--
John Watson
http://skillbuilders.com

Report message to a moderator

Re: changing of listener port number [message #577388 is a reply to message #577387]

Thu, 14 February 2013 12:22

janakors
Messages: 232
Registered: September 2009

Senior Member

sir here you mean that i change the content of this parameter (LOCAL LISTENER) as well?

Report message to a moderator

Re: changing of listener port number [message #577390 is a reply to message #577388]

Thu, 14 February 2013 12:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

12569, 00000, "TNS:packet checksum failure"
// *Cause: The data received is not the same as the data sent.
// *Action: Attempt the transaction again. If the error is persistent, turn
// on tracing and reexecute the operation.

when was last time SQL*net worked without error?
What changed since then?
Why do you think that changing the port # will fix this problem?
root cause exists at OS/Networking level & external to Oracle.

Report message to a moderator

Re: changing of listener port number [message #577391 is a reply to message #577390]

Thu, 14 February 2013 12:37

janakors
Messages: 232
Registered: September 2009

Senior Member

sir kindly u can tell me how to ON the tracing?
i agree that it external to oracle but i have to do something, let me try tracing
Regards

Report message to a moderator

Re: changing of listener port number [message #577394 is a reply to message #577391]

Thu, 14 February 2013 12:51

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

Senior Member
Account Moderator

This is explain in Net Services book you will find at http://tahiti.oracle.com.

Regards
Michel

Report message to a moderator

Re: changing of listener port number [message #577397 is a reply to message #577394]

Thu, 14 February 2013 13:26

janakors
Messages: 232
Registered: September 2009

Senior Member

ok thanks

Report message to a moderator

Previous Topic:	ORA-12518 Tns: Listener does not currently know of service
Next Topic:	ORA-02097,ORA-00119 and ORA-00119

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:50:45 CDT 2024