Solution : https://service.sap.com/sap/support/notes/601157 (Connexion à SAP Service Marketplace requise)
Résumé : Mots Clés : Notes associées :
La note SAP détaille la transition vers le fichier de paramètres serveur (SPFILE) d'Oracle à partir de la version Oracle9i, remplaçant les fichiers init
sysdba sql>shutdown sql>startup sql>show parameter spfilethe parameter 'spfile', sysdba sql>shutdown sql>startup sql>show parameter spfile spfile - migration, - setting system parameters temporarily - resetting system parameters - setting events, sql>show parameter spfilean empty string means, sql>alter system reset <parameter_name> scope = spfile sid = ' ', sql>alter system reset event scope=spfile sid=' ', explanationsgeneral recommendationspfile - descriptionspfile - search sequencespfile - functions, constraintsspfile - advantagesspfile - special featuresspfile - special features, sql>alter system set _push_join_predicate=false scope=spfile, longer execute 'alter system set' commands
1178409 ORA-32021: parameter value longer than 255 characters 948197 Merge fix for DBMS_STATS package on Oracle 9.2.x and 10.2.x 848708 Oracle Database Configuration for NWDI server 830576 Parameter recommendations for Oracle 10g 773173 Using Oracle Fail Safe cluster on Windows with SPFILE 647697 BRSPACE - New tool for Oracle database administration 598678 Oracle 9i: New functions 596423 Events and SPFILE