SQL Exception occured: ORA-00904: "VS"."WAIT_CLASS": invalid identifier

[Ivan Saenz]

Hi,

Fantastic application. I would like to create a new topic about the following error in "Initialize connection pool" phase (Completed 5%):

SQL Exception occured: ORA-00904: "VS"."WAIT_CLASS": invalid identifier
java.lang.NullPointerException

The DB I'm trying to connect is version 9i:

SQL> select * from v$version;

BANNER

Oracle9i Release 9.2.0.6.0 - 64bit Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production

I installed ASH Viewer in Windows following README.

Followed step for 9i:
For Oracle 9i(8i) DB, user SYSTEM must have access rights to the views sys.x_$ksuse, sys.x_$ksusecst

            create view x_$ksuse as select * from x$ksuse;
            create view x_$ksusecst as select * from x$ksusecst;

            grant select on sys.x_$ksuse to system;
            grant select on sys.x_$ksusecst to system;

Also copied ojdbc6.jar into bin folder.

Created monitor DB user using user_privs.sql scripts. I got two errors:

SQL> grant select on v_$active_session_history to monitor
*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> grant execute on DBMS_WORKLOAD_REPOSITORY to monitor
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist

My JDK is jdk1.8.0_25.

Thanks!

Kind Regards,

Ivan Saenz
Medior MST Consultant
C/Copérnico, 6,
A Coruña A Coruña
Spain
Phone: +34 981 101 164
Mobile: +34 668 139 482
eMail: isaenz@quistor.com

[cid:image001.png@01D28875.9C9F1C30]https://www.facebook.com/quistor[cid:image002.png@01D28875.9C9F1C30]http://www.linkedin.com/company/quistor[cid:image003.png@01D28875.9C9F1C30]https://twitter.com/quistorcompany[cid:image004.png@01D28875.9C9F1C30]https://www.youtube.com/channel/UCNo8KiX3heHc6pg2xr--0fw[cid:image005.png@01D28875.9C9F1C30]http://www.quistor.com/en/blog/latest

[Alexander Kardapolov]

Hi!

It seems you use Standard option in connection dialog.
For Oracle 8i/9i please use Enterprise.

Thanks,
Alex.

[Ivan Saenz]

Thanks Alexander,

That helped a little. Now error is:

SQL Exception occured: ORA-00942: table or view does not exist
java.lang.NullPointerException

also at 5%.

If I use a user with DBA role instead of 'monitor' user, following error happens at 40% (Initialize history tab):

java.lang.NumberFormatException: empty String

Appreciate your help. Regards,
Iván