If you are using the SPFILE instead of the INIT.ORA file, database parameters can be set using the alter system command. For example, log into SQL*Plus as a sysdba user and execute the following command to change the OPEN_CURSORS parameter to 1024 in the SPFILE and the running instance:
Alter system set open_cursors=1024 scope=both;