Home » RDBMS Server » Networking and Gateways » Domain name adds to every new entry in tnsname.ora
icon5.gif  Domain name adds to every new entry in tnsname.ora [message #287882] Thu, 13 December 2007 23:43 Go to next message
pankajkmeena
Messages: 46
Registered: September 2007
Member
=======================
Oracle9i==WindowsXP
===========================
whenever i add new entry to my tnsnames.ora my domain name (xyz.co.in) automatically adds to it
however there isno entry in sqlnet.ora. where is problem can u plz help me

# SQLNET.ORA Network Configuration File: f:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

Re: Domain name adds to every new entry in tnsname.ora [message #287886 is a reply to message #287882] Thu, 13 December 2007 23:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the DB_DOMAIN parameter value?
How do you add an entry in tnsnames.ora?

Regards
Michel
Re: Domain name adds to every new entry in tnsname.ora [message #287988 is a reply to message #287886] Fri, 14 December 2007 04:32 Go to previous messageGo to next message
pankajkmeena
Messages: 46
Registered: September 2007
Member
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='PROD1'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='PROD1'

I add entry through NET CONFIG. ASSIST.

[Updated on: Fri, 14 December 2007 04:33]

Report message to a moderator

Re: Domain name adds to every new entry in tnsname.ora [message #287996 is a reply to message #287988] Fri, 14 December 2007 04:50 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
netca adds you machine domain name.

Regards
Michel
Previous Topic: How to connect oracle db by OracleConnection?
Next Topic: TNS Error for seconds occasionally through out day
Goto Forum:
  


Current Time: Fri Apr 19 17:57:44 CDT 2024