RE: windows host name length

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Fri, 3 Apr 2009 14:04:29 -0400
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F266CBAE1_at_US-BOS-MX011.na.pxl.int>

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 [mailto:jkstill_at_gmail.com] 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 <Richard.Goulet_at_parexel.com> 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          

---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 

--
http://www.freelists.org/webpage/oracle-l

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