Please Help - Control File Errors

[dushkin]

Hi. I am installing oracle for the first time. I managed to get through some initial errors, but can't seem to clear this last hurdle. When the database config assistant runs, I get the following errors:

Ora 01503: Create control file failed
Ora 01565: Error identifying file c:/oracle/oradata/my_name/system01.dbf
Ora 27046: file size not a multiple of log block size
Database not mounted

I am using a PIII with Win 2K (dual booting with Linux).
Oracle is installed on the Win side.

Thanks in advance.
Pbd

 

[JJSmith]

There are 2 possible reasons here:
1. You tried to resize a datafile.
2. The datafile has autoextend on - in which case the system re-sized.

Normally it would be a case of backup, dropping the tablespace and recreating, then restore data - how ever in your case it is the system tablespace that has the error. In which case it is not so simple - if you have a full backup, revert to that - if not, I think you may have to contact Oracle - I'm not sure that even they could help with a system tablespace/datafile problem.

As far as I am aware you only have 2 choices
Two approaches are possible:

Restore the file from a backup then do recovery on it
OR
Rebuild the database ( re-creating the system tablespace ).

 

[dushkin]

Hi JJ. Thanks for your reply.
I am installing the product for the first
time so, there is currently no data that
i am working with. I have deleted and reinstalled
the Oracle 8 product numerous time to see if that
would fix the problem but it doesn't. I am assuming
that the reinstall recreates the system tablespace.
So, maybe the answer is to reinstall and then do a
recovery? How would i go about that (I am sorry, I
am just getting started).

Thanks a lot for your help...

 

[JJSmith]

There should be no need to re-install the software. It is re-creating the database that is necessary.
Are you creating a default database when installing the software.
If you are then the database is not created - it is copied from the installation media.
Can you get the database actually started so that you can log in using sqlplus or svrmgrl?
If so connect as sys or internal then run the following command;

select name from v$datafile
union
select name from v$controlfile
union
select member from v$logfile;

Make a record of these filenames.

Shut the service

Use Oracle Database Configuration Assistant to delete the database.

Check the files recorded have been removed - if not manually delete them.

Use Oracle Database Configuration Assistant to create a new database from scratch.

 

[uparna]

Dushkin ,
Eafter deinstalling Oracle, the datafiles etc are not dropped. Hence you have to physically delete/relocate the Oracle folder on your drive before reinstalling Oracle again -> otherwise the same tablefiles etc are used. Beware -> if you have data( i dont think you do ) then this method is unthinkable.......
Hope this helps you . Regards,
S. Jayaram Uparna .

If the need arises,you are welcome to mail me at oracguru@yahoo.com .

 

[dushkin]

Hi JJ and Uparna,

I did what you both said and I think it was
a great help - I don't have any of the old
install problems any more - the database config
assistant runs smoothly. I am now attacking
trying to log into the OEM which is harder than
I thought it would be. I have tried all of the
suggested first time login names:
sys - manager sysman - oem_temp - sys - change_on_install
but keep getting the error that oracle is unable to
connect to the management server.

suggestions appreciated. I'll keep at it...

Thanks!

 

[anirudhadeo]

Hi Duskin,
have you created a repository for the OEM?
If not create one through the configuration assistant and then try it.

Regards anirudha

 

[dushkin]

Hi. I just created a repository
for the OEM but when I tried to login to the
oracle enterprise manager it told me
"invalid login credentials supplied".
I found this encouraging though - the error
screen is different than before I created the
repository for the OEM. Getting close...
the Admin IDs I used:

OEM, SYSTEM, SYS

THE PWDs:

OEM_TEMP, CHANGE_ON_INSTALL, MANAGER