Oracle does not start due to setup of log_archive_dest_1 in init.ora !
Posted on 2003-10-30
I have Oracle 8i installed on a Windows NT server.
The database is currently NOT in archivelog mode (checked with DBA Studio).
The instance used the init.ora from which I have the 3 following COMMENTED lines :
# log_archive_start = false
# log_archive_dest_1 = "D:\oracle\oradata\radon\archive"
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
Now if I uncomment some of these lines, and stop/start the DB, the DB still works EXCEPT if the second line (log_archiv_dest_1) is uncommented. No idea why.
Even if there is an error on this line,I can not understand why it seems to take that into account as anyway the archivelog mode is NOT set and the line before says log_archive_start = false !
ps : I checked that the indicated location (D:\oracle...) really exists.