Powerhouse Oracle Solaris : connect to database but cannot see tables

Thu Jan 12 13:42:21 CST 2023

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 ****

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20230112/fab447fd/attachment.html>