OraFAQ Forum: Networking and Gateways » How can I connect client with oracle server

Home » RDBMS Server » Networking and Gateways » How can I connect client with oracle server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: How can I connect client with oracle server [message #124068 is a reply to message #123965]

Thu, 16 June 2005 04:08

No0ZBeeX
Messages: 5
Registered: June 2005

Junior Member

Have you configure tnsnames.ora ?

You can add on your /etc/hosts NAME MACHINE / IP.

Report message to a moderator

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

Report message to a moderator

Previous Topic:	question about listener and service name
Next Topic:	ORA-12541 - TNS: no listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 11:40:21 CDT 2025