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

  • From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
  • To: uwe@xxxxxxxxxxxx
  • Date: Mon, 8 Nov 2010 18:03:59 +0100

Uwe,

If you're using your own DDL to create those tables, there's an easy way
around that limitation -- just put your table names in double quotes. You
can put pretty much anything in a table name that way.

Stefan


=========================

Stefan P Knecht
CEO & Founder
s@xxxxxxxx

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch

=========================


2010/11/4 Uwe Küchler <uwe@xxxxxxxxxxxx>

>  Hello Niall,
>
> you mean the hyphen character in the host name? I thought so, too and tried
> to find some documentation or other pointers to support my thoughts -
> especially when trying to argue with Ops. But so far I haven't found
> anything on MOS that goes like "don't use hyphens in hostnames".
>
> The only trouble we have so far is our own admin tool (DB with APEX), that
> cannot create tables using the host name when there's a hyphen in it (not
> allowed for Oracle object names).
>
>
> Best regards,
> Uwe
>
>
>
> Am 03.11.2010 19:35, schrieb Niall Litchfield:
>
> The hyphen character may be problematic here. It certainly is for db links
> and db domains.
>
> On 3 Nov 2010 16:05, "Uwe Küchler" <uwe@xxxxxxxxxxxx> wrote:
>
> 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 th...
>
>
>

Other related posts:

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