Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 521
  • Last Modified:

Adding Oracle Parameters

Oracle9i Enterprise Edition Release - Production
PL/SQL Release - Production
CORE      Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production

I am trying to add some oracle parameters on my PR3 system and this is what I am getting:
SQL> show parameter spfile;

 NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------

spfile                               string      %ORACLE_HOME%\DATABASE\SPFILE%


SQL> alter system set _eliminate_common_subexp =false scope=spfile;
alter system set _eliminate_common_subexp =false scope=spfile

ERROR at line 1:
ORA-00911: invalid character

I believe it does not like the underscore at the start of this parameter _eliminate_common_subexp.   I believe what I need to do is go back to the INIT.ORA type parameter file
SQL> create pfile from spfile;
Manually add all the Oracle Initialization Parameter with underscores (example: _eliminate_common_subexp, _optimizer_join_sel_sanity_check, _optimizer_or_expansion) to the  INIT.ORA  and than create the SPFILE again.

SQL> create spfile from pfile;
Or is there another way of adding these parameters to the SPILE ?
Thanks for your time

I also tried:

SQL> alter system set "_ELIMINATE_COMMON_SUBEXP"= FALSE  scope=spfile sid='*';
alter system set "_ELIMINATE_COMMON_SUBEXP"= FALSE  scope=spfile sid='*'
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM



1 Solution
you sure that's the correct hidden parameter

_eliminate_common_subexpr     (you're missing an R at the end)
algotubeAuthor Commented:
Oh my God dbmullen. I was following a consultant solution and just trusted it was right....... Thank you for pointing that out.....  

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now