| ORA1122 ERROR [message #128555] |
Tue, 19 July 2005 06:52  |
pnbzomds
Messages: 1
Registered: July 2005
|
Junior Member |
|
|
I AM NEW TO ORACLE.
WHEN I TRY TO LOGIN IT GIVES THE ERROR:
ORA-01033:ORACLE INITIALISATION / SHUTDOWN IN PROGRESS.
I CHECKED THE ALERT LOG FILE-- THE LAST LINE SAYS
ORA-1122 signalled during: alter database open...
THE LAST FEW LINES OF THE LOG FILE ARE GIVEN BELOW. PL. LET ME KNOW THE SOLUTION. URGENT
THANKS IN ADVANCE.
racle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Tue Jul 19 12:37:39 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Jul 19 12:37:41 2005
alter database mount exclusive
Tue Jul 19 12:37:48 2005
Successful mount of redo thread 1, with mount id 4025136732.
Tue Jul 19 12:37:48 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Jul 19 12:37:48 2005
alter database open
ORA-1122 signalled during: alter database open...
|
|
|
|
| Re: ORA1122 ERROR [message #128599 is a reply to message #128555] |
Tue, 19 July 2005 12:05  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Sounds like your database is broken:
01122, 00000, "database file %s failed verification check"
// *Cause: The information in this file is inconsistent with information
// from the control file. See accompanying message for reason.
// *Action: Make certain that the db files and control files are the correct
// files for this database.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
