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.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.