Oracle and PH843d1 on hp-ux
Jonas Rosell
jonas.rosell at cefalo.se
Thu Feb 16 04:36:07 CST 2006
Hi all,
We are in the process of migrating from MPE/IX and Image to HP-UX and Oracle.
In this process we have encounterd a smal problem regarding attach to the database. It seems that quiz,qtp,quick need the file resolv.conf and that we must have a DNS server to lookup in order to connect to the database.
Is there a way to avoid this, ? we have oracle and the application on the same server. When we delete resolv.conf we can not attach to the database. We have a nameserver but this server is not inhouse.
we have set upp nsswitch.conf like this
hosts: dns [NOTFOUND=continue] files
ipnodes: dns [NOTFOUND=continue] files
networks: files
protocols: files
rpc: files
publickey: files
netgroup: files
automount: files nis
aliases: files nis
services: files
Best Regards
Jonas
________________________________
Från: powerh-l-bounces+jonas.rosell=cefalo.se at lists.sowder.com genom Peter Bateman
Skickat: to 2006-02-16 02:23
Till: powerh-l at lists.sowder.com
Ämne: RE: Show files error
Harold:
My understanding of the NODELAY option is that PowerHouse
will try to open every relational database referenced in the dictionary.
If my understanding is correct then could there be a db that development
powerhouse can't open?? But production can open them all!
Regards,
Peter
>thnx, but my QUIZ command is already:
>
>QUIZ == "$PH_LOCATION:QUIZA710G1 SUBDICT=(NODELAY,SEARCH)"
>
>We have 840d1 installed and when I try that version, it works fine in
>production. However, in development, I get a different error at the
>same point:
>
>*E* No dictionary file with the specified name exists.
>
>It appears to me to be a Powerhouse bug of some sort. I've also been
>informed that other completely different Powerhouse systems in my area
>also have the same problem.
>
>
> _____
>
>From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
>Sent: Tue, February 14, 2006 12:30 PM
>To: Johnson, Harold A EDUC:EX; powerh-l at lists.sowder.com
>Subject: RE: Show files error
>
>
>
>in fact, it could be that you need to use 'qshow subdict=search'
>
>Regards, Joe.
>
> _____
>
>From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
>[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On
>Behalf Of Joe Boyle
>Sent: 14 February 2006 20:18
>To: Johnson, Harold A EDUC:EX; powerh-l at lists.sowder.com
>Subject: Re: Show files error
>
>
>
>try 'show file in mydbname'
>
> ----- Original Message -----
>
> From: Johnson, Harold A EDUC:EX
><mailto:Harold.A.Johnson at gov.bc.ca>
>
> To: powerh-l at lists.sowder.com
>
> Sent: Tuesday, February 14, 2006 8:03 PM
>
> Subject: Show files error
>
>
>
> Hi all. I get the following error when I try to do a "Show
>files" command in quiz or qshow (for example). Any ideas what is
>causing this? I get the same error in all of our environments for a
>particular system (ie: deve, test, prod). It's been occuring for some
>time (months) but there doesn't seem to be any other problems with
>either the database or with Powerhouse.
>
> A QSHOW "show record" of the product_component_version" comes
>back fine.
> A "show table" in SQL is fine.
>
> OpenVMS v7.3-2
> Oracle RDB v7.1-241
> Powerhouse v710g1
>
> $quiz
>
> >show file
>
> ...
>
> ... lots of tables
>
> ...
>
> ALL_SNAPSHOTS IN SFAS_DATABASE
>
> USER_SNAPSHOTS IN SFAS_DATABASE
>
> PRODUCT_COMPONENT_VERSION IN SFAS_DATABASE
>
> *E* Relational Database access failed.
>
> %RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime
>
> %COSI-F-INTOVF, integer overflow
>
>
>
>
>
>
>
>
> _____
>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: "subscribe" in message body to
>powerh-l-request at lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a
>subscriber.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
_________________________________________________________________
Powerful Parental Controls Let your child discover the best the Internet has
to offer.
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
Start enjoying all the benefits of MSN® Premium right now and get the
first two months FREE*.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060216/25b50572/attachment.html
More information about the powerh-l
mailing list