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