Home » RDBMS Server » Server Administration » Ora-01033 Error Rectifiation (Oracle 8i)
Ora-01033 Error Rectifiation (Oracle 8i) [message #229998] Tue, 10 April 2007 08:51 Go to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Hi all
i am in trouble due to ORA-01033.
The documentation says about this error to wait few minutes, so i waited for many minutes.
But my problem is not solved.

I searched the forum but could not do the step-2 for the solution
Step-1: run from cmd sqlplus /nolog
Stept-2 connect / as sysdba (which i beleive is system/manager@mos as sysdba)



Please help me
I am using Oracle 8i.

[Updated on: Tue, 10 April 2007 15:46]

Report message to a moderator

Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230007 is a reply to message #229998] Tue, 10 April 2007 09:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check alert.log file.

Regards
Michel
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230066 is a reply to message #229998] Tue, 10 April 2007 15:55 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Dear Michel

I can not find alert.log on my PC.

Still Looking for help.


Additional Information:

1) I am using Windowns 2000 Professional
2) ORA-01033 means: Oracle Initialization or Shutdown in progress
3) I am successfully running other database named CHA on my same machine. (My machine has two databases one is CHA while other is MOS)
4) With refernce to my above post, in step-2, when i type

connect system/********@mos as sysdba
The error comes in front is ORA-01031: insufficient priviliges

Please help!
-Dude

[Updated on: Tue, 10 April 2007 15:56]

Report message to a moderator

Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230068 is a reply to message #230066] Tue, 10 April 2007 16:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alert.log is on the server.
alert.log is a shortcut for alert<SID>.log or alert_<SID>.log or <SID>ALRT.LOG or... depending on your version.
It is in the background_dump_dest directory.

Check in this file why the instance is always in "Initialization or Shutdown in progress" state.

SYSTEM is not granted SYSDBA by default hence the "insufficent privilege" error.

Regards
Michel

[add the last sentence]

[Updated on: Tue, 10 April 2007 16:05]

Report message to a moderator

Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230071 is a reply to message #229998] Tue, 10 April 2007 16:06 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>Check in this file why the instance is always in "Initialization or Shutdown in progress" state.
IMO, it does not matter why/how it got into this state.
AFAIK, the (only) solution is to
sqlplus
SQL> / as sysdba
SQL> shutdown abort
SQL> startup
SQL> exit
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230073 is a reply to message #230071] Tue, 10 April 2007 16:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Surely the final solution but I prefer to know the reason before doing anything.

Regards
Michel
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230074 is a reply to message #229998] Tue, 10 April 2007 16:17 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
ok i got the file. It was <sid>ALRT.log

But i am not capable enough to anaylyze it. So here are last few lines of this file

Wed Apr 11 01:03:05 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Apr 11 01:03:06 2007
alter database mount exclusive 
Wed Apr 11 01:03:10 2007
Successful mount of redo thread 1, with mount id 2831777550.
Wed Apr 11 01:03:10 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Apr 11 01:03:10 2007
alter database open
ORA-1122 signalled during: alter database open...
Dump file d:\oracle\admin\mos\bdump\mosALRT.LOG
Wed Apr 11 01:39:21 2007
ORACLE V8.1.5.0.0 - Production vsnsta=0
vsnsql=d vsnxtr=3
Windows NT V5.0, OS V8.147, CPU type 586
Wed Apr 11 01:39:21 2007
Starting up ORACLE RDBMS Version: 8.1.5.0.0.
System parameters with non-default values:
  processes                = 59
  shared_pool_size         = 15728640
  java_pool_size           = 20971520
  nls_date_format          = DD-MON-YYYY
  control_files            = d:\oracle\oradata\mos\control01.ctl, d:\oracle\oradata\mos\control02.ctl
  db_block_buffers         = 8192
  db_block_size            = 2048
  compatible               = 8.1.0
  log_buffer               = 32768
  log_checkpoint_interval  = 10000
  log_checkpoint_timeout   = 1800
  db_files                 = 1024
  db_file_multiblock_read_count= 8
  remote_login_passwordfile= EXCLUSIVE
  global_names             = TRUE
  distributed_transactions = 500
  service_names            = mos
  instance_name            = mos
  mts_dispatchers          = (ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))(DIS=1)(SES=254)(CON=254)(TIC=15)(POO=NO)(MUL=NO)(LIS=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=mos))))(PRE=oracle.aurora.server.SGiopServer)
  mts_servers              = 1
  open_links               = 4
  db_name                  = mos
  os_authent_prefix        = 
  job_queue_processes      = 2
  job_queue_interval       = 10
  parallel_max_servers     = 5
  background_dump_dest     = d:\oracle\admin\mos\bdump
  user_dump_dest           = d:\oracle\admin\mos\udump
  max_dump_file_size       = 10240
  oracle_trace_collection_name= 
PMON started with pid=2
CKPT started with pid=5
SMON started with pid=6
LGWR started with pid=4
DBW0 started with pid=3
RECO started with pid=7
SNP0 started with pid=8
Wed Apr 11 01:39:53 2007
starting up 1 shared server(s) ...
SNP1 started with pid=9
Wed Apr 11 01:39:58 2007
starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Apr 11 01:40:20 2007
alter database mount exclusive 
Wed Apr 11 01:40:50 2007
Successful mount of redo thread 1, with mount id 2831772891.
Wed Apr 11 01:40:50 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Apr 11 01:40:51 2007
alter database open
Wed Apr 11 01:41:04 2007
ORA-1122 signalled during: alter database open...




Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230076 is a reply to message #230071] Tue, 10 April 2007 16:22 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
anacedent wrote on Wed, 11 April 2007 02:06
>Check in this file why the instance is always in "Initialization or Shutdown in progress" state.
IMO, it does not matter why/how it got into this state.
AFAIK, the (only) solution is to
sqlplus
SQL> / as sysdba
SQL> shutdown abort
SQL> startup
SQL> exit





How to connect as sysdba? what is the default password?

Who has sysdba priviliges by default (i mean when a database is created who has sysdba privilges)


Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230077 is a reply to message #230074] Tue, 10 April 2007 16:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora-01122: 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.

Seems there should be something else in your alert.log file.
Check if disk is not full.
Check if all control files are there.
Check if all data files are there.

Regards
Michel
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230078 is a reply to message #229998] Tue, 10 April 2007 16:25 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>How to connect as sysdba?
As the OS user who owns the oracle directory/software tree
>what is the default password?
There is none.

Who has sysdba priviliges by default (i mean when a database is created who has sysdba privilges)
See answer #1 above

try it, you'll like it.
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230079 is a reply to message #230077] Tue, 10 April 2007 16:34 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Michel Cadot wrote on Wed, 11 April 2007 02:24
ora-01122: 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.

Seems there should be something else in your alert.log file.
Check if disk is not full.
Check if all control files are there.
Check if all data files are there.

Regards
Michel



-1- Disk has ample space. 3 GB in current partition where Oracle is installed.
-2- Control files? data files? I am very poor at DBA.

Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230083 is a reply to message #230078] Tue, 10 April 2007 16:42 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
anacedent wrote on Wed, 11 April 2007 02:25
>How to connect as sysdba?
As the OS user who owns the oracle directory/software tree
>what is the default password?
There is none.

Who has sysdba priviliges by default (i mean when a database is created who has sysdba privilges)
See answer #1 above

try it, you'll like it.



Your answer is leading me to the thinking that in my case OS administator has created the directory.
Hence it OS's administrator will be entered as sysdba in oracle?

My thinking does not sounds good.

Anyhow i have done this:

Step-1: After click start>Run, i typed SQLPLUS /nolog
Step-2: connect administrator/admin_password as sysdba

and i got the error ORA-12203 TNS: Unable to connect to destination


Please help me to align my thinking
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230091 is a reply to message #229998] Tue, 10 April 2007 20:01 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
I apologize for being less than 100% crystal clear for those who are clue resistant.
$ sqlplus

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 10 17:58:48 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  188743680 bytes
Fixed Size                   778036 bytes
Variable Size             162537676 bytes
Database Buffers           25165824 bytes
Redo Buffers                 262144 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


Does this cut & paste example make things clearer & more understandable?

[Updated on: Tue, 10 April 2007 20:02] by Moderator

Report message to a moderator

Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230126 is a reply to message #230079] Tue, 10 April 2007 23:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I meant disk containing database files and the one containing the alert.log and trace files.
Check if you don't have any trace files from the last startup (in the same directory as alert.log).
Control files are listed in alert.log (and you posted them).
Data files can be gotten by querying v$datafile when connected "as sysdba". Check alsio status and enabled columns in v$datafile and v$datafile_header views.

Regards
Michel
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230138 is a reply to message #230091] Wed, 11 April 2007 00:54 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
anacedent wrote on Wed, 11 April 2007 06:01
I apologize for being less than 100% crystal clear for those who are clue resistant.
$ sqlplus

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Apr 10 17:58:48 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  188743680 bytes
Fixed Size                   778036 bytes
Variable Size             162537676 bytes
Database Buffers           25165824 bytes
Redo Buffers                 262144 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


Does this cut & paste example make things clearer & more understandable?


Dear anacedent
i am stuck at step-2 again. After typing SQLPLUS in start>Run Box, i have the following thing


SQL*Plus: Release 8.0.6.0.0 - Production on Wed Apr 11 10:53:13 2007

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Enter user-name: / as sysdba
ERROR:
ORA-12203: TNS:unable to connect to destination

Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230165 is a reply to message #230138] Wed, 11 April 2007 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't you have LOCAL environment parameter set?
Check in your registry HKLM/Software/Oracle/...

Btw, is your database local or remote?

Regards
Michel
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230179 is a reply to message #230165] Wed, 11 April 2007 02:46 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Michel Cadot wrote on Wed, 11 April 2007 12:14
Don't you have LOCAL environment parameter set?
Check in your registry HKLM/Software/Oracle/...

Btw, is your database local or remote?

Regards
Michel



I have admitted before that i am very weak at DBA. So, i prefer to use the default Values in the registry. Only sting which i used to edit is "PATH" one. Hence HKLM/Software/Oracle/... is full of strings having defualt values.

My database is local and i am using only one single machine. (having two different databases)



Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230183 is a reply to message #230126] Wed, 11 April 2007 02:54 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Michel Cadot wrote on Wed, 11 April 2007 09:48
I meant disk containing database files and the one containing the alert.log and trace files.
Check if you don't have any trace files from the last startup (in the same directory as alert.log).
Control files are listed in alert.log (and you posted them).
Data files can be gotten by querying v$datafile when connected "as sysdba". Check alsio status and enabled columns in v$datafile and v$datafile_header views.

Regards
Michel



Thanks for your guidence.
My mosalrt.log file has the following line in begining

control_files = d:\oracle\oradata\mos\control01.ctl, d:\oracle\oradata\mos\control02.ctl


Thus i have check the presence of these ctl files in the above specified path and they seems to be ok. The database files are also present in the same directory.

i am still unable to connected "as sysdba" so can not see the status of the views

Still looking for the solution
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230192 is a reply to message #230179] Wed, 11 April 2007 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about LOCAL environment variable?
Either in Oracle part of registry or in "Environment Variables" in "System properties"/"Advanced" tab.

Regards
Michel
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230204 is a reply to message #230192] Wed, 11 April 2007 03:42 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Michel Cadot wrote on Wed, 11 April 2007 13:10
What about LOCAL environment variable?
Either in Oracle part of registry or in "Environment Variables" in "System properties"/"Advanced" tab.

Regards
Michel



well, about Local Variable, i have never set them as i have no knowledge about its settings.
Environment Variables in System properties/ Advance Tab are at their normal/default values (as i have never touched them).

What i can see their is two blocks.
Block 1: user variables for admin
It has two variables, TEMP and TMP

Block 2: System variables
It has many variables like:Path, processors, Temp, TMP, wv_gateway_cfg etc


Please guide me if you feel some discripency






Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230321 is a reply to message #229998] Wed, 11 April 2007 09:26 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
12203, 00000, "TNS:unable to connect to destination"
// *Cause: Invalid address specified or destination is not listening.
// This error can also occur because of underlying network or network
// transport problems.
// *Action: Verify that the net service name you entered was correct.
// Verify that the ADDRESS portion of the connect descriptor which
// corresponds to the net service name is correct. Ensure that the
// destination process (for example the listener) is running at the
// remote node.

To me this implies that the connection is trying to use SQL*Net,
when it should NOT be doing so.

Bring up "command window" (cmd) & issue the command :
$ SET

post results back here.
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230392 is a reply to message #230321] Wed, 11 April 2007 14:18 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
anacedent wrote on Wed, 11 April 2007 19:26
12203, 00000, "TNS:unable to connect to destination"
// *Cause: Invalid address specified or destination is not listening.
// This error can also occur because of underlying network or network
// transport problems.
// *Action: Verify that the net service name you entered was correct.
// Verify that the ADDRESS portion of the connect descriptor which
// corresponds to the net service name is correct. Ensure that the
// destination process (for example the listener) is running at the
// remote node.

To me this implies that the connection is trying to use SQL*Net,
when it should NOT be doing so.

Bring up "command window" (cmd) & issue the command :
$ SET

post results back here.


Now i am not getting ORA-012203 error as i am procedding as follow:
1) Started Listener manually by running D:\oracle\BIN\TNSLSNR.EXE
2) Entering CMD at run
3) Issuing command at C:\>set oracle_sid=mos
4) Issuing command at C:\>SQLPLUS /nolog
5) a new window is appered with SQL>
6) entering connect / as sysdba giving me insufficient priviliges message. Even i have checked that the OS administrator is memmber of ORA_DBA too.


But if i proceed as follow then i am getting ORA-012203.
1) Started Listener manually by running D:\oracle\BIN\TNSLSNR.EXE
2) Issuing command at Run... SQLPLUS
3) a new window is appered with asking username
6) entering connect / as sysdba giving me ORA-012203 error


The set command has given me

ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Administrator\Application Data
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=SJMOS-GKIB94DFF
ComSpec=C:\WINNT\system32\cmd.exe
HOMEDRIVE=C:
HOMEPATH=\
LOGONSERVER=\\SJMOS-GKIB94DFF
NUMBER_OF_PROCESSORS=1
oracle_sid=mos
OS=Windows_NT
Os2LibPath=C:\WINNT\system32\os2\dll;
Path=d:\orant\bin;d:\oracle\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINNT\s
ystem32;C:\WINNT;C:\WINNT\System32\Wbem;d:\orant\jdk\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 7 Stepping 3, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0703
ProgramFiles=C:\Program Files
PROMPT=$P$G
SystemDrive=C:
SystemRoot=C:\WINNT
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
USERDOMAIN=SJMOS-GKIB94DFF
USERNAME=administrator
USERPROFILE=C:\Documents and Settings\Administrator
windir=C:\WINNT
wv_gateway_cfg=d:\orant\listener\cfg\wdbsvr.app

Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230882 is a reply to message #229998] Fri, 13 April 2007 03:45 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
I have run
"Oracle Administration Assistant for Windows NT"
under "Database Administartion" Program group.

I did hit and trials to fix my problem but failed.

I am still seeking help for the solution.
The screen imgae of Oracle console is attached below:

  • Attachment: oracle.jpg
    (Size: 63.93KB, Downloaded 365 times)
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230978 is a reply to message #229998] Fri, 13 April 2007 10:57 Go to previous messageGo to next message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Somehow i have managed to contact with the help of "internal" user.
The session was as follow:
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL> connect internal/p as sysdba
Connected.
SQL> select user from dual;

USER
------------------------------
SYS

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area   36437964 bytes
Fixed Size                    65484 bytes
Variable Size              19521536 bytes
Database Buffers           16777216 bytes
Redo Buffers                  73728 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\MOS\SYSTEM01.DBF'
ORA-01207: file is more recent than controlfile - old controlfile


SQL> exit
Disconnected from Oracle8i Personal Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

C:\>


But my problem is not solved as i am still getting ORA-01033

So requesting you all to analyze my above findings.
Thanks
Re: Ora-01033 Error Rectifiation (Oracle 8i) [message #230979 is a reply to message #230126] Fri, 13 April 2007 11:00 Go to previous message
dude4084
Messages: 221
Registered: March 2005
Location: Mux
Senior Member
Michel Cadot wrote on Wed, 11 April 2007 09:48
I meant disk containing database files and the one containing the alert.log and trace files.
Check if you don't have any trace files from the last startup (in the same directory as alert.log).
Control files are listed in alert.log (and you posted them).
Data files can be gotten by querying v$datafile when connected "as sysdba". Check alsio status and enabled columns in v$datafile and v$datafile_header views.

Regards
Michel



The ouput by quering v$datafile and v$datafile_header is as follow: (sorry as i could not format it)


SQL> select * from v$datafile ;

    FILE# CREATION_CHANGE# CREATION_TI       TS#    RFILE# STATUS  ENABLED    CH
ECKPOINT_CHANGE#
--------- ---------------- ----------- --------- --------- ------- ---------- --
----------------
CHECKPOINT_ UNRECOVERABLE_CHANGE# UNRECOVERAB LAST_CHANGE# LAST_TIME   OFFLINE_C
HANGE#
----------- --------------------- ----------- ------------ ----------- ---------
------
ONLINE_CHANGE# ONLINE_TIME     BYTES    BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ----------- --------- --------- ------------ ----------
NAME
--------------------------------------------------------------------------------
--------------------
PLUGGED_IN
----------
        1                4 01-MAR-1999         0         1 SYSTEM  READ WRITE
         1177407
09-APR-2007                     0
137638
        137639 10-MAR-2007 146800640     71680            0       2048
D:\ORACLE\ORADATA\MOS\SYSTEM01.DBF
         0

        2             4385 01-MAR-1999         1         2 ONLINE  READ WRITE
         1177407
09-APR-2007                     0
137638
        137639 10-MAR-2007   3145728      1536            0       2048
D:\ORACLE\ORADATA\MOS\USERS01.DBF
         0

        3             4394 01-MAR-1999         2         3 ONLINE  READ WRITE
         1177407

    FILE# CREATION_CHANGE# CREATION_TI       TS#    RFILE# STATUS  ENABLED    CH
ECKPOINT_CHANGE#
--------- ---------------- ----------- --------- --------- ------- ---------- --
----------------
CHECKPOINT_ UNRECOVERABLE_CHANGE# UNRECOVERAB LAST_CHANGE# LAST_TIME   OFFLINE_C
HANGE#
----------- --------------------- ----------- ------------ ----------- ---------
------
ONLINE_CHANGE# ONLINE_TIME     BYTES    BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ----------- --------- --------- ------------ ----------
NAME
--------------------------------------------------------------------------------
--------------------
PLUGGED_IN
----------
09-APR-2007                     0
137638
        137639 10-MAR-2007  26214400     12800            0       2048
D:\ORACLE\ORADATA\MOS\RBS01.DBF
         0

        4             4403 01-MAR-1999         3         4 ONLINE  READ WRITE
         1177407
09-APR-2007                     0
137638
        137639 10-MAR-2007   2097152      1024            0       2048
D:\ORACLE\ORADATA\MOS\TEMP01.DBF
         0

        5             4413 01-MAR-1999         4         5 ONLINE  READ WRITE
         1177407
09-APR-2007                     0
137638

    FILE# CREATION_CHANGE# CREATION_TI       TS#    RFILE# STATUS  ENABLED    CH
ECKPOINT_CHANGE#
--------- ---------------- ----------- --------- --------- ------- ---------- --
----------------
CHECKPOINT_ UNRECOVERABLE_CHANGE# UNRECOVERAB LAST_CHANGE# LAST_TIME   OFFLINE_C
HANGE#
----------- --------------------- ----------- ------------ ----------- ---------
------
ONLINE_CHANGE# ONLINE_TIME     BYTES    BLOCKS CREATE_BYTES BLOCK_SIZE
-------------- ----------- --------- --------- ------------ ----------
NAME
--------------------------------------------------------------------------------
--------------------
PLUGGED_IN
----------
        137639 10-MAR-2007   5242880      2560            0       2048
D:\ORACLE\ORADATA\MOS\OEMREP01.DBF
         0

        6             4422 01-MAR-1999         5         6 ONLINE  READ WRITE
         1177407
09-APR-2007                     0
137638
        137639 10-MAR-2007   2097152      1024            0       2048
D:\ORACLE\ORADATA\MOS\INDX01.DBF
         0


6 rows selected.

SQL> select * from v$datafile_header;

    FILE# STATUS  ERROR
       FORMAT REC
--------- ------- --------------------------------------------------------------
--- --------- ---
FUZ CREATION_CHANGE# CREATION_TI TABLESPACE_NAME                      TS#    RFI
LE#
--- ---------------- ----------- ------------------------------ --------- ------
---
RESETLOGS_CHANGE# RESETLOGS_T CHECKPOINT_CHANGE# CHECKPOINT_ CHECKPOINT_COUNT
  BYTES    BLOCKS
----------------- ----------- ------------------ ----------- ---------------- --
------- ---------
NAME
--------------------------------------------------------------------------------
--------------------
        1 ONLINE  OLD CONTROLFILE
            8
                   4 01-MAR-1999 SYSTEM                                 0
  1
           137639 10-MAR-2007            1198736 10-APR-2007             1050 14
6800640     71680
D:\ORACLE\ORADATA\MOS\SYSTEM01.DBF

        2 ONLINE  OLD CONTROLFILE
            8
                4385 01-MAR-1999 USERS                                  1
  2
           137639 10-MAR-2007            1198736 10-APR-2007             1042
3145728      1536
D:\ORACLE\ORADATA\MOS\USERS01.DBF

        3 ONLINE  OLD CONTROLFILE
            8
                4394 01-MAR-1999 RBS                                    2
  3
           137639 10-MAR-2007            1198736 10-APR-2007             1042  2
6214400     12800
D:\ORACLE\ORADATA\MOS\RBS01.DBF


    FILE# STATUS  ERROR
       FORMAT REC
--------- ------- --------------------------------------------------------------
--- --------- ---
FUZ CREATION_CHANGE# CREATION_TI TABLESPACE_NAME                      TS#    RFI
LE#
--- ---------------- ----------- ------------------------------ --------- ------
---
RESETLOGS_CHANGE# RESETLOGS_T CHECKPOINT_CHANGE# CHECKPOINT_ CHECKPOINT_COUNT
  BYTES    BLOCKS
----------------- ----------- ------------------ ----------- ---------------- --
------- ---------
NAME
--------------------------------------------------------------------------------
--------------------
        4 ONLINE  OLD CONTROLFILE
            8
                4403 01-MAR-1999 TEMP                                   3
  4
           137639 10-MAR-2007            1198736 10-APR-2007             1042
2097152      1024
D:\ORACLE\ORADATA\MOS\TEMP01.DBF

        5 ONLINE  OLD CONTROLFILE
            8
                4413 01-MAR-1999 OEM_REPOSITORY                         4
  5
           137639 10-MAR-2007            1198736 10-APR-2007             1042
5242880      2560
D:\ORACLE\ORADATA\MOS\OEMREP01.DBF

        6 ONLINE  OLD CONTROLFILE
            8
                4422 01-MAR-1999 INDX                                   5
  6
           137639 10-MAR-2007            1198736 10-APR-2007             1042
2097152      1024
D:\ORACLE\ORADATA\MOS\INDX01.DBF


6 rows selected.

SQL>


Previous Topic: Inserting Error
Next Topic: SERVICE_NAME
Goto Forum:
  


Current Time: Mon Dec 05 18:46:55 CST 2016

Total time taken to generate the page: 0.09947 seconds