Powerhouse Oracle Solaris : connect to database but cannot see tables

[Tracy Johnson]

I know nothing about Solaris however on my former platform you had to embed
the DB password in the PDL file.  Could be an issue if it changes
frequently.  (My old platform it was never.)


On Thu, Jan 12, 2023, 11:44 AM Pierre Bouthillette <
pierre.bouthillette at gmail.com> wrote:

> Hi all
>
> We are running powerhouse 8.43e on solaris 11 using cisam
> we want to introduce access to Oracle database(Boat)
> we can access the table TEST in sqlplus on solaris 11
>
> powerhouse
> added oracle definition in pdl for database boat owner boat
> tried FILE or DATABASE statement, compiled ok
>
> File boat organization relational type oracle    &
>      open ORACLE at boat@orcl/boat123 owner boat    &
>      null values not allowed
>
> powerhouse qdesign & qshow using dbaudit seem to connect to database but
> cannot see tables
>
> test and config bellow
>
>
>
> entreprise2-v2-{yvadev}: qdesign dbaudit=full
> Q D E S I G N (PowerHouse 8.43.E)
> Copyright (C) 2007 Cognos Incorporated. All rights reserved.
> Licensed PH8-*****
>
> screen r
> file TEST IN boat
> ATTACH 0 to ORACLE ORACLE at boat@orcl/boat123
> START transaction 0 (in LOGICAL transaction DICTIONARY) in attach(es) 0
> Read Committed
> COMPILE request 0
>
> START request 0 in transaction 0
> RELEASE request 0 from attach 0
> *E* The file TEST wasnt found.
> COMMIT logical transaction DICTIONARY
> COMMIT transaction 0
> DETACH 0 from ORACLE at boat@orcl/boat123
>
> entreprise2-v2-{yvadev}: qshow dbaudit=full
> Q S H O W (PowerHouse 8.43.E)
> Copyright (C) 2007 Cognos Incorporated. All rights reserved.
>
> show rec test in boat
> ATTACH 0 to ORACLE ORACLE at boat@orcl/boat123
>
> START transaction 0 (in LOGICAL transaction DICTIONARY) in attach(es) 0
> Read Committed
> COMPILE request 0
>
> START request 0 in transaction 0
> RELEASE request 0 from attach 0
> *E* The Record test was not found in the data dictionary.
>
>
> **** WE CHANGED PDL DATABASE FOR A WRONG PASSWORD ****
>
> entreprise2-v2-{yvadev}: qshow dbaudit=full
> Q S H O W (PowerHouse 8.43.E)
> Copyright (C) 2007 Cognos Incorporated. All rights reserved.
>
> show files boat
> 2023/01/12 TurboBoat Page 1
> F I L E R E P O R T
> For DICTIONARY: /develop/exec/dict/phd.pdc
> Database: boat
> Organization: RELATIONAL
> Null Values Allowed:Yes
> Type: ORACLE
> Hold Cursor: Unspecified
> Open: ORACLE@@orcl/
> Owner: boat
> *W* SQL START DBE error (boat).
> DMS-E-INVLLOGIN, Invalid login information was detected by the underlying
> database.
> ORA-01017: invalid username/password; logon denied
>
> Records ; Sizes: ** none **
>
> *******************************************************
> we can access database with sqlplus
>
> entreprise2-v2-{yvadev}: sqlplus
>
> SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 12 10:41:21 2023
>
> Copyright (c) 1982, 2013, Oracle. All rights reserved.
>
> Enter user-name: boat at orcl/boat123
>
> Connected to:
> Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
>
>
> SQL> SELECT owner, table_name FROM all_tables where owner='boat';
>
> OWNER TABLE_NAME
> ------------------------------ ------------------------------
> boat TEST
>
> select * from test;
>
> CODE PROV_NOM TPS_NUM
> ---- ------------------------------ ----------
> BRIT British Columbia 111111
>
> SQL>
>
>
>
> : uname -a -m -n -r -s -v
> SunOS entreprise2-v2 5.11 11.4.50.126.3 sun4v sparc sun4v non-global-zone
>
>
> entreprise2-v2-{yvadev}: env | grep -i ora
>
>
> PATH=/usr/bin:/usr/sbin:/usr/lib:/data/exec/userbin:/usr/lib/lp/postscript:.:/op
> t/oracle/instantclient_11_2:/opt/cognos/ph843e/bin
>
> LD_LIBRARY_PATH=/opt/cognos/ph843e/lib:/usr/lib:/opt/oracle/instantclient_11_2
>
> ORACLE_HOME=/opt/oracle/instantclient_11_2
>
> TNS_ADMIN=/opt/oracle/instantclient_11_2/network/admin
>
>
>
> root at entreprise2-v2# file /opt/cognos/ph843e/bin/q*
> /opt/cognos/ph843e/bin/qdesign: ELF 32-bit MSB executable SPARC Version 1,
> dynamically linked, stripped
> /opt/cognos/ph843e/bin/qkextdrvr.c:     c program text
> /opt/cognos/ph843e/bin/qkexttbl.h:      empty file
> /opt/cognos/ph843e/bin/qkgo:    executable shell script
> /opt/cognos/ph843e/bin/qkgomaint:       executable shell script
> /opt/cognos/ph843e/bin/qshow:   ELF 32-bit MSB executable SPARC Version 1,
> dynamically linked, stripped
> /opt/cognos/ph843e/bin/qtp:     ELF 32-bit MSB executable SPARC Version 1,
> dynamically linked, stripped
> /opt/cognos/ph843e/bin/quick:   ELF 32-bit MSB executable SPARC Version 1,
> dynamically linked, stripped
> /opt/cognos/ph843e/bin/quiz:    ELF 32-bit MSB executable SPARC Version 1,
> dynamically linked, stripped
> /opt/cognos/ph843e/bin/qutil:   ELF 32-bit MSB executable SPARC Version 1,
> dynamically linked, stripped
> root at entreprise2-v2#
>
> 4. Oracle library PowerHouse is 32 bits:
>
> root at entreprise2-v2# file /opt/cognos/ph843e/lib/or*.so
> /opt/cognos/ph843e/lib/ordba.so:        ELF 32-bit MSB dynamic lib SPARC
> Version 1, dynamically linked, not stripped
> root at entreprise2-v2#
>
> 5. Oracle client is 32 bits:
>
> root at entreprise2-v2# file /opt/oracle/instantclient_11_2/*.so
> libclntsh.so:   ELF 32-bit MSB dynamic lib SPARC32PLUS Version 1, V8+
> Required, dynamically linked, not stripped
> libnnz11.so:    ELF 32-bit MSB dynamic lib SPARC32PLUS Version 1, V8+
> Required, dynamically linked, not stripped
> libociei.so:    ELF 32-bit MSB dynamic lib SPARC32PLUS Version 1, V8+
> Required, dynamically linked, not stripped
> libocijdbc11.so:        ELF 32-bit MSB dynamic lib SPARC32PLUS Version 1,
> V8+ Required, dynamically linked, not stripped
> libsqlplus.so:  ELF 32-bit MSB dynamic lib SPARC32PLUS Version 1, V8+
> Required, dynamically linked, not stripped
> libsqlplusic.so:        ELF 32-bit MSB dynamic lib SPARC32PLUS Version 1,
> V8+ Required, dynamically linked, not stripped
> root at entreprise2-v2#
>
>
>
> Pierre
> Pierre.Bouthillette at gmail.com
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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
> https://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20230112/b1b6b505/attachment-0001.html>