ORACLE Workgroup Server Password on NETWARE problems

Having spent much time trying to strighten this one out with ORACLE tech support people who have admitted there is a problem in the documentation but nothing else, I attach a workaround for anyone trying to set up one of these things and finds that after installing the client side tools that most of them require an unknow database password.  

Notes on configuring the Workgroup server for ORACLE/Windows    

1. Add the CONTROL_FILES parameter to the INIT.ORA so ORACLE can find the control files otherwise it will look in %RDBMS70%\DATABASE ***Above Only if you are upgrading from a 7.0 non WG system *****
2. The database password manager should be oracle by default but this may not work....
3. If the database password does not work and there is no password manager icon (does not ship on the Netware install CD)

        From SQLDBA shutdown ORACLE 
        From Rconsole type  
LOAD SYS:ORANW\NLM\ORAPW71.NLM FILENAME=<fname> PASSWORD=MANAGER 
         
        This will build a new password file called fname and associate the
password MANAGER with the database 
         
4)      Add a new line to the CONFIG.ORA file 
        ORA_PWFILE=<fname> 
         
5)      Restart ORACLE from SQLDBA 
 
6)      Start windows and run the Session manager, type in the new password
  MANAGER and you should be able to connect. 
         
 

MJ                    Received on Sat Mar 11 1995 - 20:56:41 CET