Oracle 9i - sys login question

From: Marco Casale <mjcasale_at_yahoo.com>
Date: 22 Dec 2001 07:50:16 -0800
Message-ID: <f79df195.0112220750.2c8e7006@posting.google.com>

Hi,

I'm trying to setup an application called Spotlight made by Quest software to monitor my Oracle database. I need to login as SYS in order to setup the 'spotlight' user account in Oracle. Unfortunately, I can't login as SYS. Is there a way to change the sys account so that I can login a SYS normal? I'm only able to login as SYS as SYSDBA. I'm running Oracle 9i on both Win2k and Solaris 8. When I try logging in as a different DBA account , Spotlight tells me insufficient privileges but doesn't explain anything further.

Any advice is appreciated.

Thank you,

Marco Received on Sat Dec 22 2001 - 09:50:16 CST