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