Home » Developer & Programmer » Reports & Discoverer » Unable to Connect to DB from Reports10g (Windows7, Reports 10G)
Unable to Connect to DB from Reports10g [message #545112] Mon, 27 February 2012 05:41 Go to next message
tauseefcafe
Messages: 3
Registered: February 2012
Junior Member
Hi,

I have installed Windows7 64bit on my laptop and then installed Reports10G.

I am not able to connect to DB from Reports10g, Its gives below error -

REP-0501: Unable to connect to the specified database
ORA-02248: Invalid Option for ALTER SESSION

Same Reports10g is able to connect to DB on WindowsXP machine. Database version is 11g which is remote.

Regards
Tauseef
Re: Unable to Connect to DB from Reports10g [message #545115 is a reply to message #545112] Mon, 27 February 2012 05:53 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Can you connect using sqlplus?
Re: Unable to Connect to DB from Reports10g [message #545118 is a reply to message #545115] Mon, 27 February 2012 06:00 Go to previous messageGo to next message
tauseefcafe
Messages: 3
Registered: February 2012
Junior Member
Hello,

I tried that but its also giving the same error for Alter session.

Apart from that I installed 10g client, if I used Oracle 10g clients SQL PLUS then I am able to connect.

Seems Reports10g installs 9i version of SQL PLUS and that could be the problem

Regards
Tauseef
Re: Unable to Connect to DB from Reports10g [message #545153 is a reply to message #545118] Mon, 27 February 2012 10:52 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
Seems Reports10g installs 9i version of SQL PLUS

Please, post a proof.


Which Windows 7 version do you use?
Re: Unable to Connect to DB from Reports10g [message #545161 is a reply to message #545153] Mon, 27 February 2012 11:55 Go to previous messageGo to next message
tauseefcafe
Messages: 3
Registered: February 2012
Junior Member
Hi,

While try to connect via SQL Plus Installed by Oracle Developer Suite I could see its version is 9.. Check the attached file.

I am using Windows 7 Ulimate 64 bit.

Regards
Tauseef
  • Attachment: Error.jpg
    (Size: 67.05KB, Downloaded 1297 times)
Re: Unable to Connect to DB from Reports10g [message #545222 is a reply to message #545161] Tue, 28 February 2012 00:21 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Huh, right ... which Reports version exactly is it? Maybe one of the earliest 10g ones (which is "identified" as 9.0.x), maybe?

Oracle - generally speaking - is certified with MS Windows Ultimate version (but not with a Home one), so that's not a problem. However, My Oracle Support lists only 11.x Reports versions (i.e. I can't check earlier versions at all) so *maybe* you are running a not supported / not certified combination of Reports and operating system. Have a look by yourself, you might see better than me.

Therefore, if possible, upgrade your Reports version (perhaps by installing the latest patch?). I suppose that downgrading your operating system isn't really a way out of it, right? In that case, you might install virtual machine on your Windows 7, install Windows XP onto it, install Reports on XP and run it happily.

Finally, search the board and/or Internet. I've seen people saying that they run the most incredible combinations of Oracle products and operating systems, but these are more exceptions to the rule than exact guidelines.

Good luck!
Previous Topic: Accepting parameter Form user to drill down report
Next Topic: problem with report parameter
Goto Forum:
  


Current Time: Thu Mar 28 17:03:29 CDT 2024