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