OraFAQ Forum: Networking and Gateways » configure listener using net manager

Home » RDBMS Server » Networking and Gateways » configure listener using net manager

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

configure listener using net manager [message #529194]

Sat, 29 October 2011 11:30

lonion
Messages: 96
Registered: August 2011
Location: shenzhen,China

Member

hi ,everybody .when i configure a listener using net manager,if found that the red text box in the picture can fill "the value of the global name " or "the value of the service_names".
is that right ?

Attachment: listener.jpg
(Size: 44.94KB, Downloaded 119 times)

Report message to a moderator

Re: configure listener using net manager [message #529222 is a reply to message #529194]

Sat, 29 October 2011 20:52

lonion
Messages: 96
Registered: August 2011
Location: shenzhen,China

Member

who can reply me ?

Report message to a moderator

Re: configure listener using net manager [message #529223 is a reply to message #529222]

Sat, 29 October 2011 21:05

BlackSwan
Messages: 20247
Registered: January 2009

Senior Member

I don't use netca so I don't know what I am looking at.
No listener.ora file is required to exist.

log onto DB Server
issue follow commands

lsnrctl status
lsnrctl service

COPY commands & results then PASTE all back here

rephrase your question & I will try to answer it

Report message to a moderator

Re: configure listener using net manager [message #529245 is a reply to message #529223]

Sun, 30 October 2011 04:54

lonion
Messages: 96
Registered: August 2011
Location: shenzhen,China

Member

hi ,BlackSwan,thank you for your replying.don't look the first post,please look at the following from the listener.ora:

# listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(SID_NAME = HS251)
(PROGRAM = hsodbc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle10g.shenzhen) --here ,can i use The value of the parameter service_names to replace it
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(SID_NAME = oracle10)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LENOVO-BD7D4885)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

--------------------------------------

Thank you in advance!

Report message to a moderator

Re: configure listener using net manager [message #529250 is a reply to message #529245]

Sun, 30 October 2011 05:14

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

Senior Member

I think global names cause nothing but confusion. I would remove the line completely.
Rgds, John.

Report message to a moderator

Re: configure listener using net manager [message #529252 is a reply to message #529250]

Sun, 30 October 2011 06:07

lonion
Messages: 96
Registered: August 2011
Location: shenzhen,China

Member

it can be removed ??

Report message to a moderator

Re: configure listener using net manager [message #529255 is a reply to message #529252]

Sun, 30 October 2011 08:54

BlackSwan
Messages: 20247
Registered: January 2009

Senior Member

>it can be removed ??
yes, in fact the whole file can be removed.

Report message to a moderator

Re: configure listener using net manager [message #529367 is a reply to message #529255]

Mon, 31 October 2011 06:44

lonion
Messages: 96
Registered: August 2011
Location: shenzhen,China

Member

>yes, in fact the whole file can be removed.
i'm try removing the listener.ora file,but the result is the listener don't work .
after i'm removing the file,i run the following command:
C:\>lsnrctl start

at last,fail.

Report message to a moderator

Previous Topic:	Oracle disconnect
Next Topic:	listener.ora is not found on oracle on windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 20 03:45:55 CDT 2013

Total time taken to generate the page: 0.07097 seconds