| How can I connect client with oracle server [message #123965] |
Wed, 15 June 2005 13:54  |
fahedakhter
Messages: 39
Registered: March 2005
Location: Pakistan
|
Member |
|
|
Hai
If any body knows how can I connect clients with oracle database.Actually I perform following work
1) Make a service on client name as "TEST"
2) Make a entry in LISTENER in server.
But when I start listener It cannot start bu give me error "HOST OR TARGET DOES NOT EXISTS".and as well as I make a service on client ang give hostname=SERVER MACHINE NAME and after I test service It give me error TNS COULD NOT RESOLVE SERVICE NAME.Please help me it is urgent.Please give me detail step.
|
|
|
|
|
|
| Re: How can I connect client with oracle server [message #124327 is a reply to message #124068] |
Fri, 17 June 2005 09:33  |
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
|
Senior Member |
|
|
1. Make an entry in sqlnet.ora file
2. Make an entry in listener file
3. make an entry in tnsnames.ora file.
1. SQLNET.ORA file will have something like this.
NAMES.DEFAULT_DOMAIN = MYHOST.COM(host name)
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
2. listener.ora will have something like this
NOTE : - XP-M60 is your host name like your computer name if you are using the laptop or desktop......
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XP-M60)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\Ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\Ora92)
(SID_NAME = orcl)
)
)
3. Finally the tnsnames.ora
INST1_HTTP.MYHOST.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XPM60)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
ORCL.MYHOST.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = XP-M60)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA.MYHOST.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Also below link has a good article on sqlnet, listener and tnsnames.... This will give you understanding....
http://www.databasejournal.com/features/oracle/article.php/3092461
Hope this helps.
Ravi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
