Home » RDBMS Server » Enterprise Manager » Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8
Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143474] Thu, 20 October 2005 09:40 Go to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
i am having Oracle 9.2.0.6.0 database running on Solaris 5.8
I created one more database on the server.
after creating database i restarted the server and started (opened) both the databases.

however when i am trying to create connection string (using net8 assistant) i am getting an error "unable to resolve service name"

i gave command
LSNRCTL> show current_listener
LISTENER

however when i opened listener.ora i could not found entry of the listener "LISTNER" in it.
Then i opened Oracle Net Manager Local>Listeners, here also i could not saw the entry of listener "LISTENER".
what could be the reason that i am unable to see the "LISTENER" either in listener.ora as well as "ORACLE NET MANAGER" and that is in fact running?

What i was intending to do was to add database service name of my newly created database to the listener "LISTENER"
Is that correct action to connect from other machines using tnsnames.ora(i.e. configuring tnsnames.ora once i add the service to LISTENER)

will that be a correct action?

please suggest.

Thanks in Advance
Pratap

Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143577 is a reply to message #143474] Fri, 21 October 2005 00:10 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Connection :
For connecting to a server , you need a listener running on the server and a net_service configured on each client in respect to the listener on the server.


By any chance, did you set TNS_ADMIN environment variable ? Can you crosscheck the variable. Try this at your prompt while you logged in as Oracle user,

 # echo $TNS_ADMIN

      or

 # env  -- this command will list all the environment variables.
  



[Edit : oops! i didnt notice you write both the databases. Did you configure listener to listen for both the databases ? ]
regards,
tarun


[Updated on: Fri, 21 October 2005 00:12]

Report message to a moderator

Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143591 is a reply to message #143577] Fri, 21 October 2005 02:12 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
thanks for the quick reply.
i have checked the TNS_ADMIN variable.
no value is set for it.

what i is that
db01 service is configured for the listener "LISTENER"
which people can access using tnsnames.ora from their m/c
i want to confifure db02 service to the listener "LISTENER"

however i am unable to see the listener named "LISTENER" IN Oracle Net Manager screen a well as listener.ora file

and 'LSNRCTL> current_listener' output is "LISTENER" ONLY

please suggest.

Thanks and Regards,
Pratap Zope
Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143609 is a reply to message #143591] Fri, 21 October 2005 04:06 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Now i think you should post the SID of both the databases and

your listener.ora , tnsnames.ora file.

and one more question (just to confirm),

how did you create a new database ? ( can u explain in brief)

regards,
tarun

Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143623 is a reply to message #143609] Fri, 21 October 2005 05:05 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
i created database using DBCA
attached herewith is a zip containg
listener.ora
listener_backup.ora
tnasnames.ora
1)
listener_backup.ora
this is original file with entries till the time i completed database creation.
2)
listener.ora
this is the file at present.
since i was unable to connect from other machine(using oracle client and tnsnames), i opened oracle net manager and surprisingly found that there are 3 listeners each with 2 database services, with each listener having the newly database added to database service.
however none of the 3 listener was having name "LISTENER" which is in fact i found as current_listener
so i removed the database service of my new database from each of the 3 listeners and created one more listener "LISTENER1" to listen at port 1522.
however since again i will need to modifi Dispatcher, local_listener setting , i stopped there.
so the above "listener.ora" file is after all these happenings.
3)tnsnames.ora
this is file on client machine i configured for connecting the oracle server.
in fact the test while creating local service name (connection string) even failed.

i am not sending tnsnames.ora on server.
shall i send that too?

please suggest

once again thanks for your time

Regards,
Pratap


Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143628 is a reply to message #143623] Fri, 21 October 2005 05:26 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


hi pratap,

Lets take LISTENER1 and start to do everything .

LISTENER1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = motsunsrv)(PORT = 1522))
  )

SID_LIST_LISTENER1 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = mclaims1)
      (ORACLE_HOME = /u01/oracle/product/9206)
      (SID_NAME = mclaims1)
    )
  )




Now the above listener is pointing on

port --1522
DB -- mclaims
HOST -- motsunsrv


Now excerpt from your tnsnames.ora file


 MCLAIMS1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.222.84)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = MCLAIMS1)
    )
  )

MCLAIMS_P =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.222.223)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = mclaims)
    )
  )

MCLAIMS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.222.223)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mclaims)
    )
  )

MCLAIMSM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.222.12)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mclaims)
    )
  )

pratap =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.222.12)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mclaims1)
    )
  )


Leaving the rest of the net_services, and other information like IP , i cant see any service name pointing on PORT -- 1522 , on which listener the above is configured .

And can i ask you why there are so many net services ? Is this machine acts as a client for several databases?

Now try this ,


--> Configure at least one service on 1522 port and try to connect from the client .

--> then post the proper error number that you got while connecting .

--> Try to ping the server from the client machine
 #ping server_ip_address 


--> Try to TNSPING the name of the service from the client .

 # tnsping net_service_name 


And then come up with the specific error that you are getting while connection.

Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143641 is a reply to message #143628] Fri, 21 October 2005 05:59 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
the tnsnames.ora on my machine
is showing connection string "pratap", which i configured before creating the listener "LISTENER1"

sine i did not start LISTENER1(only created) at all on the server, i did not configure my tnsnames.ora for "LISTENER1"

the reason i did not start LISTENER1 is that i am not sure about the exact sequence of operations for configuring the listener.

will i need to configure local_listener parameter?is that dynamic?
will i need to configure "DISPATCHERS"? can i do that dynamically?
is anything more i will need to configure before starting LISTENER1?

because without doing above thing when i tried to start LISTENER1
i got the error

please suggest

Thanks and Regards,
Pratap
Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143649 is a reply to message #143641] Fri, 21 October 2005 06:14 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
pratapsz wrote on Fri, 21 October 2005 16:29


when i tried to start LISTENER1
i got the error



What error, pratap ?? No one can guess what is happening on your machine when you try to start the listener.

Are you using shared server environment, if not then no issue for DISPATCHERS ?

You dont need to configure anything, i suppose .

Just try to do this and you might get that you want ,

--> Start the listener on the server?
( if get error then please post the copy of that specific error with error number)

--> configure a service on the client which connects to that listener and
--> then give a try to connect from the client?

or else for configuration , look here

http://otn.oracle.com/pls/db92/db92.show_toc?partno=a96580&remark=drilldown&word=local+listener

regards,
tarun

Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143674 is a reply to message #143649] Fri, 21 October 2005 07:22 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
did not send the exact error occured while starting the LISTENER1 was that , yesterday was getting different error and today it is different error
todays error has been logged in listener1.log (attached herewith)

and since i was unable to start the LISTENER1 did not tried to configure connection string with port 1522 at client side (i.e. tnsnames.ora)

Thanks and Regards,
Pratap

Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143676 is a reply to message #143649] Fri, 21 October 2005 07:28 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
hi,
sorry i did not informed you the new database instance name i created
it is MCLAIMS1

and i am able to connect one more database instance MCLAIMS on the same database server from my machine.

Thanks and regards,
Pratap
Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143682 is a reply to message #143649] Fri, 21 October 2005 08:03 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
its Amazing Smile Smile Smile
what you suggested was
"
Just try to do this and you might get that you want ,

--> Start the listener on the server?
( if get error then please post the copy of that specific error with error number)

--> configure a service on the client which connects to that listener and
"
Now since my tries to start the listener failed i did not tried to configure my tnsnames again,
but after your reply , i again gave a try to configure tnsnames
by creating local service name i.e. connection string

and to my surprize it worked Smile

Many thanks for your friendly support.

however i am still thinking how i got conected with the listener "LISTENER" only (yes still LSNRCTL is showing current_listener as "LISTENER" only)

and while creating local service i gave port 1522 which in fact i configured for LISTENER1.

PLEASE SUGGEST
MANY THANKS
Pratap





Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143688 is a reply to message #143649] Fri, 21 October 2005 08:29 Go to previous messageGo to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
one problem is there

telnet 10.31.222.12
$sqlplus
username :pratap/pratap@mclaims1
ERROR
ORA-12541 : TNS: no listener

however
i am able to connect through TOAD
AS WELL AS
through windows as
run>cmd
c:>\sqlplus
username : pratap/pratap@mclaims1
connected

Do i need to configure the port 1522 somewhere in TELNET?

Thanks and Regards,
Pratap
Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143766 is a reply to message #143688] Sat, 22 October 2005 03:07 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Quote:

however i am still thinking how i got conected with the listener "LISTENER" only (yes still LSNRCTL is showing current_listener as "LISTENER" only)


Its might be showing because we have not made LISTENER1 as the default listener for the database. ( i m not quite sure about that) But if you want to see the proper listener then use this command :

 lsnrctl> status 



--> telnet 10.31.222.12

Is this the IP of your server where database is located. If yes then how wil you connect using the command
$sqlplus
username :pratap/pratap@mclaims1

because this net_service "mclaims1" exist on the client and not on the server .






Re: Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #144379 is a reply to message #143766] Wed, 26 October 2005 05:32 Go to previous message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member
Hi,
sorry could not reply immediately,

1)
after issuing command "status"
LSNRCTL>status
it si showing only one service
"service mclaims" has one instance(s)"

it does not display "mclaims1"

2)
i am able to connect another database "mclaims" as well as "mclaims1" using telnet as follows

commands from windows client
telnet 10.31.222.12
$ export ORACLE_SID=mclaims1
$ sqlplus
username: sys/paswd as sysdba
sql>

what i was missing that day was,
i was issuing
$ set ORACLE_SID= mclaims1
but not
$ export ORACLE_SID=mclaims1

here was the mistake Smile

Many Thanks and Regards
Pratap

Previous Topic: Enterprise manager & Oracle OLAP error
Next Topic: unable to login to the database
Goto Forum:
  


Current Time: Wed May 18 14:50:25 CDT 2022