Ask the Expert

Database Configuration Assistant not executing

I'm installing Oracle9i in Red Hat Linux. The installation is correct, but the execution of the Database Configuration Assistant is not correct. I obtain this error: "ORA-01092: ORACLE instance terminated. Disconnection forced". In my alert.log I've found this other error: "ORA-01990: error opening password file '/u01/app/oracle/product/9.0.1/dbs/orapw"

I should have the environment variables ORA_sid_PWFILE and ORA_PWFILE to solve this, but I don't know where these variables should point.

    Requires Free Membership to View

The password file on Linux must be named $ORACLE_HOME/dbs/orapwSID. The ORA_sid_PWFILE and ORA_PWFILE parameters are registry entries allowed on Windows systems to reference the location of the password file. On other platforms, the file must be in the $ORACLE_HOME/dbs directory and must be named orapwSID or there must be a link (usually symbolic) with that name that points to the location of the password file.

There are two ways that you can address your issue:

1. Run this command:
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=
... which will create the file in the correct location (assuming your ORACLE_HOME and ORACLE_SID environment variables are set correctly).

2. Modify the instance initialization parameters to set the remote_login_passwordfile = none. This will force the instance not to use a password file and, therefore, it will not look for one. Having a password file is optional and it can be created later (and the initialization parameter reset appropriately) if you wish to have one.

This was first published in April 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: