Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

2248ORA - 02248: invalid option for ALTER SESSION

883679Aug 21 2011 — edited Aug 21 2011
Hi,

I have an application running for years (written in ORACLIP) without any change.

The application runs fine against Oracle 8 and 9, and now I am trying to run against Oracle 11gR2.

The Oracle11gR2 installation looks fine, I can sucessfully connect to instance using SQLPLUS SYSTEM/MANAGER.

But my old oraclip application, (that are working fine in Oracle 8 and 9), fails to connect to the Oracle11gR2 instance with the error: 2248ORA - 02248: invalid option for ALTER SESSION.

The error occurs in a ORACLIP function (I believe that this function try to execute the ALTER SESSION), but I have not access to the source code.

I want to know if something have changed in Oracle 11gR2 about ALTER SESSION sintax or behaviour.

If not, any idea about some missing or wrong configuration in the Oracle 11gR2 that cause this problem?

How can I get ( to capture / to trace) the exactly ALTER SESSION that fails?

There is a way to make ORACLE 11gR2 to ignore this error and continuing without return a error? Maybe the "ALTER SESSION" is not important to the program.

There is a way to make ORACLE 11gR2 works like an ORACLE 9 or 10 (in order to verify if this problems is about the version or some wrong configuration).

I will apreciate any idea or help.

Thanks in advance,

Luigggye
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2011
Added on Aug 21 2011
2 comments
1,219 views