Hi!
We have a software:
Oracle DB, Java GUI, Oracle Reports. We must to migrate the database to DB2.
Some manuals said, it is possible to connect to DB2 from Oracle SQL*Plus (I have version 8.0.6.0.0) and from Oracle Report Builder.(6.0.8.11.3) (User must install OCA (Oracle Open Client Adapter for ODBC (6.0.5.29.0))) and make ODBC entry.
I did it.
run with: plus80 db2user/db2pass@odbc:db2test
SQL*Plus made the connection, but with errors:
---
SQL*Plus: Release 8.0.6.0.0 - Production on Fri Oct 17 16:12:56 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Server not available or version too low for this feature
ORA-00022: invalid session id; access denied
Connected to:
Oracle Open Client Adapter for ODBC 6.0.5.29.0
DB2/NT 08.01.0000
SQL>
---
The error refers PUPBLD.SQL, but I think it is Oracle specific, don't help.
Worse, that it can't connect from Report Builder, just throws error.
Have you any idea, how can I solve this?
Thanks
Brioska
We have a software:
Oracle DB, Java GUI, Oracle Reports. We must to migrate the database to DB2.
Some manuals said, it is possible to connect to DB2 from Oracle SQL*Plus (I have version 8.0.6.0.0) and from Oracle Report Builder.(6.0.8.11.3) (User must install OCA (Oracle Open Client Adapter for ODBC (6.0.5.29.0))) and make ODBC entry.
I did it.
run with: plus80 db2user/db2pass@odbc:db2test
SQL*Plus made the connection, but with errors:
---
SQL*Plus: Release 8.0.6.0.0 - Production on Fri Oct 17 16:12:56 2003
(c) Copyright 1999 Oracle Corporation. All rights reserved.
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
ORA-00022: invalid session id; access denied
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Server not available or version too low for this feature
ORA-00022: invalid session id; access denied
Connected to:
Oracle Open Client Adapter for ODBC 6.0.5.29.0
DB2/NT 08.01.0000
SQL>
---
The error refers PUPBLD.SQL, but I think it is Oracle specific, don't help.
Worse, that it can't connect from Report Builder, just throws error.
Have you any idea, how can I solve this?
Thanks
Brioska