Re: Oracle on Windows question

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: JJReimer@xxxxxxxxxxxxxx
  • Date: Tue, 10 Feb 2009 15:12:39 -0800

Normally I would suspect that *SQLNET_AUTHENTICATION* =*NTS*  was not set in
the sqlnet.ora

But you have 5 other databases working from the same OH.

Is the logon account for this database service the same as the others?
It defaults to Local System Account.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist



On Tue, Feb 10, 2009 at 1:42 PM, Reimer, John J. <JJReimer@xxxxxxxxxxxxxx>wrote:

>  We have a problem connecting to a database that we have not seen before,
> and I am wondering if any else has encountered it.
>
> OS: Windows2003 32-bit
> Database Version: 9.2.0.8
> Only one Oracle Home on the box
>
> There are six databases running on this server.  We can connect to five of
> them just fine.
>
> When setting ORACLE_SID to the problem SID, and trying
> "Connect sys as sysdba"  we get
> "ORA-12546: TNS:permission denied"
>
> When we do "Connect sys@sidname as sysdba" it connects fine.
>
> Why would one database have a problem when the others all work?
>

Other related posts: