| Configuring LISTENER - ORACLE 9.2.0.6.0 on Solaris 5.8 [message #143474] |
Thu, 20 October 2005 09:40  |
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  |
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 |
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 #143623 is a reply to message #143609] |
Fri, 21 October 2005 05:05 |
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 |
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
--> 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 |
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 |
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 |
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 #143688 is a reply to message #143649] |
Fri, 21 October 2005 08:29 |
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 |
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 :
--> 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 |
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 
Many Thanks and Regards
Pratap
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
