ORACLE Discoverer usage note --------------------------------------- Part of 9.0.2 ORACLE9iDS * What is a EUL? End user layer Discoverer administrator -------------------------- 1. From DBA account grant connect, resource to dsadmin identified by dsadmin; alter user dsadmin default tablespace users quota unlimited on users; 2. Start administrator connect to dsadmin. Request to create an EUL will be prompted. Grant EUL to public. * If you see error about dcmresus.msb not in the "path", chances are the ORACLE_HOME environment is not set properly or was overwritten by other ORACLE product installation. Reset the environment variables will correct it. * If you see ora-12705 error complaining about the NLS setting, chances are the infamous NLS_LANG setting is messed up. Run regedit to remove NLS_LANG and NLS_PREV_LANG from HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE * If the above do not work, it might be easier just to deinstall/reinstall 9.0.2. The whole process takes only 15 minutes or so. No side effects. * Note that the NLS_LANG is set to AMERICAN_AMERICA.WE8MSWIN1252 in the registry. No environment varaible of NLS_LANG is set.