ORA-02248: invalid option for ALTER SESSION
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



ORA-02248: invalid option for ALTER SESSION Expand / Collapse
Message
Posted 6/15/2010 9:45:30 AM Post #362
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

ORA-02248:

invalid option for ALTER SESSION
Cause:Obvious.
Action:see SQL Language Manual for legal options
Posted 6/15/2010 9:46:30 AM Post #363
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
You did an ALTER SESSION, but the option specified does not exist.

It might be that you are trying to change a hidden option, if this is the case put quotes around the parameter name.
eg:
SQL> alter session set unknown_option=false;
alter session set unknown_option=false
*
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION
Posted 6/15/2010 9:46:54 AM Post #364
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

ORA-02248 error while connecting Developer 6i to Database 11g

If you have an older version of Developer 6i and try to connect to Database server 11g, connection fails with following error message

ORA-02248: invalid option for ALTER SESSION

To resolve this problem simply upgrade your Developer 6i release by applying a patch or by fresh installation. For example, when I first time encountered this problem, I was using Forms Builder 6.0.5.0.2. I removed my previous release and installed Developer release 6.0.8.8.0. After up-gradation I was able to connect to 11g server without further problem.

When I first time tried to run my form, Forms Builder 6.0.8.8.0 asked me to re-enter password. This is because 11g has new Case sensitive password feature. When I first time connected to Forms Builder, I supplied correct password which was in lower case. When I tried to run form, Forms Builder tried to connect to 11g server with upper case user and upper case password. This is default behavior of Forms builder. Similar problem occurred when I tried to call reports from Forms using RUN_PRODUCT() method. To resolve this problem either set database users passwords to upper case or issue following SQL command to disable case Sensitive password feature.

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;

Upgrading your Developer release will resolve you problem but you must remember that developer 6i with 11g is not a supported combination by oracle as support for Developer 6i has been dis-continued. Oracle recommends upgrading you developer to latest version like Oracle Developer Suite 10g or Forms 11g.

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 2 (2 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 10:11am

Powered By InstantForum.NET v4.1.4 © 2012
Execution: 0.110. 4 queries. Compression Disabled.
Contextual Links