RE: "Long" hostnames, Oracle 9+10 and HP-UX

        Our host names are something like 'US-BOS-DB999.na.pxl.int' which obviously exceeds the 8 character limit so they end up as US-BOS-D which doesn't help much. The Ops folks came up with an idea to reverse the name as in 'DB999-BOS-US.NA.PXL.INT'. Ok, so it gets truncated to 'DB999-BO', but it does pass along more information.

Dick Goulet
Senior Oracle DBA

-----Original Message-----
From: Uwe Küchler [mailto:uwe_at_kuechler.org] Sent: Tuesday, November 02, 2010 3:40 PM To: Goulet, Richard
Cc: oracle-l
Subject: Re: "Long" hostnames, Oracle 9+10 and HP-UX

Dick,

which measures did you take? Did you rename the hosts or did you just leave the longer names? Have you experienced any trouble aside from incomplete hostnames in dump/trace files?

Best regards,
Uwe

Am 02.11.2010 19:12, schrieb Goulet, Richard:
> Uwe,
>
> Same problem here. We filed a tar with MOS and got back that it is a bug in the Oracle kernel & should be fixed in 11gR2.
>
>
> Dick Goulet
> Senior Oracle DBA
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Uwe Küchler
> Sent: Tuesday, November 02, 2010 1:20 PM
> To: oracle-l
> Subject: "Long" hostnames, Oracle 9+10 and HP-UX
>
> Dear fellows,
>
> at my current site we got a bunch of new DB servers running under HP-UX.
> The servers are configured to support host names up to 64 characters and
> some of them already exceed the former 8 character limit.
>
> After starting up an Oracle 10gR2 instance, I found in the logs and traces
> that the host name was truncated to 8 characters. The same can be observed
> in v$instance or sys_context('userenv','host').
>
> So far I found only one document describing this on MOS but no further
> pointers to potential problems or bugs.
> https://supporthtml.oracle.com/ep/faces/secure/km/DocumentDisplay.jspx?id=957443.1
>
> Do you have any experiences with this?
> Would you recommend to switch back the hostnames to 8 characters?
>
> Regards,
> Uwe
>
> --
> http://oraculix.wordpress.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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