Advertisement

10.07.2005 at 12:28PM PDT, ID: 21587728
[x]
Attachment Details

How do I configure Oracle 9i to use OS authentication on Windows Server 2003 over terminal services?

Asked by Mourdekai in Oracle Database

Tags: oracle, authentication, os, 9i, windows

Here is some background:

I installed Oracle 9i 9.2.0.1.0 and patched to 9.2.0.7.0 on a server running Windows Server 2003.  Whenever I re-booted the server, I would get the following message on trying to login through SQL*Plus.

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

I have found other solutions that point to commenting out the following line in the sqlnet.ora:

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

this works, but I have found that just making the line read:

SQLNET.AUTHENTICATION_SERVICES= ()

also works.

I'm not sure of what authentication service I am supposed to use for 2K3.  If it is supposed to be NTS, then how can I resolve my 27101 error?  If not, then what service method do I use, and how do I configure authentication in Oracle so that users logging into the 2K3 machine, using Microsoft Terminal Service Console, will not have to login to Oracle?

(If this is a complex answer, I'll raise points accordingly)

Thanks!Start Free Trial
 
Keywords: How do I configure Oracle 9i to use O…
Title
1 ORA-01034 and ORA-27101
2 sqlnet.ora
3 ORA-01034: ORACLE not availa…
4 Ora-01034: Oracle not available …
5 sqlnet.ora
6 Problem in setting the environmental va…
 
Loading Advertisement...
 
[+][-]10.07.2005 at 12:37PM PDT, ID: 15041418

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 12:48PM PDT, ID: 15041505

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 12:48PM PDT, ID: 15041506

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 12:49PM PDT, ID: 15041509

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 12:55PM PDT, ID: 15041568

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 01:02PM PDT, ID: 15041628

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 01:03PM PDT, ID: 15041645

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 01:08PM PDT, ID: 15041685

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 01:23PM PDT, ID: 15041844

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 01:34PM PDT, ID: 15041938

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 01:49PM PDT, ID: 15042086

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 02:01PM PDT, ID: 15042180

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.07.2005 at 02:20PM PDT, ID: 15042313

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.11.2005 at 09:04PM PDT, ID: 15066062

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.13.2005 at 01:25PM PDT, ID: 15080967

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.13.2005 at 04:45PM PDT, ID: 15082151

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.14.2005 at 10:08AM PDT, ID: 15087109

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.17.2005 at 09:38PM PDT, ID: 15104815

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.18.2005 at 12:12PM PDT, ID: 15110518

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.05.2006 at 07:33PM PST, ID: 15625941

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.10.2006 at 04:19AM PST, ID: 15659149

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle Database
Tags: oracle, authentication, os, 9i, windows
Sign Up Now!
Solution Provided By: DarthMod
Participating Experts: 3
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32