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: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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 bytes
Database mounted.
SVRMGR>recover database
Database recovered. (There may be more to this step to do any media
recovery.)
SVRMGR> alter database open;
Statement processed.
SVRMGR>
... and on you go ...
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: [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: Walthour, Jon (GEAE, Compaq)
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).
_________________________________________________________________
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: [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: Walthour, Jon (GEAE, Compaq)
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).
RE: Logging into Windows 2000 "Advanced" Server
Walthour, Jon (GEAE, Compaq) Sun, 09 Sep 2001 04:21:57 -0700
- Logging into Windows 2000 "Advanced"... DBarbour
- RE: Logging into Windows 2000 "Adva... Walthour, Jon (GEAE, Compaq)
- RE: Logging into Windows 2000 "Adva... Mohammad Rafiq
- Walthour, Jon (GEAE, Compaq)
