| 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: Logging into Windows 2000 "Advanced" Server - Solved, Thanks
Thanks folks,
The SET command was what I needed. It turns out that the network folks installed some new software on the server and somehow trashed the Oracle environment. Even though I manually set my environmental variables, I still was unable to connect to the instance. Oracle support told me this was an indication on Windows 2000 that my binaries needed to be relinked, and the only way to accomplish this on 2000 was to reinstall Oracle. I did, and it's now working.
Live and learn.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Walthour, Jon
(GEAE, To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
Compaq)" cc:
<Jon.walthour@ Subject: RE: Logging into Windows 2000
"Advanced" Server
ae.ge.com>
Sent by:
root_at_fatcity.c
om
09/09/2001
07:20 AM
Please respond
to ORACLE-L
Thank you for the correction, Mohammad.
Jon Walthour
-----Original Message-----
Sent: Sunday, September 09, 2001 1:10 AM
To: Multiple recipients of list ORACLE-L
David,
Although Jon has given you almost complete solution but your answer to
login
as sqlplus is
sqlplus "/ as sysdba"
and you will connected as sys...This is also courtsy of Jon who gave this
answer to someone couple of days back...
Regards
MOHAMMAD RAFIQ
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Sat, 08 Sep 2001 20:30:17 -0800
The ORA-1113 message suggests that you have a file that needs media
recovery, which makes sense considering the abrupt shutdown. Instead of
opening the database, mount it first through SVRMGRL, the type "recover
database". You may be asked for some archive logs if you're in archivelog
mode. Just follow the directions that Oracle provides. You should be able
to
do a full recovery if the file is not permanently damaged. My guess is that
the db may just be out of sync and media recovery will just get things back
in sync. After the media recovery finishes, run "alter database open".
To do this, go to a command prompt and type "set" to see all your environment variables. To use SVRMGRL, you need to set your ORACLE_SID variable. To do this, enter "set ORACLE_SID=<your oracle sid goes here>". The run SVRMGRL, connect internal, and mount the database. Then recover it and open it. For example:
C:\>set oracle_sid=mydb
C:\>svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production
With the Partitioning option
JServer Release 8.1.7.2.1 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup mount
ORACLE instance started.
Total System Global Area 52193308 bytes Fixed Size 75804 bytes Variable Size 10342400 bytes Database Buffers 41697280 bytes Redo Buffers 77824 bytesDatabase mounted.
Hope this helps.
Jon Walthour
-----Original Message-----
Sent: Saturday, September 08, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L
Hope somebody can help.
Our network personnel rebooted a Windows 2000 production box without
shutting down Oracle. I now have the following error in my alert log: Sat
Sep 08 13:45:08 2001 Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sat Sep 08 13:45:08 2001
alter database open
ORA-1113 signalled during: alter database open...
Metalink says to check my environment variables. Is there an equivalent of
the UNIX env command on NT? I'm not sure exactly where the environment is
defined here. I'd also like to access this database from the command line
to manually start it up. Having had no success with the "as SYSDBA"
options
for sqlplus on either UNIX or NT, I figure I must be using the wrong
syntax. I know I can't use terminal services client (because the bequeath
protocol doesn't work), but here's what I'm gettiing after I explicitly set
the ORACLE_SID (Metalink says the double quotes are
mandatory):
sqlplus "<username>/<password> connect as sysdba" Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= - | -? | [ [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
<start> ::= @<filename>[.<ext>] [<parameter> ...]
"-" displays the usage syntax
"-?" displays the SQL*Plus version banner
"-M <o>" uses HTML markup options <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode
TIA -
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
-- 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 ListsReceived on Mon Sep 10 2001 - 10:57:07 CDT
--------------------------------------------------------------------
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: Walthour, Jon (GEAE, Compaq) INET: Jon.walthour_at_ae.ge.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). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857_at_hotmail.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: Walthour, Jon (GEAE, Compaq) INET: Jon.walthour_at_ae.ge.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).
 |
 |