RE: windows host name length

From: Goulet, Richard <>
Date: Fri, 3 Apr 2009 14:04:29 -0400
Message-ID: <>

Well, now that I can get to Metalink, it's Doc ID: 753157.1 and yes it does pertain to HP-UX only.  

Dick Goulet  

From: Jared Still [] Sent: Friday, April 03, 2009 1:53 PM
To: Goulet, Richard
Subject: Re: windows host name length

Where exactly?

I just did this on both a 9i and 10g Windows database:

   select host_name from v$instance;

And got back the full 10 character names

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On Fri, Apr 3, 2009 at 6:46 AM, Goulet, Richard <> wrote:

        Not being a Windoze admin I certainly don't know, but there is a bug in Oracle (at least through 10g) that limits the host_name in v$instance to the first 8 characters.          

        Dick Goulet          

[] On Behalf Of Jeffrey Beckstrom

	Sent: Friday, April 03, 2009 7:35 AM
	To: oracle-l-freelists; oracle-db-l
	Subject: windows host name length
	We just received some new servers and the admin group is
proposing a new naming convention for them. The name would be 12 characters in length. Are there any limitations on windows for the length of a server name?                    
	Jeffrey Beckstrom
	Database Administrator
	Greater Cleveland Regional Transit Authority
	1240 W. 6th Street
	Cleveland, Ohio 44113 

Received on Fri Apr 03 2009 - 13:04:29 CDT

Original text of this message