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

  • From: Uwe Küchler <uwe@xxxxxxxxxxxx>
  • To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • Date: Wed, 3 Nov 2010 17:04:06 +0100 (CET)

Hi Dick,

that idea is not too bad.
Finally, my Ops folks decided to rename the servers using a simple naming
scheme that constrains names to 8 characters. The nuisance is that with
prefix and suffix (when clustered) only 3 to 5 characters remain to
distinguish the server.

BTW: Do you (or anyone here) know if this issue is solved in 11gR2? MOS
documents only say that the issue pertains to all releases up to 11.1, but
no document says if this got fixed in 11.2...

And, last but not least, here's a small test case to show that this
problem isn't strictly academic. I used utl_inaddr to resolve the server's
IP address:

$ uname -n
xx-myserver

SQL> select sys.utl_inaddr.get_host_address() from dual;
select sys.utl_inaddr.get_host_address() from dual
       *
ERROR in line 1:
ORA-29257: host xx-myser unknown
ORA-06512: at "SYS.UTL_INADDR", line 19
ORA-06512: at "SYS.UTL_INADDR", line 40
ORA-06512: at line 1



Have a nice day,
Uwe

Am Di, 2.11.2010, 20:55, schrieb Goulet, Richard:
> 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