We help IT Professionals succeed at work.

Error ORA-02248 while trying to connect Oracle8 (8.0.5)-Client to Oracle11g Server

olka
olka asked
on
7,634 Views
Last Modified: 2013-12-19
Hi,
I have an old Oracle installation running since 1998. I have an UNIX-HP-UX Workstation with Oracle 8.0.5 Database. The Clients are running on Windows machines. Some processes are running on the Server itself with connection to this Oracle 8.0.5 database. These processes are developed in C with Oracle ProC.
Now i'm changing the HP-UX server to an Win2003-Server with Oracle 11g database. My Windows Client program is now connecting to this Oracle 11g DB. But the Unix processes cannot switch at one time to the new system. For a short time, I want to run these processes on the Unix system, but with connection to the new Oracle 11g database.
But now, i get the error ORA-02248 " invalid option for ALTER SESSION" while starting my unix-process or while starting sqlplus.
Has anyone an idea if (and how) it is possible to connect an Oracle8 client to an Oracle11 database.
Thanks in advance
olka
Comment
Watch Question

David VanZandtSr Software Engineer
CERTIFIED EXPERT

Commented:
ORA-02248: invalid option for ALTER SESSION Action: see SQL Language Manual for legal options.
Your issue is not with the 8x client, rather with your syntax.  Please post your ALTER statement for further assistance.

Author

Commented:
and that's my problem!
there is no alter session statement in my program. I get this error also when i want to start sqlplus (without calling directly a sql-script)
David VanZandtSr Software Engineer
CERTIFIED EXPERT

Commented:
Post the syntax, please. Also, I'd like to see the glogin.sql script from your host, and the login.sql (if any) from your user home.  Thirdly, results from "which sqlplus" should return something like "/u01/app/oracle/product/10.2/bin/sqlplus".

Commented:
create a new db string in tnsnames.ora file at oracle 8,  for oracle 11g database
and
then tnsping that db string, for example you created a new db string as ora11 in tnsnames.ora in oracle 8

$ tnsping ora11

and is it pinging properly ?

Author

Commented:
tnsping on server oracle11 is pinging properly.
In the meantime i have found an old test machine with Oracle 8.0.5 and 8.0.6 installed.
Connecting from 8.0.5 to Oracle11 is not working , but i can connect from 8.0.6 to my oracle 11 DB.
So i will install this 8.0.6 version on my production system.

thanks for your hints
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
your old client is likely issuing an alter session to set NLS_LANG.  It's doing this on its own.
or a logon trigger is doing it for you.

Author

Commented:
yes, that's the same I'm thinking of. But when i don't set NLS_LANG i get a core dump with SIGSEGV. Do you know a way how to trace wo do at what time this ALTER SESSION statement ?
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
Do you have Toad?  It comes with a an OCI monitor.

SQLMonitor.exe


This will track all activity through the Oracle Call Interface for your application.

Author

Commented:
yes, i have TOAD, but i have never worked with SQLMonitor. I will try this to see what happens. In the meantime I will upgrade to 8.0.6 client.
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
I recommend upgrading to at least a 9.2 client.

As any 8i or lower client (including 8.0.6) should be rejected by an 11g database

See metalink doc: 207303.1

Author

Commented:
I know that 8.0.6 client running against 11g database is not supported by oracle. But this solution (8.0.6) is only temporary for ~2 months. After that time i think we have finished our upgrade-project to 11g client and server.
Now the client machine is an HP-UX 10.20 unix workstation, and i don't want to change to much for that short time.
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.