| 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
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:
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 - 11:41:57 CST
 |
 |