Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 9i connection string with SYS account

Re: oracle 9i connection string with SYS account

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Tue, 4 Jun 2002 22:53:48 +0800
Message-ID: <adik9m$81r$1@clematis.singnet.com.sg>

You'll have to set "O7_DICTIONARY_ACCESSIBILITY=TRUE" in the init.ora [not sure if it can be dynamically modified in 9i] and restart the instance.

Hemant K Chitale

"Bertus Dam" <b.dam_at_gmx.net> wrote in message news:3cfc878f$1_at_news.mhogaming.com...
> I'm trying to create a connectionstring in my application to an oracle 9i
> database.
> I can't get it to work though. This is what I try:
>
> Provider=OraOLEDB.Oracle;Data Source=svr;User
> ID=SYS;Password=change_on_install;
>
> Errormessage:
>
> Message: "ORA-28009: connection to sys should be as sysdba or sysoper"
>
> How can I fix this? Or how do I create a connectionstring which uses
> integrated O/S security?
>
>
>
> Thanx, Bertus
>
>
>
Received on Tue Jun 04 2002 - 09:53:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US