Yes
However connections achieved by using
set oracle_sid=<sid>
sqlplus username/password
will fail in a terminal services session. You will need to use a tnsnames
alias.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
>Yes
Beg/q to disagree with you on this one. The BEQUEATH protocol doesn't
work on Microsux Terminal Services, and Oracle has no plans to fix
this, as Microsux is the only vendor having problems. In some cases
you are *forced* to use BEQ and using a tnsnames alias is simply not
possible. This is at least the issue with using the Oracle Agent for
Arcserve.
In the particular case the internal customer *only* wants to work with
Microsux Terminal Server because that seems to be the only secure
option. As far as Oracle is concerned *any* emulator (PcAnywhere, VNC,
Timbukto pro, you name it) will *fully* work, *except* Microsux
Terminal Server.
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address
Why is this necessary? With Unix, we can just telnet.
Regards,
Paul
I believe I alluded to this problem in my reply.
> In some cases
> you are *forced* to use BEQ and using a tnsnames alias is simply not
> possible. This is at least the issue with using the Oracle Agent for
> Arcserve.
I'm not aware of any occasions where you are *forced* to use the BEQ
protocol., though I'll admit that in many cases it is the natural protocol
to use. In the example you give, surely the appropriate solution would be to
write a shell script and not bother with the 3rd party agent. Admittedly
what you save on software you will probably spend on disks to hold the
backups before they go to tape.
> In the particular case the internal customer *only* wants to work with
> Microsux Terminal Server because that seems to be the only secure
> option.
I couldn't possibly comment :(.
Of course if you wanted to you could telnet into a win2k box :(.
AS> it is possible to run Oracle 8i on Windows 2000 Server simultaneously with
AS> Terminal Services?
AS> Whithout TSC everything is ok. When I installed TSC and try to connect to
AS> the instance there is an error: "ORA-12560: TNS:protocol adapter error".
yes, it is
1.set up tnsnames.ora like your server is a client
2.create string parameter in registry "LOCAL"="YOUR_SID"
3.or you can use command "set local=YOUR_SID"
4.now you can log on to database using any client program in remote
session mode
Dan Yusuph
Learning Oracle DBA
Greetings, all.
back in the day of 8.1.7, svrmgrl used bequeath - along with the
utilities lsnrctl, namesctl and cmanctl.
I believe that utilities such as Openlink [odbc] use it also.
If you don't feel like coughing up the funds for NetOp, PC Anywhere or
Timbuktu, there is always vnc. Development on that has seemed to
pickup lately - check http://www.realvnc.org for the latest ...
I see bequeath and MS Terminal Services incompatibilities to a be a
blessing.
Why would you want to have to support users running software on the
console, virtual or otherwise - of an oracle server?
Get them back onto an app server or their own desktops where they
belong.
Paul
Good point. Admittedly I rarely use these (read never for the last two) and
then only to stop and start the service which can be done from control panel
or a net start/net stop command, but point taken.
> I see bequeath and MS Terminal Services incompatibilities to a be a
> blessing.
> Why would you want to have to support users running software on the
> console, virtual or otherwise - of an oracle server?
I think the problem is if your business is that of being a remote DBA either
in-house or otherwise. Users definitely belong at the end of a client but
DBA tasks require console acccess (generally).
What about when the DBA needs to fix something?
Regards,
Paul
Regards,
Paul