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: 179
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

Report message to a moderator

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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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: 8964
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.

Report message to a moderator

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: 179
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

Report message to a moderator

Re: ORA-02248 [message #594240 is a reply to message #594224] Mon, 26 August 2013 08:58 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 17:19:54 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.