Failing to connect to database after configuring spotlight user.
Message:
"User Configuration required...
Before connecting to this database, you need to configure the spotlight user (SpotlightUser) using the Spotlight user Wizard.
This configuration is required because the user "SpotlightUser" has not been setup for use with this version of Spotlight on Oracle RAC."
Log in as Spotlight user and run the below scripts:
1. SELECT SUBSTR(SUBSTR(v.banner,INSTR(v.banner,'Release ')+8),1,INSTR(SUBSTR(v.banner,INSTR(v.banner,'Release ')+8),' ')),
v.banner,
s.machine
FROM v$version v, (SELECT machine FROM v$session WHERE type='BACKGROUND' AND machine IS NOT NULL AND rownum=1) s
WHERE ( v.banner LIKE 'Oracle%' OR v.banner LIKE 'Personal Oracle%' );
WORKAROUND:
Download and apply the attached user.dat file using the following steps:
1. Locate currently installed user.dat, at "\Plug-ins\SoO\"
2. Backup or rename the original user.dat
3. Copy the attached user.dat into the above folder
4. Run the User Wizard inside Spotlight to install the User again
5. Try connecting
STATUS:
Issue fixed in the current release of Spotlight on RAC. Latest version of Spotlight can be downloaded from here.
