Yesterday in the link in the link ORACLE today, suddenly link, display the ORA - 01033, on the Internet to find some solutions, such as using the DBA ORACLE to SHUTDOWN, then at STARTUP, as their operation, to link has not solved, which is a great god can help see ~

CodePudding user response:

After STARTUP, there is a error message, you post;

CodePudding user response:

Blame is here, I didn't prompt error message after STARTUP

CodePudding user response:

1. In the "start" - & gt; 'run' execution CMDS

2. Input: up sqlplus "/as sysdba"

Should prompt similar to the following information:

SQL * Plus: Release 9.2.0.1.0 - Production on Wednesday, May 20 22:07:45 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
To connect to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining, Oracle options
The JServer Release 9.2.0.1.0 - Production

3. Input: shutdown immediate

Should prompt similar to the following information:

ORA - 01109: the database is not open

Have unloaded database,

4. Input: startup

Should prompt similar to the following information:

ORA - 01157: can't identify/locking data file 15 - please refer to the DBWR trace file
ORA - 01110: data file 15: 'D: \ TEST \ MY_INDEX1_1. DBF'
5. According to the step 4 information input: the alter database datafile 'D: \ TEST \ MY_INDEX1_1. DBF' offline drop

Should prompt similar to the following information:

Database has been changed,

6. Repeat steps 3-5, ORA - 01157 is no longer present until step 4, ORA - 01110 error information, is OK.

CodePudding user response:

refer to the second floor m0_37186895 response:

is here, I haven't prompt error message after STARTUP

There are no mistakes startup, and then can't connect?
Not in theory,
Maybe there is an error, otherwise I would have

CodePudding user response:

Stick the alert_sid. The contents of the log file, if too much, stick to the last 100 can