| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SVRMGRL and W2K
Thanks David!!
Lisa
-----Original Message-----
From: DBarbour_at_austin.isd.tenet.edu [SMTP:DBarbour_at_austin.isd.tenet.edu] Sent: Tuesday, November 27, 2001 12:10 PM To: Multiple recipients of list ORACLE-LSubject: Re: SVRMGRL and W2K
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 <ORACLE-L_at_fatcity.com> <michael_at_atelo cc: .com> Subject: Sent by: root_at_fatcity.c 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 <lisa.koivu_at_efairfield.com> >Subject: svrmgrl and W2k >Date: 27 Nov 01, 03:25 PM >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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: michael_at_atelo.com 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: ListGuru_at_fatcity.com (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: DBarbour_at_austin.isd.tenet.edu 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: ListGuru_at_fatcity.com (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).Received on Tue Nov 27 2001 - 16:16:37 CST
 |
 |