Re: Oracle on Windows question
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.
Certifiable Oracle DBA and Part Time Perl Evangelist
On Tue, Feb 10, 2009 at 1:42 PM, Reimer, John J. <JJReimer_at_coopertire.com>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: 220.127.116.11
> 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_at_sidname as sysdba" it connects fine.
> Why would one database have a problem when the others all work?