| Hostnaming Method ? [message #52368] |
Thu, 18 July 2002 00:14  |
SureshB
Messages: 7
Registered: June 2002
|
Junior Member |
|
|
I woould like to create an environment in our production unit where we can eliminate the need for service name lookup in the tnsnames.ora files.
i.e no need of copying the tnsnames.ora in each and every machine to access the database.Fot this i was selected HOSTNAMING method.
Can anyone help me what are the steps to be followed to achieve this or is there any alternative.
All of my databases are under NT environment.
Thanks in Advance,
Suresh.B
|
|
|
|
| Re: Hostnaming Method ? [message #52401 is a reply to message #52368] |
Fri, 19 July 2002 00:46  |
Kair
Messages: 8
Registered: July 2002
|
Junior Member |
|
|
1: make sure that tcp/ip is installed on both clients
and server.
2: edit each sqlnet.ora on all the cients and add the
following as a single line:
names.directory_path = (TNSNAMES, HOSTNAME)
net8 will using tnsnames and hostname sequentially.
this mean u could using both tnsnames and hostname.
3:find listener.ora on the server side,and make sure
it looks like this:
LISTENER=
(DESCRIPTION =
(ADDRESS =(PROTOCOL=TCP)(HOST=hn-kair)(PORT=1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = hn-kair)
(ORACLE_HOME = d:oracleora81)
(SID_NAME = dbkair)
note:global_dbname is the host name of the server.
hn-kair is the host name of my db server.
4: connect using sqlplus:
command line:
sqlplus sys/yourpwd@hn-kair
|
|
|
|
| Re: Hostnaming Method ? [message #62412 is a reply to message #52401] |
Wed, 21 July 2004 00:18 |
Pratap Zope
Messages: 23
Registered: July 2004
|
Junior Member |
|
|
hi,
i was trying 'host naming method'
and need some help in that regard,
1)(GLOBAL_DBNAME = db05)
here db05 is name of my server i.e. machine name or my service_name for oracle database
2)do i need to configure /etc/hosts on my client or server
3)if user1 is my network account shall i create user1 as database account also, else to which account i will be logged in
4)the cofiguration of 'sqlnet.ora' is required on server side?
5)if etc/hosts needs to be configured, is it like this
ipOfserver servicename machinename
Kindly help me.
Thanks in Advance,
Best Regards,
Pratap
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
