Home » RDBMS Server » Networking and Gateways » configure listener using net manager
configure listener using net manager [message #529194] Sat, 29 October 2011 11:30 Go to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
./fa/9511/0/
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 163 times)
Re: configure listener using net manager [message #529222 is a reply to message #529194] Sat, 29 October 2011 20:52 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
who can reply me ?
Re: configure listener using net manager [message #529223 is a reply to message #529222] Sat, 29 October 2011 21:05 Go to previous messageGo to next message
BlackSwan
Messages: 22793
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
Re: configure listener using net manager [message #529245 is a reply to message #529223] Sun, 30 October 2011 04:54 Go to previous messageGo to next message
lonion
Messages: 97
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!
Re: configure listener using net manager [message #529250 is a reply to message #529245] Sun, 30 October 2011 05:14 Go to previous messageGo to next message
John Watson
Messages: 4570
Registered: January 2010
Location: Global Village
Senior Member
I think global names cause nothing but confusion. I would remove the line completely.
Rgds, John.
Re: configure listener using net manager [message #529252 is a reply to message #529250] Sun, 30 October 2011 06:07 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
it can be removed ??
Re: configure listener using net manager [message #529255 is a reply to message #529252] Sun, 30 October 2011 08:54 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>it can be removed ??
yes, in fact the whole file can be removed.
Re: configure listener using net manager [message #529367 is a reply to message #529255] Mon, 31 October 2011 06:44 Go to previous message
lonion
Messages: 97
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.
Previous Topic: Oracle disconnect
Next Topic: listener.ora is not found on oracle on windows
Goto Forum:
  


Current Time: Sun Sep 21 15:35:39 CDT 2014

Total time taken to generate the page: 0.07515 seconds