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

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: Uwe Küchler <uwe@xxxxxxxxxxxx>
  • Date: Tue, 2 Nov 2010 15:55:04 -0400

Uwe,

        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@xxxxxxxxxxxx] 
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>   

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2010