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.
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

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



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: