RE: svrmgrl and W2k
Title: svrmgrl and W2k Lisa, I'm running 8.1.6 and 8.1.7 EE on Win2k machines and I connect to them all the time via Terminal Server. I get the same ORA-12560, but I just invoke svrmgrl using internal@test or internal@dev. Works just fine. Am I missing part of the problem? Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Tuesday, November 27, 2001 9:25 AMTo: Multiple recipients of list ORACLE-LSubject: svrmgrl and W2k 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
RE: SVRMGRL and W2K
Title: RE: SVRMGRL and W2K Thanks David!! Lisa -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 12:10 PM To: Multiple recipients of list ORACLE-L Subject: 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= < 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/@ 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]> .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-50
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= < 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/@ 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]> 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