 Posted 6/14/2010 10:57:26 AM
|
|
|
|
ORA-01986: | OPTIMIZER_GOAL is obsolete | | Cause: | An obsolete parameter, OPTIMIZER_GOAL, was referenced.
| | Action: | Use the OPTIMIZER_MODE parameter. |
|
|
|
Posted 6/14/2010 10:58:25 AM
|
|
|
|
Getting log in error in connecting Oracle 10g Enterprise Edition Release 10.2.0.2.0 - 64bit using SQL Navigator old release 4.3.1.460. Per Oracle metalink cause/solution verified that LoginTrigger is not the issue (which we dropped).
Does it need any patch/upgrade for SQL Navigator and how to get/implement that please?
Thanks
|
|
|
Posted 6/14/2010 10:58:41 AM
|
|
|
|
Hi,
sqlnav is doing some alters,after logon, setting nls parameters and optimizer mode (goal in previous versions) too. Yes OPTIMIZER_GOAL was replaced with OPTIMIZER_MODE in latest versions of oracle, so sqlnav 4 is rather old and it uses old method to set this parameter. Try go to preferencess, session, and set optimizer_goal to default, then try connect to database.
In versions 5.x and 6.x this problem not exists.
|
|
|
Posted 6/14/2010 10:59:23 AM
|
|
|
|
Error Message: ORA-01986 invalid option for OPTIMIZER_GOAL
Error Cause:
An invalid OPTIMIZER_GOAL option is present.
Action:
Check the syntax for OPTIMIZER_GOAL, specify a valid option and re-execute the statement.
|
|
|
Posted 6/14/2010 10:59:44 AM
|
|
|
|
| Hi, ORA-01986 error is bacause obsolete parameter, OPTIMIZER_GOAL was referenced use OPTIMIZER_MODE parameter and then try.
|
|
|
Posted 6/14/2010 11:01:57 AM
|
|
|
|
ops$tkyte@ORA10G> alter session set optimizer_goal = first_rows
2 /
alter session set optimizer_goal = first_rows
*
ERROR at line 1:
ORA-01986: OPTIMIZER_GOAL is obsolete
ops$tkyte@ORA10G> c/goal/mode
1* alter session set optimizer_mode = first_rows
ops$tkyte@ORA10G> /
Session altered.
|
|
|
|