Bugs in Oracle Query Wizard
Posted: Fri Jul 13, 2012 12:47 pm
Hi - I'm running 2011R3.2 on OL6.2 x86_64 with Oracle Query Wizard from 18 Aug 2011 and Oracle Instant Client 11.2.
The following happened to me when trying to set up a query and I believe they are bugs.
1. oracleinstall.sh did not return the correct PATH for ORACLE_HOME and LD_LIBARARY_PATH - namely it didn't detect the "$version" so the paths it displayed were incorrect - e.g. "ORACLE_HOME=/usr/lib/oracle//client64".
2. If the password has an exclamation mark "!" in it, the wizard will split the connection string into the next $ARG$ where the ! should have been.
3. The database name specified in the wizard isn't applied to the connect string and the monitor fails. If I go back and manually add it e.g. "-connect server.example.net:1521/dbname" it works as expected.
Since this took up several hours of my time I thought I'd pass it along. Thank you.
JG
The following happened to me when trying to set up a query and I believe they are bugs.
1. oracleinstall.sh did not return the correct PATH for ORACLE_HOME and LD_LIBARARY_PATH - namely it didn't detect the "$version" so the paths it displayed were incorrect - e.g. "ORACLE_HOME=/usr/lib/oracle//client64".
2. If the password has an exclamation mark "!" in it, the wizard will split the connection string into the next $ARG$ where the ! should have been.
3. The database name specified in the wizard isn't applied to the connect string and the monitor fails. If I go back and manually add it e.g. "-connect server.example.net:1521/dbname" it works as expected.
Since this took up several hours of my time I thought I'd pass it along. Thank you.
JG