DBA Interview Question

Initialization Parameters

Topic : Initialization Parameters

You have installed Oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish; what should you check first to determine if there is a problem?

Answer :

Check to make sure that the archiver isn?t stuck. If archive logging is turned on during install a large number of logs will be created. This can fill up your archive log destination causing Oracle to stop to wait for more space.