 configuring tnsnames [message #140882] |
Thu, 06 October 2005 00:39  |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
This is how my listener is configured
# LISTENER.ORA Network Configuration File: /export/home/oracle8i/OraHome1/networ
k/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kesdeeora)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home/oracle8i/OraHome1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(ORACLE_HOME = /export/home/oracle8i/OraHome1)
(SID_NAME = kesd)
)
)
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
This is what i configured for client side tnsnames.i feel this is right.but at the
'connection test result' it show SERVICE error.i skipped that configured this
KESD.BLR.KESDEE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = kesd)
)
)
when i try to connect to database it shows
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
ALTER i gave this
KESD.BLR.KESDEE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.3)(PORT = 1521))
)
(CONNECT_DATA =
(SID = kesd)
(SERVER = DEDICATED)
)
)
but it works.it connect to database.
i dont know why?
plz ans me........
|
|
|
|
| Re: configuring tnsnames [message #141699 is a reply to message #140882] |
Tue, 11 October 2005 12:24  |
dmauldin
Messages: 3
Registered: April 2005
|
Junior Member |
|
|
I think that oracle 8i uses SID rather than SERVICE_NAME... or that SERVICE_NAME is something that has to be added to a connection manager, not sure though. I always use SID and generally it seems to work.
Denise
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
