Oracle cannot be started after system parameters are created and modified

Oracle memory configuration file: % Oracle_HOME % \ ora92 \ database \ SPFILETIANCI. ORA File

Actually: SPFILESID. ORA file SID is a database service

Run cmd

Input sqlplus/nolog

Enter the conn user name/password as sysdba

Copy the Oracle \ admin \ tianci \ pfile \ init. ora file to drive C.

Enter startup pfile = 'C: \ init. ora ';

If an exception occurs, you cannot start to delete % Oracle_HOME % \ ora92 \ database \ SPFILETIANCI. ORA.

Enter create spfile = 'C:/SPFILETIANCI. ORA 'from pfile = 'C: \ init. ora ';

Copy the newly generated file spfileSID. ora to "% Oracle_HOME % \ ora92 \ database \". The directory overwrites the original file. If the initSID. ora file exists, rename it.

Restart Oracle services