connect to the database using SID

Hi all,

let's assume there are no connect string and the only thing we have is ORACLE_SID is running (BTW, it's on Windows 2000). the reason I asked b/c I only have the service and I tried to use Terminal servers to create my database. Any way, in terminal servers, you can not set the environment to the ORACLE_SID b/c it won't resolve the services. Is there any ways for us to create the database using Terminal Services??? obviously, we can't use the connect string b/c the database does not exist yet.

Any thoughts?

Quote:

---

Originally posted by candyman
Any way, in terminal servers, you can not set the environment to the ORACLE_SID b/c it won't resolve the services.

---

I just TS into another machine and execute the following

C:\Documents and Settings\oracle>set ORACLE_SID=DALLAS2

C:\Documents and Settings\oracle>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.2.0 - Production on Wed Oct 1 10:38:38 2003

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL>


..........seems to work ok for me, and yes there are several other Oracle DB's on that box

stmontgo,

I just tested as we speak now. I ts to the server,
1. create the service using ORADIM,
2. set ORACLE_SID
3. SQLPLUS /nolog
4. connect internal/manager (I am on 8i, but 8i or 9i should not make any differences)
I got the errror: ORA-01017: invalid username/password; logon denied



but I do the same procedure at the server it works fines.


any comments???

add the TSInternetUser to the ORA_DBA group

steve

i JUST CHECKed, the ts user is in ORA_DBA group

and who said internal´s password is manager?

and who said 8i and 9i are same? there is NO internal user in 9i

Pando,

I apologize for stating 9i, I mean the way Terminal server work. I am well aware what support and what not on 9i. The point here is Terminal Server.

To answer your question: internal password is manager b/c I create the service with manager as the password.

do you use

SQLNET.AUTHENTICATION_SERVICES=(NTS)

no, should I

yes and dont supply any password

thanks Pando

I did make the change on my sqlnet.ora and log into the database without password, I got different error:


SQL> connect internal
ERROR:
ORA-24314: service handle not initialized

I look into Metalink and below what I found:

From: Oracle, Gina Thunder 01-Feb-02 14:37
Subject: Re : ORA-24314 when in local Administrators group


Are you connected in a Terminal Service session? This error will occur using Terminal Services as bequeath connections are not supported. If this is the case you must connect using a SQL*Net alias.

If you are not in a Terminal Services environment, make sure that the ORACLE_SID is set correctly within the registry. Also make sure the OracleServiceSID is started and running and that your SID name is less than 15 charcaters long and does not include any special characters.



Do you have any other advises???

er are you candyman or what?

SORRY, i HAVE THE SAME PROBLEM AND I AM CURRENTLY WORKING ORACLE TO RESOLVE MINE. I SHOULD CLARIFY A LITTLE BETTER.

DO YOU HAVE ANY COMMENTS???

hmmm you both have same ip :confused:

pando,

what do you mean????



Mike2000,

I don't have Metalink support please give me an update if you hear anything from Oracle.

thanks both of you for the input???

Quote:

---

Originally posted by candyman
Mike2000,

I don't have Metalink support please give me an update if you hear anything from Oracle.

---

Candyman & Mike2000,

Since you both are posting all of your posts from the same IP address all the time, it should be easy for you to exchange your informations from Oracle/Metalink. :rolleyes:

Wow - I'm lost, why would someone spoof 2 personas?

Terminal Services is evil, it prevented me from accessing a windows database this week and it ruined an install of Biz Portal.

Interesting thread though as stmontgo seems to be immune to TS grief.