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

  • From: Uwe Küchler <uwe@xxxxxxxxxxxx>
  • Date: Fri, 05 Nov 2010 13:12:25 +0100

Hi Sandeil,

this is interesting. The resolved address makes me assume that your
server's networking isn't configured at all...
- do you use DNS in your network?
- have you configured /etc/hosts ?
- can you reach your server from other machines using its name (like
"ping oracleebsprod")?
- what does "ifconfig" return?


Regards,
Uwe


Am 05.11.2010 10:53, schrieb seekuel:
> Hi Uwe,
>
> Please see result:
>
> SQL> select sys.utl_inaddr.get_host_address('oracleebsprod') from dual;
>
> SYS.UTL_INADDR.GET_HOST_ADDRESS('ORACLEEBSPROD')
> --------------------------------------------------------------------------------
> 127.0.0.1
>
> No error here...
>
> Is there another test we can use? I also need to know on the reason on
> why it is working on our side.
>
> Regards,
> Sandeil
>
>
> 2010/11/4 Uwe Küchler <uwe@xxxxxxxxxxxx <mailto:uwe@xxxxxxxxxxxx>>
>
>     Sandeil,
>
>     could it be that you don't have DNS in your network?
>     At least that's the only difference I can guess. I just tried the
>     same with Oracle 9.2.0.6 and got the error back.
>
>     What happens when you
>     select sys.utl_inaddr.get_host_address('oracleebsprod') from dual;
>     ?
>
>     If you don't mind, then please also CC it to oracle-l, so everyone
>     can benefit from this information.
>
>
>     Regards,
>     Uwe
>
>     Am 04.11.2010 02:26, schrieb seekuel:
>>     Hi Uwe,
>>
>>     We have a 9iR2 here its working fine. I want to share with you on
>>     the results of the query you have shown. I'm also thinking with
>>     MOS documentation if its all applicable (new to oracle). I also
>>     encountered that document when browsing MOS website before and
>>     checked our host name and its more than 8 characters. No idea yet
>>     on why its working. We are using EBS 11.5.9. Its database is
>>     originally 9.2.3 but upgraded to 9.2.8
>>
>>     Please see results below.
>>
>>     # uname -n
>>     oracleebsprod
>>
>>     SQL> select * from v$version;
>>
>>     BANNER
>>     ----------------------------------------------------------------
>>     Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
>>     PL/SQL Release 9.2.0.8.0 - Production
>>     CORE    9.2.0.8.0       Production
>>     TNS for Linux: Version 9.2.0.8.0 - Production
>>     NLSRTL Version 9.2.0.8.0 - Production
>>
>>     SQL> select sys.utl_inaddr.get_host_address() from dual;
>>
>>     SYS.UTL_INADDR.GET_HOST_ADDRESS()
>>     
>> --------------------------------------------------------------------------------
>>     127.0.0.1
>>
>>     Any thoughts on this?
>>
>>     Thank you,
>>     Sandeil
>>
>>     2010/11/4 Uwe Küchler <uwe@xxxxxxxxxxxx <mailto:uwe@xxxxxxxxxxxx>>
>>
>>         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 <http://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
>>         <http://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
>>         <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>
>>         >> [mailto: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