OraFAQ Forum: Networking and Gateways » question about listener and service name

Home » RDBMS Server » Networking and Gateways » question about listener and service name

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

question about listener and service name [message #123579]

Tue, 14 June 2005 00:47

aiken
Messages: 7
Registered: June 2005
Location: ph

Junior Member

good day 2 all Smile

this is my 1st post here.
i think this site is cool,
because it contain a lot of resources...
and enjoy reading it Smile

im a newbeeeee on oracle so please help me,

ive searched the forum but got no luck finding the correct answer Smile

if ever that my question is already posted, forgive me...
just please send me the link of the thread,
but if not, please reply to my question Smile

my problem is this

when i used lsnrctl status

it says....

"The listener supports no services"

how does it happen?

i google it and found out that
service_name must be added to the initSID.ora
but got no luck Sad

after i edit it, i stop then start the server, but it generating an error Sad

so i decided to remove it again.

can someone outthere please tell me how to register a services???

any reply is appreciated.

thanks in advance Smile

Report message to a moderator

Re: question about listener and service name [message #123586 is a reply to message #123579]

Tue, 14 June 2005 01:26

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

pls post ur listener.ora file here.

This file will be at location $ORACLE_HOME/network/admin

Report message to a moderator

Re: question about listener and service name [message #123595 is a reply to message #123579]

Tue, 14 June 2005 01:59

aiken
Messages: 7
Registered: June 2005
Location: ph

Junior Member

heres my listener.ora

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = aiken)(PORT = 1521))
)

i check that already and tnsnames.ora many many times Smile

but still got no luck Sad

Report message to a moderator

Re: question about listener and service name [message #123597 is a reply to message #123595]

Tue, 14 June 2005 02:07

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

In case u use static service registeration then the service's entry has to be done in listener.ora file.

A sample listener.ora file with registered services entries looks like this:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = XXXX)(PORT = 1521))
      )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = F:\oracle\ora92)
      (SID_NAME = orcl)
    )
   
  )

Report message to a moderator

Re: question about listener and service name [message #123628 is a reply to message #123579]

Tue, 14 June 2005 03:33

aiken
Messages: 7
Registered: June 2005
Location: ph

Junior Member

ok thanks "girish.rohini"

i'll try that...

"salamat....." (filipino word 4 thanks)

Smile

Report message to a moderator

Re: question about listener and service name [message #124234 is a reply to message #123579]

Fri, 17 June 2005 00:59

aiken
Messages: 7
Registered: June 2005
Location: ph

Junior Member

another question sir Smile

i created a another datasbase.

what will it look like for my listener if i want my listener to support 2 services?

thanks Wink

Report message to a moderator

Re: question about listener and service name [message #124239 is a reply to message #124234]

Fri, 17 June 2005 01:41

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

U need to add one more service in ur listener.ora file.

U will be required to add these few lines for ur new database under the sid_list_listener tab:

(SID_DESC =
(GLOBAL_DBNAME = <name of db>)
(ORACLE_HOME = F:\oracle\ora92)
(SID_NAME = <service name>)

Regds
Girish

Report message to a moderator

Re: question about listener and service name [message #124306 is a reply to message #123579]

Fri, 17 June 2005 07:31

aiken
Messages: 7
Registered: June 2005
Location: ph

Junior Member

many thanks Smile

Report message to a moderator

Previous Topic:	using external file in tnsnames.ora
Next Topic:	How can I connect client with oracle server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 05:46:41 CDT 2024