Lisa,
Got bit by this first time out of the box with W2K. I don't have access to
PCAnywhere, so I had to do the install from the console. I have however
created a ton of .bat files that perform various functions that I can
execute from Terminal Services. I found it necessary to use sqlplus with
the 'connect as' string, but it gets me in just fine. If I don't have the
script do something completely (backup, startup, shutdown, analyze, etc), I
have a generic one that pops up a DOS Prompt screen and puts me at the SQL>
prompt with sysdba privileges. Here's how I've done it (Perl is still on
my list Jared):
First file is login.bat
set ORACLE_SID=<SID> <---- These are just for good measure,
Registry and Environment SHOULD suffice, but it's Windoze
set ORACLE_HOME=F:\oracle\ora81
sqlplus /nolog @F:\oracle\admin\system_scripts\sysconnect.sql
exit
Next file is sysconnect.sql
connect sys/<password>@<SID> as sysdba
That's it. Go in through terminal services, run login.bat, and you're home
free. Everything else follows.
Hope this helps.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Michael
Netrusov To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<michael@atelo cc:
.com> Subject:
Sent by:
[EMAIL PROTECTED]
om
11/27/2001
10:25 AM
Please respond
to ORACLE-L
Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal
Server Client do not work. I used PC Anywhere, everything went fine.
HTH,
Michael
>From: Koivu, Lisa <[EMAIL PROTECTED]>
>Subject: svrmgrl and W2k
>Date: 27 Nov 01, 03:25 PM
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
------ Original message ------
OH MY GOSH this sucks.
Is anyone running 8.1.7 EE on W2k? I am trying to start the database (and
the listener, for that matter) via Terminal Server and it keeps erring out
with ORA-12560 protocol adapter error.
I look on Metalink and it just plain says, Go to the console. WHAT? Are
you KIDDING! Here's the note:
* fact: Oracle Server - Enterprise Edition
* fact: RDBMS
* fact: MS Windows 2000
* fact: MS Windows NT
* symptom: Cannot connect to SVRMGRL
* symptom: ORA-12560: TNS:protocol adapter error
* symptom: Cannot connect to SVRMGR30
* symptom: ORA-12203: TNS:unable to connect to destination
* cause: Bequeath protocol is not supported with Microsoft
Terminal
Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on
Oracle8i.
fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is
not available using an MS Windows 2000 Terminal Server Client. To startup
the instance, use the the Windows 2000 console to connect to the SVRMGRL.
I can do this with W2k, Terminal Server and Standard Edition.
Has anyone else seen this ? I am so irked I could scream. (But it could be
the hormones).
Lisa Koivu
Oracle Database Monkey.
Fairfield Resorts, Inc.
954-935-4117
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Netrusov
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
