Service_Name

[Nikee]

Dear Friends & Support,

We are using SID_name int he listener.ora and in tnsnames.ora. We have a requirement to use the service_name as well.

Kindly let me know where and what exactly do I have to change in order to support the new requirement?

Additional Details:
-----------------
Listerner.ora file content
--------------------------

LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= DV2.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= DV2)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = pluto)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = DV2)
(ORACLE_HOME = /oracle/DV2/102_64)
)
)


tnsnames.ora file content
--------------------------

DV2.WORLD=
(DESCRIPTION =
(SDU = 32768)
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = pluto)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = DV2)
(GLOBAL_NAME = DV2.WORLD)
)
)


sqlnet.ora content:
------------------

AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = WORLD
NAME.DEFAULT_ZONE = WORLD

SQL> show parameters service_names

NAME TYPE VALUE
------------------------------------ -----------
service_names string DV2


Kindly help me with this request...

Thank you,
Nikee

[vnktummala]

you need to replace SID_NAME with SERVICE_NAME. Also make sure the respective service is registered in database. I believe Oracle 10g listener do that automatically.

Thanks,