Ask the Expert

Unable to start new database in 9i

I am unable to start up a new database in Oracle 9i. If I give the end command startup nomount=pfile then problems arise, but my init.ora file is correct. Also, the RMAN backup is not working. Can you help?

    Requires Free Membership to View

There could be any number of reasons why you cannot start your new database. Did you connect to the database as someone in the SYSDBA or SYSOPER group? After that, the syntax to start the database in NOMOUNT mode is:

START NOMOUNT PFILE=/directory/initSID.ora
Since there are a number of reasons why the database won't start, we'll need more information from you. Please resubmit your question with a complete cut-and-paste of your exact command and any and all errors messages.

This was first published in July 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: