Does nobody tried to attach a catalog to DB as sysdba?

[ferrob]

Hi to all,

I'm using Cognos Impromptu 7.1 with database Oracle 9i. I'd like to attach to db using Oracle drivers (NOT ODBC!), and I'm able to do that, but I can't do it as sysdba user. So, the steps I followed was:


from Menu Catalog-->Databases

Database Drivers-->Oracle-->New Database

Logical database name field filled with "myDb"

Sql*Net connect string field with "myDb"

Button Test pressed and athentication done with user ID="sys" and password="sys"..

at this point the error was:

ORA-28009: connection to sys must be like sysdba or sysoper[/color red]


Any ideas?

Many thanks,
ferrob

 

[flex13]

Try to log into the Oracle console with the sys user using a 'normal' mode and you will get the same error. You must use SYSDBA when using the SYS user. Not an Impromptu problem.