Home » Developer & Programmer » Reports & Discoverer » ORA-02248 (Discoverer 3.1.36.06 - EUL 3.1.13 - database 11g)
ORA-02248 [message #594189] Sun, 25 August 2013 11:11 Go to next message
emadnabil
Messages: 155
Registered: August 2007
Senior Member
Dear all,
I got this error when try to connect to the database using discover administrator or user edition

ora - 02248 : invalid option for ALTER SESSION


N.B i can connect to the database with sqlplus with no problem


so please help
Re: ORA-02248 [message #594190 is a reply to message #594189] Sun, 25 August 2013 11:53 Go to previous messageGo to next message
Michel Cadot
Messages: 59173
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-02248: invalid option for ALTER SESSION
 *Cause: Obvious.
 *Action:  see SQL Language Manual for legal options.

Activate SQL*Net trace on the client side to see the statement.

Regards
Michel
Re: ORA-02248 [message #594191 is a reply to message #594189] Sun, 25 August 2013 12:10 Go to previous messageGo to next message
John Watson
Messages: 4580
Registered: January 2010
Location: Global Village
Senior Member
I remember seeing this once before, the problem is with a logon trigger that doesn't work in 11g. Look at the source code for any Discoverer related logon triggers, and it should (you can hope!) be obvious.
Re: ORA-02248 [message #594224 is a reply to message #594191] Mon, 26 August 2013 07:00 Go to previous messageGo to next message
emadnabil
Messages: 155
Registered: August 2007
Senior Member
Dear Mr. John
I searched for any triggrs on the administrator user of the discoverer and didnot found any trigger


Re: ORA-02248 [message #594240 is a reply to message #594224] Mon, 26 August 2013 08:58 Go to previous message
Michel Cadot
Messages: 59173
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search in database for any logon trigger; you have to ask to your DBA if you are not one.

Regards
Michel
Previous Topic: Reports 11g Compilation Error
Next Topic: Bad Images Cause Report to Crash
Goto Forum:
  


Current Time: Tue Sep 23 02:18:38 CDT 2014

Total time taken to generate the page: 0.21642 seconds