connect to the database using SID

[candyman]

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?

[stmontgo]

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

[candyman]

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???

[stmontgo]

add the TSInternetUser to the ORA_DBA group

steve

[candyman]

i JUST CHECKed, the ts user is in ORA_DBA group

[pando]

and who said internal´s password is manager?

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

[candyman]

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.

[pando]

do you use

SQLNET.AUTHENTICATION_SERVICES=(NTS)

[candyman]

no, should I

[pando]

yes and dont supply any password